public ImageModel GetImageByFilePath(string imagePath) { using (var db = new SortMImageContext()) { return(db.Images.FirstOrDefault(img => img.ImagePath == imagePath)); } }
public User GetUserByUserName(string username) { using (var db = new SortMImageContext()) { return(db.Users.FirstOrDefault(usr => usr.Username == username)); } }
public ImageModel GetImageByName(string imageName) { using (var db = new SortMImageContext()) { return(db.Images.FirstOrDefault(img => img.Name == imageName)); } }
public IList <User> GetUsers() { using (var db = new SortMImageContext()) { return(db.Users.ToList()); } }
private void DeleteImage(ImageModel image) { using (var db = new SortMImageContext()) { db.Images.Remove(image); db.SaveChanges(); } }
public void DeleteUser(User user) { using (var db = new SortMImageContext()) { db.Users.Remove(user); db.SaveChanges(); } }
public void SaveUser(User user) { using (var db = new SortMImageContext()) { db.Users.Add(user); db.SaveChanges(); } }
public void UpdateImagePathByImageData(byte[] imageData, string imagePath) { using (var db = new SortMImageContext()) { ImageModel image = GetImageByImageData(imageData); if (image != null) { image.ImagePath = imagePath; db.SaveChanges(); } } }
public void UpdateImageTagsByImageData(byte[] imageData, List <ImageTag> imageTags) { using (var db = new SortMImageContext()) { ImageModel image = GetImageByImageData(imageData); if (image != null) { image.ImageTags = imageTags; db.SaveChanges(); } } }
public void UpdateImageTagsByImageName(string imageName, List <ImageTag> imageTags) { using (var db = new SortMImageContext()) { ImageModel image = db.Images.FirstOrDefault(img => img.Name.Equals(imageName)); if (image != null) { image.ImageTags = imageTags; db.SaveChanges(); } } }
private void SaveImage(ImageModel image) { using (var db = new SortMImageContext()) { ImageModel img = GetImageByImageData(image.ImageData); if (img == null) { db.Images.Add(image); db.SaveChanges(); } } }
public List <ImageModel> GetAllImages() { List <ImageModel> retrievedImages = new List <ImageModel>(); using (var db = new SortMImageContext()) { foreach (ImageModel image in db.Images) { db.Entry(image).Collection(img => img.ImageTags).Load(); retrievedImages.Add(image); } return(retrievedImages); } }