Date wise data search in mvc

Question

When i select Company name in dropdown then after From date & To Date select and display all data of selected company between selected date.   ans quickly please.... give me ans for only MVC not in simple asp   Thanx

Kaushik Dhameliya · Answer

Hello Rajesh   Follow below url for getting data between two dates   https://stackoverflow.com/questions/2237440/c-sharp-linq-where-date-between-2-dates   Try this public ActionResult Getdata(Model objModel) {     Db.Employee.Where(x => x.CompanyName == objModel.CompanyName && (x.Start.Date >=  objModel.StartDate.Date && x.Start.Date }

Ramesh Palanivel · Answer

Hi Rajesh,   Please try the  below code,   public  ActionResult GetFilteredRecord( string  companyname,DateTime from,DateTime to)   {   var result=DbContext.CompanyDetails(x=>x.CompanyName.toUpper()==companyname.toUpper() && x.FromDate>=from && x.To return  json(result,JsonRequestBehaviour.AllowGet);   }