public ActionResult Edit(int id) { Context.PenetapanDriver dbitem = RepoPenetapanDriver.FindByPK(id); PenetapanDriver model = new PenetapanDriver(dbitem); ViewBag.name = model.VehicleNo; return(View("Form", model)); }
public void delete(PenetapanDriver dbitem) { context.PenetapanDriver.Remove(dbitem); var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Penetapan Driver", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); context.SaveChanges(); }
public void save(PenetapanDriver dbitem) { if (dbitem.Id == 0) //create { context.PenetapanDriver.Add(dbitem); var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Penetapan Driver", QueryDetail = "Add " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); } else //edit { context.PenetapanDriver.Attach(dbitem); var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Penetapan Driver", 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(PenetapanDriver model) { if (ModelState.IsValid) { bool isPalid = true; if (RepoPenetapanDriver.IsExist(model.IdDataTruck.Value)) { isPalid = false; ModelState.AddModelError("IdDataTruck", "Data truck sudah digunakan."); } if (RepoPenetapanDriver.isExistDriver(model.IdDriver1.Value, 0)) { isPalid = false; ModelState.AddModelError("idDriver1", "Driver sudah digunakan."); } if (model.IdDriver2.HasValue) { if (RepoPenetapanDriver.isExistDriver(model.IdDriver2.Value, 0)) { isPalid = false; ModelState.AddModelError("IdDriver2", "Driver sudah digunakan."); } if (model.IdDriver1 == model.IdDriver2) { isPalid = false; ModelState.AddModelError("IdDriver1", "Driver tidak boleh sama."); ModelState.AddModelError("IdDriver2", "Driver tidak boleh sama."); } if (model.IdDitetapkanOleh2 == null) { isPalid = false; ModelState.AddModelError("IdDitetapkanOleh2", "Penetap Driver 2 Belum Ditentukan."); } } if (model.IdDitetapkanOleh1 == null) { isPalid = false; ModelState.AddModelError("IdDitetapkanOleh1", "Penetap Driver 1 Belum Ditentukan."); } if (!isPalid) { return(View("Form", model)); } Context.PenetapanDriver dbitem = new Context.PenetapanDriver(); Context.PenetapanDriverHistory dbitemHistory = new Context.PenetapanDriverHistory(); //history model.SetDb(dbitem, UserPrincipal.firstname + ' ' + UserPrincipal.lastname); model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname); dbitemHistory.CreatedBy = UserPrincipal.firstname + " " + UserPrincipal.lastname; dbitemHistory.CreatedDate = DateTime.Now; dbitem.PenetapanDriverHistory.Add(dbitemHistory); //history driver Context.DataTruck dbtruck = RepoTruck.FindByPK(model.IdDataTruck.Value); Context.Driver dbdriver1 = RepoDriver.FindByPK(model.IdDriver1.Value); Context.DriverTruckHistory dbdriverHistory1 = new Context.DriverTruckHistory(); dbdriver1.NoHp1 = model.NoHp1Driver1; dbdriver1.NoHp2 = model.NoHp2Driver1; dbdriverHistory1.Tanggal = DateTime.Now; dbdriverHistory1.Nopol = dbtruck.VehicleNo; dbdriverHistory1.Type = model.JenisTruck; dbdriver1.DriverTruckHistory.Add(dbdriverHistory1); RepoDriver.save(dbdriver1); string query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dbdriver1.NoHp1 + ", \"NoHp2\" = " + dbdriver1.NoHp2 + " WHERE \"Id\" = " + dbdriver1.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" (\"IdDriver\", " + "\"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory1.IdDriver + ", " + dbdriverHistory1.Tanggal + ", " + dbdriverHistory1.Type + ", " + dbdriverHistory1.Nopol + ");"; RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Add", UserPrincipal.id); if (model.IdDriver2.HasValue) { Context.Driver dbdriver2 = RepoDriver.FindByPK(model.IdDriver2.Value); Context.DriverTruckHistory dbdriverHistory2 = new Context.DriverTruckHistory(); dbdriver2.NoHp1 = model.NoHp1Driver2; dbdriver2.NoHp2 = model.NoHp2Driver2; dbdriverHistory2.Tanggal = DateTime.Now; dbdriverHistory2.Nopol = dbtruck.VehicleNo; dbdriverHistory2.Type = model.JenisTruck; dbdriver2.DriverTruckHistory.Add(dbdriverHistory2); RepoDriver.save(dbdriver2); query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dbdriver2.NoHp1 + ", \"NoHp2\" = " + dbdriver2.NoHp2 + " WHERE \"Id\" = " + dbdriver2.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" ( " + "\"IdDriver\", \"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory2.IdDriver + ", " + dbdriverHistory2.Tanggal + ", " + dbdriverHistory2.Type + ", " + dbdriverHistory2.Nopol + ");"; RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Add", UserPrincipal.id); } RepoPenetapanDriver.save(dbitem); return(RedirectToAction("Index")); } return(View("Form", model)); }
public ActionResult Add() { PenetapanDriver model = new PenetapanDriver(); return(View("Form", model)); }