/// <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");
        }
    }