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