public string GetTruckImport(int idSo)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByKontrak(idSo);
List <DataTruckDetail> model = new List <DataTruckDetail>();
foreach (Context.SalesOrderKontrakTruck item in dbitem.SalesOrderKontrak.SalesOrderKontrakTruck)
{
model.Add(new DataTruckDetail(item.DataTruck, null, RepoSalesOrder.FindAll()));
}
return(new JavaScriptSerializer().Serialize(model));
}
public string CheckArea(int id)
{
Context.SalesOrder dbso = RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && d.SalesOrderOncall.IdDataTruck == id) || (d.SalesOrderPickupId.HasValue && d.SalesOrderPickup.IdDataTruck == id) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && d.SalesOrderProsesKonsolidasi.IdDataTruck == id) ||
(d.SalesOrderKontrakId.HasValue && d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == id))
)
).FirstOrDefault();
if (dbso.SalesOrderOncallId.HasValue)
{
return(new JavaScriptSerializer().Serialize(new { area = RepoSalesOrder.FindArea(dbso.SalesOrderOncall.IdDaftarHargaItem.Value) }));
}
return(null);
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.SalesOrder> items = RepoSalesOrder.FindAll().Where(d => d.SalesOrderKonsolidasiId == null).ToList();
List <ListOrder> ListModel = new List <ListOrder>();
foreach (Context.SalesOrder item in items)
{
if (item.SalesOrderKontrakId.HasValue)
{
if (item.SalesOrderKontrak.SalesOrderKontrakListSo.Any(p => p.IsProses))
{
foreach (var itemKontrak in item.SalesOrderKontrak.SalesOrderKontrakListSo.Where(s => s.Status != null && s.Status != "").GroupBy(d => new { d.IdDataTruck, d.Driver1Id, d.Status, d.Urutan }).Select(grp => grp.ToList()))
{
foreach (var itemKontrakPerOrder in itemKontrak.OrderBy(t => t.MuatDate).ToList())
{
ListModel.Add(new ListOrder(item, itemKontrakPerOrder));
}
}
}
else
{
ListModel.Add(new ListOrder(item));
}
}
else
{
ListModel.Add(new ListOrder(item));
}
}
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count, data = ListModel }));
}
public string Binding()
{
List <Context.SalesOrder> items = RepoSalesOrder.FindAll().Where(d =>
(d.SalesOrderOncallId != null || d.SalesOrderProsesKonsolidasiId != null || d.SalesOrderPickupId != null) &&
(d.Status == "save planning" || d.Status == "draft konfirmasi")).ToList();
List <ListOrder> ListModel = new List <ListOrder>();
foreach (Context.SalesOrder item in items)
{
ListModel.Add(new ListOrder(item));
}
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count(), data = ListModel }));
}
