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); }