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