public ActionResult Create()
{
ApercuViewModel viewModel = new ApercuViewModel();
ViewBag.PlanCadre = _db.PlanCadre.ToList();
return(View(viewModel));
}
public ActionResult Create()
{
List <PlanCoursDepart> pcd = new List <PlanCoursDepart>();
viewModel = new ApercuViewModel();
var liste = _db.Cours.ToList();
viewModel.PlanCadre = _db.PlanCadre.ToList();
return(View(viewModel));
}
public ActionResult Create()
{
ApercuViewModel viewModel = new ApercuViewModel();
List <PlanCadre> PlanCadres = new List <PlanCadre>();
var planCadre = from PC in _db.PlanCadre
join Programme in _db.Programme on PC.IdProgramme equals Programme.IdProgramme
join DevisMinistere in _db.DevisMinistere on Programme.IdDevis equals DevisMinistere.IdDevis
join Departement in _db.Departement on DevisMinistere.Discipline equals Departement.Discipline
where Departement.Discipline == "420"
select PC;
PlanCadres = planCadre.ToList();
ViewBag.PlanCadre = PlanCadres;
return(View(viewModel));
}
public ActionResult Create(ApercuViewModel ApercuViewModel, FormCollection collection)
{
try {
string UserId = User.Identity.GetUserId();
PlanCadre planCadre = _db.PlanCadre.Find(ApercuViewModel.IdPlanCadre);
var Cours = from cours in _db.Cours
where cours.IdPlanCadre == ApercuViewModel.IdPlanCadre
select cours;
int CoursId = Cours.First().IdCours;
Models.Plan_Cours.PlanCours PC = new Models.Plan_Cours.PlanCours()
{
DateCreation = DateTime.Today,
DateValidation = null,
IdCours = CoursId,
StatutPlanCours = false,
};
_db.PlanCours.Add(PC);
_db.SaveChanges();
var idPlanCours = PC.IdPlanCours;
var PCU = new PlanCoursUtilisateur()
{
IdPlanCoursUtilisateur = UserId,
IdPlanCours = idPlanCours,
BureauProf = ApercuViewModel.BureauProf,
Poste = ApercuViewModel.NoPoste,
};
_db.PlanCoursUtilisateur.Add(PCU);
_db.SaveChanges();
_apercu = GetUser(idPlanCours);
for (var i = 1; i < 15; i++)
{
var texteSectionDefault = new TexteSection {
IdPlanCours = idPlanCours, IdContenuSection = i
};
_db.TexteSection.Add(texteSectionDefault);
_db.SaveChanges();
}
return(RedirectToAction("Index", new
{
apercu = _apercu,
id = PC.IdPlanCours,
}));
}
catch
{
return(View());
}
}
public ActionResult Index()
{
ApercuViewModel model;
try
{
ConnectionSQL csql = new ConnectionSQL();
LigneHistorique data = csql.DerniereEntreeHistorique();
Profil profil = gp.Selectionner(data.Id_profil) ?? new Profil();
Reglage reglage = profil.SelectionnerReglage(data.Id_reglage) ?? new Reglage();
model = new ApercuViewModel(gpa, data, reglage);
}
catch (Exception ex)
{
ModelState.AddModelError("", "Erreur : " + ex.Message);
model = new ApercuViewModel();
}
return(View(model));
}
public ActionResult Index(ApercuPlanCours apercu, int?id)
{
viewModel = new ApercuViewModel();
var courrielConnexion = User.Identity.Name;
var requete = from acces in _db.AccesProgramme
where acces.UserMail == courrielConnexion
select acces.Discipline;
var listePlanCours = new List <Models.Plan_Cours.PlanCours>();
foreach (var planCoursId in GetPlanCours())
{
listePlanCours.Add(_db.PlanCours.Find(planCoursId));
}
foreach (var planCours in listePlanCours)
{
var nomSection = from nomS in _db.NomSection
join cs in _db.ContenuSection on nomS.IdNomSection equals cs.IdNomSection
join ts in _db.TexteSection on cs.IdContenuSection equals ts.IdContenuSection
join pco in _db.PlanCours on ts.IdPlanCours equals pco.IdPlanCours
where pco.IdPlanCours == planCours.IdPlanCours
select nomS;
viewModel.MainPageViewModel.NomSections = new List <List <NomSection> >
{
new List <NomSection> {
nomSection as NomSection
}
};
}
if (id == null)
{
id = 1;
}
var idPlanCadre = from planCours in _db.PlanCours
join cours in _db.Cours on planCours.IdCours equals cours.IdCours
join planCadre in _db.PlanCadre on cours.IdPlanCadre equals planCadre.IdPlanCadre
where planCours.IdPlanCours == id
select planCadre.IdPlanCadre;
viewModel.MainPageViewModel.PlanCours = listePlanCours;
viewModel.MainPageViewModel.ContenuSection = _db.ContenuSection.ToList();
viewModel.MainPageViewModel.NomSection = _db.NomSection.ToList();
apercu = GetUser(Convert.ToInt32(id));
if (apercu != null)
{
List <PlanCoursDepart> pcd = new List <PlanCoursDepart>();
ViewBag.courrielProf = apercu.CourrielProf;
ViewBag.imageCegep = VirtualPathUtility.ToAbsolute(apercu.ImageCegep);
ViewBag.imageDepart = VirtualPathUtility.ToAbsolute(apercu.ImageDepart);
ViewBag.phrase = apercu.Phrase;
ViewBag.infosCours = CreationInfoCours(Convert.ToInt32(idPlanCadre.First()));
ViewBag.infosProf = apercu.InfosProf;
ViewBag.LocalProf = apercu.LocalProf;
ViewBag.session = apercu.Session;
viewModel.TexteContenu = new string[15];
viewModel.TitreSection = new string[15];
var listeSection = RetourneSection(requete.First(), Convert.ToInt32(id));
viewModel.IndexSection = listeSection;
foreach (var section in listeSection)
{
try
{
var texte = CreationSectionDepart(Convert.ToInt32(id), section, requete.First());
viewModel.TexteContenu[section] = texte;
var titre = CreationTitreSection(Convert.ToInt32(id), section);
viewModel.TitreSection[section] = titre;
}
catch (Exception)
{
var textecontenu = CreationSectionDefaut(Convert.ToInt32(id), section, requete.First());
viewModel.TexteContenu[section] = textecontenu;
var titreSection = CreationTitreSection(Convert.ToInt32(id), section);
viewModel.TitreSection[section] = titreSection;
}
}
CreationEnonceCompetence(viewModel, (int)id);
}
else
{
this.AddToastMessage("Attention", "Aucun plan cours n'est associé à votre compte", ToastType.Warning);
}
return(View(viewModel));
}
public void CreationEnonceCompetence(ApercuViewModel ApercuViewModel, int id)
{
var listeElementCompetence = new List <ElementCompetence>();
var listeEnonceCompetence = new List <EnonceCompetence>();
var listeElementConnaissance = new List <ElementConnaissance>();
var listeActiviteApprentissage = new List <ActiviteApprentissage>();
var listePlanCadreCompetence = new List <PlanCadreCompetence>();
var listePlanCadreElement = new List <PlanCadreElement>();
var ponderationEnHeure = new List <int>();
var planCours = _db.PlanCours.Find(id);
if (planCours == null)
{
throw new NullReferenceException();
}
var cours = _db.Cours.Find(planCours.IdCours);
if (cours == null)
{
throw new NullReferenceException();
}
var planCadre = _db.PlanCadre.Find(cours.IdPlanCadre);
var enonceCompetence = from enonce in _db.EnonceCompetence
join planCadreCompetence in _db.PlanCadreCompetence on enonce.IdCompetence equals planCadreCompetence.IdCompetence
join _planCadre in _db.PlanCadre on planCadreCompetence.IdPlanCadre equals _planCadre.IdPlanCadre
where true
select enonce;
foreach (var enonce in enonceCompetence)
{
var planCadreCompetence = from tabPlanCadreCompetence in _db.PlanCadreCompetence
join tabEnonceCompetence in _db.EnonceCompetence on tabPlanCadreCompetence.IdCompetence equals tabEnonceCompetence.IdCompetence
where tabPlanCadreCompetence.IdCompetence == enonce.IdCompetence
select tabPlanCadreCompetence;
foreach (var planCadreComp in planCadreCompetence)
{
listePlanCadreCompetence.Add(planCadreComp);
var planCadreElement = from tabPlanCadreElement in _db.PlanCadreElement
where tabPlanCadreElement.IdPlanCadreCompetence == planCadreComp.IdPlanCadreCompetence
select tabPlanCadreElement;
foreach (var planCadreElements in planCadreElement)
{
listePlanCadreElement.Add(planCadreElements);
}
}
var ponderation = (from tabPlanCadreCompetence in _db.PlanCadreCompetence
where tabPlanCadreCompetence.IdCompetence == enonce.IdCompetence
select tabPlanCadreCompetence.PonderationEnHeure);
foreach (var ponderationHeure in ponderation)
{
ponderationEnHeure.Add(Convert.ToInt32(ponderation.First()));
}
listeEnonceCompetence.Add(enonce);
var _elementCompetence = from tabElement in _db.ElementCompetence
join planCadreElement in _db.PlanCadreElement on tabElement.IdElement equals planCadreElement.IdElement
join PlanCadreCompetence in _db.PlanCadreCompetence on planCadreElement.IdPlanCadreCompetence equals PlanCadreCompetence.IdPlanCadreCompetence
join competence in _db.EnonceCompetence on PlanCadreCompetence.IdCompetence equals competence.IdCompetence
where competence.IdCompetence == tabElement.IdCompetence
select tabElement;
foreach (var _element in _elementCompetence)
{
listeElementCompetence.Add(_element);
var elementConnaissances = from tabConnaissance in _db.ElementConnaissance
join planCadreElement in _db.PlanCadreElement on tabConnaissance.IdPlanCadreElement equals planCadreElement.IdPlanCadreElement
join element in _db.ElementCompetence on planCadreElement.IdElement equals element.IdElement
where true
select tabConnaissance;
foreach (var connaissance in elementConnaissances)
{
listeElementConnaissance.Add(connaissance);
}
var activiteApprentissages = from tabActivite in _db.ActiviteApprentissage
join planCadreElement in _db.PlanCadreElement on tabActivite.IdPlanCadreElement equals planCadreElement.IdElement
join elementCompetence in _db.ElementCompetence on planCadreElement.IdElement equals elementCompetence.IdElement
where elementCompetence.IdElement == _element.IdElement
select tabActivite;
foreach (var activite in activiteApprentissages)
{
listeActiviteApprentissage.Add(activite);
}
}
}
ApercuViewModel.ListeEnonceCompetence = listeEnonceCompetence;
ApercuViewModel.ListeElementCompetence = listeElementCompetence;
ApercuViewModel.ListeActiviteApprentissage = listeActiviteApprentissage;
ApercuViewModel.ListeElementConnaissance = listeElementConnaissance;
ApercuViewModel.PonderationEnHeure = ponderationEnHeure;
ApercuViewModel.ListePlanCadreCompetence = listePlanCadreCompetence;
ApercuViewModel.ListePlanCadreElement = listePlanCadreElement;
}
public void CreationEnonceCompetence(ApercuViewModel AVM, int id)
{
List <ElementCompetence> listeElementCompetence = new List <ElementCompetence>();
List <EnonceCompetence> listeEnonceCompetence = new List <EnonceCompetence>();
List <ElementConnaissance> listeElementConnaissance = new List <ElementConnaissance>();
List <ActiviteApprentissage> listeActiviteApprentissage = new List <ActiviteApprentissage>();
List <PlanCadreCompetence> listePlanCadreCompetence = new List <PlanCadreCompetence>();
List <PlanCadreElement> listePlanCadreElement = new List <PlanCadreElement>();
List <int> ponderationEnHeure = new List <int>();
Models.Plan_Cours.PlanCours PC = _db.PlanCours.Find(id);
Cours cours = _db.Cours.Find(PC.IdCours);
PlanCadre planCadre = _db.PlanCadre.Find(cours.IdPlanCadre);
var EnonceCompetence = from Enonce in _db.EnonceCompetence
join PlanCadreCompetence in _db.PlanCadreCompetence on Enonce.IdCompetence equals PlanCadreCompetence.IdCompetence
join PlanCadre in _db.PlanCadre on PlanCadreCompetence.IdPlanCadre equals PlanCadre.IdPlanCadre
where PlanCadre.IdPlanCadre == planCadre.IdPlanCadre
select Enonce;
foreach (Models.EnonceCompetence Enonce in EnonceCompetence)
{
var planCadreCompetence = from PCC in _db.PlanCadreCompetence
join EC in _db.EnonceCompetence on PCC.IdCompetence equals EC.IdCompetence
where PCC.IdCompetence == Enonce.IdCompetence
select PCC;
foreach (Models.PlanCadreCompetence planCadreComp in planCadreCompetence)
{
listePlanCadreCompetence.Add(planCadreComp);
var planCadreElement = from PCE in _db.PlanCadreElement
where PCE.IdPlanCadreCompetence == planCadreComp.IdPlanCadreCompetence
select PCE;
foreach (Models.PlanCadreElement planCadreElements in planCadreElement)
{
listePlanCadreElement.Add(planCadreElements);
}
}
var ponderation = (from PlanCadreCompetence in _db.PlanCadreCompetence
where PlanCadreCompetence.IdCompetence == Enonce.IdCompetence
select PlanCadreCompetence.PonderationEnHeure);
foreach (int ponderationHeure in ponderation)
{
ponderationEnHeure.Add(Convert.ToInt32(ponderation.First()));
}
listeEnonceCompetence.Add(Enonce);
var ElementCompetence = from Element in _db.ElementCompetence
join PlanCadreElement in _db.PlanCadreElement on Element.IdElement equals PlanCadreElement.IdElement
join PlanCadreCompetence in _db.PlanCadreCompetence on PlanCadreElement.IdPlanCadreCompetence equals PlanCadreCompetence.IdPlanCadreCompetence
join competence in _db.EnonceCompetence on PlanCadreCompetence.IdCompetence equals competence.IdCompetence
where competence.IdCompetence == Enonce.IdCompetence
select Element;
foreach (Models.ElementCompetence Element in ElementCompetence)
{
listeElementCompetence.Add(Element);
var elementConnaissances = from Connaissance in _db.ElementConnaissance
join PlanCadreElement in _db.PlanCadreElement on Connaissance.IdPlanCadreElement equals PlanCadreElement.IdPlanCadreElement
join element in _db.ElementCompetence on PlanCadreElement.IdElement equals element.IdElement
where element.IdElement == Element.IdElement
select Connaissance;
foreach (Models.ElementConnaissance connaissance in elementConnaissances)
{
listeElementConnaissance.Add(connaissance);
}
var activiteApprentissages = from Activite in _db.ActiviteApprentissage
join PlanCadreElement in _db.PlanCadreElement on Activite.IdPlanCadreElement equals PlanCadreElement.IdElement
join elementCompetence in _db.ElementCompetence on PlanCadreElement.IdElement equals elementCompetence.IdElement
where elementCompetence.IdElement == Element.IdElement
select Activite;
foreach (Models.ActiviteApprentissage activite in activiteApprentissages)
{
listeActiviteApprentissage.Add(activite);
}
}
}
AVM.ListeEnonceCompetence = listeEnonceCompetence;
AVM.ListeElementCompetence = listeElementCompetence;
AVM.ListeActiviteApprentissage = listeActiviteApprentissage;
AVM.ListeElementConnaissance = listeElementConnaissance;
AVM.PonderationEnHeure = ponderationEnHeure;
AVM.ListePlanCadreCompetence = listePlanCadreCompetence;
AVM.ListePlanCadreElement = listePlanCadreElement;
}
