public int GetImageLikes(int id)
{
using var context = new ImageDBContext(_connectionString);
var image = GetImageById(id);
return(image.Likes);
}
public void Update(int id)
{
using var context = new ImageDBContext(_connectionString);
var image = GetImageById(id);
image.Likes += 1;
context.Images.Attach(image);
context.Entry(image).State = EntityState.Modified;
context.SaveChanges();
}
public void AddImage(Image image)
{
using var context = new ImageDBContext(_connectionString);
context.Images.Add(image);
context.SaveChanges();
}
public Image GetImageById(int id)
{
using var context = new ImageDBContext(_connectionString);
return(context.Images.FirstOrDefault(i => id == i.Id));
}
public List <Image> GetImages()
{
using var context = new ImageDBContext(_connectionString);
return(context.Images.OrderByDescending(i => i.Date).ToList());
}
