public void delete(BatalOrder dbitem)
{
context.BatalOrder.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Batal Order", QueryDetail = "Delete Batal Order " + dbitem.SalesOrder, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void save(BatalOrder dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.BatalOrder.Add(dbitem);
var query = "INSERT INTO dbo.\"BatalOrder\" (\"Id\", \"IdSalesOrder\", \"Keterangan\", \"ModifiedDate\", \"IsBatalTruk\", \"Code\", \"IdSoKontrak\") VALUES (" + dbitem.Id + ", " +
dbitem.IdSalesOrder + ", " + dbitem.Keterangan + ", " + dbitem.ModifiedDate + ", " + dbitem.IsBatalTruk + ", " + dbitem.Code + ", " + dbitem.IdSoKontrak + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Batal Order", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.BatalOrder.Attach(dbitem);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
