public void Themphanhoi(int idbantin, int iduser, string noidung, DateTime thoigian)
{
bantin_phanhoi_doc themphanhoi = new bantin_phanhoi_doc();
int idsp = (from tk in data.bantin_phanhoi_docs
select tk).ToList().Last().idphanhoi;
if (idsp == 0)
{
themphanhoi.idphanhoi = 1;
}
else
{
themphanhoi.idphanhoi = idsp + 1;
}
themphanhoi.idbantin = idbantin;
themphanhoi.iduser = iduser;
themphanhoi.noidung = noidung;
themphanhoi.ngaygio = thoigian;
themphanhoi.xoa = false;
data.bantin_phanhoi_docs.InsertOnSubmit(themphanhoi);
bantin_gui users = (from tk in data.bantin_guis
where tk.idbantin == idbantin && tk.iduser == iduser
select tk).Single();
users.daphanhoi = true;
data.SubmitChanges();
}
public void Xoaphanhoi(int idbantin, int iduser, string noidung)
{
bantin_phanhoi_doc xoaph = (from tk in data.bantin_phanhoi_docs
where tk.idbantin == idbantin && tk.iduser == iduser && tk.noidung == noidung
select tk).Single();
data.bantin_phanhoi_docs.DeleteOnSubmit(xoaph);
data.SubmitChanges();
bantin_gui users = (from tk in data.bantin_guis
where tk.idbantin == idbantin && tk.iduser == iduser
select tk).Single();
users.daphanhoi = false;
data.SubmitChanges();
}
