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();
}
}
//INSERT
public static int Save(int gameId, GameDescriptionBO gameDescriptionToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (gameDescriptionToSave.GameId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteGameDescription", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@GameId", gameId);
if (gameDescriptionToSave.HowToPlay != null)
{
myCommand.Parameters.AddWithValue("@HowToPlay", gameDescriptionToSave.HowToPlay);
}
if (gameDescriptionToSave.GameDescript != null)
{
myCommand.Parameters.AddWithValue("@GameDescription", gameDescriptionToSave.GameDescript);
}
if (gameDescriptionToSave.GameCost != null)
{
myCommand.Parameters.AddWithValue("@GameCost", gameDescriptionToSave.GameCost);
}
if (gameDescriptionToSave.NumberOfBalls != null)
{
myCommand.Parameters.AddWithValue("@NumberOfBalls", gameDescriptionToSave.NumberOfBalls);
}
if (gameDescriptionToSave.SpecialBall != null)
{
myCommand.Parameters.AddWithValue("@SpecialBall", gameDescriptionToSave.SpecialBall);
}
//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 static GameDescriptionBO GetGameDescriptionRestfulConsume(int gameId)
{
GameDescriptionBO tempItem = new GameDescriptionBO();
Base myBase = new Base();
using (WebClient webClient = new WebClient())
{
//Call REST service and get JSON response
string json = webClient.DownloadString("http://localhost:60706/LotteryService/GameDescription/Item/" + gameId.ToString());
LotteryWindowsFormsApp.BO.GameDescriptionDTO item = myBase.GetGameItem<LotteryWindowsFormsApp.BO.GameDescriptionDTO>(json);
if (!string.IsNullOrEmpty(item.GameDescript))
{
tempItem.GameName = item.GameName;
tempItem.GameDescript = item.GameDescript;
tempItem.HowToPlay = item.HowToPlay;
tempItem.GameCost = item.GameCost;
}
}
return tempItem;
}
public static int Save(int gameId, GameDescriptionBO gameDescriptionToSaveOrUpdate)
{
int returnValue = GameDescriptionDAL.Save(gameId, gameDescriptionToSaveOrUpdate);
return returnValue;
}