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