/// <summary> /// Get all the games by their price from the /// database. /// </summary> /// <returns>Retuns a list of games by their price.</returns> public static List <Game> getAllGamesByPrice() { // gets games by price from DB GameStoreDB db = new GameStoreDB(); return(db.Games.OrderBy(g => g.Price).ToList()); }
/// <summary> /// Get a list of all the games by their name from /// the database. /// </summary> /// <returns>Returns a list of all the games by their name.</returns> public static List <Game> getAllGamesByName() { // get's all games by name from DB. GameStoreDB db = new GameStoreDB(); return(db.Games.OrderBy(g => g.GameName).ToList()); }
public static void deleteGame(Game games) { GameStoreDB db = new GameStoreDB(); if (games != null) { var game = db.Games.Find(games.GameID); db.Games.Remove(game); db.SaveChanges(); MessageBox.Show("Game Deleted!"); } else { MessageBox.Show("You did not select a game to delete!"); } }
/// <summary> /// Adds or updates a game depending on whether /// the user added a new game or tried to update /// a current game. /// </summary> /// <param name="game">A game that is being passed to the method to be updated or added.</param> public static void AddOrUpdateGame(Game game) { GameStoreDB db = new GameStoreDB(); Game g = db.Games.Find(game.GameID); if (g == null) { db.Games.Add(game); MessageBox.Show("Game Added"); } else { g.GameName = game.GameName; g.NumberOfCopies = game.NumberOfCopies; g.Price = game.Price; g.Availability = game.Availability; MessageBox.Show("Game Updated"); } db.SaveChanges(); }