public TuDienCollection SelectTuDien(string taikhoan)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
TuDienCollection tdColl = new TuDienCollection();
IEnumerable<TuDien> tudien = from p in db.TuDiens
where p.taikhoan == taikhoan
select p;
//Addrange
foreach (TuDien tv in tudien)
{
TuDienBO tdBO = new TuDienBO();
tdBO.TuDienID = tv.TudienID.ToString();
tdBO.TaiKhoan = tv.taikhoan;
tdBO.TenTuDien = tv.TenTuDien;
tdBO.CongDong = (bool)tv.CongDong;
tdColl.Add(tdBO);
}
return tdColl;
}
public TuDienCollection SelectTuDien_CongDong(string tentudien)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
TuDienCollection tdColl = new TuDienCollection();
IEnumerable<TuDien> tudien;
if (tentudien != "")
{
tudien = from p in db.TuDiens
where p.CongDong == true
&& p.TenTuDien.Contains(tentudien)
select p;
}
else
{
tudien = from p in db.TuDiens
where p.CongDong == true
select p;
}
//Addrange
foreach (TuDien tv in tudien)
{
TuDienBO tdBO = new TuDienBO();
tdBO.TuDienID = tv.TudienID.ToString();
tdBO.TaiKhoan = tv.taikhoan;
tdBO.TenTuDien = tv.TenTuDien;
tdBO.CongDong = (bool)tv.CongDong;
tdColl.Add(tdBO);
}
return tdColl;
}
