public async Task <Picture> GetPictureByKeyAsync(int pictureKey)
{
using (var context = new AOLContext())
{
var pictureRepo = context.EntityRepository <Picture>();
return(await pictureRepo.Query().FirstOrDefaultAsync(p => p.PictureKey == pictureKey));
}
}
public async Task <Article> GetArticleByCodeAsync(string code)
{
using (var context = new AOLContext())
{
var articleRepo = context.EntityRepository <Article>();
return(await articleRepo.Query().Where(a => a.Deleted == false && a.Code == code).FirstOrDefaultAsync());
}
}
public async Task <IEnumerable <Article> > GetArticlesAsync()
{
using (var context = new AOLContext())
{
var articleRepo = context.EntityRepository <Article>();
return(await articleRepo.Query().Where(a => a.Deleted == false).Take(10).ToListAsync());
}
}
public async Task UpdatePictureAsync(Picture picture)
{
picture.State = EntityState.Modified;
using (var context = new AOLContext())
{
var pictureRepo = context.EntityRepository <Picture>();
pictureRepo.UpdateEntity(picture);
await context.SaveChangesAsync();
}
}
public async Task <Picture> AddPictureAsync()
{
var picture = new Picture()
{
PictureTypeId = 2, State = Entity.EntityState.Added
};
using (var context = new AOLContext())
{
var pictureRepo = context.EntityRepository <Picture>();
pictureRepo.AddEntity(picture);
await context.SaveChangesAsync();
return(picture);
}
}
