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