List view in MVC with Date Parameter

Question

I am new in MVC. I want list view to generate by passing Date Parameter in controller; But I got error please help me solve the problem. my controller code is

LPDBContext DB = new LPDBContext();
var items = db.Processes.Where(x =>x.PRDate.ToShortDateString().Equals(08 / 09 / 2018)).ToList();
return View(items);

My List View code is

@model IEnumerable<EasyApp.Models.Process>
@{
ViewBag.Title = "ExportP3List";
Layout = "~/Views/Shared/_Layout.cshtml";
}
<div class="EasyViewDiv table-responsive">
<h2>Cutting</h2>
<table style="font-size:smaller;" class="table table-bordered">
<tr>
<th>
Production Date
</th>
<th>
In-Out Time
</th>
<th>
Employer
</th>
<th>
Operator Name
</th>
<th>
WO No
</th>
<th>
OD
</th>
<th>
Thk
</th>
<th>
Specification
</th>
<th>
Pipe No
</th>
<th>
Length
</th>
<th>
MT
</th>
<th>
Actual Meter
</th>
<th>
Time Taken
</th>
<th>
Speed
</th>
</tr>
@foreach (var item in Model)
{
<tr>
<td>
@Html.DisplayFor(modelItem => item.PRDate)
</td>
<td>
@Html.DisplayFor(modelItem => item.Atten.INTIME) TO @Html.DisplayFor(modelItem => item.Atten.OUTIME)
</td>
<td>
@Html.DisplayFor(modelItem => item.Atten.Emp.CompanyID)
</td>
<td>
@Html.DisplayFor(modelItem => item.Atten.Emp.EmpName)
</td>
<td>
@Html.DisplayFor(modelItem => item.PipeAl.Order.WONO)
</td>
<td>
@Html.DisplayFor(modelItem => item.PipeAl.Order.DIA)
</td>
<td>
@Html.DisplayFor(modelItem => item.PipeAl.Order.THK)
</td>
<td>
@Html.DisplayFor(modelItem => item.PipeAl.Order.PISPEC)
</td>
<td>
@Html.DisplayFor(modelItem => item.PIPENO)
</td>
<td>
@Html.DisplayFor(modelItem => item.PipeAl.LENGTH)
</td>
<td>
@Html.DisplayFor(modelItem => item.PipeAl.MT)
</td>
<td>
@Html.DisplayFor(modelItem => item.ActualMeter)
</td>
<td>
@Html.DisplayFor(modelItem => item.CuttingTime)
</td>
<td>
@Html.DisplayFor(modelItem => item.CuttingSpeed)
</td>
</tr>
}
</table>
</div>

I got following error

LINQ to Entities does not recognize the method 'System.String ToShortDateString()' method, and this method cannot be translated into a store expression.

Piyush Pansuriya · Answer

Hi Raju, I think your Field PRDate should be equivelent to datetime. So, you have to convert it also like.. LPDBContext DB = new LPDBContext(); var items = db.Processes.Where(x => Convert . ToDateTime ( x.PRDate) == Datetime.parse( "08/09/2018" )).ToList(); return View(items);

Piyush Pansuriya · Answer

i Raju, You have to convert date from the string LPDBContext DB = new LPDBContext(); var items = db.Processes.Where(x =>x.PRDate == Datetime.parse( "08/09/2018" )).ToList(); return View(items);

Raju Fodse · Answer

Thanks Piyush, I Change the code accoring to you But still getting error LINQ to Entities does not recognize the method 'System.DateTime Parse(System.String)' method, and this method cannot be translated into a store expression. public ActionResult ExportP3List() /*string ProductionDate*/ { LPDBContext DB = new LPDBContext(); var items = db.Processes.Where(x => x.PRDate == DateTime.Parse( "08/09/2018" )).ToList(); return View(items); }

Vivek Kumar · Answer

Hi raju, Your have to write in correct appraoch. Please find link for better understadning. https://www.c-sharpcorner.com/blogs/exception-linq-to-entities-does-not-recognize-the-method-tostring https://stackoverflow.com/questions/5899683/linq-to-entities-does-not-recognize-the-method-system-string-tostring-method

Raju Fodse · Answer

Hi All, Ultimately I succeed to passing List view in MVC with “Hardcoded” Date Parameter public ActionResult ExportP3List(DateTime FromDate) /*string ProductionDate*/ { LPDBContext DB = new LPDBContext(); FromDate = Convert.ToDateTime( "23/02/2018" ); var items = from s in db.Processes.Where(x => x.StageID.Equals( "P3" )) select s; items = items.Where(s => s.PRDate == FromDate); return View(items); } Now next target is passing Parameters from controller, I tried follwing Code but did not get any result public ActionResult ExportP3List( string SearchString) { //DateTime sDate = Convert.ToDateTime(FromDate); LPDBContext DB = new LPDBContext(); var items = from s in db.Processes.Where(x => x.StageID.Equals( "P3" )) select s; items = items.Where(s => s.PipeAl.Order.PISPEC.Contains(SearchString)); return View(items); }

Raju Fodse · Answer

Hi Piyush, I still get same error. Would you take my pc remotely or any other solution