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);
}
}
