private void acceptBtn_Click(object sender, EventArgs e) { string oldPass = oldPassTxt.Text.ToString(); string newPass = newPassTxt.Text.ToString(); string newPass2 = newPassTxt2.Text.ToString(); var row = db.GetData($"select * from NHANVIEN where tenDN='{username}' and matKhau='{oldPass}'").Rows; if (row.Count == 1 && newPass.Equals(newPass2)) { db.Execute($"update NHANVIEN set matKhau='{newPass}' where tenDN='{username}'"); alertLabel.Visible = true; alertLabel.ForeColor = System.Drawing.Color.Green; alertLabel.Text = "Thành Công"; } if (row.Count == 0) { alertLabel.Text = "Sai Mật Khẩu"; alertLabel.Visible = true; return; } else if (!newPass.Equals(newPass2)) { alertLabel.Text = "Nhập lại không khớp"; alertLabel.Visible = true; return; } }
public ThongTinCaNhan(string username) { InitializeComponent(); this.username = username; var staffInfo = db.GetData($"select * from NHANVIEN where tenDN='{username}'").Rows[0].ItemArray; loginNameLabel.Text = staffInfo[0].ToString(); nameLabel.Text = staffInfo[2].ToString(); sexLabel.Text = staffInfo[3].ToString(); DoBLabel.Text = ((DateTime)staffInfo[4]).ToShortDateString(); phoneLabel.Text = staffInfo[5].ToString(); IDLabel.Text = staffInfo[6].ToString(); positionLabel.Text = staffInfo[7].ToString(); }
private void loginBtn_Click(object sender, EventArgs e) { QuanLyKaraokeDB db = new QuanLyKaraokeDB(); var row = db.GetData($"select * from NHANVIEN where tenDN='{usernameTxt.Text.ToString()}' and matKhau='{passTxt.Text.ToString()}'").Rows; if (row.Count == 1) { string username = row[0].ItemArray[0].ToString(); bool isManager = Convert.ToInt32(row[0].ItemArray[8].ToString()) == 1; Console.WriteLine(row[0].ItemArray[7]); Console.WriteLine(isManager); this.Hide(); TrangChu f = new TrangChu(isManager, username); f.Text = "Trang Chủ"; f.ShowDialog(); } else { alertLabel.Visible = true; } }
private void loadServiceList() { serviceList.DataSource = db.GetData("select * from DICHVU"); }
private void loadList(DataGridView datagrid, string table) { datagrid.DataSource = db.GetData($"select * from {table}"); }
private void loadRoomList() { roomList.DataSource = db.GetData("select * from PHONG"); }
public void loadData() { employeList.DataSource = db.GetData("select * from NHANVIEN"); }