public int GetLikesCount(int Id)
{
using (var context = new PictureContext(_connectionString))
{
return(context.Picture.FirstOrDefault(p => p.Id == Id).Likes);
}
}
public Picture GetPictureById(int Id)
{
using (var context = new PictureContext(_connectionString))
{
return(context.Picture.FirstOrDefault(p => p.Id == Id));
}
}
public List <Picture> GetPictures()
{
using (var context = new PictureContext(_connectionString))
{
return(context.Picture.OrderBy(p => p.Date).ToList());
}
}
public void AddLike(int Id)
{
using (var context = new PictureContext(_connectionString))
{
context.Picture.FirstOrDefault(p => p.Id == Id).Likes++;
context.SaveChanges();
}
}
public void AddPicture(Picture picture)
{
using (var context = new PictureContext(_connectionString))
{
context.Picture.Add(picture);
context.SaveChanges();
}
}