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