private void btnWithdraw_Click(object sender, EventArgs e) { adminFunctions = new UseDatabase.UseDatabase(); adminFunctions.ConnectToDB(); try { adminPad.ShowDialog(); this.amount = Admin_DigitalPad.amount; if (amount != 0) { queryString = "UPDATE WORKER SET balance = balance + " + amount + "WHERE username='******' AND position='Supervisor'"; if (adminFunctions.ExecuteCommand(queryString)) { MessageBox.Show("TRANSACTION SUCCESSFULL!"); } else { MessageBox.Show("OOPS! SOMETHING WENT WRONG. TRY AGAIN!"); } } else { MessageBox.Show("OOPS! SOMETHING WENT WRONG. TRY AGAIN!"); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { adminFunctions.DisconnectToDB(); } }
private void btnCashFromOperator_Click(object sender, EventArgs e) { adminPad.ShowDialog(); try { adminFunctions = new UseDatabase.UseDatabase(); adminFunctions.ConnectToDB(); this.amount = Admin_DigitalPad.amount; queryString = "SELECT * FROM WORKER WHERE username='******' AND iPassword='******' AND cashRecieved<=" + amount; SqlDataReader reader = adminFunctions.ExecuteQuery(queryString); if (reader != null && reader.HasRows) { reader.Close(); this.operatorUsername = Admin_DigitalPad.operatorUsername; reader = checkIfLoggedIn(); if (reader != null && reader.HasRows) { reader.Close(); SqlDataReader reader1 = checkUsername(); if (reader1 != null && reader1.HasRows) { reader1.Close(); queryString = "EXEC cashFromOperator " + amount + ", '" + operatorUsername + "'"; bool result = adminFunctions.ExecuteCommand(queryString); if (result) { MessageBox.Show("YOUR TRANSACTION HAS BEEN ACCEPTED SUCCESSFULLY"); } else { MessageBox.Show("USERNAME DOES NOT EXIST"); } } } else { MessageBox.Show("YOUR ARE ATTEMPTING TO INTERACT WITH AN UN-LOGGED IN OPERATOR", "Un-logged in user", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } else { MessageBox.Show("CHECK IF YOU HAVE ENTERED THE CORRECT AMOUNT OR A VALID USERNAME!"); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { adminFunctions.DisconnectToDB(); } }
private void btnProcess_Click(object sender, EventArgs e) { useStart = new UseDatabase.UseDatabase(); useStart.ConnectToDB(); try { string queryString = "SELECT * FROM WORKER WHERE username='******' AND iPassword='******'"; SqlDataReader reader = useStart.ExecuteQuery(queryString); if (reader != null && reader.HasRows) { reader.Close(); queryString = "UPDATE WORKER SET balance = balance + " + total + " WHERE username='******' AND iPassword='******'"; if (useStart.ExecuteCommand(queryString)) { lstItems.Items.Add(""); lstItems.Items.Add(""); lstItems.Items.Add("THANK YOU FOR SHOPPING WITH GLOBAL_HYPER"); } for (int i = 0; i < itemsArray.Count; i++) { queryString = "UPDATE AVAILABLESTOCK SET stock = stock - 1 WHERE proID=" + itemsArray[0]; if (useStart.ExecuteCommand(queryString)) { lstItems.Items.Add("HAVE A NICE DAY"); } } itemsArray.Clear(); btnCancel.Text = "Clear"; gpbNumbers.Enabled = true; } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { useStart.DisconnectToDB(); } btnTotal.Enabled = true; }
private void btnAdd_Click(object sender, EventArgs e) { string name = txtName.Text; float price = float.Parse(txtPrice.Text); int stock = Convert.ToInt32(numOfStock.Value); int proID; if (!validateData(name, price, stock)) { useAddProducts = new UseDatabase.UseDatabase(); useAddProducts.ConnectToDB(); string queryString = @"INSERT INTO PRODUCTS(name, price) VALUES ('" + name + "', " + price + ")"; if (useAddProducts.ExecuteCommand(queryString)) { MessageBox.Show("YOU HAVE ENTERED YOU PRODUCT ITEM"); } else { MessageBox.Show("OOPS... SOEMTHING WENT WRONG!"); } try { string expression = "name='" + name + "'"; DataRow[] foundRow = getRow(expression); proID = Convert.ToInt32(foundRow[0]["proID"]); queryString = @"INSERT INTO AVAILABLESTOCK(stock, proId) VALUES (" + stock + ", " + proID + ")"; if (useAddProducts.ExecuteCommand(queryString)) { MessageBox.Show("YOUR STOCK WILL BE UPDATED"); this.Close(); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { useAddProducts.DisconnectToDB(); } } }
private void btnSave_Click(object sender, EventArgs e) { newPassword = txtNewPassword.Text; changePass = new UseDatabase.UseDatabase(); if (txtNewPassword.Text.Equals(txtConfirmPassword.Text)) { try { changePass.ConnectToDB(); queryString = "SELECT * FROM WORKER WHERE username = '******' AND iPassword = '******'"; SqlDataReader reader = changePass.ExecuteQuery(queryString); if (reader != null && reader.HasRows) { reader.Close(); queryString = "UPDATE WORKER SET iPassword = '******' WHERE username = '******' AND iPassword = '******'"; bool result = changePass.ExecuteCommand(queryString); if (result) { MessageBox.Show("Your password is changed!"); this.Hide(); } else { lblResult.Text = "Unable to change password, try again"; } } else { lblResult.Text = "Unable to change password, try again"; } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { changePass.DisconnectToDB(); } } else { lblResult.Text = "Your password(s) do not match"; } }
private void btnDeposit_Click(object sender, EventArgs e) { adminFunctions = new UseDatabase.UseDatabase(); adminFunctions.ConnectToDB(); try { adminPad.ShowDialog(); this.amount = Admin_DigitalPad.amount; if (amount != 0) { queryString = "SELECT * FROM WORKER WHERE username='******' AND position='Supervisor' AND balance >= " + amount; SqlDataReader reader = adminFunctions.ExecuteQuery(queryString); if (reader != null && reader.HasRows) { reader.Close(); queryString = "UPDATE WORKER SET balance = balance - " + amount + "WHERE position='Supervisor'"; if (adminFunctions.ExecuteCommand(queryString)) { MessageBox.Show("TRANSACTION SUCCESSFULL!"); } else { MessageBox.Show("OOPS! SOMETHING WENT WRONG. TRY AGAIN!"); } } else { MessageBox.Show("TRANSACTION UNSUCCESSFUL!\n\nCHECK YOUR BALANCE AND MAKE SURE YOU ARE TRANSFERRING THE CORRECT AMOUNT"); } } else { MessageBox.Show("OOPS! SOMETHING WENT WRONG. TRY AGAIN!"); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { adminFunctions.DisconnectToDB(); } }
private void btnLogOff_Click(object sender, EventArgs e) { logOff.ConnectToDB(); try { string expression = "username='******' AND iPassword='******'"; DataRow[] foundRow = getRow(expression); if (foundRow != null) { double balance = Convert.ToDouble(foundRow[0]["balance"]); double cashRecieved = Convert.ToDouble(foundRow[0]["cashRecieved"]); double cashTransfered = Convert.ToDouble(foundRow[0]["cashTransfered"]); if ((balance == 0) && (cashRecieved == 0) && (cashTransfered == 0)) { string queryString = "UPDATE WORKER SET loggedIn='false' WHERE username='******' AND iPassword='******'"; bool update = logOff.ExecuteCommand(queryString); this.Hide(); LoginForm openLogin = new LoginForm(); openLogin.ShowDialog(); } else if (balance != 0) { MessageBox.Show("YOUR BALANCE IS NOT TRANSFERED", "TRANSFER YOUR BALANCE", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (cashRecieved != 0) { MessageBox.Show("YOUR CASH TRANSFERED TO SUPERVISOR IS NOT ACCEPTED YET", "TRANSFER YOUR BALANCE", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (cashTransfered != 0) { MessageBox.Show("YOUR CASH RECIEVED IS NOT ACCEPTED YET", "TRANSFER YOUR BALANCE", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (SqlException se) { MessageBox.Show("(YOUR LOGGING OFF WAS UNSUCCESSFUL. CHECK IF HAVE CLEARED YOUR SCREEN OR YOUR BALANCE) " + se.Message); } finally { logOff.DisconnectToDB(); } }
private void btnAdd_Click(object sender, EventArgs e) { string name = txtName.Text; string surname = txtSurname.Text; string username = txtUsername.Text; string password = txtPassword.Text; string confirmPassword = txtConfirmPassword.Text; if (!validateData(name, surname, username, password, confirmPassword)) { if (password.Equals(txtConfirmPassword.Text)) { string queryString = "EXEC insertTable " + name + "," + surname + "," + username + "," + password + ""; UseDatabase.UseDatabase addCashierFunctions = new UseDatabase.UseDatabase(); addCashierFunctions.ConnectToDB(); try { if (addCashierFunctions.ExecuteCommand(queryString)) { MessageBox.Show("YOU HAVE ADDED AN OPERATOR SUCCESSFULLY"); this.Close(); } else { MessageBox.Show("SOMETHING WENT WRONG, CHECK YOUR DETAILS AND RE-ENTER THEM AGAIN"); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { addCashierFunctions.DisconnectToDB(); } } else { lblResults.Text = "Your password(s) do not match"; } } }
private void btnCashFromSuper_Click(object sender, EventArgs e) { numPad.ShowDialog(); try { functions = new UseDatabase.UseDatabase(); functions.ConnectToDB(); num = DigitalPad.numEntered; queryString = "SELECT * FROM WORKER WHERE username='******' AND iPassword='******' AND cashRecieved=" + num; SqlDataReader reader = functions.ExecuteQuery(queryString); if (reader != null && reader.HasRows) { reader.Close(); queryString = "EXEC cashFromSupervisor " + num + ", '" + username + "', '" + password + "'"; bool result = functions.ExecuteCommand(queryString); if (result) { MessageBox.Show("YOUR TRANSACTION HAS BEEN ACCEPTED SUCCESSFULLY"); } else { MessageBox.Show("SOMETHING WENT WRONG WHEN PERFORMING TRANSACTION"); } numPad.Hide(); } else { MessageBox.Show("CHECK IF YOU HAVE ENTERED THE CORRECT AMOUNT!"); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { functions.DisconnectToDB(); } }
private void btnRemove_Click(object sender, EventArgs e) { if (txtEmpID.Text != string.Empty) { try { int emp = Int32.Parse(txtEmpID.Text); delOperator.ConnectToDB(); string queryString = "SELECT * FROM WORKER WHERE empID = " + emp; SqlDataReader reader = delOperator.ExecuteQuery(queryString); if (reader != null && reader.HasRows) { reader.Close(); DialogResult result = MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { queryString = "EXEC deleteWorker " + emp; if (delOperator.ExecuteCommand(queryString)) { MessageBox.Show("YOU HAVE DELETED AN ITEM SUCCESSFULLY"); } } else { this.Close(); } } } catch (SqlException sql) { lblResult.Text = "Oops! check your product ID value"; } finally { delOperator.DisconnectToDB(); } } else { lblResult.Text = "Please enter a operator's identification"; } }
private void btnValidate_Click(object sender, EventArgs e) { string superPass = txtSuperPassword.Text; string newPass = txtNewPassword.Text; string confirmPass = txtConfirmPassword.Text; if (!validateData(superPass, newPass, confirmPass)) { int empID = Int32.Parse(txtEmpID.Text); if ((txtSuperPassword.Text.Equals(password)) && (txtNewPassword.Text.Equals(txtConfirmPassword.Text))) { UseDatabase.UseDatabase usePassRecover = new UseDatabase.UseDatabase(); usePassRecover.ConnectToDB(); try { string queryString = "UPDATE WORKER SET iPassword = '******' WHERE empID=" + empID; if (usePassRecover.ExecuteCommand(queryString)) { MessageBox.Show(empID + " HAS BEEN UPDATED HER PASSWORD", "UPDATE", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("OOPS... SOMETHING WENT WRONG! YOU MIGHT OF ENTERED AN INVALID EMPLOYEE NUMBER"); } } catch (SqlException sql) { MessageBox.Show(sql.Message); } finally { usePassRecover.DisconnectToDB(); } } else { lblResult.Text = "Your password(s) do not match!"; } } }