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