public void AddNewPhoto(Photo photo)
{
using (TheContext ctx = new TheContext())
{
ctx.Photos.Add(photo);
ctx.SaveChanges();
}
}
public void AddNewUser(User user)
{
using (TheContext ctx = new TheContext())
{
ctx.Users.Add(user);
ctx.SaveChanges();
}
}
public void DeleteAlbum(Guid id)
{
using (TheContext ctx = new TheContext())
{
var album = ctx.Albums.FirstOrDefault(a => a.AlbumId == id);
ctx.Albums.Remove(album);
ctx.SaveChanges();
}
}
public void SavePhotoInAlbum(Guid id, Photo photo)
{
using (TheContext ctx = new TheContext())
{
var album = ctx.Albums.Include("Photos").FirstOrDefault(a => a.AlbumId == id);
album.Photos.Add(photo);
ctx.SaveChanges();
}
}
public void DeletePhoto(Guid id)
{
using (TheContext ctx = new TheContext())
{
var photo = ctx.Photos.FirstOrDefault(p => p.PhotoId == id);
ctx.Photos.Remove(photo);
ctx.SaveChanges();
}
}
public void DeleteComment(Guid commentId)
{
using (TheContext ctx = new TheContext())
{
var comment = ctx.Comments.FirstOrDefault(c => c.CommentId == commentId);
ctx.Comments.Remove(comment);
ctx.SaveChanges();
}
}
public void AddNewAlbum(Album album, Guid userId)
{
using (TheContext ctx = new TheContext())
{
ctx.Albums.Add(album);
var user = ctx.Users.FirstOrDefault(x => x.UserId == userId);
user.Albums.Add(album);
ctx.SaveChanges();
}
}
public void AddNewComment(Guid photoId, Comment comment)
{
using (TheContext ctx = new TheContext())
{
var photo = ctx.Photos.Single(p => p.PhotoId == photoId);
photo.Comments.Add(comment);
ctx.Comments.Add(comment);
ctx.SaveChanges();
}
}