public static List <T> Search <TKey>(Expression <Func <T, bool> > expression, Expression <Func <T, TKey> > orderBy, int pageIndex, int pageSize, out int totalCount) { using (MVCDemoDBEntities db = new MVCDemoDBEntities()) { totalCount = db.Set <T>().Where(expression).Count(); return(db.Set <T>().Where(expression).OrderByDescending(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
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(); } } }
public List <T> FindAll() { using (MVCDemoDBEntities db = new MVCDemoDBEntities()) { return(db.Set <T>().ToList()); } }
public static T Find(params object[] keyValues) { using (MVCDemoDBEntities db = new MVCDemoDBEntities()) { return(db.Set <T>().Find(keyValues)); } }
public static void Delete(T model) { using (MVCDemoDBEntities db = new MVCDemoDBEntities()) { db.Set <T>().Remove(model); db.SaveChanges(); } }
public static T Add(T model) { using (MVCDemoDBEntities db = new MVCDemoDBEntities()) { db.Set <T>().Add(model); db.SaveChanges(); } return(model); }
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(); } }
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); }