public static ObservableCollection <ImageModel> GetImageModels(UserModel user)
{
ObservableCollection <ImageModel> images = new ObservableCollection <ImageModel>();
using (var context = new ImageStoreEntities())
{
try
{
var dbImages = context.Images.Where(i => i.UserId == user.Id);
foreach (var image in dbImages)
{
images.Add(new ImageModel
{
Id = image.Id,
Created = image.Created,
Description = image.Description,
Path = image.Path,
Title = image.Title,
UserId = image.UserId,
Data = LoadImage(image.Path),
});
}
}
catch (Exception e)
{
Trace.WriteLine(e.Message);
}
return(images);
}
}
public static void SaveImage(ImageModel image)
{
using (var context = new ImageStoreEntities())
{
try
{
var id = (short)(context.Images.Any() ? context.Images.Max(x => x.Id) + 1 : 0);
var images = context.Images.Add(new Image
{
Id = id,
Created = DateTime.Now,
Description = image.Description,
Title = image.Title,
Path = image.Path,
UserId = image.UserId,
});
context.SaveChanges();
}
catch (Exception e)
{
Trace.WriteLine(e.Message);
}
}
}
public static bool CheckIfUserExist(string username, string password)
{
using (var context = new ImageStoreEntities())
{
return(context.Users.Any(u => u.UserName == username && u.Password == password));
}
}
public static bool CheckIfUsernameExist(string username)
{
using (var context = new ImageStoreEntities())
{
return(context.Users.Any(u => u.UserName == username));
}
}
public static void UpdateUser(UserModel user)
{
using (var context = new ImageStoreEntities())
{
try
{
var dbUser = context.Users.Where(u => u.Id == user.Id).Single();
dbUser.UserName = user.Username;
dbUser.Password = user.Password;
context.SaveChanges();
}
catch (Exception e)
{
Trace.WriteLine(e.Message);
}
}
}
public static void SaveUser(UserModel User)
{
using (var context = new ImageStoreEntities())
{
try
{
var id = (short)(context.Users.Any() ? context.Users.Max(x => x.Id) + 1 : 0);
context.Users.Add(new User
{
Id = id,
UserName = User.Username,
Password = User.Password,
});
context.SaveChanges();
}catch (Exception e)
{
Trace.WriteLine(e.Message);
}
}
}
public static UserModel GetUser(UserModel User)
{
var user = new UserModel();
using (var context = new ImageStoreEntities())
{
try
{
var dbUser = context.Users.Include(u => u.Images)
.Where(u => u.UserName == User.Username && u.Password == User.Password).Single();
var imageList = new ObservableCollection <ImageModel>();
foreach (var image in dbUser.Images)
{
imageList.Add(new ImageModel
{
Id = image.Id,
Created = image.Created,
Description = image.Description,
Path = image.Path,
Title = image.Title,
UserId = image.UserId,
});
}
user = new UserModel
{
Id = dbUser.Id,
Username = dbUser.UserName,
Password = dbUser.Password,
Images = imageList,
};
}catch (Exception e)
{
Trace.WriteLine(e.Message);
}
}
return(user);
}
