private SqlDataReader checkUsername() { queryString = "SELECT * FROM WORKER WHERE username='******' AND loggedIn='true'"; SqlDataReader reader = adminFunctions.ExecuteQuery(queryString); return(reader); }
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 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 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 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"; } }