/// <summary> /// Confirms the transaction in the database and displays the transaction info /// </summary> /// Creator: Olivia Johnson 11-28-12 private void dinnerConfirmation() { BusinessTier bt = new BusinessTier(); DataSet ds = new DataSet(); Decimal childCost = 0; Decimal adultCost = 0; int numOfAdults = 0; int numOfChildren = 0; try { ds = bt.confirmDinnerPayment(customerInfo); numOfChildren = Convert.ToInt16(ds.Tables[1].Rows[0][5].ToString()); numOfAdults = Convert.ToInt16(ds.Tables[1].Rows[0][6].ToString()); childCost = Convert.ToDecimal(bt.getDinnerDetails(eventID).Tables[1].Rows[0][12].ToString()); adultCost = Convert.ToDecimal(bt.getDinnerDetails(eventID).Tables[1].Rows[0][13].ToString()); lblticketType1.Text = "Child Dinner Ticket x" + numOfChildren; lblprice1.Text = (numOfChildren * childCost).ToString("C"); lblticketType2.Text = "Adult Dinner Ticket x" + numOfAdults; lblprice2.Text = (numOfAdults * adultCost).ToString("C"); lbltotalCost.Text = ((numOfAdults * adultCost) + (numOfChildren * childCost)).ToString("C"); sendConfirmationEmail("Dinner Event", ds.Tables[1].Rows[0][0].ToString(), ds.Tables[1].Rows[0][3].ToString()); } catch (Exception ex) { ErrorLog.logError(ex); Response.Redirect("Oops.aspx"); } }