public Model.PageInfo GetPage(int pageId) { using (var dbContext = new DAL.PhotoContext()) { return dbContext.PageInfos.SingleOrDefault(o => o.id == pageId); } }
public Model.FileInfo Get(int id) { using (var dbContext = new DAL.PhotoContext()) { return dbContext.FileInfos.Where(o => o.id == id).FirstOrDefault(); } }
public int Add(Model.FileInfo fileInfo) { using (var dbContext = new DAL.PhotoContext()) { dbContext.Entry(fileInfo).State = EntityState.Added; return dbContext.SaveChanges(); } }
public IEnumerable<Model.PageInfo> GetPages(int startRowIndex, int pageSize) { using (var dbContext = new DAL.PhotoContext()) { var pages = dbContext.PageInfos .OrderByDescending(p=>p.add_time) .Skip(startRowIndex) .Take(pageSize) .ToList(); return pages; } }
public int Delete(int id) { using (var dbContext = new DAL.PhotoContext()) { var fileInfo = (from f in dbContext.FileInfos where f.id == id select new Model.FileInfo { id = f.id }).FirstOrDefault(); dbContext.Entry(fileInfo).State = EntityState.Deleted; return dbContext.SaveChanges(); } }