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