private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtGameName.Text))
{
MessageBox.Show("Game name is a required field.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//Instantiate new Game and GameDescription objects
GameBO gameToSaveOrUpdate = new GameBO();
GameDescriptionBO gameDescriptionToSaveOrUpdate = new GameDescriptionBO();
//Set Game object properties and call game manager to save
gameToSaveOrUpdate.GameId = _GameId;
gameToSaveOrUpdate.GameName = txtGameName.Text;
int returnedGameId = GameManager.Save(gameToSaveOrUpdate);
//Set GameDescription object properties and call game manager to save
gameDescriptionToSaveOrUpdate.GameId = _GameId;
gameDescriptionToSaveOrUpdate.GameCost = Convert.ToInt32(txtGameCost.Text);
gameDescriptionToSaveOrUpdate.GameDescript = txtDescription.Text;
gameDescriptionToSaveOrUpdate.HowToPlay = txtHowToPlay.Text;
GameDescriptionManager.Save(returnedGameId, gameDescriptionToSaveOrUpdate);
//Close the dialog window after serving
base.Close();
}
}
private Data_Contracts.GameDescriptionDTO HydrateGameDTOItem(GameBO gameItem)
{
Data_Contracts.GameDescriptionDTO tempItem = new Data_Contracts.GameDescriptionDTO();
if (!string.IsNullOrEmpty(gameItem.GameId.ToString()))
{
tempItem.GameName = gameItem.GameName;
tempItem.GameId = gameItem.GameId;
tempItem.GameDescript = gameItem.GameDescription.GameDescript;
tempItem.HowToPlay = gameItem.GameDescription.HowToPlay;
tempItem.GameCost = gameItem.GameDescription.GameCost;
}
return tempItem;
}
/// <Summary Fill Data Record>
/// Initializes a new instance of the Game class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static GameBO FillDataRecord(IDataRecord myDataRecord)
{
GameBO myGameObject = new GameBO();
myGameObject.GameDescription = new GameDescriptionBO();
myGameObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameName")))
{
myGameObject.GameName = myDataRecord.GetString(myDataRecord.GetOrdinal("GameName"));
}
return myGameObject;
}
//INSERT
public static int Save(GameBO gameToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (gameToSave.GameId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteGame", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@GameId", gameToSave.GameId);
if (gameToSave.GameName != null)
{
myCommand.Parameters.AddWithValue("@GameName", gameToSave.GameName);
}
//add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
//Opens connection and executes query
myConnection.Open();
myCommand.ExecuteNonQuery();
//Get return value from stored procedure and return Id
result = Convert.ToInt32(myCommand.Parameters["@ReturnValue"].Value);
}
myConnection.Close();
}
return result;
}
public void GameGetInformation_Instantiation_NotNull()
{
GameBOCollection collection = new GameBOCollection();
GameBO myGame = new GameBO();
myGame.GameDescription = new GameDescriptionBO();
myGame.GameName = "Game1";
myGame.GameDescription.GameDescript = "Description Stuff";
myGame.GameDescription.HowToPlay = "Number of balls";
collection.Add(myGame);
if (collection != null)
{
Assert.IsTrue(true);
}
}
public static int Save(GameBO gameToSave)
{
int returnedGameId = GameDAL.Save(gameToSave);
return returnedGameId;
}
/// <Summary Fill Data Record>
/// Initializes a new instance of the Game class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static GameBO FillDataRecord(IDataRecord myDataRecord)
{
GameBO myGameObject = new GameBO();
myGameObject.GameDescription = new GameDescriptionBO();
myGameObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameName")))
{
myGameObject.GameName = myDataRecord.GetString(myDataRecord.GetOrdinal("GameName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameDescriptionId")))
{
myGameObject.GameDescription.GameDescriptionId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameDescriptionId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("HowToPlay")))
{
myGameObject.GameDescription.HowToPlay = myDataRecord.GetString(myDataRecord.GetOrdinal("HowToPlay"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameDescription")))
{
myGameObject.GameDescription.GameDescript = myDataRecord.GetString(myDataRecord.GetOrdinal("GameDescription"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameCost")))
{
myGameObject.GameDescription.GameCost = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameCost"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("NumberOfBalls")))
{
myGameObject.GameDescription.NumberOfBalls = myDataRecord.GetInt32(myDataRecord.GetOrdinal("NumberOfBalls"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("SpecialBall")))
{
myGameObject.GameDescription.SpecialBall = myDataRecord.GetInt32(myDataRecord.GetOrdinal("SpecialBall"));
}
return myGameObject;
}
