private void btnCal_Click(object sender, EventArgs e)
{
frmEmployee emp = new frmEmployee();
double balanceDue = emp.getBalanceDue;
double Bal;
try
{
connect = new SqlConnection(connectionString);
connect.Open();
string readQuery = @"SELECT * FROM Tab WHERE Cust_ID = '" + txtTabID.Text + "'";
command = new SqlCommand(readQuery, connect);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Bal = double.Parse(reader.GetValue(1).ToString());
Bal += balanceDue;
listBox1.Items.Add("New Balance: " + Bal.ToString());
}
connect.Close();
}
catch (SqlException err)
{
MessageBox.Show(err.Message);
}
emp.ShowDialog();
}
private void BtnDone_Click(object sender, EventArgs e)
{
items = lstHotDrinks.Items.ToString();
/*emp.lstOrderName.Items.Add(items);*/
emp.ShowDialog();
this.Close();
}
private void BtnLogin_Click(object sender, EventArgs e)
{
connect = new SqlConnection(connectionString);
connect.Open();
String sql = @"SELECT * FROM Staff";
command = new SqlCommand(sql, connect);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
username = dataReader.GetValue(1).ToString();
password = dataReader.GetValue(2).ToString();
userPos = dataReader.GetValue(3).ToString();
if (username == tbUsername.Text && password == tbPassword.Text)
{
lblSearching.Text = "";
tbUsername.Text = "";
tbPassword.Text = "";
lblSearching.Text = "";
if (userPos == "O")
{
frmOwner owner = new frmOwner();
owner.ShowDialog();
}
else
{
frmEmployee employee = new frmEmployee();
employee.ShowDialog();
}
}
else
{
if (tbUsername.Text == "" && tbPassword.Text == "")
{
lblSearching.Text = "Please enter username and password";
}
else if (tbUsername.Text == "")
{
lblSearching.Text = "Please enter username";
}
else if (tbPassword.Text == "")
{
lblSearching.Text = "Please enter password";
}
else if (username != tbUsername.Text)
{
tbUsername.SelectAll();
tbPassword.SelectAll();
lblSearching.Text = "The username or the password is incorrect";
}
else if (password != tbPassword.Text)
{
tbUsername.SelectAll();
tbPassword.SelectAll();
lblSearching.Text = "The username or the password is incorrect";
}
}
}
/* }
* if (username == tbUsername.Text && password == tbPassword.Text)
* {
* lblSearching.Text = "";
* tbUsername.Text = "";
* tbPassword.Text = "";
*
* if (userPos == "O")
* {
* frmOwner owner = new frmOwner();
* owner.ShowDialog();
* //this.Close();
* }
* else
* {
* frmEmployee emp = new frmEmployee();
* emp.ShowDialog();
* // this.Close();
* }
* }
* else
* {
* if (username != tbUsername.Text)
* {
* tbUsername.SelectAll();
* tbPassword.SelectAll();
* lblSearching.Text = "The username or the password is incorrect";
* }
* else if (password != tbPassword.Text)
* {
* tbUsername.SelectAll();
* tbPassword.SelectAll();
* lblSearching.Text = "The username or the password is incorrect";
* }
* }
*
* }*/
connect.Close();
/*
* frmOwner ow = new frmOwner();
* ow.ShowDialog();
*
* frmEmployee emp = new frmEmployee();
* emp.ShowDialog();*/
}
private void BtnDone_Click(object sender, EventArgs e)
{
emp.ShowDialog();
this.Close();
}