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