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()); } }