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();
}
}
