public void save(JenisTrucks dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.JenisTrucks.Add(dbitem);
var query = "INSERT INTO dbo.\"JenisTrucks\" (\"StrJenisTruck\", \"GolTol\", \"Alias\", \"Biaya\", \"AcInterval\") VALUES (" + dbitem.StrJenisTruck + ", " + dbitem.GolTol + ", " + dbitem.Alias + ", " +
dbitem.Biaya + ", " + dbitem.AcInterval + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Jenis Truk", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.JenisTrucks.Attach(dbitem);
var query = "UPDATE dbo.\"JenisTrucks\" SET \"StrJenisTruck\" = " + dbitem.StrJenisTruck + ", \"GolTol\" = " + dbitem.GolTol + ", \"Alias\" = " + dbitem.Alias + ", \"Biaya\" = " + dbitem.Biaya +
", \"AcInterval\" = " + dbitem.AcInterval + "WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Jenis Truk", QueryDetail = "Edit " + dbitem.StrJenisTruck, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void delete(JenisTrucks dbitem, int id)
{
context.JenisTrucks.Remove(dbitem);
var query = "DELETE FROM dbo.\"JenisTrucks\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Jenis Truk", QueryDetail = "Delete " + dbitem.StrJenisTruck, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
