public ActionResult Edit(int id)
{
BAP model = new BAP(RepoBAP.FindByPK(id));
ViewBag.name = model.NoBAP;
return(View("Form", model));
}
public void save(BAP dbitem, int id)
{
string query = "";
if (dbitem.Id == 0) //create
{
context.BAP.Add(dbitem);
query = "INSERT INTO dbo.\"BAP\" (\"NoBAP\", \"TanggalKejadian\", \"JamKejadian\", \"KategoriId\", \"LaporanKejadian\", \"DilaporkanOleh\", \"Departemen1Id\", \"HasilPemeriksaan\"," +
"\"Penyelesaian\", \"DiperiksaOleh\", \"Departemen2Id\", \"SalesOrderId\", \"Driver1Id\", \"Driver2Id\", \"IdDataTruck\", \"Status\", \"File\", \"SalesOrderKontrakId\") VALUES (" +
dbitem.NoBAP + ", " + dbitem.TanggalKejadian + ", " + dbitem.JamKejadian + ", " + dbitem.KategoriId + ", " + dbitem.LaporanKejadian + ", " + dbitem.DilaporkanOleh + ", " +
dbitem.Departemen1Id + ", " + dbitem.HasilPemeriksaan + ", " + dbitem.Penyelesaian + ", " + dbitem.DiperiksaOleh + ", " + dbitem.Departemen2Id + ", " + dbitem.SalesOrderId + ", " +
dbitem.Driver1Id + ", " + dbitem.Driver2Id + ", " + dbitem.IdDataTruck + ", " + dbitem.Status + ", " + dbitem.File + ", " + dbitem.SalesOrderKontrakId + ");";
}
else //edit
{
context.BAP.Attach(dbitem);
query = "UPDATE dbo.\"BAP\" SET \"NoBAP\" = " + dbitem.NoBAP + ",\"TanggalKejadian\" = " + dbitem.TanggalKejadian + ",\"JamKejadian\" = " + dbitem.JamKejadian + ",\"KategoriId\" = " +
dbitem.KategoriId + ",\"LaporanKejadian\" = " + dbitem.LaporanKejadian + ",\"DilaporkanOleh\" = " + dbitem.DilaporkanOleh + ",\"Departemen1Id\" = " + dbitem.Departemen1Id +
",\"HasilPemeriksaan\" = " + dbitem.HasilPemeriksaan + ",\"Penyelesaian\" = " + dbitem.Penyelesaian + ",\"DiperiksaOleh\"; = " + dbitem.DiperiksaOleh + ",\"Departemen2Id\" = " +
dbitem.Departemen2Id + ",\"SalesOrderId\" = " + dbitem.SalesOrderId + ",\"Driver1Id\" = " + dbitem.Driver1Id + ",\"Driver2Id\" = " + dbitem.Driver2Id + ",\"IdDataTruck\" = " +
dbitem.IdDataTruck + ",\"Status\" = " + dbitem.Status + ",\"File\" = " + dbitem.File + ",\"SalesOrderKontrakId\" = " + dbitem.SalesOrderKontrakId + "WHERE \"Id\" = " + dbitem.Id + ";";
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
var auditrail = new Auditrail {
Actionnya = "Update", EventDate = DateTime.Now, Modulenya = "BAP", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(BAP dbitem, int id)
{
context.BAP.Remove(dbitem);
var query = "DELETE FROM dbo.\"BAP\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "BAP", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.SaveChanges();
}
public static void RunProperties()
{
BAP bap = new BAP();
Console.WriteLine("Введите курс");
Student student = new Student();
student.Year = Convert.ToInt32(Console.ReadLine());
Console.WriteLine(student.Year);
student.M(pAB: bap);
}
public ActionResult Edit(BAP model)
{
if (ModelState.IsValid)
{
Context.BAP dbitem = RepoBAP.FindByPK(model.Id);
bool Isexist = RepoBAP.IsExist(model.SOBapId, model.SOBapKontrakId, model.Driver1Id, model.IdDataTruck, model.KategoriId, model.Id);
if (Isexist)
{
ModelState.AddModelError("NoBAP", "BAP telah dipakai.");
return(View("Form", model));
}
model.setDb(dbitem);
RepoBAP.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Add(BAP model)
{
if (ModelState.IsValid)
{
int seq = RepoBAP.getUrutanOnCAll(model.TanggalKejadian.Value);
model.NoBAP = RepoBAP.GenerateCode(model.TanggalKejadian.Value, seq);
bool Isexist = RepoBAP.IsExist(model.SOBapId, model.SOBapKontrakId, model.Driver1Id, model.IdDataTruck, model.KategoriId, model.Id);
if (Isexist)
{
ModelState.AddModelError("NoBAP", "BAP telah dipakai.");
return(View("Form", model));
}
Context.BAP dbitem = new Context.BAP();
model.setDb(dbitem);
RepoBAP.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Add()
{
BAP model = new BAP();
return(View("Form", model));
}
