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(); } }