public void calculerPreselec(int niveau, string fil, string diplome) { ConfigurationPreselection conf = db.ConfigurationPreselections.Where(c => c.Filiere.Equals(fil) && diplome.Contains(c.TypeDiplome)).First(); double sum; int sumCoeff; sumCoeff = conf.CoeffBac + conf.CoeffS1 + conf.CoeffS2 + conf.CoeffS3 + conf.CoeffS4; if (niveau == 4) { sumCoeff += conf.CoeffS5 + conf.CoeffS6; } foreach (PreselectionModel c in this.getAll(niveau, fil, diplome).ToList()) { sum = 0; sum = (c.NoteBac * conf.CoeffBac) + (c.Note1 * conf.CoeffS1) + (c.Note2 * conf.CoeffS2) + (c.Note3 * conf.CoeffS3) + (c.Note4 * conf.CoeffS4); if (niveau == 4) { sum += (c.Note5 * conf.CoeffS5) + (c.Note6 * conf.CoeffS6); } //il se peut y7eydo ila b9a void c.NotePreselec = Math.Round(sum / sumCoeff, 2); c.Convoque = (c.NotePreselec >= conf.NoteSeuil) ? true : false; var temp = db.Candidats.Find(c.Cne); temp.NotePreselec = c.NotePreselec; temp.Convoque = c.Convoque; db.SaveChanges(); } }
public IEnumerable <SearchModel3> conformCandidat(string cne, int niveau) { var x = db.Candidats.Where(c => c.Cne == cne).SingleOrDefault(); x.Conforme = !x.Conforme; db.SaveChanges(); var y = this.info(niveau); return(y); }
public void enregisterByCin(string cin) { var candidat = db.Candidats.Where(x => x.Cin.Equals(cin)).SingleOrDefault(); //après enregistrement : présence=true + génération de num de dossier : if (candidat != null) { candidat.Presence = true; candidat.Num_dossier = generateNumDossier(candidat.Cin); db.SaveChanges(); } }
public void calculeNoteGlobale(string filiere) { Console.WriteLine("the filiere is " + filiere); ConfigurationSelection conf = db.ConfigurationSelections.Where(a => a.Filiere.Equals(filiere) && a.Niveau == "3").SingleOrDefault(); var data = db.Candidats.Where(c => c.Filiere.Nom.Equals(filiere) && c.Niveau == 3); foreach (var person in data) { ConcourEcrit concours = db.CouncourEcrits.Where(c => c.Cne.Equals(person.Cne)).SingleOrDefault(); concours.NoteGenerale = (concours.NoteMath * conf.CoeffMath + concours.NoteSpecialite * conf.CoeffSpecialite) / (conf.CoeffMath + conf.CoeffSpecialite); } db.SaveChanges(); }
public ActionResult INFO_Post(UserViewModel etudiants) { for (int i = 0; i < etudiants.Cne.Count; i++) { ConcourEcrit con = _context.CouncourEcrits.Find(etudiants.Cne[i]); con.NoteMath = etudiants.NoteMath[i]; con.NoteSpecialite = etudiants.NoteSpecialite[i]; _context.SaveChanges(); } return(RedirectToAction("index")); }
public IEnumerable <SearchModel3> restoreCorbeil(string cne, int niveau) { var y = db.Corbeilles.Where(cor => cor.CNE == cne).SingleOrDefault(); db.Corbeilles.Remove(y); db.SaveChanges(); var x = this.info(niveau); return(x); }
public void setBaccalaureat(BaccalaureatModel bac_saisi) { Baccalaureat bac = db.Baccalaureats.Find(bac_saisi.Cne); bac.DateObtentionBac = bac_saisi.DateObtentionBac; bac.MentionBac = bac_saisi.MentionBac; bac.NoteBac = bac_saisi.NoteBac; bac.TypeBac = bac_saisi.TypeBac; db.Update(bac); db.SaveChanges(); }
public int Upload(UploadModel model) { int msg = 0; string uniqueFileName = null; if (model.fichier != null) { try { String extension = Path.GetExtension(model.fichier.FileName); //se positionner dans le dossier string uploadFolder = Path.Combine(hostingEnvironment.WebRootPath, "epreuves"); //make a unique filename Random r = new Random(); int rInt = r.Next(0, 10000); uniqueFileName = rInt.ToString() + extension.ToLower(); /*//se positionner dans le dossier * string uploadFolder = Path.Combine(hostingEnvironment.WebRootPath, "epreuves"); * //make a unique filename * uniqueFileName = Guid.NewGuid().ToString() + "_" + model.fichier.FileName; * //définir le chemin complet*/ string filePath = Path.Combine(uploadFolder, uniqueFileName); //upload dans le fichier epreuve FileStream stream = new FileStream(filePath, FileMode.Create); model.fichier.CopyTo(stream); stream.Close(); //Inserer le name dans la bd Epreuves epreuve = new Epreuves { Matiere = model.matiere, Annee = model.annee, NomFichier = uniqueFileName }; db.Add(epreuve); db.SaveChanges(); msg = 1; } catch (Exception ex) { } } return(msg); }
public ActionResult Step1(InfoPersoModel candidat) { string cne = HttpContext.Session.GetString("cne"); if (ModelState.IsValid) { var originalCandiat = (from c in _db.Candidats where c.Cne == cne select c).First(); originalCandiat.DateNaissance = candidat.DateNaissance; originalCandiat.LieuNaissance = candidat.LieuNaissance; originalCandiat.Sexe = candidat.Sexe; originalCandiat.Nationalite = candidat.Nationalite; originalCandiat.Gsm = candidat.Gsm; originalCandiat.Telephone = candidat.Telephone; originalCandiat.Adresse = candidat.Adresse; originalCandiat.Ville = candidat.Ville; _db.SaveChanges(); HttpContext.Session.SetInt32("steps", 2); return(RedirectToAction("Step2")); } return(View(candidat)); }