[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")); }