/// <summary>
/// Initializes a new instance of the DrawingDate class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static PrizeOddsOfWinning FillDataRecord(IDataRecord myDataRecord)
{
PrizeOddsOfWinning myPrizeOddsOfWinningObject = new PrizeOddsOfWinning();
myPrizeOddsOfWinningObject.PrizeOddsOfWinningId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("PrizeOddsOfWinningId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Match")))
{
myPrizeOddsOfWinningObject.Match = myDataRecord.GetString(myDataRecord.GetOrdinal("Match"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Win")))
{
myPrizeOddsOfWinningObject.Win = myDataRecord.GetString(myDataRecord.GetOrdinal("Win"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Odds")))
{
myPrizeOddsOfWinningObject.Odds = myDataRecord.GetString(myDataRecord.GetOrdinal("Odds"));
}
return myPrizeOddsOfWinningObject;
}
public static int Save(int gameId, PrizeOddsOfWinning prizeToSave)
{
//Call DAL to save
return PrizesDAL.Save(gameId, prizeToSave);
}
public static int Save(int gameId, PrizeOddsOfWinning prizeToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (prizeToSave.PrizeOddsOfWinningId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecutePrizeOddsOfWinning", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
if (prizeToSave.Match != null)
{
myCommand.Parameters.AddWithValue("@Match", prizeToSave.Match);
}
if (prizeToSave.Win != null)
{
myCommand.Parameters.AddWithValue("@Win", prizeToSave.Win);
}
if (prizeToSave.Odds != null)
{
myCommand.Parameters.AddWithValue("@Odds", prizeToSave.Odds);
}
if (gameId != null)
{
myCommand.Parameters.AddWithValue("@GameId", gameId);
}
//add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//Get return value from stored procedure and return Id
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return result;
}
