private void Start_Form_Load(object sender, EventArgs e)
{
txtNumbers.Focus();
DateTime date = DateTime.Now;
lblTime.Text = date.ToString();
txtNumbers.Focus();
useStart = new UseDatabase.UseDatabase();
useStart.ConnectToDB();
try
{
dt = useStart.getProduct().Tables[0];
}
catch (SqlException sql)
{
MessageBox.Show(sql.Message);
}
finally
{
useStart.DisconnectToDB();
}
}
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 btnSend_Click(object sender, EventArgs e)
{
if (txtNumbers.Text != string.Empty)
{
useStart = new UseDatabase.UseDatabase();
useStart.ConnectToDB();
try
{
int itemNum = Int32.Parse(txtNumbers.Text);
expression = "proID=" + itemNum;
DataRow[] foundRow = getRow(expression);
if (foundRow != null)
{
try
{
double price = Convert.ToDouble(foundRow[0]["price"]);
string name = foundRow[0]["name"].ToString();
itemsArray.Add(itemNum);
lstItems.Items.Add(name + " R" + price);
total += Convert.ToDouble(foundRow[0]["price"]);
lblPrice.Text = "Price R" + price;
}
catch (IndexOutOfRangeException sql)
{
lblNotification.Text = "The item you entered is not available";
}
}
else
{
lblNotification.Text = "The item you entered is not available";
}
txtNumbers.Clear();
txtNumbers.Focus();
//lblNotification.Text = "Notification";
}
catch (SqlException sql)
{
MessageBox.Show(sql.Message);
}
finally
{
useStart.DisconnectToDB();
}
}
else
{
lblNotification.Text = "Please enter a valid item number";
}
}
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 btnCashReport_Click(object sender, EventArgs e)
{
DateTime date;
adminFunctions = new UseDatabase.UseDatabase();
adminFunctions.ConnectToDB();
try
{
expression = "username='******' AND iPassword='******'";
DataRow[] foundRow = getRow(expression);
if (foundRow != null)
{
date = DateTime.Now;
string balance = Convert.ToString(foundRow[0]["balance"]);
double cashRecieved = Convert.ToDouble(foundRow[0]["cashRecieved"]);
double cashTransferred = Convert.ToDouble(foundRow[0]["cashTransfered"]);
if (cashRecieved != 0)
{
MessageBox.Show(@date + "\nBalance = R" + balance + "\n PENDING TRANSFER\n----------------------\n\n CASH RECIEVED = R"
+ cashRecieved);
}
else if (cashTransferred != 0)
{
MessageBox.Show(@date + "\nBalance = R" + balance + "\n PENDING TRANSFER\n----------------------\n\n CASH TRANSFERRED = R"
+ cashTransferred);
}
else if ((cashTransferred != 0) && (cashRecieved != 0))
{
MessageBox.Show(@date + "\nBalance = R" + balance + "\n PENDING TRANSFER\n----------------------\n\n CASH RECIEVED = R"
+ cashRecieved + "\n CASH TRANSFERRED = R" + cashTransferred);
}
else
{
MessageBox.Show(@date + "\nBalance = R" + balance + "\n PENDING TRANSFER\n ----------------------\n\n Nil");
}
}
}
catch (SqlException se)
{
MessageBox.Show(se.Message);
}
finally
{
adminFunctions.DisconnectToDB();
}
}
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 ViewProducts_Load(object sender, EventArgs e)
{
//// TODO: This line of code loads data into the 'globalHyperDataSet2.productInfo' table. You can move, or remove it, as needed.
//this.productInfoTableAdapter.Fill(this.globalHyperDataSet2.productInfo);
//// TODO: This line of code loads data into the 'globalHyperDataSet1.PRODUCTS' table. You can move, or remove it, as needed.
//this.pRODUCTSTableAdapter.Fill(this.globalHyperDataSet1.PRODUCTS);
//// TODO: This line of code loads data into the 'globalHyperDataSet.productInfo' table. You can move, or remove it, as needed.
UseDatabase.UseDatabase useProducts = new UseDatabase.UseDatabase();
useProducts.ConnectToDB();
DataTable dt = useProducts.viewProduct().Tables[0];
ProductsDataGrid.DataSource = dt;
useProducts.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 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 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!";
}
}
}
