private Dictionary <string, object> prepareGameParameters(clsAllGame prGame) { Dictionary <string, object> par = new Dictionary <string, object>(9); par.Add("GameID", prGame.GameID); par.Add("GenreID", prGame.GenreID); par.Add("Title", prGame.Title); par.Add("Price", prGame.Price); par.Add("DateTimeModified", prGame.DateTimeModified); par.Add("Quantity", prGame.Quantity); par.Add("ReleaseDate", prGame.ReleaseDate); par.Add("GameType", prGame.GameType); par.Add("Warranty", prGame.Warranty); par.Add("Discount", prGame.Discount); return(par); }
public string PostGame(clsAllGame prGame) { // insert try { int lcRecCount = clsDbConnection.Execute("INSERT INTO Game " + "(GenreID, Title, Price, DateTimeModified, Quantity, ReleaseDate, GameType, Warranty, Discount) " + "VALUES (@GenreID, @Title, @Price, @DateTimeModified, @Quantity, @ReleaseDate, @GameType, @Warranty, @Discount)", prepareGameParameters(prGame)); if (lcRecCount == 1) { return("New game record created"); } else { return("Unexpected game creation count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }
public string PutGame(clsAllGame prGame) { // update try { int lcRecCount = clsDbConnection.Execute( "UPDATE Game SET GenreID = @GenreID, Title = @Title, Price = @Price, DateTimeModified = @DateTimeModified," + "Quantity = @Quantity, ReleaseDate = @ReleaseDate, GameType = @GameType, Warranty = @Warranty," + "Discount = @Discount WHERE GameID = @GameID", prepareGameParameters(prGame)); if (lcRecCount == 1) { return("Game details updated"); } else { return("Unexpected game update count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }