public static List<Games> GetAllGames() { using (var dbCtx = new GrafilogikaDBEntities()) { return dbCtx.Games.ToList(); } }
public static void DeleteGameByName(string gameName) { using (var dbCtx = new GrafilogikaDBEntities()) { try { var result = (from g in dbCtx.Games where g.Name == gameName select g).First(); dbCtx.Games.Remove(result); dbCtx.SaveChanges(); } catch (Exception) { throw; } } }
public static void AddUser(string name, string pw, int isadmin, string email, int isverified) { Users addThis = new Users(); using (var dbCtx = new GrafilogikaDBEntities()) { addThis.Name = name; addThis.Password = pw; addThis.Wins = 0; addThis.Mistakes = 0; addThis.Isadmin = isadmin; addThis.Email = email; addThis.Isverified = isverified; dbCtx.Users.Add(addThis); dbCtx.SaveChanges(); } }
public static void AddGame(string name, string uploader, string game) { Games addThis = new Games(); using (var dbCtx = new GrafilogikaDBEntities()) { try { addThis.Name = name; addThis.Uploader = uploader; addThis.Wins = 0; addThis.Rating = 0; addThis.Mistakes = 0; addThis.Game = game; dbCtx.Games.Add(addThis); dbCtx.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.StackTrace); } } }
public static Games GetGameByName(string name) { try { using (var dbCtx = new GrafilogikaDBEntities()) { var result = (from g in dbCtx.Games where g.Name == name select g).First(); return result; } } catch (Exception) { return null; } }
public static List<Users> GetAllUsers() { using (var dbCtx = new GrafilogikaDBEntities()) { return dbCtx.Users.ToList(); } }
public static void UpdateUserWins(Users usr) { using (var dbCtx = new GrafilogikaDBEntities()) { try { if (usr.Wins == null) { usr.Wins = 0; } usr.Wins++; dbCtx.Entry(usr).State = EntityState.Modified; dbCtx.SaveChanges(); } catch (Exception) { throw; } } }
public static void UpdateUserVerification(string userName) { try { using (var dbCtx = new GrafilogikaDBEntities()) { var result = (from u in dbCtx.Users where u.Name == userName select u).First(); result.Isverified++; dbCtx.Entry(result).State = EntityState.Modified; dbCtx.SaveChanges(); } } catch (Exception) { throw; } }
public static void UpdateUserAdmin(string userName) { try { using (var dbCtx = new GrafilogikaDBEntities()) { var result = (from u in dbCtx.Users where u.Name == userName select u).First(); if (result.Isadmin == 1) { result.Isadmin = 0; } else if (result.Isadmin == 0) { result.Isadmin = 1; } dbCtx.Entry(result).State = EntityState.Modified; dbCtx.SaveChanges(); } } catch (Exception) { throw; } }
public static void UpdateGameWins(Games game) { using (var dbCtx = new GrafilogikaDBEntities()) { try { if (game.Wins == null) { game.Wins = 0; } game.Wins++; dbCtx.Entry(game).State = EntityState.Modified; dbCtx.SaveChanges(); } catch (Exception) { throw; } } }
public static void UpdateGameRating(Games game, int rating) { using (var dbCtx = new GrafilogikaDBEntities()) { try { if (game.Rating == null || game.Rating == 0) { game.Rating = rating; } else { game.Rating += rating; } dbCtx.Entry(game).State = EntityState.Modified; dbCtx.SaveChanges(); } catch (Exception) { throw; } } }
public static Users GetUserByNameAndPassword(string name, string pswd) { try { using (var dbCtx = new GrafilogikaDBEntities()) { var result = (from u in dbCtx.Users where u.Name == name && u.Password == pswd select u).First(); return result; } } catch (Exception) { return null; } }
public static List<Games> GetGamesByUploader(string uploader) { try { using (var dbCtx = new GrafilogikaDBEntities()) { var result = (from g in dbCtx.Games where g.Uploader == uploader select g).ToList(); return result; } } catch (Exception) { return null; } }