public void setDb(Context.Removal dbitem) { List <string> listBor = new List <string>(); foreach (var item in ModelListBorongan.Where(d => d.IsDelete == false)) { listBor.Add(item.IdDataBorongan.Value.ToString()); } dbitem.IdDataBorongan = string.Join(",", listBor); dbitem.NilaiBorongan = NilaiBorongan; dbitem.Kawalan = Kawalan; dbitem.Timbangan = Timbangan; dbitem.Karantina = Karantina; dbitem.SPSI = SPSI; dbitem.Multidrop = Multidrop; dbitem.TotalBorongan = TotalBorongan; dbitem.KeteranganAdmin = KeteranganAdmin; dbitem.IdDriver1 = IdDriver1; dbitem.IdDriver2 = IdDriver2; dbitem.KasbonDriver1 = KasbonDriver1; dbitem.KasbonDriver2 = KasbonDriver2; dbitem.TotalKasbon = TotalKasbon; dbitem.KlaimDriver1 = KlaimDriver1; dbitem.KlaimDriver2 = KlaimDriver2; dbitem.TotalKlaim = TotalKlaim; dbitem.TotalPotonganDriver = TotalPotonganDriver; dbitem.RemovalTambahanRute.Clear(); foreach (AdminUangJalanTambahanRute item in ModelListTambahanRute.Where(d => d.IsDelete == false)) { dbitem.RemovalTambahanRute.Add(item.setDb(new Context.RemovalTambahanRute())); } dbitem.RemovalTambahanLain.Clear(); foreach (AdminUangJalanTambahanLain item in ModelListTambahanLain.Where(d => d.IsDelete == false)) { dbitem.RemovalTambahanLain.Add(item.setDb(new Context.RemovalTambahanLain())); } dbitem.RemovalPotonganDriver.Clear(); foreach (AdminUangJalanPotonganLain item in ModelListPotonganLain.Where(d => d.IsDelete == false)) { dbitem.RemovalPotonganDriver.Add(item.setDb(new Context.RemovalPotonganDriver())); } dbitem.RemovalVoucherSpbu.Clear(); foreach (AdminUangJalanVoucherSpbu item in ModelListSpbu) { dbitem.RemovalVoucherSpbu.Add(item.setDb(new Context.RemovalVoucherSpbu())); } dbitem.RemovalVoucherKapal.Clear(); foreach (AdminUangJalanVoucherKapal item in ModelListKapal) { dbitem.RemovalVoucherKapal.Add(item.setDb(new Context.RemovalVoucherKapal())); } dbitem.RemovalUangTf.Clear(); foreach (AdminUangJalanUangTf item in ModelListTf) { dbitem.RemovalUangTf.Add(item.setDb(new Context.RemovalUangTf())); } dbitem.TotalAlokasi = TotalAlokasi; }
public Kasirkas(Context.Removal dbitem) { Context.RemovalUangTf dbkas = dbitem.RemovalUangTf.Where(n => n.Keterangan == "Tunai").FirstOrDefault(); if (dbkas != null) { IdRemoval = dbitem.Id; IdSalesOrder = dbitem.IdSO; if (dbitem.Status == "settlement") { Status = "Close"; } else { Status = dbkas.isTf ? "Sudah" : "Belum"; } Jumlah = dbkas.Value; Realisasi = dbkas.JumlahTransfer; Waktu = dbkas.TanggalAktual + dbkas.JamAktual; Tanggal = dbkas.Tanggal; Penerima = dbkas.IdDriverPenerima.HasValue ? dbkas.Driver.NamaDriver : ""; ModifiedDate = dbitem.ModifiedDate; if (dbitem.SalesOrder.SalesOrderOncallId.HasValue) { DnNo = dbitem.SalesOrder.SalesOrderOncall.DN; SoNo = dbitem.SalesOrder.SalesOrderOncall.SONumber; IdChild = dbitem.SalesOrder.SalesOrderOncallId.Value; IdDriver = dbitem.SalesOrder.SalesOrderOncall.Driver1.KodeDriver; Driver = dbitem.SalesOrder.SalesOrderOncall.Driver1.NamaDriver; VehicleNo = dbitem.SalesOrder.SalesOrderOncall.DataTruck.VehicleNo; Customer = dbitem.SalesOrder.SalesOrderOncall.Customer.CustomerNama; TanggalJalan = dbitem.SalesOrder.SalesOrderOncall.TanggalMuat; } else if (dbitem.SalesOrder.SalesOrderPickupId.HasValue) { DnNo = dbitem.SalesOrder.SalesOrderPickup.SONumber; IdChild = dbitem.SalesOrder.SalesOrderPickupId.Value; IdDriver = dbitem.SalesOrder.SalesOrderPickup.Driver1.KodeDriver; Driver = dbitem.SalesOrder.SalesOrderPickup.Driver1.NamaDriver; VehicleNo = dbitem.SalesOrder.SalesOrderPickup.DataTruck.VehicleNo; Customer = dbitem.SalesOrder.SalesOrderPickup.Customer.CustomerNama; TanggalJalan = dbitem.SalesOrder.SalesOrderPickup.TanggalOrder; } else if (dbitem.SalesOrder.SalesOrderProsesKonsolidasiId.HasValue) { DnNo = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.DN; SoNo = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.SONumber; IdChild = dbitem.SalesOrder.SalesOrderProsesKonsolidasiId.Value; IdDriver = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.Driver1.KodeDriver; Driver = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.Driver1.NamaDriver; VehicleNo = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo; TanggalJalan = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.TanggalMuat; } } }
public KasirTf(Context.Removal dbitem) { IdSalesOrder = dbitem.IdSO; IdRemoval = dbitem.Id; Jumlah = 0; Realisasi = 0; if (dbitem.Status == "settlement") { Status = "Close"; } else if ((dbitem.RemovalUangTf.Where(s => s.Keterangan != "Tunai").Any(n => n.isTf == false)) && (dbitem.RemovalUangTf.Where(s => s.Keterangan != "Tunai").Any(n => n.isTf == true))) { Status = "On Progress"; } else if (dbitem.RemovalUangTf.Where(s => s.Keterangan != "Tunai").Any(n => n.isTf == false)) { Status = "Belum"; } else { Status = "Sudah"; } Waktu = dbitem.RemovalUangTf.Where(d => d.TanggalAktual != null).OrderByDescending(t => t.TanggalAktual).Select(t => t.TanggalAktual).FirstOrDefault(); Tanggal = dbitem.RemovalUangTf.Where(d => d.TanggalAktual != null).OrderByDescending(t => t.TanggalAktual).Select(t => t.Tanggal).FirstOrDefault(); ModifiedDate = dbitem.ModifiedDate; if (dbitem.SalesOrder.SalesOrderOncallId.HasValue) { DnNo = dbitem.SalesOrder.SalesOrderOncall.DN; SoNo = dbitem.SalesOrder.SalesOrderOncall.SONumber; IdChild = dbitem.SalesOrder.SalesOrderOncallId.Value; IdDriver = dbitem.SalesOrder.SalesOrderOncall.Driver1.KodeDriver; Driver = dbitem.SalesOrder.SalesOrderOncall.Driver1.NamaDriver; VehicleNo = dbitem.SalesOrder.SalesOrderOncall.DataTruck.VehicleNo; Customer = dbitem.SalesOrder.SalesOrderOncall.Customer.CustomerNama; foreach (var item in dbitem.RemovalUangTf.Where(n => n.Keterangan != "Tunai")) { Jumlah = Jumlah + item.Value; Realisasi = Realisasi + item.JumlahTransfer; } TanggalJalan = dbitem.SalesOrder.SalesOrderOncall.TanggalMuat; } else if (dbitem.SalesOrder.SalesOrderPickupId.HasValue) { DnNo = dbitem.SalesOrder.SalesOrderPickup.SONumber; IdChild = dbitem.SalesOrder.SalesOrderPickupId.Value; IdDriver = dbitem.SalesOrder.SalesOrderPickup.Driver1.KodeDriver; Driver = dbitem.SalesOrder.SalesOrderPickup.Driver1.NamaDriver; VehicleNo = dbitem.SalesOrder.SalesOrderPickup.DataTruck.VehicleNo; Customer = dbitem.SalesOrder.SalesOrderPickup.Customer.CustomerNama; foreach (var item in dbitem.RemovalUangTf.Where(n => n.Keterangan != "Tunai")) { Jumlah = Jumlah + item.Value; Realisasi = Realisasi + item.JumlahTransfer; } TanggalJalan = dbitem.SalesOrder.SalesOrderPickup.TanggalPickup; } else if (dbitem.SalesOrder.SalesOrderProsesKonsolidasiId.HasValue) { DnNo = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.DN; SoNo = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.SONumber; IdChild = dbitem.SalesOrder.SalesOrderProsesKonsolidasiId.Value; IdDriver = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.Driver1.KodeDriver; Driver = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.Driver1.NamaDriver; VehicleNo = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo; foreach (var item in dbitem.RemovalUangTf.Where(n => n.Keterangan != "Tunai")) { Jumlah = Jumlah + item.Value; Realisasi = Realisasi + item.JumlahTransfer; } TanggalJalan = dbitem.SalesOrder.SalesOrderProsesKonsolidasi.TanggalMuat; } }
public RemovalAUJ(Context.Removal dbitem, List <Context.Atm> listAtm, List <Context.DataBorongan> listBorongan) { Id = dbitem.Id; IdAdminUangJalan = dbitem.IdAdminUangJalan; IdSO = dbitem.IdSO; ModelListTambahanRute = new List <AdminUangJalanTambahanRute>(); foreach (var item in dbitem.RemovalTambahanRute) { ModelListTambahanRute.Add(new AdminUangJalanTambahanRute(item)); } ModelListTambahanLain = new List <AdminUangJalanTambahanLain>(); foreach (var item in dbitem.RemovalTambahanLain) { ModelListTambahanLain.Add(new AdminUangJalanTambahanLain(item)); } ModelListPotonganLain = new List <AdminUangJalanPotonganLain>(); foreach (var item in dbitem.RemovalPotonganDriver) { ModelListPotonganLain.Add(new AdminUangJalanPotonganLain(item)); } ModelListBorongan = new List <AdminUangBorongan>(); if (dbitem.IdDataBorongan != null) { foreach (var item in dbitem.IdDataBorongan.Split(',')) { ModelListBorongan.Add(new AdminUangBorongan() { IdDataBorongan = int.Parse(item), NamaDataBorongan = listBorongan.Where(d => d.Id == int.Parse(item)).FirstOrDefault().NamaBorongan }); } } if (ModelListBorongan.Count == 0) { ModelListBorongan.Add(new AdminUangBorongan()); } NilaiBorongan = dbitem.NilaiBorongan; Kawalan = dbitem.Kawalan; Timbangan = dbitem.Timbangan; Karantina = dbitem.Karantina; SPSI = dbitem.SPSI; Multidrop = dbitem.Multidrop; TotalBorongan = dbitem.TotalBorongan; KeteranganAdmin = dbitem.KeteranganAdmin; KeteranganRemoval = dbitem.KeteranganRemoval; IdDriver1 = dbitem.IdDriver1; NamaDriver1 = dbitem.IdDriver1.HasValue ? dbitem.Driver1.KodeDriver + " - " + dbitem.Driver1.NamaDriver : ""; IdDriver2 = dbitem.IdDriver2; NamaDriver2 = dbitem.IdDriver2.HasValue ? dbitem.Driver2.KodeDriver + " - " + dbitem.Driver2.NamaDriver : ""; TotalKasbon = dbitem.TotalKasbon; KasbonDriver1 = dbitem.KasbonDriver1; KasbonDriver2 = dbitem.KasbonDriver2; TotalKlaim = dbitem.TotalKlaim; KlaimDriver1 = dbitem.KlaimDriver1; KlaimDriver2 = dbitem.KlaimDriver2; TotalPotonganDriver = dbitem.TotalPotonganDriver; Status = dbitem.Status; ModelListSpbu = new List <AdminUangJalanVoucherSpbu>(); foreach (var item in dbitem.RemovalVoucherSpbu) { ModelListSpbu.Add(new AdminUangJalanVoucherSpbu(item)); } ModelListKapal = new List <AdminUangJalanVoucherKapal>(); foreach (var item in dbitem.RemovalVoucherKapal) { ModelListKapal.Add(new AdminUangJalanVoucherKapal(item)); } ModelListTf = new List <AdminUangJalanUangTf>(); foreach (var item in dbitem.RemovalUangTf) { ModelListTf.Add(new AdminUangJalanUangTf(item, listAtm)); } TotalAlokasi = dbitem.TotalAlokasi; if (listAtm.Any(d => d.IdDriver == IdDriver1)) { DummyAtm = new Atm(listAtm.Where(d => d.IdDriver == IdDriver1).FirstOrDefault()); } if (dbitem.SalesOrder.SalesOrderOncallId.HasValue) { ModelOncall = new SalesOrderOncall(dbitem.SalesOrder); } else if (dbitem.SalesOrder.SalesOrderPickupId.HasValue) { ModelPickup = new SalesOrderPickup(dbitem.SalesOrder); } else if (dbitem.SalesOrder.SalesOrderProsesKonsolidasiId.HasValue) { ModelKonsolidasi = new SalesOrderProsesKonsolidasi(dbitem.SalesOrder); } }