public void delete(LookupCodeCategories dbitem) { context.LookupCodeCategories.Remove(dbitem); var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Lookup Code Categories", QueryDetail = "Delete " + dbitem.Description, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); context.SaveChanges(); }
public void save(LookupCodeCategories dbitem) { if (dbitem.Id == 0) //create { context.LookupCodeCategories.Add(dbitem); var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Lookup Code Categories", QueryDetail = "Add " + dbitem.Description, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); } else //edit { context.LookupCodeCategories.Attach(dbitem); var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Lookup Code Categories", QueryDetail = "Edit " + dbitem.Description, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }