public void save(VendorGps dbitem, int id) { if (dbitem.Id == 0) //create { context.VendorGps.Add(dbitem); var query = "INSERT INTO dbo.\"VendorGps\" (\"Nama\", \"Merk\", \"Alamat\", \"Email\", \"Telp\", \"Web\") VALUES (" + dbitem.Nama + ", " + dbitem.Merk + ", " + dbitem.Alamat + ", " + dbitem.Email + ", " + dbitem.Telp + ", " + dbitem.Web + ");"; var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Vendor List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); } else //edit { context.VendorGps.Attach(dbitem); var query = "UPDATE dbo.\"VendorGps\" SET \"Nama\" = " + dbitem.Nama + ", \"Merk\" = " + dbitem.Merk + ", \"Alamat\" = " + dbitem.Alamat + ", \"Email\" = " + dbitem.Email + ", \"Telp\" = " + dbitem.Telp + ", \"Web\" = " + dbitem.Web + " WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Vendor List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public ActionResult Edit(int id) { Context.VendorGps dbitem = RepoVendor.FindByPK(id); VendorGps model = new VendorGps(dbitem); ViewBag.name = model.Nama; return(View("Form", model)); }
public void delete(VendorGps dbitem, int id) { context.VendorGps.Remove(dbitem); var query = "DELETE FROM dbo.\"VendorGps\" WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Vendor List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); context.SaveChanges(); }
public ActionResult Edit(VendorGps model) { if (ModelState.IsValid) { Context.VendorGps dbitem = RepoVendor.FindByPK(model.Id); model.setDb(dbitem); RepoVendor.save(dbitem, UserPrincipal.id); return(RedirectToAction("Index")); } Kontak[] result = JsonConvert.DeserializeObject <Kontak[]>(model.strVendor); model.ListKontak = result.ToList(); return(View("Form", model)); }
public ActionResult Add() { VendorGps model = new VendorGps(); return(View("Form", model)); }