/// <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);
