public void save(JnsTols dbitem, int id, HistoryJnsTols hjt)
{
var h_query = "INSERT INTO dbo.\"HistoryJnsTols\" (\"IdTol\", \"Tanggal\", \"NamaTol\", \"GolonganTol1\", \"GolonganTol2\", \"GolonganTol3\", \"GolonganTol4\", \"Keterangan\", \"IdUser\") VALUES (" + hjt.IdTol +
", " + hjt.Tanggal + ", " + hjt.NamaTol + ", " + hjt.GolonganTol1 + ", " + hjt.GolonganTol2 + ", " + hjt.GolonganTol3 + ", " + hjt.GolonganTol4 + ", " + hjt.Keterangan + ", " + hjt.IdUser + ");";
if (dbitem.Id == 0) //create
{
context.JnsTols.Add(dbitem);
var query = "INSERT INTO dbo.\"JnsTols\" (\"NamaTol\", \"GolonganTol1\", \"GolonganTol2\", \"GolonganTol3\", \"GolonganTol4\", \"Keterangan\") VALUES (" + dbitem.NamaTol + ", " + dbitem.GolonganTol1 + ", " +
dbitem.GolonganTol2 + ", " + dbitem.GolonganTol3 + ", " + dbitem.GolonganTol4 + ", " + dbitem.Keterangan + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Jenis Tol", QueryDetail = query + h_query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.JnsTols.Attach(dbitem);
var query = "UPDATE dbo.\"JnsTols\" SET \"NamaTol\" = " + dbitem.NamaTol + ", \"GolonganTol1\" = " + dbitem.GolonganTol1 + ", \"GolonganTol2\" = " + dbitem.GolonganTol2 + ", \"GolonganTol3\" = " +
dbitem.GolonganTol3 + ", \"GolonganTol4\" = " + dbitem.GolonganTol4 + ", \"Keterangan\" = " + dbitem.Keterangan + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Jenis Tol", QueryDetail = query + h_query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void delete(JnsTols dbitem, int id)
{
context.JnsTols.Remove(dbitem);
var query = "DELETE FROM dbo.\"JnsTols\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Jenis Tol", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
