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