public void LoadTuDienList()
{
TuDienCollection tudienColl = new TuDienCollection();
tudienColl = tudienBUS.LayDSTuDien_CongDong(TimTuDienTextBox.Text);
TuDienList.DataSource = tudienColl;
TuDienList.DataValueField = "TuDienID";
TuDienList.DataTextField = "TenTuDien";
TuDienList.DataBind();
}
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;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["taikhoan"] == null)
{
Response.Redirect("index.aspx");
}
if (!IsPostBack)
{
if (Session["taikhoan"] != null)
{
TuDienCheckBoxList.Items.Clear();
string taikhoan = Session["taikhoan"].ToString();
TuDienCollection tudiencanhan = new TuDienCollection();
TuDienCollection tudienlienket = new TuDienCollection();
TuDienCollection tudiencongdong = new TuDienCollection();
tudiencanhan = tudienBUS.LayDSTuDien(taikhoan);
tudienlienket = tudienBUS.LayDSTuDien_LienKet(taikhoan);
tudiencongdong = tudienBUS.LayDSTuDien_CongDong("");
foreach (TuDienBO td in tudiencanhan)
{
ListItem item = new ListItem();
item.Text = td.TenTuDien + " - " + td.TaiKhoan;
item.Value = td.TuDienID;
TuDienCheckBoxList.Items.Add(item);
}
foreach (TuDienBO td in tudienlienket)
{
ListItem item = new ListItem();
item.Text = td.TenTuDien + " - " + td.TaiKhoan;
item.Value = td.TuDienID;
TuDienCheckBoxList.Items.Add(item);
}
foreach (TuDienBO td in tudiencongdong)
{
ListItem item = new ListItem();
item.Text = td.TenTuDien + " - " + td.TaiKhoan;
item.Value = td.TuDienID;
TuDienCheckBoxList.Items.Add(item);
}
}
}
}
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;
}
public TuVungCollection SelectTuVung_Viet(string tuvung,string taikhoan)
{
TuDienDAO tudienDAO = new TuDienDAO();
TuVungCollection tuvungColl = new TuVungCollection();
//Lấy tất cả từ vựng [Công Đồng]
tuvungColl = SelectAllTuVung_CongDong();
if (taikhoan != "")
{
//Lấ tát cả từ vựng[Cá nhân]
TuDienCollection tudiencanhan = new TuDienCollection();
tudiencanhan = tudienDAO.SelectTuDien(taikhoan);
foreach (TuDienBO td in tudiencanhan)
{
tuvungColl.Addrange(SelectTuVung_CaNhan("", taikhoan, td.TuDienID));
}
TuDienCollection tudienlienket = new TuDienCollection();
tudienlienket = tudienDAO.SelectTuDien_LienKet(taikhoan);
foreach (TuDienBO td in tudienlienket)
{
tuvungColl.Addrange(SelectTuVung_LienKet("", taikhoan, td.TuDienID));
}
}
//Lấy danh sách từ vựng tìm đựơc
TuVungCollection foundColl = new TuVungCollection();
foreach (TuVungBO tv in tuvungColl)
{
if (tv.NghiaTu.Contains(tuvung))
{
//kiểm tra từ đó có tồn tại chưa
bool exist = false;
if (foundColl.Count > 0)//chỉ kiểm tra khi foundColl>0
{
foreach (TuVungBO tv1 in foundColl)
{
if (tv.TuVungID == tv1.TuVungID)
{
exist = true;
break;
}
}
}
if (exist == false)//nếu chưa thì thêm vào
foundColl.Add(tv);
}
}
return foundColl;
}
