public ActionResult Edit(int id) { Context.DaftarHargaOnCall dbitem = RepoDHO.FindByPK(id); DaftarHargaOnCall model = new DaftarHargaOnCall(dbitem); ViewBag.name = model.NamaCustomer; return(View("Form", model)); }
public void delete(DaftarHargaOnCall dbitem) { context.DaftarHargaOnCall.Remove(dbitem); var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Daftar Harga Oncall", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); context.SaveChanges(); }
public void FindRuteTruk(int id, out string IdRute, out int idJenisTruk) { try { DaftarHargaOnCall db = context.DaftarHargaOnCall.Where(d => d.DaftarHargaOnCallItem.Any(i => i.Id == id)).FirstOrDefault(); DaftarHargaOnCallItem dbitem = db.DaftarHargaOnCallItem.Where(i => i.Id == id).FirstOrDefault(); IdRute = dbitem.ListIdRute; idJenisTruk = dbitem.IdJenisTruck; } catch (Exception) { IdRute = ""; idJenisTruk = -1; } }
public void save(DaftarHargaOnCall dbitem) { if (dbitem.Id == 0) //create { context.DaftarHargaOnCall.Add(dbitem); var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Daftar Harga Oncall", QueryDetail = "Add " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); } else //edit { context.DaftarHargaOnCall.Attach(dbitem); var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Daftar Harga Oncall", QueryDetail = "Edit " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public ActionResult Add(DaftarHargaOnCall model) { //validasi kondisi int idx = 0; foreach (DaftarHargaKondisi item in model.listKondisi.Where(d => d.IsDelete == false)) { if (item.kondisi != "Biaya Multidrop" && item.IsDefault == true && item.IsInclude == true && item.IsBill == false && item.value == null) { ModelState.AddModelError("listKondisi[" + idx + "].value", "Nilai harus diisi."); } if (item.kondisi == "Biaya Multidrop" && item.IsKota == true && item.ValKota == null) { ModelState.AddModelError("listKondisi[" + idx + "].ValKota", "Nilai harus diisi."); } if (item.kondisi == "Biaya Multidrop" && item.IsTitik == true && item.ValTitik == null) { ModelState.AddModelError("listKondisi[" + idx + "].ValTitik", "Nilai harus diisi."); } if (item.IsDefault == false) { if (item.kondisi == "" || item.kondisi == null) { ModelState.AddModelError("listKondisi[" + idx + "].kondisi", "Nama kondisi harus diisi."); } if (item.IsInclude == true && item.IsBill == false && item.value == null) { ModelState.AddModelError("listKondisi[" + idx + "].value", "Nilai harus diisi."); } } idx++; } DaftarHargaOnCallItem[] result = JsonConvert.DeserializeObject <DaftarHargaOnCallItem[]>(model.StrItem); model.listItem = result.ToList(); DaftarHargaOnCallAttachment[] resultAtt = JsonConvert.DeserializeObject <DaftarHargaOnCallAttachment[]>(model.StrAttachment); model.listAtt = resultAtt.ToList(); if (ModelState.IsValid) { bool palid = true; if (RepoDHO.IsPeriodValid(model.PeriodStart.Value, model.PeriodEnd.Value, model.IdCust.Value)) { ModelState.AddModelError("PeriodStart", "Periode awal tidak boleh overlaping."); ModelState.AddModelError("PeriodEnd", "Periode akhir tidak boleh overlaping."); palid = false; } if (!palid) { return(View("Form", model)); } Context.DaftarHargaOnCall dbitem = new Context.DaftarHargaOnCall(); model.setDb(dbitem); RepoDHO.save(dbitem); return(RedirectToAction("Index")); } return(View("Form", model)); }
public ActionResult Add() { DaftarHargaOnCall model = new DaftarHargaOnCall(); return(View("Form", model)); }
public ActionResult Edit(DaftarHargaOnCall model) { //validasi kondisi int idx = 0; foreach (DaftarHargaKondisi item in model.listKondisi.Where(d => d.IsDelete == false)) { if (item.kondisi != "Biaya Multidrop" && item.IsDefault == true && item.IsInclude == true && item.IsBill == false && item.value == null) { ModelState.AddModelError("listKondisi[" + idx + "].value", "Nilai harus diisi."); } if (item.kondisi == "Biaya Multidrop" && item.IsKota == true && item.ValKota == null) { ModelState.AddModelError("listKondisi[" + idx + "].ValKota", "Nilai harus diisi."); } if (item.kondisi == "Biaya Multidrop" && item.IsTitik == true && item.ValTitik == null) { ModelState.AddModelError("listKondisi[" + idx + "].ValTitik", "Nilai harus diisi."); } if (item.IsDefault == false) { if (item.kondisi == "" || item.kondisi == null) { ModelState.AddModelError("listKondisi[" + idx + "].kondisi", "Nama kondisi harus diisi."); } if (item.IsInclude == true && item.IsBill == false && item.value == null) { ModelState.AddModelError("listKondisi[" + idx + "].value", "Nilai harus diisi."); } } idx++; } if (RepoDHO.IsPeriodValid(model.PeriodStart.Value, model.PeriodEnd.Value, model.IdCust.Value, model.Id)) { ModelState.AddModelError("PeriodStart", "Periode awal tidak boleh overlaping."); ModelState.AddModelError("PeriodEnd", "Periode akhir tidak boleh overlaping."); } //if (RepoDHO.IsUsedPrices(model.Id)) //{ // //ModelState.AddModelError("PeriodStart", "Periode awal tidak boleh overlaping."); // ViewBag.errorMsg = "Daftar Harga sudah digunakan, Proses tidak dapat dilanjutkan"; // return View("Form", model); //} if (ModelState.IsValid) { Context.DaftarHargaOnCall dbitem = RepoDHO.FindByPK(model.Id); model.setDb(dbitem); RepoDHO.save(dbitem); return(RedirectToAction("Index")); } ViewBag.name = model.NamaCustomer; DaftarHargaOnCallItem[] result = JsonConvert.DeserializeObject <DaftarHargaOnCallItem[]>(model.StrItem); model.listItem = result.ToList(); DaftarHargaOnCallAttachment[] resultAtt = JsonConvert.DeserializeObject <DaftarHargaOnCallAttachment[]>(model.StrAttachment); model.listAtt = resultAtt.ToList(); return(View("Form", model)); }