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