// A bunch of input validation and calculations done previous to this point...
        if (error == 0)
        {
            try
            {
                string sSQL = "UpdateTicket";
                SqlConnection cnUpdateRecord = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                SqlCommand cmdUpdateRecord = new SqlCommand();
                cmdUpdateRecord.Parameters.Clear();
                cmdUpdateRecord.CommandText = sSQL;
                cmdUpdateRecord.CommandType = CommandType.StoredProcedure;
                cmdUpdateRecord.Parameters.AddWithValue("@TicketID", int.Parse(Session["TicketID"].ToString()));
                cmdUpdateRecord.Parameters.AddWithValue("@TicketDate", dateTextBox.Text);
                cmdUpdateRecord.Parameters.AddWithValue("@TicketDescription", descriptionTextBox.Text);
                cmdUpdateRecord.Parameters.AddWithValue("@TherapistID", therapistID);
                cmdUpdateRecord.Parameters.AddWithValue("@CustomerID", int.Parse(Session["CID"].ToString()));
                cmdUpdateRecord.Parameters.AddWithValue("@TicketBillableTime", billableTimeDecimal);
                cmdUpdateRecord.Parameters.AddWithValue("@TicketBillableRate", billableRateDecimal);
                cmdUpdateRecord.Parameters.AddWithValue("@TicketTotal", ticketTotalDecimal);
                cmdUpdateRecord.Parameters.AddWithValue("@TicketPaid", ticketPaidString);
                cmdUpdateRecord.Parameters.AddWithValue("@TicketProfit", ticketProfitDecimal);
                cmdUpdateRecord.Connection = cnUpdateRecord;
                cnUpdateRecord.Open();
                cmdUpdateRecord.ExecuteNonQuery();
                cnUpdateRecord.Close();
            }
            catch
            {
                errorText = "There was an error and the ticket did not get edited. <br />";
                error++;
            }
        }
        if (error != 0)
        {
            errorLabel.Text = errorText;
        }
        else
        {
            Server.Transfer("Tickets.aspx");
        }

ALTER PROCEDURE dbo.UpdateTicket
    (
    @TicketDate datetime,
    @TicketDescription varchar (MAX),
    @TherapistID int,
    @CustomerID int,
    @TicketBillableTime decimal,
    @TicketBillableRate decimal,
    @TicketTotal decimal,
    @TicketPaid varchar (50),
    @TicketProfit decimal,
    @TicketID int
    )
AS
    SET NOCOUNT ON;
UPDATE Tickets SET
    TicketDate = @TicketDate,
    TicketDescription = @TicketDescription,
    TherapistID = @TherapistID,
    CustomerID = @CustomerID,
    TicketBillableTime = @TicketBillableTime,
    TicketBillableRate = @TicketBillableRate,
    TicketTotal = @TicketTotal,
    TicketPaid = @TicketPaid,
    TicketProfit = @TicketProfit
WHERE (TicketID = @TicketID);

            EditRecord(int.Parse(Session["TicketID"].ToString()), ticketDateTextBox.Text, ticketDescriptionTextBox.Text,
                billableTimeDecimal, billableRateDecimal, ticketTotalDecimal, ticketPaidString, ticketProfitDecimal);

            EditRecord(int.Parse(Session["TicketID"].ToString()), ticketDateTextBox.Text, "I'm Working, WooHoo",
                .5m, 75m, ticketTotalDecimal, ticketPaidString, ticketProfitDecimal);

using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using System.Data.SqlClient;
using System.Configuration;

public partial class EditTicket : System.Web.UI.Page
{
    int therapistID = 0;
    decimal therapistPercentageDecimal = 0m;

