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