private void loginButton_click(object sender, EventArgs e)
{
try{
// Check for empty username or password
if(usernameTextbox.Text == "" || passwordTextbox.Text == ""){
throw new Exception("You must enter a username and password.");
}
// Query the kddb database to check if the username/password combination are valid.
string queryString = string.Format("SELECT * FROM skrohn_kddb.login WHERE username=\"{0}\" AND pw=\"{1}\"", usernameTextbox.Text, passwordTextbox.Text);
DataTable dt = DatabaseAccess.selectDB(queryString);
// Check if the query returned any rows with the specified username and password.
if(dt.Rows.Count > 0){
// Valid username and password
MyMessageBox box = new MyMessageBox("Login successful.");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
this.Visible = false;
EmployeeScreen employeeGUI = new EmployeeScreen(this);
employeeGUI.StartPosition = FormStartPosition.CenterParent;
employeeGUI.ShowDialog();
}
else{
MyMessageBox box = new MyMessageBox("Invalid login information.");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
}
catch(Exception ex){
MyMessageBox box = new MyMessageBox(ex.Message);
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
}
// Add the order to the database of completed orders, then clear the shopping cart.
public void checkout()
{
if(cart.itemCount() > 0){
string orderData = "";
// Check for multiples of the same item to add to orderData string.
for(int i = 0; i < cart.itemCount(); i++){
for(int count = 0; count < cart.getItem(i).itemTwo; count++){
orderData += cart.getItem(i).itemOne.toDataString();
}
}
// Create the MySql query using the orderData string.
string queryString = string.Format("INSERT INTO skrohn_kddb.orders (orderdata) VALUES (\"{0}\")", orderData);
// Submit the query to the database, clear the cart if successful. Display success message.
if(DatabaseAccess.insertDB(queryString)){
cart.emptyCart();
MyMessageBox box = new MyMessageBox("Order successfully submitted.");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
}
else{
MyMessageBox box = new MyMessageBox("Your cart is empty.");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
}
private void logoutButton_Click(object sender, EventArgs e)
{
this.Close();
MyMessageBox box = new MyMessageBox("You're now logged out.");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
previousForm.Visible = true;
}
// Validate username/password, check for existing username, then add new user to database if valid.
private void createAccountButton_Click(object sender, EventArgs e)
{
try{
// Validate username and password format.
if(!validUsername(usernameTextbox.Text)){
throw new Exception("Invalid username.\nUsername must be alphanumeric.");
}
else if(!validPassword(passwordTextbox.Text)){
throw new Exception("Invalid password.\nPassword must be at least 6 characters long and contain at least 1 number.");
}
// Check if the username already exists in the database.
string queryString = string.Format("Select * FROM skrohn_kddb.login WHERE username=\"{0}\"", usernameTextbox.Text);
DataTable dt = DatabaseAccess.selectDB(queryString);
if(dt.Rows.Count > 0){
// If the username exists, throw exception.
throw new Exception("Username already exists, please select a new username.");
}
else{
// If the username didn't exist, add it to the database.
string insertString = string.Format("INSERT INTO skrohn_kddb.login (username, pw) VALUES (\"{0}\", \"{1}\")", usernameTextbox.Text, passwordTextbox.Text);
DatabaseAccess.insertDB(insertString);
}
// Display message if registration was successful.
MyMessageBox box = new MyMessageBox("Registration successful. Please login with your username and password.");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
this.Close();
previousForm.Visible = true;
}
catch(Exception ex){
MyMessageBox box = new MyMessageBox(ex.Message);
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
}
private void addToCartButton_Click(object sender, EventArgs e)
{
try{
if(tabContol.SelectedTab == chalkboardTab){
ShoppingCart.Chalkboard board = getChalkboardOrder();
for(int i = 0; i < chalkboard_countNumeric.Value; i++){
cart.addItem(board);
}
clearAllChalkboardFields();
}
else if(tabContol.SelectedTab == sconceTab){
ShoppingCart.Sconce sconce = getSconceOrder();
for(int i = 0; i < sconce_countNumeric.Value; i++){
cart.addItem(sconce);
}
clearAllSconceFields();
}
else if(tabContol.SelectedTab == boxTab){
ShoppingCart.Box weddingBox = getBoxOrder();
for(int i = 0; i < box_countNumeric.Value; i++){
cart.addItem(weddingBox);
}
clearAllBoxFields();
}
else if(tabContol.SelectedTab == organizerTab){
}
else if(tabContol.SelectedTab == masonSconceTab){
}
else{
throw new Exception("You must select a type of item to add to the cart");
}
MyMessageBox box = new MyMessageBox("Item added to cart");
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
catch(Exception ex){
MyMessageBox box = new MyMessageBox(ex.Message);
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
}
// Pricing for the standard sizes are stored in the database. This fuctions gets those prices based on the size.
private Pair<double, double> getPricing(double length, double width, ShoppingCart.Chalkboard.Magnetic_Type mag)
{
try{
bool isMagnetic = (mag == ShoppingCart.Chalkboard.Magnetic_Type.Magnetic) ? true:false;
string queryString = string.Format("SELECT * FROM skrohn_kddb.pricing_chalkboard WHERE length=\"{0}\" AND width=\"{1}\" AND magnetic={2}", length, width, isMagnetic);
DataTable data = DatabaseAccess.selectDB(queryString);
return new Pair<double,double>(Convert.ToDouble(data.Rows[0][4]), Convert.ToDouble(data.Rows[0][5]));
}
catch(Exception ex){
MyMessageBox box = new MyMessageBox(ex.Message);
box.StartPosition = FormStartPosition.CenterParent;
box.ShowDialog();
}
throw new Exception("Unable to locate pricing data.");
}
