public static int Save(int drawingDateId, int gameId, DrawingDateBO drawingDateToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (drawingDateId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteDrawingDate", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@DrawingDateId", drawingDateId);
if (drawingDateToSave.DrawingDate != null)
{
myCommand.Parameters.AddWithValue("@DrawingDate", drawingDateToSave.DrawingDate);
}
if (drawingDateToSave.Jackpot != null)
{
myCommand.Parameters.AddWithValue("@Jackpot", drawingDateToSave.Jackpot);
}
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;
}
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 DrawingDate class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static DrawingDateBO FillDataRecord(IDataRecord myDataRecord)
{
DrawingDateBO myDrawingDateObject = new DrawingDateBO();
myDrawingDateObject.WinningNumbers = new WinningNumbers();
myDrawingDateObject.DrawingDateId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingDateId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("DrawingDate")))
{
myDrawingDateObject.DrawingDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("DrawingDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Jackpot")))
{
myDrawingDateObject.Jackpot = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Jackpot"));
}
return myDrawingDateObject;
}
