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