private void btTra_Click(object sender, EventArgs e) // tra tu (chưa hoàn chỉnh)
{
string s = tbTra.Text;
if (s == "") // chưa xử lý được cái này
{
MessageBox.Show("Bạn chưa nhập từ cần tra");
}
else
{
listBox2.Items.Clear();
Word w = BLL_QLWord.Instance.SearchWord(s);
if (w.ID_Word == null)
{
listBox2.Items.Add(w.Explaination);
}
else
{
listBox2.Items.Add(w.Explaination);
if (phanquyen == 1 || phanquyen == 0)
{
History h = new History();
h.IDW = w.ID_Word;
h.ID = phanquyen.ToString() + ID_UA;
h.date = DateTime.Now;
BLL_History.Instance.AddHis(h);
f1 = Getfavor(w);
}
}
}
}
private Favor_Word Getfavor(Word w)
{
Favor_Word f = new Favor_Word();
f.ID = phanquyen.ToString() + ID_UA;
f.IDW = w.ID_Word;
return(f);
}
public void DeleteFavor(Favor_Word F)
{
string query = "DELETE FROM Favorite_Word WHERE ID_User="******";";
DBhelper.Instance.ExecuteDB(query);
}
public void AddFavor(Favor_Word F)
{
string query = "INSERT INTO Favorite_Word VALUES( " + " N'" + F.ID.ToString() + "'" + ", N'" + F.IDW.ToString() + "');";
DBhelper.Instance.ExecuteDB(query);
}
public void DeleteFavor_W(Favor_Word f)
{
DAL_Favor.Instance.DeleteFavor(f);
}
public void AddFavorW_BLL(Favor_Word f)
{
DAL_Favor.Instance.AddFavor(f);
}
