public List <TaiKhoanOBJ> Select_all_User()
{
List <TaiKhoanOBJ> list = new List <TaiKhoanOBJ>();
list = TaiKhoanDB.LoadAll_User();
return(list);
}
//load du lieu
public List <TaiKhoanDB> loadtk()
{
List <TaiKhoanDB> loadtk = new List <TaiKhoanDB>();
try
{
SqlConnection cn = new SqlConnection(ketnoi.cn);
cn.Open();
string sql = "SELECT nguoi_dung.ma_tk, dang_nhap.ten_dang_nhap, dang_nhap.chuc_vu, nguoi_dung.ten, nguoi_dung.dia_chi, nguoi_dung.sdt, nguoi_dung.email, nguoi_dung.img FROM dang_nhap INNER JOIN nguoi_dung ON dang_nhap.ma_tk = nguoi_dung.ma_tk";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
TaiKhoanDB tk = new TaiKhoanDB();
tk.matk = rd.GetString(0);
tk.tentk = rd.GetString(1);
tk.chucvu = rd.GetString(2);
tk.hoten = rd.GetString(3);
tk.diachi = rd.GetString(4);
tk.sdt = rd.GetString(5);
tk.email = rd.GetString(6);
tk.img = rd.GetString(7);
loadtk.Add(tk);
}
rd.Close();
}
catch
{
}
return(loadtk);
}
public string Select_all_user_string()
{
string str_User = TaiKhoanDB.Load_All_User_Json();
return(str_User);
}
