public List <DangNhapBEAN> getListDangNhap()
{
string sql = "SELECT * FROM DangNhap";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlDataReader rs = cmd.ExecuteReader();
List <DangNhapBEAN> ds = new List <DangNhapBEAN>();
while (rs.Read())
{
string taiKhoan = rs["TaiKhoan"].ToString();
string matKhau = rs["MatKhau"].ToString();
DangNhapBEAN dn = new DangNhapBEAN(taiKhoan, matKhau);
ds.Add(dn);
}
rs.Close();
return(ds);
}
public List <DangNhapBEAN> themDangNhap(List <DangNhapBEAN> ds, string taiKhoan, string matKhau, out Boolean kq)
{
kq = false;
// lấy về tất cả các loại có mã là maLoai
var q = from l in ds
where l.TaiKhoan.Equals(taiKhoan)
select l;
if (q.Count() == 0)
{
// thêm csdl
dangNhap.themDangNhap(taiKhoan, matKhau);
// thêm bộ nhớ
DangNhapBEAN b = new DangNhapBEAN(taiKhoan, matKhau);
ds.Add(b);
kq = true;
}
return(ds);
}
public List <DangNhapBEAN> timDangNhap(string key)
{
string sql = "SELECT * FROM DangNhap WHERE TaiKhoan LIKE @taiKhoan ";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlParameter ts = new SqlParameter("@taiKhoan", "%" + key + "%");
cmd.Parameters.Add(ts);
SqlDataReader rs = cmd.ExecuteReader();
List <DangNhapBEAN> ds = new List <DangNhapBEAN>();
while (rs.Read())
{
string taiKhoan = rs["TaiKhoan"].ToString();
string matKhau = rs["MatKhau"].ToString();
DangNhapBEAN dn = new DangNhapBEAN(taiKhoan, matKhau);
ds.Add(dn);
}
rs.Close();
return(ds);
}
