private static int SaveGame(LotteryGameDetail detailsToSave)
{
LotteryGameValue tempGame = new LotteryGameValue();
tempGame.LotteryGameId = detailsToSave.LotteryGameId;
if (detailsToSave.GameName != null)
tempGame.GameName = detailsToSave.GameName;
if (detailsToSave.GameNameAbbrev != null)
tempGame.GameNameAbbrev = detailsToSave.GameNameAbbrev;
return LotteryGameManager.Save(tempGame);
}
public static int Save(LotteryGameDetail detailsToSave)
{
LotteryGameDetail game = new LotteryGameDetail();
game.LotteryGameId = detailsToSave.LotteryGameId;
int lotteryGameId = SaveGame(detailsToSave);
detailsToSave.LotteryGameId = lotteryGameId;
if (detailsToSave.GameDescription != null)
game.GameDescription = detailsToSave.GameDescription;
if (detailsToSave.HowToPlay != null)
game.HowToPlay = detailsToSave.HowToPlay;
if (detailsToSave.Cost != null)
game.Cost = detailsToSave.Cost;
return DetailsDAL.Save(detailsToSave);
}
public static int Save(LotteryGameDetail detailsToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
// notes: check for valid LotteryGameId - if exists then UPDATE , else INSERT
if (detailsToSave.LotteryGameDetailId > 0)
queryId = ExecuteTypeEnum.UpdateItem;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteLotteryGameDetail", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@LotteryGameId", detailsToSave.LotteryGameId);
if (detailsToSave.GameDescription != null)
myCommand.Parameters.AddWithValue("@GameDescription", detailsToSave.GameDescription);
if (detailsToSave.HowToPlay != null)
myCommand.Parameters.AddWithValue("@HowToPlay", detailsToSave.HowToPlay);
if (detailsToSave.Cost != null)
myCommand.Parameters.AddWithValue("@Cost", detailsToSave.Cost);
//notes: add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//notes: get return value from stored procedure and return Id
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return result;
}
private static LotteryGameDetail FillDataRecord(IDataRecord myDataRecord)
{
LotteryGameDetail myObject = new LotteryGameDetail();
myObject.LotteryGameDetailId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("LotteryGameDetailId"));
myObject.LotteryGameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("LotteryGameId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameDescription")))
myObject.GameDescription = myDataRecord.GetString(myDataRecord.GetOrdinal("GameDescription"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("HowToPlay")))
myObject.HowToPlay = myDataRecord.GetString(myDataRecord.GetOrdinal("HowToPlay"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Cost")))
myObject.Cost = myDataRecord.GetString(myDataRecord.GetOrdinal("Cost"));
return myObject;
}
private void ProcessForm()
{
StringBuilder formControlValues = new StringBuilder();
string Win = Win1.Text;
string odd = Odd.Text;
string match = Match.Text;
//notes: set Game properties
LotteryGameDetail detailToSave = new LotteryGameDetail();
//notes: game specific info
//detailToSave.GameName = gameName;
// detailToSave.GameNameAbbrev = gameNameAbbrev;
//notes: detail specific info
//detailToSave.HowToPlay = howToPlay;
//detailToSave.GameDescription = gameDescription;
//detailToSave.Cost = cost;
//notes: call middle tier to save details
DetailsManager.Save(detailToSave);
//notes: set Id's from hidden fields
//detailToSave.LotteryGameId = LotteryGameId.Value.ToInt();
// Output
if (detailToSave.LotteryGameId > 0)
{
base.DisplayPageMessage(PageMessage, "Update was successful.");
}
else
{
//notes: INSERT was successful - redirect back
Response.Redirect("LotteryBasic.aspx?LotteryId=" + detailToSave.LotteryGameId.ToString());
}
}
