Example #1
0
 public static T Update(T model)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         if (db.Entry <T>(model).State == EntityState.Modified)
         {
             db.SaveChanges();
         }
         else if (db.Entry <T>(model).State == EntityState.Detached)
         {
             db.Set <T>().Attach(model);
             db.Entry <T>(model).State = EntityState.Modified;
             db.SaveChanges();
         }
     }
     return(model);
 }
Example #2
0
 public static void Delete(T model)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Set <T>().Remove(model);
         db.SaveChanges();
     }
 }
Example #3
0
 public static void AddAdmin(Admin admin)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Admin.Add(admin);
         db.SaveChanges();
     }
 }
Example #4
0
 public static T Add(T model)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Set <T>().Add(model);
         db.SaveChanges();
     }
     return(model);
 }
Example #5
0
 public static void EditAdmin(Admin admin)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Set <Admin>().Attach(admin);
         db.Entry <Admin>(admin).State = EntityState.Modified;
         db.SaveChanges();
     }
 }
Example #6
0
 public static void Delete(params object[] keyValues)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         T model = db.Set <T>().Find(keyValues);
         if (model != null)
         {
             db.Set <T>().Remove(model);
             db.SaveChanges();
         }
     }
 }
Example #7
0
 public static void DeleteLogical(int id)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         Role role = db.Role.Find(id);
         if (role != null)
         {
             role.IsDeleted = true;
             db.SaveChanges();
         }
     }
 }
Example #8
0
 public static void DeleteAdmin(int id)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         Admin admin = db.Admin.Find(id);
         if (admin != null)
         {
             admin.IsDeleted = true;
         }
         db.SaveChanges();
     }
 }