예제 #1
0
 public static List <User> GetAllUsers(Guid queryGuid)
 {
     using (var context = new RandomizerDBContext())
     {
         return(context.Users.Where(u => u.Queries.All(r => r.Guid != queryGuid)).ToList());
     }
 }
예제 #2
0
 public static User GetUserByGuid(Guid guid)
 {
     using (var context = new RandomizerDBContext())
     {
         return(context.Users.Include(u => u.Queries).FirstOrDefault(u => u.Guid == guid));
     }
 }
예제 #3
0
 public static User GetUserByLogin(string login)
 {
     using (var context = new RandomizerDBContext())
     {
         return(context.Users.Include(u => u.Queries).FirstOrDefault(u => u.Login == login));
     }
 }
예제 #4
0
 public static bool UserExists(string login)
 {
     using (var context = new RandomizerDBContext())
     {
         return(context.Users.Any(u => u.Login == login));
     }
 }
예제 #5
0
 public static void SaveQuery(Query query)
 {
     using (var context = new RandomizerDBContext())
     {
         context.Entry(query).State = EntityState.Modified;
         context.SaveChanges();
     }
 }
예제 #6
0
 public static void AddUser(User user)
 {
     using (var context = new RandomizerDBContext())
     {
         context.Users.Add(user);
         context.SaveChanges();
     }
 }
예제 #7
0
 public static void AddQuery(Query query)
 {
     using (var context = new RandomizerDBContext())
     {
         query.DeleteDatabaseValues();
         context.Queries.Add(query);
         context.SaveChanges();
     }
 }
예제 #8
0
 public static void DeleteQuery(Query selectedQuery)
 {
     using (var context = new RandomizerDBContext())
     {
         selectedQuery.DeleteDatabaseValues();
         context.Queries.Attach(selectedQuery);
         context.Queries.Remove(selectedQuery);
         context.SaveChanges();
     }
 }