How to compare blank textbox with date in LINQ where clause ?

Question

0.00/5 (No votes)

See more:

Following is my LINQ Query. Which retrive some records from database. I have give date comparision with textboxes. When I put date in these textboxes the records will retrive but when i keep date textboxes empty its not retriving records and rise exception"String was not recognised as valid datetime"

When I keep textboxes od date blank i want to retrive all records. And When I put date i want to retrive that date range records.

So please let me know how to write query for this.

C#

var AllRequest = (from objm in db.tbl_MemberMasters
                             join objreq in db.tbl_ProductRequests
                             on objm.MemberId equals objreq.memberId
                             where objm.IsDistrictFranchise == true && (objreq.date >= Convert.ToDateTime(txtfromDate.Text)  && objreq.date <= Convert.ToDateTime(txtToDate.Text)
                             select new { objreq.requestId, FranchiseeID = objm.MemberId, OwnerName = objm.MemberFirstName + " " + objm.MemberLastName, objm.MobileNumber, objm.City, Date = string.Format("{0:d}", objreq.date), objreq.status }).AsQueryable();

What I have tried:

var AllRequest = (from objm in db.tbl_MemberMasters
join objreq in db.tbl_ProductRequests
on objm.MemberId equals objreq.memberId
where objm.IsDistrictFranchise == true && (objreq.date >= Convert.ToDateTime(txtfromDate.Text) && objreq.date <= Convert.ToDateTime(txtToDate.Text)
select new { objreq.requestId, FranchiseeID = objm.MemberId, OwnerName = objm.MemberFirstName + " " + objm.MemberLastName, objm.MobileNumber, objm.City, Date = string.Format("{0:d}", objreq.date), objreq.status }).AsQueryable();

Posted 23-Mar-16 22:19pm

Veeshal Mali

Updated 24-Mar-16 2:54am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2016-03-24T02:54:00

You'll also have this problem if your users enter a value which isn't a valid date. You need to use DateTime.TryParse[^] to try to parse the entered values as DateTime instances, and only apply the filter if the value is valid:

C#

var requests = from objm in db.tbl_MemberMasters
               join objreq in db.tbl_ProductRequests
               on objm.MemberId equals objreq.memberId
               where objm.IsDistrictFranchise == true
               select new { objm, objreq };

DateTime fromDate;
if (DateTime.TryParse(txtFromDate.Text, out fromDate))
{
    requests = requests.Where(r => r.objreq.date >= fromDate);
}

DateTime toDate;
if (DateTime.TryParse(txtToDate.Text, out toDate))
{
    requests = requests.Where(r => r.objreq.date <= toDate);
}

var AllRequests = requests.Select(r => new 
{ 
    r.objreq.requestId, 
    FranchiseID = r.objm.MemberId, 
    OwnerName = r.objm.MemberFirstName + " " + r.objm.MemberLastName,
    r.objm.MobileNumber,
    r.objm.City,
    Date = r.objreq.date.ToString("d"),
    r.objreq.status
});