public JsonResult PendingDeliveryTableSummary(string DepartmentId, string SectionId, string YearId, string MonthId, string MatNameId) { // add IEnumerable<DeliveryOntimeSummaryViewModels> List<PendingDeliveryViewModels> viewSummaryModel = new List<PendingDeliveryViewModels>(); //filter department var q = from d in objBs.ontimePendingBs.GetByFilter(DepartmentId, SectionId, Convert.ToInt32(MonthId), Convert.ToInt32(YearId)) select d; //filter department if (!String.IsNullOrEmpty(DepartmentId)) q = q.Where(x => x.DEPARTMENT_ID == DepartmentId); //filter Section if (!String.IsNullOrEmpty(SectionId)) q = q.Where(x => x.SECTION_ID == SectionId); //filter matname if (!String.IsNullOrEmpty(MatNameId)) q = q.Where(x => x.MATFRIGRP == MatNameId); foreach (var item in q) { PendingDeliveryViewModels model = new PendingDeliveryViewModels(); model.Shipment = item.SHPMNTNO; model.DeliveryNote = item.DELVNO; model.RegionName = item.REGION_NAME_TH; model.SoldtoName = item.SOLDTO_NAME; model.ShiptoName = item.TO_SHPG_LOC_NAME; model.ShippingPoint = item.SHPPOINT; model.TruckType = item.TRUCK_TYPE; if (item.REQUESTED_DATE != null) { model.RequestedDate = item.REQUESTED_DATE.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); } else { model.RequestedDate = ""; } if (item.ORDCMPDATE != null) { model.OrderCompDate = item.ORDCMPDATE.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); } else { model.OrderCompDate = ""; } if (item.SHCRDATE != null) { model.ShcrDate = item.SHCRDATE.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); } else { model.ShcrDate = ""; } model.PlanDelivery = item.PLNONTIMEDATE_D.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); model.Delays = item.DATEDIFF.ToString(); viewSummaryModel.Add(model); } return Json(viewSummaryModel, JsonRequestBehavior.AllowGet); }
public JsonResult PendingDeliveryTableSummary(string DepartmentId, string SectionId, string YearId, string MonthId, string MatNameId) { // add IEnumerable<DeliveryOntimeSummaryViewModels> List <PendingDeliveryViewModels> viewSummaryModel = new List <PendingDeliveryViewModels>(); //filter department var q = from d in objBs.ontimePendingBs.GetByFilter(DepartmentId, SectionId, Convert.ToInt32(MonthId), Convert.ToInt32(YearId)) select d; //filter department if (!String.IsNullOrEmpty(DepartmentId)) { q = q.Where(x => x.DEPARTMENT_ID == DepartmentId); } //filter Section if (!String.IsNullOrEmpty(SectionId)) { q = q.Where(x => x.SECTION_ID == SectionId); } //filter matname if (!String.IsNullOrEmpty(MatNameId)) { q = q.Where(x => x.MATFRIGRP == MatNameId); } foreach (var item in q) { PendingDeliveryViewModels model = new PendingDeliveryViewModels(); model.Shipment = item.SHPMNTNO; model.DeliveryNote = item.DELVNO; model.RegionName = item.REGION_NAME_TH; model.SoldtoName = item.SOLDTO_NAME; model.ShiptoName = item.TO_SHPG_LOC_NAME; model.ShippingPoint = item.SHPPOINT; model.TruckType = item.TRUCK_TYPE; if (item.REQUESTED_DATE != null) { model.RequestedDate = item.REQUESTED_DATE.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); } else { model.RequestedDate = ""; } if (item.ORDCMPDATE != null) { model.OrderCompDate = item.ORDCMPDATE.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); } else { model.OrderCompDate = ""; } if (item.SHCRDATE != null) { model.ShcrDate = item.SHCRDATE.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); } else { model.ShcrDate = ""; } model.PlanDelivery = item.PLNONTIMEDATE_D.Value.ToString("dd/MM/yyyy HH:mm", new CultureInfo("th-TH")); model.Delays = item.DATEDIFF.ToString(); viewSummaryModel.Add(model); } return(Json(viewSummaryModel, JsonRequestBehavior.AllowGet)); }