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