public void Capnhatnguoinhan(int idbantin, List <int> iduser)
{
List <bantin_gui> xoa = (from tk in data.bantin_guis
where tk.idbantin == idbantin
select tk).ToList();
data.bantin_guis.DeleteAllOnSubmit(xoa);
data.SubmitChanges();
foreach (int id in iduser)
{
bantin_gui users = new bantin_gui();
int dem = (from tk in data.bantin_guis
select tk).ToList().Last().idguibantin;
if (dem == 0)
{
users.idguibantin = 1;
}
else
{
users.idguibantin = dem + 1;
}
users.idbantin = idbantin;
users.iduser = id;
users.dagui = false;
users.daxem = false;
users.daphanhoi = false;
data.bantin_guis.InsertOnSubmit(users);
data.SubmitChanges();
}
}
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 Xembantin(int idbantin, int iduser)
{
bantin_gui xembt = (from tk in data.bantin_guis
where tk.idbantin == idbantin && tk.iduser == iduser
select tk).Single();
xembt.daxem = 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();
}
