protected void fillEditUserForm()
        {
            consignorsPanel.Visible = false;
            editUserInfo.Visible = false;

            mySqlConnector mySqlConn = new mySqlConnector();
            if(mySqlConn.isInitialized()){

                if (mySqlConn.getUserInfo(Session["emailAddress"].ToString()))
                {
                    FirstName.Text = mySqlConn.UserObj.FirstName;
                    LastName.Text = mySqlConn.UserObj.LastName;
                    Email.Text = mySqlConn.UserObj.Email;

                    //split this string
                    PhoneNumber.Text = mySqlConn.UserObj.Phone;

                    Address1.Text = mySqlConn.UserObj.Address1;
                    Address2.Text = mySqlConn.UserObj.Address2;
                    City.Text = mySqlConn.UserObj.City;
                    State.SelectedValue = State.Items.FindByValue(mySqlConn.UserObj.State).Value;
                    stateVal = mySqlConn.UserObj.State;

                    //split this string
                    Zip.Text = mySqlConn.UserObj.Zip;
                    Zip2.Text = mySqlConn.UserObj.Zip2;

                    OptIn.Checked = mySqlConn.UserObj.mailingList;
                }

            }
            else{
                displayEditErrors("DB Error. Please refresh and try again.");
            }
        }
        protected Boolean saveTestimonial(int custID)
        {
            try
            {
                if (mySqlObj.isInitialized())
                {
                    if (mySqlObj.saveTestimonial(custID, Single_Testimonial))
                    {
                        mySqlObj.deInitialize();
                        mySqlObj = null;
                        return true;
                    }
                    else
                    {
                        this.errMsg = mySqlObj.connErrMsg;
                    }
                }
            }
            catch (Exception e)
            {
                this.errMsg = e.Message.ToString();
            }

            try
            {
                mySqlObj.deInitialize();
                mySqlObj = null;
            }
            catch(Exception e){
                //do nothing.
            }
            return false;
        }
        protected void autoLogin()
        {
            mySqlConnector mySqlconn = new mySqlConnector();
            if (mySqlconn.isInitialized())
            {
                responseText.Visible = true;
                if (mySqlconn.login("*****@*****.**", "testing"))
                {
                    //validated, so write user session info
                    Session["firstname"] = mySqlconn.UserObj.FirstName;
                    Session["lastName"] = mySqlconn.UserObj.LastName;
                    Session["emailAddress"] = mySqlconn.UserObj.Email;
                    Session["isConsignor"] = mySqlconn.UserObj.isConsignor;
                    Session["isAdmin"] = mySqlconn.UserObj.isAdmin;
                    Session["userId"] = mySqlconn.UserObj.UserId;
                    Session["isLoggedIn"] = true;

                    //close connection
                    mySqlconn.deInitialize();

                    redirectUser();
                }
                else
                {
                    //displayResponseMessage(true, "Email & password combination are incorrect.  <br/>Please try again.");
                    displayResponseMessage(true, mySqlconn.connErrMsg);
                }
            }
            else
            {
                string whatGives = mySqlconn.testConnection();
                displayResponseMessage(true, "Database Connection Failure: " + whatGives);
            }
        }
        protected string joinMailingListSuccess()
        {
            string addToMailingList = Request.QueryString["a"];
            string emailAddress = Request.QueryString["e"];
            string errMsg = String.Empty;

            if (addToMailingList != "")
            {
                mySqlConnector mySqlConn = new mySqlConnector();
                try
                {
                    if (mySqlConn.isInitialized())
                    {
                        return mySqlConn.joinMailingList(emailAddress)?  "true" : mySqlConn.connErrMsg;
                    }
                    else
                    {
                        return "db connection err";
                    }
                }
                catch(Exception ee)
                {
                    errMsg = ee.Message.ToString();
                    return "db connection error";
                }

            }
            else
            {
                return "err";
            }
        }
        protected Boolean getTestimonial(int custID, Boolean getAll)
        {
            if (mySqlObj.isInitialized())
            {
                if(mySqlObj.getTestimonial(custID, getAll)){
                    //pass data from sqlQuery
                    this.ds = mySqlObj.ds;

                    mySqlObj.deInitialize();
                    mySqlObj = null;
                    return true;
                }
            }
            return false;
        }
        protected void verifyConsignor(string consignorEmail, string consignorID, string adminID)
        {
            string dbErr = "dbErr";

            mySqlConnector mySqlConn = new mySqlConnector();
            if (mySqlConn.isInitialized())
            {
                if (mySqlConn.callApproveConsignor(consignorEmail, consignorID, adminID))
                {
                    mySqlConn.deInitialize();
                    dbErr = "";
                }
            }

            Response.Redirect("~/Admin/Default.aspx?err=" + dbErr + "&f=approveconsignor&eid=" + consignorEmail);
        }
        protected void authenticateUser()
        {
            mySqlConnector mySqlconn = new mySqlConnector();
            if (mySqlconn.isInitialized())
            {
                if (mySqlconn.login(EmailAddress.Text, Password.Text, false))
                {
                    //validated, so write user session info
                    Session["firstname"] = mySqlconn.UserObj.FirstName;
                    Session["lastName"] = mySqlconn.UserObj.LastName;
                    Session["emailAddress"] = mySqlconn.UserObj.Email;
                    Session["isConsignor"] = mySqlconn.UserObj.isConsignor;
                    Session["isAdmin"] = mySqlconn.UserObj.isAdmin;
                    Session["userId"] = mySqlconn.UserObj.UserId;
                    Session["isLoggedIn"] = true;

                    //close connection
                    mySqlconn.deInitialize();
                    //success!
                    redirectUser();
                }
                else
                {//AUTHENTICATION HAS FAILED
                    //displayResponseMessage(true, "Email & password combination are incorrect.  <br/>Please try again.");
                    string errMsg = mySqlconn.connErrMsg;

                    if (errMsg.IndexOf("Please register") > 0)
                    {
                        displayResponseMessage(true, errMsg);
                    }
                    else
                    {
                        displayResponseMessage(true, mySqlconn.connErrMsg);
                        return;
                    }
                }
            }
            else
            {
                string whatGives = mySqlconn.testConnection();
                displayResponseMessage(true, "Database Connection Failure: " + whatGives);
            }
        }
        protected void saveInventoryForm(Dictionary<string, string> inventoryUploadForm)
        {
            saveErr = "";

            try
            {
                mySqlConnector mySqlConn = new mySqlConnector();
                if (mySqlConn.isInitialized())
                {
                    saveErr = mySqlConn.uploadInventory(inventoryUploadForm) ? "" : mySqlConn.connErrMsg;
                    if (saveErr != "")
                    {
                        displayFormErrors();
                    }
                    mySqlConn.deInitialize();
                }
                else
                {
                    if (mySqlConn.connErrMsg == "already registered")
                    {
                        saveErr = "Email Address already registered.";
                        //trigger reset password link
                    }
                    else
                    {
                        saveErr = "Error connecting to database. Please try again later.";
                    }
                    displayFormErrors();
                    return;
                }
            }
            catch (Exception ee)
            {
                saveErr = ee.Message.ToString();
                displayFormErrors();
                return;
            }

            //push user to success page and consignment agreement
               // Response.Redirect("~/Default.aspx");
        }
        protected void showConsignorsPanel()
        {
            string errMsg = string.Empty;

            mySqlConnector mySqlConn = new mySqlConnector();

            if (mySqlConn.isInitialized())
            {
                BoundField eventTitle = new BoundField();
                eventTitle.ReadOnly = true;
                eventTitle.HeaderText = "Event";
                eventTitle.DataField = "eventtitle";
                //eventTitle.SortExpression = "eventtitle";
                gvExportList.Columns.Add(eventTitle);

                BoundField venue = new BoundField();
                venue.ReadOnly = true;
                venue.HeaderText = "Venue";
                venue.DataField = "venue";
                //venue.SortExpression = "venue";
                gvExportList.Columns.Add(venue);

                BoundField eventDate = new BoundField();
                eventDate.ReadOnly = true;
                eventDate.HeaderText = "Date";
                eventDate.DataField = "eventdate";
                //eventDate.SortExpression = "eventdate";
                gvExportList.Columns.Add(eventDate);

                BoundField eventTime = new BoundField();
                eventTime.ReadOnly = true;
                eventTime.HeaderText = "Time";
                eventTime.DataField = "eventtime";
            //	eventTime.SortExpression = "eventtime";
                gvExportList.Columns.Add(eventTime);

                BoundField qty = new BoundField();
                qty.ReadOnly = true;
                qty.HeaderText = "Qty";
                qty.DataField = "quantity";
                //qty.SortExpression = "quantity";
                gvExportList.Columns.Add(qty);

                BoundField sec = new BoundField();
                sec.ReadOnly = true;
                sec.HeaderText = "Section";
                sec.DataField = "section";
                //sec.SortExpression = "section";
                gvExportList.Columns.Add(sec);

                BoundField seatRow = new BoundField();
                seatRow.ReadOnly = true;
                seatRow.HeaderText = "Row";
                seatRow.DataField = "seatrow";
                //seatRow.SortExpression = "seatrow";
                gvExportList.Columns.Add(seatRow);

                BoundField seatFrom = new BoundField();
                seatFrom.ReadOnly = true;
                seatFrom.HeaderText = "From";
                seatFrom.DataField = "seatfrom";
                //seatFrom.SortExpression = "seatfrom";
                gvExportList.Columns.Add(seatFrom);

                BoundField seatThru = new BoundField();
                seatThru.ReadOnly = true;
                seatThru.HeaderText = "Thru";
                seatThru.DataField = "seatthru";
                //seatThru.SortExpression = "seatthru";
                gvExportList.Columns.Add(seatThru);

                BoundField cost = new BoundField();
                cost.ReadOnly = true;
                cost.HeaderText = "Price";
                cost.DataField = "cost";
                //cost.SortExpression = "cost";
                gvExportList.Columns.Add(cost);

                BoundField cNotes = new BoundField();
                cNotes.ReadOnly = true;
                cNotes.HeaderText = "Notes";
                cNotes.DataField = "consignornotes";
                //cNotes.SortExpression = "consignornotes";
                gvExportList.Columns.Add(cNotes);

                //now make call to database for rows
                if (mySqlConn.getExportList(Convert.ToInt16(Session["userId"]), true))
                {
                    gvExportList.DataSource = null;
                    gvExportList.Dispose();
                    gvExportList.DataSource = mySqlConn.ds;
                    gvExportList.DataBind();
                }
                else
                {
                    noExports.Text = mySqlConn.connErrMsg;
                    noExports.Visible = true;
                }
            }
            else
            {
                errMsg = "db connection error!";
                displayMySqlConnErr(errMsg);
            }

            mySqlConn.deInitialize();

            consignorsPanel.Visible = true;
        }
        protected void saveEditedUserInfo(Dictionary<string, string> formInfo)
        {
            saveErr = "";

            try
            {
                mySqlConnector mySqlConn = new mySqlConnector();
                if (mySqlConn.isInitialized())
                {
                    saveErr = mySqlConn.saveUserEditInfo(Email.Text, formInfo) ? "" : mySqlConn.connErrMsg;
                    if (saveErr != "")
                    {
                        displayEditErrors(saveErr);
                        mySqlConn.deInitialize();
                    }
                    else
                    {   //write new session values
                        Session["emailAddress"] = formInfo["Email"];
                        Session["firstname"] = formInfo["First Name"];
                        Session["lastName"] = formInfo["Last Name"];

                        mySqlConn.deInitialize();
                        resetPage("Your Information has been updated!");
                    }
                }
                else
                {
                    displayEditErrors(mySqlConn.connErrMsg);
                }
            }
            catch (Exception ee)
            {
                displayEditErrors(ee.Message.ToString());
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string formType = Request.Form["formType"];
                string selPhoneType = Request.Form["selPhoneType"];
                string txtCity = Request.Form["txtCity"];
                string txtDateTime = Request.Form["txtDateTime"];
                string txtDescription = Request.Form["txtDescription"];
                string txtEmail = Request.Form["txtEmail"];
                string txtEvent = Request.Form["txtEvent"];
                string txtFName = Request.Form["txtFName"];
                string txtLName = Request.Form["txtLName"];
                string txtPhone = Request.Form["txtPhone"];
                string txtPriceRange = Request.Form["txtPriceRange"];
                string txtSeating = Request.Form["txtSeating"];
                string txtState = Request.Form["txtState"];
                string txtStreet = Request.Form["txtStreet"];
                string txtStreet2 = Request.Form["txtStreet2"];
                string txtVenue = Request.Form["txtVenue"];
                string txtZip = Request.Form["txtZip"];

                Dictionary<string, string> formDetails = new Dictionary<string, string>();
                formDetails.Add("formType", formType);
                formDetails.Add("Best Time To Call", selPhoneType);
                formDetails.Add("City", txtCity);
                formDetails.Add("Date", txtDateTime);
                formDetails.Add("Description", txtDescription);
                formDetails.Add("Email", txtEmail);
                formDetails.Add("Event", txtEvent);
                formDetails.Add("First Name", txtFName);
                formDetails.Add("Last Name", txtLName);
                formDetails.Add("Phone Number", txtPhone);
                formDetails.Add("Price Range", txtPriceRange);
                formDetails.Add("Seats", txtSeating);
                formDetails.Add("State", txtState);
                formDetails.Add("Address1", txtStreet);
                formDetails.Add("Address2", txtStreet2);
                formDetails.Add("Venue", txtVenue);
                formDetails.Add("Zip", txtZip);

                String strErrMsg = String.Empty;
                mySqlConnector mySqlConn = new mySqlConnector();
                if (mySqlConn.isInitialized())
                {
                    if (mySqlConn.sendTicketRequest(formDetails))
                    {
                        Response.Redirect("~/tickets/ticketRequestSuccess.aspx");
                        return;
                    }
                    else
                    {
                        strErrMsg = mySqlConn.connErrMsg;
                    }
                }
                else
                {
                    strErrMsg = "Error connecting to Database.  Please refresh the page and try again.";
                }

                Response.Redirect("~/content/generalError.aspx?e=" + strErrMsg);
                return;
            }
            else
            {

                int bid = 3939;
                int siteId = 3;
                string evtId = Request.QueryString["evtId"];

                string plugin = "<script type=\"text/javascript\" src=\"http://tickettransaction.com/?bid=" + bid;
                plugin += "&sitenumber=" + siteId + "&tid=507&evtid=" + evtId + "\"></script>";
                ticketDetail.Text = plugin;

            //-- FB PLUGIN STUFF	#####################################################

                String ogURL = HttpContext.Current.Request.Url.ToString();
                    if (ogURL.IndexOf("Jay-Z") > 0 && ogURL.IndexOf("Kanye") > 0)
                    {
                        ogURL = ogURL + "&fbid=12";
                    }

                //title for facebook post/message
                String ogTitle = Request.QueryString["event"];
                ogTitle = ogTitle.Replace("+", " ");
                ogTitle = ogTitle.Replace("%20", " ");

                //the meta tags
                StringBuilder fbMetaTags = new StringBuilder();
                    fbMetaTags.Append("<meta property=\"og:title\" content=\"" + ogTitle + "\" />");
                    fbMetaTags.Append("<meta property=\"og:type\" content=\"activity\" />");
                    fbMetaTags.Append("<meta property=\"og:url\" content=\"" + ogURL + "\" />");
                    fbMetaTags.Append("<meta property=\"og:image\" content=\"http://www.rockstarseating.com/assets/img/hdrLogo.png\" />");
                    fbMetaTags.Append("<meta property=\"og:site_name\" content=\"Rockstar Seating\" />");
                    fbMetaTags.Append("<meta property=\"fb:admins\" content=\"1604973672\" />");
                this.metaTags.Text = fbMetaTags.ToString();

                // the script
                StringBuilder sb = new StringBuilder();
                    sb.Append("<div id=\"fb-root\"></div>");
                    sb.Append("<script type=\"text/javascript\">");
                    sb.Append("(function (d, s, id) {");
                    sb.Append("var js, fjs = d.getElementsByTagName(s)[0];");
                    sb.Append("if (d.getElementById(id)) { return; }");
                    sb.Append("js = d.createElement(s); js.id = id;");
                    sb.Append("js.src = \"//connect.facebook.net/en_US/all.js#xfbml=1&appId=202160576522677\";");
                    sb.Append("fjs.parentNode.insertBefore(js, fjs);");
                    sb.Append("} (document, 'script', 'facebook-jssdk'));");
                    sb.Append("</script>");

                    sb.Append("<div class=\"fb-like\" data-href=\"" + ogURL + "\"");
                    sb.Append(" data-send=\"true\" data-layout=\"button_count\" data-width=\"200\"");
                    sb.Append(" data-show-faces=\"true\" data-action=\"recommend\" data-font=\"arial\"></div>");
                this.likeBtn.Text = sb.ToString();

            }//end postBack check
        }
        protected void showPendingInventoryExports()
        {
            string errMsg = string.Empty;

            mySqlConnector mySqlConn = new mySqlConnector();

            if (mySqlConn.isInitialized())
            {
                if (mySqlConn.getExportList())
                {
                    GVExportList_Clear();

                    if (gvExportList.Columns.Count < 1)
                    {

                        BoundField userId = new BoundField();
                        userId.ReadOnly = true;
                        userId.HeaderText = "UserId";
                        userId.DataField = "emailaddress";
                        //userId.SortExpression = "emailaddress";
                        gvExportList.Columns.Add(userId);

                        BoundField eventTitle = new BoundField();
                        eventTitle.ReadOnly = true;
                        eventTitle.HeaderText = "Event";
                        eventTitle.DataField = "eventtitle";
                        //eventTitle.SortExpression = "eventtitle";
                        gvExportList.Columns.Add(eventTitle);

                        BoundField venue = new BoundField();
                        venue.ReadOnly = true;
                        venue.HeaderText = "Venue";
                        venue.DataField = "venue";
                        //venue.SortExpression = "venue";
                        gvExportList.Columns.Add(venue);

                        BoundField eventDate = new BoundField();
                        eventDate.ReadOnly = true;
                        eventDate.HeaderText = "Date";
                        eventDate.DataField = "eventdate";
                        //eventDate.SortExpression = "eventdate";
                        gvExportList.Columns.Add(eventDate);

                        BoundField eventTime = new BoundField();
                        eventTime.ReadOnly = true;
                        eventTime.HeaderText = "Time";
                        eventTime.DataField = "eventtime";
                        //	eventTime.SortExpression = "eventtime";
                        gvExportList.Columns.Add(eventTime);

                        BoundField qty = new BoundField();
                        qty.ReadOnly = true;
                        qty.HeaderText = "Qty";
                        qty.DataField = "quantity";
                        //qty.SortExpression = "quantity";
                        gvExportList.Columns.Add(qty);

                        BoundField sec = new BoundField();
                        sec.ReadOnly = true;
                        sec.HeaderText = "Section";
                        sec.DataField = "section";
                        //sec.SortExpression = "section";
                        gvExportList.Columns.Add(sec);

                        BoundField seatRow = new BoundField();
                        seatRow.ReadOnly = true;
                        seatRow.HeaderText = "Row";
                        seatRow.DataField = "seatrow";
                        //seatRow.SortExpression = "seatrow";
                        gvExportList.Columns.Add(seatRow);

                        BoundField seatFrom = new BoundField();
                        seatFrom.ReadOnly = true;
                        seatFrom.HeaderText = "From";
                        seatFrom.DataField = "seatfrom";
                        //seatFrom.SortExpression = "seatfrom";
                        gvExportList.Columns.Add(seatFrom);

                        BoundField seatThru = new BoundField();
                        seatThru.ReadOnly = true;
                        seatThru.HeaderText = "Thru";
                        seatThru.DataField = "seatthru";
                        //seatThru.SortExpression = "seatthru";
                        gvExportList.Columns.Add(seatThru);

                        BoundField cost = new BoundField();
                        cost.ReadOnly = true;
                        cost.HeaderText = "Price";
                        cost.DataField = "cost";
                        //cost.SortExpression = "cost";
                        gvExportList.Columns.Add(cost);

                        BoundField cNotes = new BoundField();
                        cNotes.ReadOnly = true;
                        cNotes.HeaderText = "Notes";
                        cNotes.DataField = "consignornotes";
                        //cNotes.SortExpression = "consignornotes";
                        gvExportList.Columns.Add(cNotes);

                        gvExportList.DataSource = mySqlConn.ds;
                        gvExportList.DataBind();
                    }
                }
                else
                {
                    GVExportList_Clear();
                    noExports.Text = mySqlConn.connErrMsg;
                    noExports.Visible = true;
                }
            }
            else
            {
                errMsg = "db connection error!";
                displayFormErrors(errMsg);
            }

            mySqlConn.deInitialize();
        }
        protected void getLastExportTime()
        {
            string lastExport = String.Empty;
            mySqlConnector mySqlConn = new mySqlConnector();

            if (mySqlConn.isInitialized())
            {
                lastExport = mySqlConn.getLastInventoryExport();
            }
            else
            {
                lastExport = "db connection error!";
            }
            mySqlConn.deInitialize();
            lastExported.Text = lastExport;
        }
        protected void checkForConsignmentApprovals()
        {
            string errMsg = string.Empty;
            string statusMsg = string.Empty;
            string cEmailID = (!String.IsNullOrEmpty(Request.QueryString["eid"]))? Request.QueryString["eid"].ToString() : "";
            string dbErr =
            (!String.IsNullOrEmpty(Request.QueryString["dbErr"]))? Request.QueryString["dbErr"].ToString() : "";
            string funkShun =
            (!String.IsNullOrEmpty(Request.QueryString["f"]))? Request.QueryString["f"].ToString() : "";

            if (funkShun == "approveconsignor")
            {
                if (dbErr == "")
                {
                    statusMsg = "Consignor [ " + cEmailID + " ] approved.";
                    lblStatusMsg.CssClass = "statusMsg";
                }
                else
                {
                    statusMsg = "DB error on Consignor Approval: [ " + cEmailID + " ]. Please try again.";
                    lblStatusMsg.CssClass = "errMsg";
                }

                lblStatusMsg.Visible = true;
                lblStatusMsg.Text = statusMsg;
            }

            mySqlConnector mySqlConn = new mySqlConnector();

            if (mySqlConn.isInitialized())
            {
                //--	now check db for pending approvals
                if (mySqlConn.checkForPending_C_Approvals())
                {
                    HyperLinkField userId = new HyperLinkField();
                    userId.HeaderText = "UserId";
                    userId.DataTextField = "emailaddress";
                    userId.DataNavigateUrlFields = new string[] { "emailaddress", "userId" };
                    userId.DataNavigateUrlFormatString = "~/admin/approveConsignor.aspx?eid={0}&uid={1}&aid=" + Session["emailAddress"].ToString();
                    //userId.SortExpression = "emailaddress";
                    gvConsingorApproveList.Columns.Add(userId);

                    BoundField firstname = new BoundField();
                    firstname.ReadOnly = true;
                    firstname.HeaderText = "First";
                    firstname.DataField = "firstname";
                    //firstname.SortExpression = "firstname";
                    gvConsingorApproveList.Columns.Add(firstname);

                    BoundField lastname = new BoundField();
                    lastname.ReadOnly = true;
                    lastname.HeaderText = "Last";
                    lastname.DataField = "lastname";
                    //lastname.SortExpression = "lastname";
                    gvConsingorApproveList.Columns.Add(lastname);

                    BoundField address1 = new BoundField();
                    address1.ReadOnly = true;
                    address1.HeaderText = "Address";
                    address1.DataField = "address1";
                    //address1.SortExpression = "address1";
                    gvConsingorApproveList.Columns.Add(address1);

                    BoundField address2 = new BoundField();
                    address2.ReadOnly = true;
                    address2.HeaderText = "Address2";
                    address2.DataField = "address2";
                    //	address2.SortExpression = "address2";
                    gvConsingorApproveList.Columns.Add(address2);

                    BoundField city = new BoundField();
                    city.ReadOnly = true;
                    city.HeaderText = "City";
                    city.DataField = "city";
                    //city.SortExpression = "city";
                    gvConsingorApproveList.Columns.Add(city);

                    BoundField state = new BoundField();
                    state.ReadOnly = true;
                    state.HeaderText = "State";
                    state.DataField = "state";
                    //state.SortExpression = "state";
                    gvConsingorApproveList.Columns.Add(state);

                    BoundField zip = new BoundField();
                    zip.ReadOnly = true;
                    zip.HeaderText = "Zip";
                    zip.DataField = "zip";
                    //	zip.SortExpression = "zip";
                    gvConsingorApproveList.Columns.Add(zip);

                    BoundField phoneNumber = new BoundField();
                    phoneNumber.ReadOnly = true;
                    phoneNumber.HeaderText = "Phone";
                    phoneNumber.DataField = "phoneNumber";
                    //phoneNumber.SortExpression = "phoneNumber";
                    gvConsingorApproveList.Columns.Add(phoneNumber);

                    BoundField createDate = new BoundField();
                    createDate.ReadOnly = true;
                    createDate.HeaderText = "__date";
                    createDate.DataField = "created";
                    //phoneNumber.SortExpression = "phoneNumber";
                    gvConsingorApproveList.Columns.Add(createDate);

                    gvConsingorApproveList.DataSource = null;
                    gvConsingorApproveList.Dispose();
                    gvConsingorApproveList.DataSource = mySqlConn.ds;
                    gvConsingorApproveList.DataBind();
                    consingorApproveList.Visible = true;
                }
                else
                {
                    noConsignors.Text = mySqlConn.connErrMsg;
                    noConsignors.Visible = true;
                }
            }
            else
            {
                errMsg = "db connection error!";
                displayFormErrors(errMsg);
            }

            mySqlConn.deInitialize();
        }
        protected void exportBtn_click(object sender, EventArgs e)
        {
            //ten fields for export
            string[] columnHeaderList = new string[]{"Event, Venue, EventDate, EventTime, Quantity, Section, Row, SeatFrom, SeatThru, Notes, Cost"};

            List<List<string>> exportList;

            mySqlConnector mySqlConn = new mySqlConnector();

            if (mySqlConn.isInitialized())
            {
                exportList = mySqlConn.exportLatestUploads();

                if (exportList.Count < 1)
                {
                    noExports.Text = "Nothing to export.";
                    noExports.Visible = true;
                }
                else
                {
                    List<string> exportItem = exportList[0];
                    if (exportItem[0].IndexOf("Error:") > -1)
                    {
                        displayFormErrors(exportList[0].ToString());
                    }
                    else
                    {
                        mySqlConn.deInitialize();
                        showPendingInventoryExports();
                        CSVExporter csvExport = new CSVExporter(exportList, columnHeaderList);
                    }

                }
                mySqlConn.deInitialize();
            }
            else
            {
                displayFormErrors("Error connecting to database!");
            }
        }
        protected void saveUserInfo(Dictionary<string, string> formInfo)
        {
            saveErr = "";

            try
            {
                mySqlConnector mySqlConn = new mySqlConnector();
                if (mySqlConn.isInitialized() && mySqlConn.registerUser(formInfo))
                {
                    saveErr = mySqlConn.login(Email.Text, Password.Text) ? "" : mySqlConn.connErrMsg;
                    if (saveErr != "")
                    {
                        displayFormErrors();
                        mySqlConn.deInitialize();
                    }
                    else
                    {   //write session out for sng
                        Session["emailAddress"] = Email.Text;
                        Session["firstName"] = FirstName.Text;
                        Session["lastName"] = LastName.Text;
                        Session["isLoggedIn"] = true;
                        Session["userId"] = mySqlConn.UserObj.UserId;

                        //push user to success page and consignment agreement
                        mySqlConn.deInitialize();
                        Response.Redirect("RegisterSuccess.aspx");
                    }
                }
                else
                {
                    if (mySqlConn.connErrMsg == "already registered")
                    {
                        saveErr = "Email Address already registered.";
                    }
                    else
                    {
                        //TODO: refactor this code to produce a more specific error that can be reported??
                        saveErr = mySqlConn.connErrMsg;
                    }
                    displayFormErrors();
                }
            }
            catch (Exception ee)
            {
                saveErr = ee.Message.ToString();
                displayFormErrors();
            }
        }