// Returns a user with specified login or null if one does not exist
internal static User GetUserByLogin(string login)
{
using (var context = new NumberConverterDBContext())
{
return(context.Users.Include(u => u.Requests).FirstOrDefault(u => u.Login == login));
}
}
// Checks if specified email exists
internal static bool EmailExists(string email)
{
using (var context = new NumberConverterDBContext())
{
return(context.Users.Any(u => u.Email == email));
}
}
// Checks if a user with specified login exists
internal static bool UserExists(string login)
{
using (var context = new NumberConverterDBContext())
{
return(context.Users.Any(u => u.Login == login));
}
}
// Adds specified request
internal static void AddRequest(Request request)
{
using (var context = new NumberConverterDBContext())
{
context.Requests.Add(request);
context.SaveChanges();
}
}
// Updates specified user in the database
internal static void SaveUser(User user)
{
using (var context = new NumberConverterDBContext())
{
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
// Adds new user into the database
internal static void AddUser(User user)
{
using (var context = new NumberConverterDBContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}