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