public void setConfig(ConfigurationPreselection config, int niveau) { var conf_tab = db.ConfigurationPreselections.Where(c => c.Filiere.Equals(config.Filiere) && c.TypeDiplome.Equals(config.TypeDiplome)).FirstOrDefault(); if (conf_tab == null) { config.ID = 1; db.ConfigurationPreselections.Add(config); db.SaveChanges(); } else { conf_tab.Filiere = config.Filiere; conf_tab.TypeDiplome = config.TypeDiplome; conf_tab.CoeffBac = config.CoeffBac; conf_tab.CoeffS1 = config.CoeffS1; conf_tab.CoeffS2 = config.CoeffS2; conf_tab.CoeffS3 = config.CoeffS3; conf_tab.CoeffS4 = config.CoeffS4; conf_tab.NoteSeuil = config.NoteSeuil; if (niveau == 4) { conf_tab.CoeffS5 = config.CoeffS5; conf_tab.CoeffS6 = config.CoeffS6; } db.SaveChanges(); } }
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 JsonResult CalculerPreselec(string fil, string diplome, int Cs1, int Cs2, int Cs3, int Cs4, int Cbac, string seuil, int niv) { ConfigurationPreselection conf = new ConfigurationPreselection() { Filiere = fil, TypeDiplome = diplome, CoeffBac = Cbac, CoeffS1 = Cs1, CoeffS2 = Cs2, CoeffS3 = Cs3, CoeffS4 = Cs4, NoteSeuil = Convert.ToDouble(seuil.Replace(".", ",")) }; preselec.setConfig(conf, niv); preselec.calculerPreselec(niv, fil, diplome); var x = preselec.getConvoques(niv, fil, diplome); return(Json(x)); }
public JsonResult GetConfig(string fil, string diplome) { ConfigurationPreselection list = preselec.getConfig(fil, diplome); return(Json(list)); }
public JsonResult GetConfig(string fil, string diplome) { ConfigurationPreselection list = preselec.getConfig(fil, diplome); return(Json(list, JsonRequestBehavior.AllowGet)); }