//Lay Du lieu username , password
public User LayThongTinUser(string Username)
{
string sql = "Select Username, Password, Ho, Ten, a.MaNhom, TenNhom, MaNguoiDung from USERS a, USERS_NHOMNGUOIDUNG b"
+ " Where a.MaNhom = b.MaNhom AND Username = '******'";
DataTable dtUser = connData.GetDataTable(sql);
User user = new User();
if (dtUser.Rows.Count > 0)
{
DataRow drUser = dtUser.Rows[0];
user.Username = drUser["Username"].ToString();
user.Password = drUser["Password"].ToString();
user.Ho = drUser["Ho"].ToString();
user.Ten = drUser["Ten"].ToString();
user.MaNhom = drUser["MaNhom"].ToString();
user.TenNhom = drUser["TenNhom"].ToString();
user.MaNguoiDung = drUser["MaNguoiDung"].ToString();
}
else
{
user.Username = "";
user.Password = "";
user.Ho = "";
user.Ten = "";
user.MaNhom = "";
user.TenNhom = "";
user.MaNguoiDung = "";
}
return user;
}
//Dang xuat khoi chuong trinh
private void btnDangXuatHeThong_Click(object sender, EventArgs e)
{
rbItem_TrangChu.Select();
User user = new User();
Utilities.user = user;
LoadMainForm(false);
btnItem_ThemTaiKhoan.Enabled = false;
this.Text = "Chưa đăng nhập hệ thống!";
btnItem_DangNhapHeThong_Click(sender, e);
}
