C# Multiple Linq Query Search Issue -


I have multiple linq queries for searching the database of information based on a specific specific criteria for the query like ID or By name etc.

Currently, the user can only search using a query method. The problem is that I want users to be able to use multiple parameters, without even writing new questions, can combine criteria with many questions.

For example:

I is a query that returns a set of questions based on those department names under which they are stored, and another query Which gives returns to a set of questions based on the module title under which questions are stored. Since the user can currently search only by the name of the department or the module title - e.g. Computer Science or Distributed Systems, I would like to change this so that the user can specify something like this:

Return all questions, Department name == Computer Science & amp; Amp; ModuleTitle == Distributed Systems

Help will be greatly appreciated.

Here is the current code: 

  // Department name questions public static IQueryable SearchByDepartmentNameInfo (string deptName) {ExamineDataContext DC = new testDataText (); Var queryResult = dcGetTable in q with & lt; Question & gt; () Where q.Topic.Module.Department.DepartmentName.Equals (deptName) are included in d.Colutions is equal to q.QuestionID in q.QuestionID qs // Note group selection new {module = q.Topic.ModuleTitle , Topic = q.TopicName, question = q.QuestionText, question type = q.QuestionType;}; Return query result; } // module title query public static IQueryable SearchByModuleTitleInfo (string modTitle) {ExamineDataContext DC = new ExaminationDataContext (); Var queryResult = q to dc.GetTable & lt; Question & gt; () Where q.Topic.Module.ModuleTitle.Equals (modTitle) is included in dc.Solutions in q. QuestionID equals s.QuestionID qs // Note group selection new {module = q.Topic.ModuleTitle, topic = q.TopicName, question = q.QuestionText, question type = q.QuestionType;}; Return query result; }

You can add them to a single query, only if this condition is set : 

  where (cond1 == "" || row.field1 == cond1) & amp; Amp; (Cond2 == ""; row.field2 == cond2) ...

So if you search for cond1 = "" and cond2 = "somevalue", then you actually Only search on cond2 but if you specify both, then it will select the interaction of both the positions.

Add some checks to make sure at least one condition is specified.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more