public int GetLikes(int id)
{
using (var context = new ImagesContext(_connectionString))
{
return(context.Images.FirstOrDefault(i => i.ID == id).Likes);
}
}
public Image GetImage(int id)
{
using (var context = new ImagesContext(_connectionString))
{
return(context.Images.FirstOrDefault(i => i.ID == id));
}
}
public List <Image> GetImages()
{
using (var context = new ImagesContext(_connectionString))
{
return(context.Images.OrderByDescending(i => i.Date).ToList());
}
}
public void LikeImage(int id)
{
using (var context = new ImagesContext(_connectionString))
{
context.Images.FirstOrDefault(i => i.ID == id).Likes++;
context.SaveChanges();
}
}
public void AddImage(Image image)
{
using (var context = new ImagesContext(_connectionString))
{
image.Date = DateTime.Now;
context.Images.Add(image);
context.SaveChanges();
}
}
