public static int SaveNewNumber(int winningNumbersId, int drawingDateId, AstonTechnologies.AstonEngineer.WinningNumbers winningNumbersToSave)
{
//Call DAL to save
return WinningNumbersDAL.SaveNewNumber(winningNumbersId, drawingDateId, winningNumbersToSave);
}
public static int SaveNewNumber(int winningNumbersId, int drawingDateId, AstonTechnologies.AstonEngineer.WinningNumbers winningNumbersToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (winningNumbersId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteWinningNumbers", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@DrawingDateId", drawingDateId);
myCommand.Parameters.AddWithValue("@WinningNumbersId", winningNumbersId);
if (winningNumbersToSave.NumberValue != null)
{
myCommand.Parameters.AddWithValue("@NumberValue", winningNumbersToSave.NumberValue);
}
//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;
}
