// Saves data from the Add Games form public static int CreateVideoGame(string GameTitle, string ReleaseYear, string Platform, string Publisher, bool CompleteCopy, bool PhsyicalCopy) { // Linking the MVC and Library Models VideoGameModel data = new VideoGameModel { GameTitle = GameTitle, ReleaseYear = ReleaseYear, Platform = Platform, Publisher = Publisher, CompleteCopy = CompleteCopy, PhysicalCopy = PhsyicalCopy }; // SQLite statement that adds the game info into the VideoGames table string sql = @"insert into VideoGames (GameTitle, ReleaseYear, Platform, Publisher, CompleteCopy, PhysicalCopy) values (@GameTitle, @ReleaseYear, @Platform, @Publisher, @CompleteCopy, @PhysicalCopy);"; return(SQLiteDataAccess.SaveData(sql, data)); }
public static List <ConsoleModel> LoadConsole() { string sql = "select Id, ConsoleName, Manufacturer, Notes from Console;"; return(SQLiteDataAccess.LoadData <ConsoleModel>(sql)); }
// Loads data from the Add Games form into the Table public static List <VideoGameModel> LoadGames() { string sql = "select Id, GameTitle, ReleaseYear, Platform, Publisher, CompleteCopy, PhysicalCopy from VideoGames;"; return(SQLiteDataAccess.LoadData <VideoGameModel>(sql)); }