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