public static IList <Picture> GetUserPictures(Guid userId)
{
using (var db = new PicshareDbContext())
{
return(db.Pictures.Where(p => p.UserId == userId && p.Title != "avatar").ToList());
}
}
public static IList <Picture> GetSharedPictures(Guid sharedForUserId)
{
using (var db = new PicshareDbContext())
{
var pictureIds = db.ShareEntries.Where(e => e.ToUserId == sharedForUserId).Select(s => s.PictureId);
return(db.Pictures.Where(p => pictureIds.Contains(p.Id)).ToList());
}
}
public static IList <PictureComment> GetPictureComments(Guid pictureId)
{
using (var db = new PicshareDbContext())
{
var com = db.PictureComments.ToList();
return(db.PictureComments.Where(c => c.PictureId == pictureId).ToList());
}
}
public static Board GetUserBoard(Guid userId)
{
using (var db = new PicshareDbContext())
{
var board = db.Boards.FirstOrDefault(b => b.UserId == userId);
return(board);
}
}
public static async Task SaveShareEntries(IEnumerable <ShareEntry> shareEntries)
{
using (var db = new PicshareDbContext())
{
foreach (var shareEntry in shareEntries)
{
if (db.ShareEntries.Any(se => se.OwnerUserId == shareEntry.OwnerUserId && se.ToUserId == shareEntry.ToUserId && se.PictureId == shareEntry.PictureId))
{
continue;
}
db.ShareEntries.Add(shareEntry);
}
await db.SaveChangesAsync();
}
}
public static async Task SavePictureComment(PictureComment pictureComment)
{
using (var db = new PicshareDbContext())
{
if (pictureComment.Id == Guid.Empty)
{
pictureComment.Id = Guid.NewGuid();
}
if (pictureComment.CreatedOn == DateTime.MinValue)
{
pictureComment.CreatedOn = DateTime.Now;
}
db.PictureComments.Add(pictureComment);
await db.SaveChangesAsync();
}
}
public static async Task <bool> SavePicture(Picture picture)
{
using (var db = new PicshareDbContext())
{
if (picture.Id == Guid.Empty)
{
picture.Id = Guid.NewGuid();
}
if (picture.CreatedOn == DateTime.MinValue)
{
picture.CreatedOn = DateTime.Now;
}
if (!db.Pictures.Any(p => p.Id == picture.Id))
{
db.Pictures.Add(picture);
await db.SaveChangesAsync();
}
}
return(true);
}
