Exemple #1
0
        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();
        }
Exemple #2
0
 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();
 }