public static int Save(DrawingNumber gameToSave) { int returnValue; returnValue = DrawingNumberDAL.Save(gameToSave); return returnValue; }
private void ProcessForm() { StringBuilder formControlValues = new StringBuilder(); int number = Number; string ballTypeText = BallList.SelectedItem.Text; int ballTypeValue = BallList.SelectedValue.ToInt(); //notes: set Game properties DrawingNumber numberToSave = new DrawingNumber(); LotteryDrawing h = new LotteryDrawing(); //notes: game specific info numberToSave.DrawingNumberValue = number; numberToSave.BallType = ballTypeValue.ToString(); //notes: detail specific info //notes: call middle tier to save details DrawingNumberManager.Save(numberToSave); //notes: set Id's from hidden fields h.LotteryGameId = LotteryGameId.Value.ToInt(); //Output if (numberToSave.DrawingNumberId > 0) { base.DisplayPageMessage(PageMessage, "Update was successful."); } else { //notes: INSERT was successful - redirect back Response.Redirect("Drawing.aspx?LotteryId=" + numberToSave.DrawingNumberId.ToString()); } }
public static int Save(DrawingNumber numberToSave) { int result = 0; ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem; // notes: check for valid LotteryGameId - if exists then UPDATE , else INSERT if (numberToSave.DrawingNumberId > 0) queryId = ExecuteTypeEnum.UpdateItem; using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("usp_ExecuteDrawingNumber", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@QueryId", queryId); myCommand.Parameters.AddWithValue("@DrawingTypeId", numberToSave.DrawingTypeId); myCommand.Parameters.AddWithValue("@DrawingNumberValue", numberToSave.DrawingNumberValue); myCommand.Parameters.AddWithValue("@LotteryDrawingId", numberToSave.LotteryDrawingId); //notes: add return output parameter to command object myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue")); myConnection.Open(); myCommand.ExecuteNonQuery(); //notes: get return value from stored procedure and return Id result = (int)myCommand.Parameters["@ReturnValue"].Value; } myConnection.Close(); } return result; }
private static DrawingNumber FillDataRecord(IDataRecord myDataRecord) { DrawingNumber myObject = new DrawingNumber(); myObject.DrawingNumberId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingNumberId")); myObject.LotteryDrawingId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("LotteryDrawingId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("DrawingNumberValue"))) myObject.DrawingNumberValue = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingNumberValue")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("BallType"))) myObject.BallType = myDataRecord.GetString(myDataRecord.GetOrdinal("BallType")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("DrawingTypeId"))) myObject.DrawingTypeId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingTypeId")); return myObject; }