public List <Education_Matrice_GrLearner> GetMatriceOfGroupLearner(Education_GroupLearner grpLearner)
{
return(db.Education_Matrice_GrLearner
.Include("Education_Matrice")
.Where(x => x.MatriceGrLearner_GroupeLearner == grpLearner.GroupLearner_Id && x.Education_GroupLearner.GroupLearner_Actif == true)
.ToList());
}
public List <Education_GroupLearner_Agent> LoadAgentOfSelectedGroup(Education_GroupLearner grpLearner)
{
return(db.Education_GroupLearner_Agent
.Include("Education_Agent")
.Where(w => w.GroupLearnerAgent_GroupeLearner == grpLearner.GroupLearner_Id && w.Education_GroupLearner.GroupLearner_Actif == true)
.ToList());
}
internal void RemoveAgentFromGroup(Education_Agent agent, Education_GroupLearner selectedGrpLearner)
{
var agentGrp = db.Education_GroupLearner_Agent
//.Include("Education_Matrice")
.Where(x => x.GroupLearnerAgent_Agent == agent.Agent_Id &&
x.GroupLearnerAgent_GroupeLearner == selectedGrpLearner.GroupLearner_Id)
.FirstOrDefault();
db.Education_GroupLearner_Agent.Remove(agentGrp);
db.SaveChanges();
}
public Education_GroupLearner AddGrpAgent(string grpName, string SAPName)
{
Education_GroupLearner grpAgent = new Education_GroupLearner()
{
GroupLearner_Name = grpName,
GroupLearner_SAP = SAPName
};
db.Education_GroupLearner.Add(grpAgent);
db.SaveChanges();
return(grpAgent);
}
private void comboGrpAgents_SelectedIndexChanged(object sender, EventArgs e)
{
SelectedGrpLearner = (Education_GroupLearner)comboGrpAgents.SelectedItem;
listAgentPaged = grpLearnearAgentRepository.LoadAgentOfSelectedGroup(SelectedGrpLearner).ToPagedList(1, 50);
List <Education_Agent> listAgentNotInTheGroupSelected = grpLearnearAgentRepository.GetAgentNotInTheSelectedGroup(SelectedGrpLearner);
comboAgents.DataSource = listAgentNotInTheGroupSelected;
dgGrpAgent.DataSource = GetDataSource(listAgentPaged);
lblSelectedGrp.Text = "List d'agent du groupe " + SelectedGrpLearner.GroupLearner_Name;
}
internal bool DeleteGroup(Education_GroupLearner selectedGrpLearner)
{
var grp = db.Education_GroupLearner
//.Include("Education_Matrice")
.Where(x => x.GroupLearner_Id == selectedGrpLearner.GroupLearner_Id)
.FirstOrDefault();
grp.GroupLearner_Actif = false;
db.SaveChanges();
return(true);
}
public List <Education_Agent> GetAgentNotInTheSelectedGroup(Education_GroupLearner grpLearner)
{
List <Education_Agent> listAgentInGrp = db.Education_Agent
.Where(w => w.Education_GroupLearner_Agent.Any(x => x.GroupLearnerAgent_GroupeLearner == grpLearner.GroupLearner_Id) &&
w.Education_GroupLearner_Agent.Any(x => x.Education_GroupLearner.GroupLearner_Actif == true))
.ToList();
List <Education_Agent> listAgent = db.Education_Agent
.ToList();
List <Education_Agent> listIntersect = listAgent.Except(listAgentInGrp).ToList();
return(listIntersect);
}
public void AssignGrpAgentToRoute(Education_Matrice matriceSelected, Education_GroupLearner agentGrpSelected)
{
Education_GroupLearner GrpAgent = db.Education_GroupLearner
.Where(y => y.GroupLearner_Id == agentGrpSelected.GroupLearner_Id).FirstOrDefault();
if (GrpAgent == null)
{
Education_Matrice_GrLearner newRecord = new Education_Matrice_GrLearner()
{
MatriceGrLearner_Matrice = matriceSelected.Matrice_Id,
MatriceGrLearner_GroupeLearner = GrpAgent.GroupLearner_Id
};
db.Education_Matrice_GrLearner.Add(newRecord);
db.SaveChanges();
}
}
public List <Education_Matrice_GrLearner> LoadSingleTrajetGrpAgent(Education_Matrice matriceSelected, Education_GroupLearner agentGrpSelected)
{
return(db.Education_Matrice_GrLearner
.Include("Education_Matrice")
.Where(x => x.Education_GroupLearner.GroupLearner_Id == agentGrpSelected.GroupLearner_Id &&
x.MatriceGrLearner_Matrice == matriceSelected.Matrice_Id)
.ToList());
}
internal List <Education_Agent> LoadAgentsNotInTheGroupSelected(Education_GroupLearner selectedGrpLearner)
{
throw new NotImplementedException();
}
public Education_GroupLearner_Agent AddGrpLearnerAgent(Education_Agent agent, Education_GroupLearner grpLearner)
{
Education_GroupLearner_Agent grpAgent = new Education_GroupLearner_Agent()
{
GroupLearnerAgent_GroupeLearner = grpLearner.GroupLearner_Id,
GroupLearnerAgent_Agent = agent.Agent_Id
};
db.Education_GroupLearner_Agent.Add(grpAgent);
db.SaveChanges();
return(grpAgent);
}
public MyColumnCollectionDGGrpAgent(Education_GroupLearner obj)
{
_obj = obj;
}
