private void btnSave_Click(object sender, EventArgs e)
{
DrawingDateBO drawingDateToSave = new DrawingDateBO();
drawingDateToSave.DrawingDate = Convert.ToDateTime(txtDrawingDate.Text);
int returnedDrawingDateId = DrawingDateManager.Save(_DrawingDateId, _GameId, drawingDateToSave);
int i = 0;
foreach(Control ctrl in panelWinningNumbers.Controls)
{
if (ctrl is TextBox)
{
if (_WinningNumbersId == 0)
{
WinningNumbers winningNumberToSave = new WinningNumbers();
winningNumberToSave.NumberValue = Convert.ToInt32(ctrl.Text);
WinningNumbersManager.Save(_WinningNumbersId, returnedDrawingDateId, winningNumberToSave);
}
else
{
WinningNumbers winningNumberToSave = new WinningNumbers();
winningNumberToSave.NumberValue = Convert.ToInt32(ctrl.Text);
int winningNumbersId = Convert.ToInt32(ctrl.Name);
WinningNumbersManager.Save(winningNumbersId, returnedDrawingDateId, winningNumberToSave);
}
}
i++;
}
base.Close();
}
/// <summary>
/// Initializes a new instance of the WinningNumbers class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static WinningNumbers FillDataRecord(IDataRecord myDataRecord)
{
WinningNumbers myWinningNumsObject = new WinningNumbers();
//myWinningNumsObject.DrawingDateId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingDateId"));
//myWinningNumsObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("WinningNumbersId")))
{
myWinningNumsObject.WinningNumbersId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("WinningNumbersId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("NumberValue")))
{
myWinningNumsObject.NumberValue = myDataRecord.GetInt32(myDataRecord.GetOrdinal("NumberValue"));
}
return myWinningNumsObject;
}
public static int Save(int winningNumbersId, int drawingDateId, WinningNumbers winningNumberToSave)
{
int returnedValue = WinningNumbersDAL.SaveNewNumber(winningNumbersId, drawingDateId, winningNumberToSave);
return returnedValue;
}
public static int SaveNewNumber(int winningNumbersId, int drawingDateId, 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;
}