entity framework core - Searching for a range of dates in LINQ -


i'm trying search through table via linq , entity framework core. i've got 2 text boxes startdate , enddate , radio button set of 3 options created, modified , both.

this code i've produced based on google searches , tutorials 

       switch(radcreatedmodifiedboth) {             case "b":                 if (!string.isnullorempty(startdate)) {                     if (!string.isnullorempty(enddate)) {                         persons = persons.where(ps => (                                                         ps.createddate >= convert.todatetime(startdate + " 00:00:00") &&                                                         ps.createddate <= convert.todatetime(enddate + " 23:59:59")                                                         ) || (                                                         ps.modifieddate >= convert.todatetime(startdate + " 00:00:00") &&                                                         ps.modifieddate <= convert.todatetime(enddate + " 23:59:59")                                                         )                                                 );                     } else {                         persons = persons.where(ps => (                                                         ps.createddate >= convert.todatetime(startdate + " 00:00:00")                                                         ||                                                         ps.modifieddate >= convert.todatetime(startdate + " 00:00:00")                                                       )                                                 );                     }                 } else if (!string.isnullorempty(enddate)) {                     persons = persons.where(ps => (                                                     ps.createddate >= convert.todatetime(enddate + " 23:59:59")                                                     ||                                                     ps.modifieddate >= convert.todatetime(enddate + " 23:59:59")                                                   )                                             );                 }                 break;             case "c":                 if (!string.isnullorempty(startdate)) {                     if (!string.isnullorempty(enddate)) {                         persons = persons.where(ps => (                                                         ps.createddate >= convert.todatetime(startdate + " 00:00:00") &&                                                         ps.createddate <= convert.todatetime(enddate + " 23:59:59")                                                         )                                                 );                     } else {                         persons = persons.where(ps => (                                                         ps.createddate >= convert.todatetime(startdate + " 00:00:00")                                                       )                                                 );                     }                 } else if (!string.isnullorempty(enddate)) {                     persons = persons.where(ps <= (                                                     ps.createddate >= convert.todatetime(enddate + " 23:59:59")                                                   )                                             );                 }                 break;             case "m":                 if (!string.isnullorempty(startdate)) {                     if (!string.isnullorempty(enddate)) {                         persons = persons.where(ps => (                                                         ps.modifieddate >= convert.todatetime(startdate + " 00:00:00") &&                                                         ps.modifieddate <= convert.todatetime(enddate + " 23:59:59")                                                         )                                                 );                     } else {                         persons = persons.where(ps => (                                                         ps.modifieddate >= convert.todatetime(startdate + " 00:00:00")                                                       )                                                 );                     }                 } else if (!string.isnullorempty(enddate)) {                     persons = persons.where(ps <= (                                                     ps.modifieddate >= convert.todatetime(enddate + " 23:59:59")                                                   )                                             );                 }                 break;         }

this code works seems massively inefficient, not mention adding start , end time date string 

startdate + " 00:00:00" enddate + " 23:59:59"

just seems wrong. prescribed method or can suggest more efficient method preferably getting rid of " 00:00:00"/" 23:59:59"

thanks

you can simplify pushing tests sql - conditional operator translated sql case when since aren't simple constants. note assumed have enddate tests backwards in code sample. have lot of repeated sub-expressions consolidated variables. since using ef core, there isn't better way handle date comparisons using. in ef can use dbfunction, still isn't converting dates appropriate date+time indices can used.

var hasstartdate = !string.isnullorempty(startdate); var dtstartdate = hasstartdate ? convert.todatetime(startdate + " 00:00:00") : datetime.minvalue;  var hasenddate = !string.isnullorempty(enddate); var dtenddate = hasenddate ? convert.todatetime(enddate + " 23:59:59") : datetime.minvalue;  var chkcreateddate = (radcreatedmodifiedboth == "b" || radcreatedmodifiedboth == "c"); var chkmodifieddate = (radcreatedmodifiedboth == "b" || radcreatedmodifiedboth == "m");  persons = persons.where(ps => (chkcreateddate ? (hasstartdate ? ps.createddate >= dtstartdate : true) && (hasenddate ? ps.createddate <= dtenddate : true) : true)                                ||                               (chkmodifieddate ? (hasenddate ? ps.modifieddate >= dtstartdate : true) && (hasenddate ? ps.modifieddate <= dtenddate : true) : true)                         );

Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

transpose - Maple isnt executing function but prints function term -

im using maple im in worksheetmode tried using maple input , 2d input , want transpose matrix a: := `<|>`(`<,>`(1, .5, -2), `<,>`(.5, 9/4+b, 5+3*b), `<,>`(-2, 5+3*b, 18+9*b+4*a)); b:= transpose(a); when exectute sheet dont translated values, there same input. matrix looks same input matrix plus function term. you can see picture in following link: why arent functions executed? meanwhile b:=a^+ doing right way , transposed matrix. other functions return function body instead needed values... if using 2d input mode (the default) space you've got between transpose , bracketed (b) interpreted multiplcation. rid of such space. also, either load package @ start of document like, with(linearalgebra): before calling transpose command package, or call it's full name like, linearalgebra:-transpose(b);
Read more