[HttpPost] public ActionResult GetVehicleAndLubesWiseReport(IssueItemsReport issuedItem)
{
var dtIssuedSpares = _helper.ExecuteSelectStmtForDateTime("report_vehiclewise_lubeswise", "@sdate", issuedItem.StartDate.ToString(), "@edate", issuedItem.EndDate.ToString(), null, null, "@lbid", issuedItem.Sparesid.ToString(), null, null, null, null, "@veno", issuedItem.VehicleNumber);
var list = JsonConvert.SerializeObject(dtIssuedSpares, Formatting.None, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Content(list, "application/json"));
}
[HttpPost] public ActionResult GetIssuedSparesByPartNumber(IssueItemsReport issuedItem)
{
var dtIssuedSpares = _helper.ExecuteSelectStmtForDateTime("report_sparepart_issue", "@sdate", issuedItem.StartDate.ToString(), "@edate", issuedItem.EndDate.ToString(), null, null, "@SPID", issuedItem.Sparesid.ToString());
var list = JsonConvert.SerializeObject(dtIssuedSpares, Formatting.None, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Content(list, "application/json"));
}
