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";
}
}
