public bool MapTeamDepartmentWithAllClients(short tdid = 0) { try { var clientTemDepartment = db.PQClientTeamMembers.Where(t => t.TeamDepartmentRowID == tdid).Select(t => t.ClientRowID).ToList(); var data = db.PQClientMasters.Select(c => c.ClientRowID).ToList(); var clientRowIds = data.Except(clientTemDepartment).ToList(); List <PQClientTeamMember> entities = new List <PQClientTeamMember>(); foreach (var item in clientRowIds) { PQClientTeamMember entity = new PQClientTeamMember(); entity.ClientRowID = item; entity.TeamDepartmentRowID = tdid; entities.Add(entity); } db.PQClientTeamMembers.AddRange(entities); db.SaveChanges(); return(true); } catch (Exception) { return(false); throw; } }
public void AddClientTeamMember(AddPQClientTMemberViewModel model) { try { if (model != null) { PQClientTeamMember entity = new PQClientTeamMember(); entity.ClientRowID = model.ClientRowID; entity.TeamDepartmentRowID = model.TeamDepartmentRowID; db.PQClientTeamMembers.Add(entity); } else { throw new Exception("Repo Client could not be blank!"); } } catch (Exception) { throw; } }