public void Capnhatnhombantin(int idnhom, string tenmoi, string motamoi, List <int> usermoi) { bantin_nhom capnhat = (from tk in data.bantin_nhoms where tk.idnhombantin == idnhom select tk).Single(); capnhat.tennhom = tenmoi; capnhat.mota = motamoi; data.SubmitChanges(); List <bantin_kqnhom> dskqxoa = (from tk in data.bantin_kqnhoms where tk.idnhombantin == idnhom select tk).ToList(); data.bantin_kqnhoms.DeleteAllOnSubmit(dskqxoa); foreach (int item in usermoi) { int dem2 = (from tk in data.bantin_kqnhoms select tk).ToList().Last().idkqnhom; bantin_kqnhom themkq = new bantin_kqnhom(); if (dem2 == 0) { themkq.idkqnhom = 1; } else { themkq.idkqnhom = dem2 + 1; } themkq.idnhombantin = idnhom; themkq.iduser = item; data.bantin_kqnhoms.InsertOnSubmit(themkq); data.SubmitChanges(); } }
public List <int> Laynguoinhan(List <int> idnhomnhan) { List <int> ketqua = new List <int>(); foreach (int id in idnhomnhan) { bantin_kqnhom ketquanhom = new bantin_kqnhom(); List <int> nguoidung = (from tk in data.bantin_kqnhoms where tk.idnhombantin == id select tk.iduser).ToList(); foreach (int item in nguoidung) { if (!ketqua.Contains(item)) { ketqua.Add(item); } } } return(ketqua); }
public void Themnhombantin(string tennhombantin, string mota, List <int> iduser) { int dem = (from tk in data.bantin_nhoms select tk).ToList().Last().idnhombantin; bantin_nhom themnhombantin = new bantin_nhom(); if (dem == 0) { themnhombantin.idnhombantin = 1; } else { themnhombantin.idnhombantin = dem + 1; } themnhombantin.tennhom = tennhombantin; themnhombantin.mota = mota; data.bantin_nhoms.InsertOnSubmit(themnhombantin); data.SubmitChanges(); foreach (int item in iduser) { int dem2 = (from tk in data.bantin_kqnhoms select tk).ToList().Last().idkqnhom; bantin_kqnhom themkq = new bantin_kqnhom(); if (dem2 == 0) { themkq.idkqnhom = 1; } else { themkq.idkqnhom = dem2 + 1; } themkq.idnhombantin = themnhombantin.idnhombantin; themkq.iduser = item; data.bantin_kqnhoms.InsertOnSubmit(themkq); data.SubmitChanges(); } }