/// <summary> /// This function adds pas for consultants /// </summary> /// <param name="userId"></param> /// <param name="consultants"></param> public void AddConsultantsForPa(int userId, List<User> consultants) { var context = new dbDataContext(); // add new entries foreach (var con in consultants) { var paConsultant = (from j in context.tbl_ConsultantPAs where j.ConsultantId == con.UserId && j.PaId == userId select j).FirstOrDefault(); if (paConsultant == null) { var obj = new tbl_ConsultantPA { ConsultantId = con.UserId, PaId = userId }; context.tbl_ConsultantPAs.InsertOnSubmit(obj); } } context.SubmitChanges(); //delete not existing ones var idList = consultants.Select(t => t.UserId); var paConsultants = (from j in context.tbl_ConsultantPAs where !idList.Contains(j.ConsultantId) && j.PaId == userId select j).ToList(); context.tbl_ConsultantPAs.DeleteAllOnSubmit(paConsultants); context.SubmitChanges(); }
partial void Updatetbl_ConsultantPA(tbl_ConsultantPA instance);
partial void Deletetbl_ConsultantPA(tbl_ConsultantPA instance);
partial void Inserttbl_ConsultantPA(tbl_ConsultantPA instance);