public DaftarHargaOnCallItem(Context.DaftarHargaOnCallItem dbitem)
{
Id = dbitem.Id;
NamaRuteDaftarHarga = dbitem.NamaRuteDaftarHarga;
ListIdRute = dbitem.ListIdRute;
ListNamaRute = dbitem.ListNamaRute;
NamaJenisTruck = dbitem.JenisTrucks.StrJenisTruck;
IdJenisTruck = dbitem.IdJenisTruck;
MinKg = dbitem.MinKg;
Harga = dbitem.Harga;
IdSatuanHarga = dbitem.IdSatuanHarga;
SatuanHarga = dbitem.LookupCodeSatuan.Nama;
IsAdHoc = dbitem.IsAdHoc;
IsAsuransi = dbitem.IsAsuransi;
PihakPenanggung = dbitem.PihakPenanggung;
TipeNilaiTanggungan = dbitem.TipeNilaiTanggungan;
NilaiTanggungan = (dbitem.NilaiTanggungan.HasValue) ? dbitem.NilaiTanggungan.Value : 0;
Premi = (dbitem.Premi.HasValue) ? dbitem.Premi.Value : 0;
Keterangan = dbitem.Keterangan;
}
public decimal Harga(Context.SalesOrder dbso)
{
Context.DaftarHargaOnCallItem dhocItem = context.DaftarHargaOnCallItem.Where(d => d.Id == dbso.SalesOrderOncall.IdDaftarHargaItem).FirstOrDefault();
Context.DaftarHargaOnCall dhoc = context.DaftarHargaOnCall.Where(d => d.Id == dhocItem.IdDaftarHargaOnCall).FirstOrDefault();
return(dhocItem.Harga + dhoc.DaftarHargaOnCallKondisi.Where(d => d.IsInclude == true && d.IsBill == false && d.value > 0).Sum(d => d.value.Value));
}
public void setDb(Context.DaftarHargaOnCall dbitem)
{
//header
dbitem.Id = Id;
dbitem.IdCust = IdCust;
dbitem.PeriodStart = PeriodStart.Value;
dbitem.PeriodEnd = PeriodEnd.Value;
//item
//dbitem.DaftarHargaOnCallItem.Clear();
DaftarHargaOnCallItem[] result = JsonConvert.DeserializeObject <DaftarHargaOnCallItem[]>(StrItem);
List <Context.DaftarHargaOnCallItem> DummyItems = dbitem.DaftarHargaOnCallItem.ToList();
// edit row
List <int> ListAnuTeuDiHapus = new List <int>();
foreach (DaftarHargaOnCallItem item in result)
{
if (item.Id != 0)
{
Context.DaftarHargaOnCallItem dhkItem = dbitem.DaftarHargaOnCallItem.Where(i => i.IdDaftarHargaOnCall == dbitem.Id && i.Id == item.Id).FirstOrDefault();
dhkItem.Id = item.Id;
dhkItem.NamaRuteDaftarHarga = item.NamaRuteDaftarHarga;
dhkItem.ListIdRute = item.ListIdRute;
dhkItem.ListNamaRute = item.ListNamaRute;
dhkItem.IdJenisTruck = item.IdJenisTruck;
dhkItem.MinKg = item.MinKg;
dhkItem.Harga = item.Harga;
dhkItem.IdSatuanHarga = item.IdSatuanHarga;
dhkItem.IsAsuransi = item.IsAsuransi;
dhkItem.IsAdHoc = item.IsAdHoc;
dhkItem.PihakPenanggung = item.PihakPenanggung;
dhkItem.TipeNilaiTanggungan = item.TipeNilaiTanggungan;
dhkItem.NilaiTanggungan = item.NilaiTanggungan;
dhkItem.Premi = item.Premi;
dhkItem.Keterangan = item.Keterangan;
ListAnuTeuDiHapus.Add(item.Id);
}
else
{
dbitem.DaftarHargaOnCallItem.Add(new Context.DaftarHargaOnCallItem()
{
//Id = item.Id,
NamaRuteDaftarHarga = item.NamaRuteDaftarHarga,
ListIdRute = item.ListIdRute,
ListNamaRute = item.ListNamaRute,
IdJenisTruck = item.IdJenisTruck,
MinKg = item.MinKg,
Harga = item.Harga,
IdSatuanHarga = item.IdSatuanHarga,
IsAsuransi = item.IsAsuransi,
IsAdHoc = item.IsAdHoc,
PihakPenanggung = item.PihakPenanggung,
TipeNilaiTanggungan = item.TipeNilaiTanggungan,
NilaiTanggungan = item.NilaiTanggungan,
Premi = item.Premi,
Keterangan = item.Keterangan
});
}
}
//hapus anu teu dipilih
foreach (Context.DaftarHargaOnCallItem dbhapus in DummyItems)
{
if (!ListAnuTeuDiHapus.Any(d => d == dbhapus.Id))
{
dbitem.DaftarHargaOnCallItem.Remove(dbhapus);
}
}
//kondisi
dbitem.DaftarHargaOnCallKondisi.Clear();
foreach (DaftarHargaKondisi item in listKondisi.Where(d => d.IsDelete == false))
{
dbitem.DaftarHargaOnCallKondisi.Add(new Context.DaftarHargaOnCallKondisi()
{
kondisi = item.kondisi,
IsInclude = item.IsInclude,
IsBill = item.IsBill,
value = item.value,
IsDefault = item.IsDefault,
IsKota = item.IsKota,
IsTitik = item.IsTitik,
ValKota = item.ValKota,
ValTitik = item.ValTitik,
IsDelete = item.IsDelete,
});
}
//Attachment
dbitem.DaftarHargaOnCallAttachment.Clear();
DaftarHargaOnCallAttachment[] resultAtt = JsonConvert.DeserializeObject <DaftarHargaOnCallAttachment[]>(StrAttachment);
foreach (DaftarHargaOnCallAttachment item in resultAtt)
{
dbitem.DaftarHargaOnCallAttachment.Add(new Context.DaftarHargaOnCallAttachment()
{
FileName = item.FileName,
RFileName = item.RFileName,
});
}
}
