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 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 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(); } }