public void addEmployee()
{
Canteen c = new Canteen();
try
{
conn = new MySqlConnection(strConn);
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
string nall = null;
//MessageBox.Show(id);
//string getIDCateg = cbStatus.Text.Split(' ')[0];
cmd.CommandText = "insert into tbl_employee_stat values(" + this.txt_ID_NUMBER.Text + ",'" + this.txt_NAME.Text + "'," + cbStatus.Text.Split(' ')[0] + ")";
//cmd.CommandText = "Insert into tbl_employee_status values("+ nall +","+ nall +","+ cbStatus.Text.Split(' ')[0] + ")";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Employee Successfully Added");
clear();
c.Refreshwindow();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
private void btn_Ok_Click(object sender, EventArgs e)
{
Canteen c = new Canteen();
addEmployee();
c.Refreshwindow();
}
public void login()
{
try
{
conn = new MySqlConnection(strConn);
conn.Open();
int i = 0;
MySqlCommand cmd = conn.CreateCommand();
MySqlCommand getID = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = " select * from tbl_user where Username = '******' and Password = '******'";
cmd.ExecuteNonQuery();
String strQuery = "select * from tbl_user";
MySqlCommand dmc = new MySqlCommand(strQuery, conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
accountIdentifier = (dr["account_id"].ToString());
NameIdentifier = (dr["Name"].ToString());
LastNameIdentifier = (dr["LastName"].ToString());
userididentifier = (dr["user_id"].ToString());
}
conn.Close();
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
i = Convert.ToInt32(dt.Rows.Count.ToString());
if (i == 0)
{
MessageBox.Show("Invalid User!");
tb_Username.Text = "";
tb_Password.Text = "";
}
else if (Convert.ToInt32(accountIdentifier) == 2)
{
String NameandLastname = LastNameIdentifier + ", " + NameIdentifier;
Canteen can = new Canteen();
can.NameOfTheUser.Text = NameandLastname;
//IdoftheUser = userididentifier;
//txtLogOn.Text = "Cashier";
this.Hide();
can.Show();
savedLogs(tb_Username, tb_Password);
}
else if (Convert.ToInt32(accountIdentifier) == 1)
{
String NameandLastname = LastNameIdentifier + ", " + NameIdentifier;
Canteen can = new Canteen();
can.NameOfTheUser.Text = NameandLastname;
can.identify_ID.Text = userididentifier;
//IdoftheUser = userididentifier;
//txtLogOn.Text = "Cashier";
this.Hide();
can.Show();
can.Btn_Employee_List.Enabled = false;
can.Btn_OverView.Enabled = false;
can.Btn_Report.Enabled = false;
can.Btn_Payment.Enabled = false;
savedLogs(tb_Username, tb_Password);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
