public static async Task <List <Album> > ListAlbumsAsync()
{
using (var dbContext = new BrothersContext())
{
var albums = await dbContext.Albums.ToListAsync();
return(albums);
}
}
public static async Task <Photo> GetAsync(int id)
{
using (var context = new BrothersContext())
{
var photo = await context.Photos.FindAsync(id);
if (photo != null)
{
return(photo);
}
else
{
throw new ArgumentNullException();
}
}
}
public static async Task AddAsync(Photo photo)
{
using (var context = new BrothersContext())
{
if (photo.Id != 0)
{
context.Photos.Attach(photo);
var manager = ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager;
manager.ChangeObjectState(photo, EntityState.Modified);
}
else
{
context.Photos.Add(photo);
}
await context.SaveChangesAsync();
}
}
public static async Task <List <DisplayPhoto> > ListPhotosAsync()
{
using (var dbContext = new BrothersContext())
{
var photos = await dbContext
.Photos
.Select(photo => new DisplayPhoto
{
Identifier = photo.Id,
Size = photo.Size,
Name = photo.Name,
Type = photo.Type,
AlbumId = photo.AlbumId
})
.ToListAsync();
return(photos);
}
}
public static async Task <bool> DeleteAsync(int id)
{
using (var dbcontext = new BrothersContext())
{
Photo photo = await dbcontext
.Photos
.Where(item => item.Id == id)
.SingleOrDefaultAsync();
if (photo == null)
{
return(false);
}
dbcontext.Photos.Remove(photo);
await dbcontext.SaveChangesAsync();
return(true);
}
}
protected override void Seed(BrothersContext context)
{
Album album = new Album("Albomchik", AlbumType.Autumn);
context.Albums.Add(album);
List <Photo> Photos = new List <Photo>
{
new Photo("Photo1", ContentType.Fishing, 23, new byte[0], album.Id),
new Photo("Photo2", ContentType.CountryHouse, 23, new byte[0], album.Id)
};
context.Photos.AddRange(Photos);
List <Video> Videos = new List <Video>
{
new Video("Video1", ContentType.Travel, 12, "", album.Id),
new Video("Video2", ContentType.Others, 12, "", album.Id)
};
context.Videos.AddRange(Videos);
base.Seed(context);
}
