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