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