List view in MVC with Date Parameter

Raju Fodse

8y1.2k.NET

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>Cuttingh2>
<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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raju Fodse8y ago
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 Fodse8y ago
Hi Piyush,

I still get same error. Would you take my pc remotely or any other solution
Piyush Pansuriya8y ago
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);
Raju Fodse8y ago
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 Kumar8y ago
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
Piyush Pansuriya8y ago
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);

List view in MVC with Date Parameter

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