protected void Page_Load(object sender, EventArgs e) { SessionFunctions.validateLogin(); string connection = SQLFunction.sqlConnection(); MySqlConnection conn = new MySqlConnection(connection); conn.Open(); //------------------------------------------------------------------------------------------------- //Get user's customer and account data string sql = "SELECT C_First_Name FROM customers c JOIN accounts a ON c.Customer_ID = a.Customer_ID WHERE Acc_Username = @username"; MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.Parameters.Add(new MySqlParameter("@username", Session["username"])); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { welcomeLabel.Text = reader.GetString("C_First_Name"); } reader.Close(); conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { SessionFunctions.validateLogin(); AccountFunctions.loadAccountData(welcomeLabel, firstNameLabel, lastNameLabel, usernameLabel, emailLabel, addressLabel1, addressLabel2, phoneLabel); }
protected void logoutButton_Click(object sender, EventArgs e) { SessionFunctions.logoutSession(); }
protected void Page_Load(object sender, EventArgs e) { SessionFunctions.checkRequestsSubmittedToday(SessionFunctions.getRequestsSubmittedToday()); RequestFunctions.loadFormData(lblCustomerName, lblCurrentDate, rbRepairType1, rbRepairType2, carMakeDropdown); }