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