public ActionResult Edit(int id) { Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindByPK(id); FaktorBorongan model = new FaktorBorongan(dbitem); ViewBag.name = model.IdJenisTruck; return(View("Form", model)); }
public void delete(FaktorBorongan dbitem, int id) { context.FaktorBorongan.Remove(dbitem); var query = "DELETE FROM dbo.\"FaktorBorongan\" WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Faktor Borongan", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); context.SaveChanges(); }
public void save(FaktorBorongan dbitem, int id, FaktorBoronganHistory fbh) { string hstq = "INSERT INTO dbo.\"FaktorBoronganHistory\" (\"IdFaktorBorongan\", \"IdMasterPool\", \"IdJenisTruck\", \"RasioDlmKota\", \"RasioDlmKota2\", \"RasioJawaBali\", \"RasioSumatra\", \"RasioKosong\", " + "\"RasioSolar\", \"UangMakanJawaBali\", \"UangMakanSumatra\", \"FaktorPengaliGaji\", \"FaktorPengaliTips\", \"PotonganDriver1\", \"PotonganDriver2\", \"BiayaKapalBali\", \"BiayaKapalBaliNTB\", " + "\"BiayaKapalSumatra\", \"BiayaKapalKalimantan\", \"BiayaKapalSulawesi\", \"Tanggal\", username) VALUES (" + fbh.IdFaktorBorongan + ", " + fbh.IdMasterPool + ", " + fbh.IdJenisTruck + ", " + fbh.RasioDlmKota + ", " + fbh.RasioDlmKota2 + ", " + fbh.RasioJawaBali + ", " + fbh.RasioSumatra + ", " + fbh.RasioKosong + ", " + fbh.RasioSolar + ", " + fbh.UangMakanJawaBali + ", " + fbh.UangMakanSumatra + ", " + fbh.FaktorPengaliGaji + ", " + fbh.FaktorPengaliTips + ", " + fbh.PotonganDriver1 + ", " + fbh.PotonganDriver2 + ", " + fbh.BiayaKapalBali + ", " + fbh.BiayaKapalBaliNTB + ", " + fbh.BiayaKapalSumatra + ", " + fbh.BiayaKapalKalimantan + ", " + fbh.BiayaKapalSulawesi + ", " + fbh.Tanggal + ", " + fbh.username + ");"; if (dbitem.Id == 0) //create { context.FaktorBorongan.Add(dbitem); var query = "INSERT INTO dbo.\"FaktorBorongan\" (\"IdMasterPool\", \"IdJenisTruck\", \"RasioDlmKota\", \"RasioDlmKota2\", \"RasioJawaBali\", \"RasioSumatra\", \"RasioKosong\", \"UangMakanJawaBali\", " + "\"UangMakanSumatra\", \"FaktorPengaliGaji\", \"FaktorPengaliTips\", \"PotonganDriver1\", \"PotonganDriver2\", \"BiayaKapalBali\", \"BiayaKapalBaliNTB\", \"BiayaKapalSumatra\", " + "\"BiayaKapalKalimantan\", \"BiayaKapalSulawesi\") VALUES (" + dbitem.IdMasterPool + ", " + dbitem.IdJenisTruck + ", " + dbitem.RasioDlmKota + ", " + dbitem.RasioDlmKota2 + ", " + dbitem.RasioJawaBali + ", " + dbitem.RasioSumatra + ", " + dbitem.RasioKosong + ", " + dbitem.UangMakanJawaBali + ", " + dbitem.UangMakanSumatra + ", " + dbitem.FaktorPengaliGaji + ", " + dbitem.FaktorPengaliTips + ", " + dbitem.PotonganDriver1 + ", " + dbitem.PotonganDriver2 + ", " + dbitem.BiayaKapalBali + ", " + dbitem.BiayaKapalBaliNTB + ", " + dbitem.BiayaKapalSumatra + ", " + dbitem.BiayaKapalKalimantan + ", " + dbitem.BiayaKapalSulawesi + ");"; var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Faktor Borongan", QueryDetail = query + hstq, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); } else //edit { context.FaktorBorongan.Attach(dbitem); var query = "UPDATE dbo.\"FaktorBorongan\" SET \"IdMasterPool\" = " + dbitem.IdMasterPool + ", \"IdJenisTruck\" = " + dbitem.IdJenisTruck + ", \"RasioDlmKota\" = " + dbitem.RasioDlmKota + ", \"RasioDlmKota2\" = " + dbitem.RasioDlmKota2 + ", \"RasioJawaBali\" = " + dbitem.RasioJawaBali + ", \"RasioSumatra\" = " + dbitem.RasioSumatra + ", \"RasioKosong\" = " + dbitem.RasioKosong + ", \"UangMakanJawaBali\" = " + dbitem.UangMakanJawaBali + ", \"UangMakanSumatra\" = " + dbitem.UangMakanSumatra + ", \"FaktorPengaliGaji\" = " + dbitem.FaktorPengaliGaji + ", \"FaktorPengaliTips\" = " + dbitem.FaktorPengaliTips + ", \"PotonganDriver1\" = " + dbitem.PotonganDriver1 + ", \"PotonganDriver2\" = " + dbitem.PotonganDriver2 + ", \"BiayaKapalBali\" = " + dbitem.BiayaKapalBali + ", \"BiayaKapalBaliNTB\" = " + dbitem.BiayaKapalBaliNTB + ", \"BiayaKapalSumatra\" = " + dbitem.BiayaKapalSumatra + ", \"BiayaKapalKalimantan\" = " + dbitem.BiayaKapalKalimantan + ", \"BiayaKapalSulawesi\" = " + dbitem.BiayaKapalSulawesi + " WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Faktor Borongan", QueryDetail = query + hstq, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public ActionResult Edit(FaktorBorongan model) { if (ModelState.IsValid) { if (RepoFaktorBorongan.isExist(model.IdMasterPool.Value, model.IdJenisTruck.Value, model.Id)) { ModelState.AddModelError("IdMasterPool", "Alokasi Pool dan Jenis Truk sudah terdaftar."); ModelState.AddModelError("IdJenisTruck", "Alokasi Pool dan Jenis Truk sudah terdaftar."); return(View("Form", model)); } Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindByPK(model.Id); model.SetDb(dbitem); Context.FaktorBoronganHistory dbitemHistory = new Context.FaktorBoronganHistory(); model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + ' ' + UserPrincipal.lastname); dbitem.FaktorBoronganHistory.Add(dbitemHistory); RepoFaktorBorongan.save(dbitem, UserPrincipal.id, dbitemHistory); return(RedirectToAction("Index")); } return(View("Form", model)); }
public ActionResult Add() { FaktorBorongan model = new FaktorBorongan(); return(View("Form", model)); }