    protected void Page_Load(object sender, EventArgs e)
    {
        string ticketPaidString = "";
        string sSQL = "GetTicketByTicketID";
        SqlConnection cnGetRecords = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlCommand cmdGetRecords = new SqlCommand();
        SqlDataAdapter daGetRecords = new SqlDataAdapter();
        cmdGetRecords.Parameters.Clear();
        cmdGetRecords.CommandText = sSQL;
        cmdGetRecords.CommandType = CommandType.StoredProcedure;
        cmdGetRecords.Parameters.AddWithValue("@TicketID", int.Parse(Session["TicketID"].ToString()));
        cmdGetRecords.Connection = cnGetRecords;
        daGetRecords.SelectCommand = cmdGetRecords;
        cnGetRecords.Open();
        SqlDataReader rdr = null;
        rdr = cmdGetRecords.ExecuteReader();
        while (rdr.Read())
        {
            ticketDateTextBox.Text = ((DateTime)rdr["TicketDate"]).ToShortDateString();
            ticketDescriptionTextBox.Text = (string)rdr["TicketDescription"];
            therapistID = (int)rdr["TherapistID"];
            billableTimeTextBox.Text = ((decimal)rdr["TicketBillableTime"]).ToString();
            billableRateTextBox.Text = ((decimal)rdr["TicketBillableRate"]).ToString();
            ticketPaidString = (string)rdr["TicketPaid"];
        }
        cnGetRecords.Close();

        sSQL = "GetTherapistByTherapistID";
        cmdGetRecords.Parameters.Clear();
        cmdGetRecords.CommandText = sSQL;
        cmdGetRecords.CommandType = CommandType.StoredProcedure;
        cmdGetRecords.Parameters.AddWithValue("@TherapistID", therapistID);
        cmdGetRecords.Connection = cnGetRecords;
        daGetRecords.SelectCommand = cmdGetRecords;
        cnGetRecords.Open();
        rdr = null;
        rdr = cmdGetRecords.ExecuteReader();
        while (rdr.Read())
        {
            therapistPercentageDecimal = (decimal)rdr["TherapistPercentage"];
        }
        cnGetRecords.Close();

        if (ticketPaidString == "Paid")
        {
            ticketPaidYesRadioButton.Checked = true;
        }
        if (ticketPaidString == "Unpaid")
        {
            ticketPaidNoRadioButton.Checked = true;
        }
    }

