/// <summary> /// /// </summary> /// <param name="Id"></param> /// <returns></returns> public virtual T GetByID(int Id) { T result = default(T); using (AsaLocalEntities db = new AsaLocalEntities()) { result = db.Set <T>().AsNoTracking().Where(m => m.Id == Id).FirstOrDefault(); } return(result); }
/// <summary> /// /// </summary> /// <param name="function"></param> /// <param name="pageNumber"></param> /// <param name="pageSize"></param> /// <returns></returns> public PagedList <T> Get(Expression <Func <T, bool> > WhereFilter, Expression <Func <T, T> > orderSelector, int pageNumber = 1, int pageSize = 15) { PagedList <T> result = new PagedList <T>(Enumerable.Empty <T>(), m => m, pageNumber, pageSize); using (AsaLocalEntities db = new AsaLocalEntities()) { result = db.Set <T>().AsNoTracking().Where(WhereFilter).OrderBy(orderSelector).ToPagedList(pageNumber, pageSize); } return(result); }
/// <summary> /// /// </summary> /// <param name="pageNumber"></param> /// <param name="pageSize"></param> /// <returns></returns> public PagedList <T> GetAll(int pageNumber = 1, int pageSize = 15) { PagedList <T> result = new PagedList <T>(Enumerable.Empty <T>(), m => m, pageNumber, pageSize); using (AsaLocalEntities db = new AsaLocalEntities()) { result = db.Set <T>().AsNoTracking().ToPagedList(pageNumber, pageSize); } return(result); }