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