    protected void EditRecord(int TicketID, string TicketDate, string TicketDescription, decimal TicketBillableTime,
        decimal TicketBillableRate, decimal TicketTotal, string TicketPaid, decimal TicketProfit)
    {
        string sSQL = "UpdateTicket";
        SqlConnection cnUpdateRecord = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlCommand cmdUpdateRecord = new SqlCommand();
        cmdUpdateRecord.Parameters.Clear();
        cmdUpdateRecord.CommandText = sSQL;
        cmdUpdateRecord.CommandType = CommandType.StoredProcedure;
        cmdUpdateRecord.Parameters.AddWithValue("@TicketID", TicketID);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketDate", TicketDate);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketDescription", TicketDescription);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketBillableTime", TicketBillableTime);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketBillableRate", TicketBillableRate);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketTotal", TicketTotal);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketPaid", TicketPaid);
        cmdUpdateRecord.Parameters.AddWithValue("@TicketProfit", TicketProfit);
        cmdUpdateRecord.Connection = cnUpdateRecord;
        cnUpdateRecord.Open();
        cmdUpdateRecord.ExecuteNonQuery();
        cnUpdateRecord.Close();
    }

    protected void addTicketButton_Click(object sender, EventArgs e)
    {
        int error = 0;
        string errorText = "";
        decimal billableTimeDecimal = 0m;
        decimal billableRateDecimal = 0m;
        decimal ticketTotalDecimal = 0m;
        decimal ticketProfitDecimal = 0m;
        string ticketPaidString = "";

        try
        {
            billableTimeDecimal = decimal.Parse(billableTimeTextBox.Text);
        }
        catch (FormatException)
        {
            errorText += "Billable Time must be a numeric value <br />";
            error++;
        }
        try
        {
            billableRateDecimal = decimal.Parse(billableRateTextBox.Text);
        }
        catch (FormatException)
        {
            errorText += "Billable Rate must be a numeric value <br />";
            error++;
        }
        if (error == 0 && billableTimeDecimal > 0 && billableRateDecimal > 0)
        {
            ticketTotalDecimal = billableTimeDecimal * billableRateDecimal;
            if (therapistPercentageDecimal < 100)
            {
                ticketProfitDecimal = ticketTotalDecimal - (ticketTotalDecimal * (therapistPercentageDecimal / 100));
            }
            else
            {
                ticketProfitDecimal = ticketTotalDecimal;
            }
        }
        else
        {
            errorText += "Billable Rate and Billable Time must be greater than zero <br />";
            error++;
        }
        if (ticketPaidYesRadioButton.Checked)
        {
            ticketPaidString = "Paid";
        }
        else if (ticketPaidNoRadioButton.Checked)
        {
            ticketPaidString = "Unpaid";
        }
        if (error == 0)
        {
            EditRecord(int.Parse(Session["TicketID"].ToString()), ticketDateTextBox.Text, ticketDescriptionTextBox.Text,
                billableTimeDecimal, billableRateDecimal, ticketTotalDecimal, ticketPaidString, ticketProfitDecimal);

            Server.Transfer("Tickets.aspx");
        }
        else if (error != 0)
        {
            errorLabel.Text = errorText;
        }
    }
}

    protected void Page_Load(object sender, EventArgs e)
    {
        //Check the PostBack property of the page to see if the client
        //initiated a post back event
        if (!Page.IsPostBack)
        {
            string ticketPaidString = "";
            string sSQL = "GetTicketByTicketID";
            SqlConnection cnGetRecords = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            SqlCommand cmdGetRecords = new SqlCommand();
            SqlDataAdapter daGetRecords = new SqlDataAdapter();
            cmdGetRecords.Parameters.Clear();
            cmdGetRecords.CommandText = sSQL;
            cmdGetRecords.CommandType = CommandType.StoredProcedure;
            cmdGetRecords.Parameters.AddWithValue("@TicketID", int.Parse(Session["TicketID"].ToString()));
            cmdGetRecords.Connection = cnGetRecords;
            daGetRecords.SelectCommand = cmdGetRecords;
            cnGetRecords.Open();
            SqlDataReader rdr = null;
            rdr = cmdGetRecords.ExecuteReader();
            while (rdr.Read())
            {
                ticketDateTextBox.Text = ((DateTime)rdr["TicketDate"]).ToShortDateString();
                ticketDescriptionTextBox.Text = (string)rdr["TicketDescription"];
                therapistID = (int)rdr["TherapistID"];
                billableTimeTextBox.Text = ((decimal)rdr["TicketBillableTime"]).ToString();
                billableRateTextBox.Text = ((decimal)rdr["TicketBillableRate"]).ToString();
                ticketPaidString = (string)rdr["TicketPaid"];
            }
            cnGetRecords.Close();

            sSQL = "GetTherapistByTherapistID";
            cmdGetRecords.Parameters.Clear();
            cmdGetRecords.CommandText = sSQL;
            cmdGetRecords.CommandType = CommandType.StoredProcedure;
            cmdGetRecords.Parameters.AddWithValue("@TherapistID", therapistID);
            cmdGetRecords.Connection = cnGetRecords;
            daGetRecords.SelectCommand = cmdGetRecords;
            cnGetRecords.Open();
            rdr = null;
            rdr = cmdGetRecords.ExecuteReader();
            while (rdr.Read())
            {
                therapistPercentageDecimal = (decimal)rdr["TherapistPercentage"];
            }
            cnGetRecords.Close();

            if (ticketPaidString == "Paid")
            {
                ticketPaidYesRadioButton.Checked = true;
            }
            if (ticketPaidString == "Unpaid")
            {
                ticketPaidNoRadioButton.Checked = true;
            }
        }
    }