// lay thong tin cua tat ca nguoi dung
public List <nguoidungDAL> getNguoiDung()
{
List <nguoidungDAL> list = new List <nguoidungDAL>();
string sql = "SELECT * FROM nguoidung, role WHERE nguoidung.role = role.id_role";
SqlConnection cn = cnn.connectToSql();
cn.Open();
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
nguoidungDAL ds = new nguoidungDAL();
ds.id_user = rd.GetInt32(0);
ds.username = rd.GetString(1);
ds.hoten = rd.GetString(3);
ds.sdt = rd.GetString(4);
ds.diachi = rd.GetString(5);
ds.role = rd.GetInt32(6);
ds.email = rd.GetString(7);
ds.stringrole = rd.GetString(9);
list.Add(ds);
}
cmd.Dispose();
cn.Close();
return(list);
}
// lay thong tin cua tat ca nguoi dung
public List <nguoidungDAL> getNguoiDungP(int row, int hide)
{
List <nguoidungDAL> list = new List <nguoidungDAL>();
string sql = "select top " + row + " * from nguoidung, role where nguoidung.role = role.id_role AND id_user not in (select top " + hide + " id_user from nguoidung order by id_user DESC ) order by id_user DESC";
SqlConnection cn = cnn.connectToSql();
cn.Open();
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
nguoidungDAL ds = new nguoidungDAL();
ds.id_user = rd.GetInt32(0);
ds.username = rd.GetString(1);
ds.hoten = rd.GetString(3);
ds.sdt = rd.GetString(4);
ds.diachi = rd.GetString(5);
ds.role = rd.GetInt32(6);
ds.email = rd.GetString(7);
ds.stringrole = rd.GetString(9);
list.Add(ds);
}
cmd.Dispose();
cn.Close();
return(list);
}
// dang nhap
public List <nguoidungDAL> dangNhap(string tk, string mk)
{
List <nguoidungDAL> list = new List <nguoidungDAL>();
string sql = "SELECT * FROM nguoidung WHERE username = '******' AND password = '******'";
SqlConnection cn = cnn.connectToSql();
cn.Open();
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
nguoidungDAL ds = new nguoidungDAL();
ds.id_user = rd.GetInt32(0);
ds.username = rd.GetString(1);
ds.hoten = rd.GetString(3);
ds.sdt = rd.GetString(4);
ds.diachi = rd.GetString(5);
ds.role = rd.GetInt32(6);
ds.email = rd.GetString(7);
list.Add(ds);
}
cmd.Dispose();
cn.Close();
return(list);
}
