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