public bool updateVendorData(string estNo, List<Approval> approvals, List<Qualification> qualifications, string user, out string resultDesc)
    {
        bool result = false;
        resultDesc = "";

        string connectionString = WebConfigurationManager.ConnectionStrings["myConn"].ConnectionString;
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            SqlTransaction transaction = connection.BeginTransaction("transcation1");
            result = insertApprovals(approvals, user, transaction, out resultDesc);
            if (result)
                result = insertQualifications(qualifications, user, transaction, out resultDesc);
            if (result)
            {
                transaction.Commit();
            }
            else
            {
                try
                {
                    transaction.Rollback();
                    resultDesc += " -- Successfully roled back.";

                }catch(Exception ex)
                {
                    resultDesc = "Rollback failed: " + ex.GetType();
                    resultDesc += " Exception Message: " + ex.Message;
                }
            }
        }
        return result;
    }

    public bool insertApprovals(List<Approval> approvals, string user, SqlTransaction transcation, out string resultDesc)
    {
        bool result = false;
        resultDesc = "";
        try
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection = transcation.Connection;
                cmd.Transaction = transcation;
                cmd.Parameters.Clear();
                cmd.Parameters.Add("@estNo", SqlDbType.NVarChar);
                cmd.Parameters.Add("@customerID", SqlDbType.Int);
                cmd.Parameters.Add("@brandName", SqlDbType.NVarChar);
                cmd.Parameters.Add("@createdBy", SqlDbType.NVarChar);

                foreach (Approval approval in approvals)
                {
                    cmd.CommandText = @"Insert into [vmsApprovals] (vendorEstNo, customerID, brand, createdBy) VALUES (@estNo, @customerID, @brandName, @createdBy)";
                    cmd.Parameters["@estNo"].Value = approval.vendorEstNo;
                    cmd.Parameters["@customerID"].Value = Convert.ToInt32(approval.customerID);
                    cmd.Parameters["@brandName"].Value = approval.brandName;
                    cmd.Parameters["@createdBy"].Value = user;
                    cmd.ExecuteNonQuery();
                }
                result = true;
                resultDesc = "All records inserted";
            }
        }catch(Exception ex)
        {
            resultDesc = "insertApprovals - Threw an exception of type: " + ex.GetType();
        }
        return result;
    }

    public bool insertQualifications(List<Qualification> qualifications, string user, SqlTransaction transcation, out string resultDesc)
    {
        bool result = false;
        resultDesc = "";

        try
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection = transcation.Connection;
                cmd.Transaction = transcation;
                cmd.Parameters.Clear();
                cmd.Parameters.Add("@estNo", SqlDbType.NVarChar);
                cmd.Parameters.Add("@qualityID", SqlDbType.Int);
                cmd.Parameters.Add("@brandName", SqlDbType.NVarChar);
                cmd.Parameters.Add("@createdBy", SqlDbType.NVarChar);

                foreach (Qualification qualification in qualifications)
                {
                    cmd.CommandText = @"Insert into [vmsQualifications] (vendorEstNo, qualityID, brand, createdBy) VALUES (@estNo, @qualityID, @brandName, @createdBy)";
                    cmd.Parameters["@estNo"].Value = qualification.vendorEstNo;
                    cmd.Parameters["@qualityID"].Value = Convert.ToInt32(qualification.qualityID);
                    cmd.Parameters["@brandName"].Value = qualification.brandName;
                    cmd.Parameters["@createdBy"].Value = user;
                    cmd.ExecuteNonQuery();
                }
                result = true;
                resultDesc = "All records inserted";
            }
        }
        catch (Exception ex)
        {
            resultDesc = "insertQualifications - Threw an exception of type: " + ex.GetType();
        }

        return result;
    }