Esempio n. 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);
 }
Esempio n. 2
0
 public static void Delete(T model)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Set <T>().Remove(model);
         db.SaveChanges();
     }
 }
Esempio n. 3
0
 public static void AddAdmin(Admin admin)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Admin.Add(admin);
         db.SaveChanges();
     }
 }
Esempio n. 4
0
 public static T Add(T model)
 {
     using (MVCDemoDBEntities db = new MVCDemoDBEntities())
     {
         db.Set <T>().Add(model);
         db.SaveChanges();
     }
     return(model);
 }
Esempio n. 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();
     }
 }
Esempio n. 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();
         }
     }
 }
Esempio n. 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();
         }
     }
 }
Esempio n. 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();
     }
 }