Advanced search between two dates in ASP.NET MVC 5

Question

I use this code for advance search

public ActionResult AdvanceSearch(string HeadTitle, string fulltext, string firstdate, string enddate, string newstype)
    {
        var q = db.Tbl_News.Where(n => n.HeadTitle.Contains(HeadTitle) && n.FullText.Contains(fulltext) && n.Date >= firstdate && n.Date <= enddate);
        return PartialView("AdvanceSearch", q);
    }

this code work for Search in HeadTitle and full text but when I add date show me an error .

How use this code for search between two dates ?

Start by making your parameters DateTime (not string)

user3559349
– user3559349

2016-09-17 11:14:15 +00:00
Commented Sep 17, 2016 at 11:14 — user3559349
– user3559349, Commented Sep 17, 2016 at 11:14
@StephenMuecke thanks . its work

Mr Coder
– Mr Coder

2016-09-18 17:17:09 +00:00
Commented Sep 18, 2016 at 17:17 — Mr Coder
– Mr Coder, Commented Sep 18, 2016 at 17:17

Mohamed Badr · Accepted Answer · 2016-09-17 11:22:46Z

1

First, your date parameters should be of type DateTime, and I suggest updating your code to be like

var q = db.Tbl_News
            .Where (n => n.HeadTitle.Contains(HeadTitle) 
            .Where (n => n.FullText.Contains(fulltext)) 
            .Where (n => n.Date >= firstdate.Date )
            .Where (n => n.Date <= enddate.Date);

to be more readable, and compare just the date part (ignore time)

answered Sep 17, 2016 at 11:22

Mohamed Badr

2,6722 gold badges29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mahbubur Rahman Manik · Accepted Answer · 2016-09-17 17:41:51Z

1

If you don't want to change the parameter type, this is also fine.

public ActionResult AdvanceSearch(string HeadTitle, string fulltext, string firstdate, string enddate, string newstype)
{
    var q = db.Tbl_News
        .Where (n => n.HeadTitle.Contains(HeadTitle) 
        .Where (n => n.FullText.Contains(fulltext)) 
        .Where (n => n.Date >= DateTime.ParseExact(firstdate, "MM/dd/yyyy", CultureInfo.InvariantCulture))
        .Where (n => n.Date <= DateTime.ParseExact(enddate, "MM/dd/yyyy", CultureInfo.InvariantCulture));
}

answered Sep 17, 2016 at 17:41

Mahbubur Rahman Manik

5,1813 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

Advanced search between two dates in ASP.NET MVC 5

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related