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