public ActionResult Modification([Bind(Include = "cne,nationalite,email,phone,gsm,address,ville,dateNaiss,lieuNaiss")] Etudiant etudiant, string Update, String choix1, String choix2, String choix3)
{
ViewBag.Current = "Modification";
/*Update name of buttom if user click in Upload l image seule va etre modifie
*
*/
Etudiant etudiants = etudiantContext.etudiants.Find(etudiant.cne);
if (Request.Files.Count > 0 && Update == "Upload")
{
//Recupere le fichier est le sauvegarder dans /image/
HttpPostedFileBase file = Request.Files[0];
string fileName = Path.GetFileNameWithoutExtension(file.FileName);
string extension = Path.GetExtension(file.FileName);
ViewBag.exte = extension;
if (fileName != "" && ImageEx.Contains(extension) == true)
{
fileName = etudiants.nom + DateTime.Now.ToString("yymmssfff") + extension;
etudiants.photo_link = fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
file.SaveAs(fileName);
etudiants.Modified = true;
etudiantContext.SaveChanges();
return(View(etudiants));
}
else
{
ViewBag.err = " vous devez selectionner une image";
return(View(etudiants));
}
}
else
{
ViewBag.err = null;
//si clicke sur les valider les modification
etudiants.Modified = true;
etudiants.Choix = choix1 + choix2 + choix3;
etudiants.nationalite = etudiant.nationalite;
etudiants.email = etudiant.email;
etudiants.phone = etudiant.phone;
etudiants.address = etudiant.address;
etudiants.gsm = etudiant.gsm;
etudiants.address = etudiant.address;
etudiants.ville = etudiant.ville;
etudiants.dateNaiss = etudiant.dateNaiss;
etudiants.lieuNaiss = etudiant.lieuNaiss;
etudiantContext.SaveChanges();
return(RedirectToAction("SendEmailToUser"));
}
}
public ActionResult Setting(DateTime dateNotification, DateTime dateAttribution)
{
if (UserValide.IsValid() && UserValide.IsAdmin())
{
EtudiantContext db = new EtudiantContext();
ViewBag.Delai = db.settings.FirstOrDefault().Delai;
ViewBag.DatedeRappel = db.settings.FirstOrDefault().DatedeRappel;
if (dateNotification != null)
{
db.settings.FirstOrDefault().DatedeRappel = dateNotification;
}
if (dateAttribution != null)
{
db.settings.FirstOrDefault().Delai = dateAttribution;
}
db.SaveChanges();
ViewBag.Current = "Setting";
return(View("Setting"));
}
else
{
return(RedirectToAction("Authentification", "User"));
}
}
//suppression des etudiants importes mais pas les redoublants
public ActionResult DeleteImportedStudents()
{
if (UserValide.IsValid() && UserValide.IsAdmin())
{
EtudiantContext db = new EtudiantContext();
for (int i = 0; i < db.etudiants.ToList().Count; i++)
{
if (db.etudiants.ToList()[i].Redoubler == false)
{
db.etudiants.Remove(db.etudiants.ToList()[i]);
}
}
db.settings.First().Attributted = false;
db.settings.First().importEtudiant = false;
db.settings.First().importNote = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Authentification", "User"));
}
}
public IActionResult Create(User user)
{
// TODO: Encrypt password
_context.Update(user);
_context.SaveChanges();
return(new ObjectResult(user.Id));
}
public IActionResult Create(Student student)
{
// Save Image
if (!string.IsNullOrEmpty(student.Photo))
{
string base64 = student.Photo;
var filePath = Path.Combine(string.Format("Uploads/Students/{0}.png", student.IndexNumber));
_fileManager.SaveFile(filePath, base64);
student.Photo = student.IndexNumber;
}
_context.Update(student);
_context.SaveChanges();
return(new ObjectResult(student));
}
public ActionResult ImporterNoteExcel(HttpPostedFileBase excelFile)
{
if (Request != null)
{
EtudiantContext db = new EtudiantContext();
HttpPostedFileBase file = Request.Files["excelfile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName) && (file.FileName.EndsWith("xls") || file.FileName.EndsWith("xlsx")))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
Console.WriteLine("before entering ......");
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
Console.WriteLine(" entering ......");
Etudiant e = db.etudiants.Find(workSheet.Cells[rowIterator, 1].Value.ToString());
e.noteFstYear = Convert.ToDouble(workSheet.Cells[rowIterator, 2].Value);
e.noteSndYear = Convert.ToDouble(workSheet.Cells[rowIterator, 3].Value);
//db.etudiants.Add(e);
Console.WriteLine(" out ......");
}
db.settings.First().importNote = true;
db.SaveChanges();
}
}
else
{
ViewBag.errI = true;
return(View("ImporterNotes"));
}
}
return(RedirectToAction("Index"));
}
//suppression des etudiants (placer les etudiants redoublants dans la corbeille)
public ActionResult SupprimerEtudiant(string id)
{
if (UserValide.IsValid() && UserValide.IsAdmin())
{
if (id != null)
{
EtudiantContext db = new EtudiantContext();
db.etudiants.Find(id).Redoubler = true;
db.SaveChanges();
ViewBag.Current = "Index";
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Authentification", "User"));
}
}
else
{
return(RedirectToAction("Authentification", "User"));
}
}
public IActionResult Create(Branch branch)
{
_context.Update(branch);
_context.SaveChanges();
return(Ok(branch.Id));
}
public ActionResult AttributionFiliere(string infoMax, string indusMax, string gtrMax, string gpmcMax)
{
ViewBag.Current = "attributionFiliere";
if (UserValide.IsValid() && UserValide.IsAdmin())
{
EtudiantContext db = new EtudiantContext();
//return a list sorted in a desendent way
List <Etudiant> list = db.etudiants.OrderByDescending(e => (e.noteFstYear + e.noteSndYear) / 2).ToList();
int total = 0;
for (int i = 0; i < db.etudiants.ToList().Count; i++)
{
if (!db.etudiants.ToList()[i].Redoubler)
{
total++;
}
}
int maxInfo = total / 4;
int maxGtr = total / 4;
int maxIndus = total / 4;
int maxGpmc = total / 4;
int diff = total % 4;
Boolean symbol1 = false;
Boolean symbol2 = false;
Boolean symbol3 = false;
Boolean symbol4 = false;
Boolean taken = false;
int info = 0, indus = 0, gpmc = 0, gtr = 0;
for (int i = 0; i < db.etudiants.ToList().Count; i++)
{
if (!db.etudiants.ToList()[i].Redoubler && db.etudiants.ToList()[i].Validated)
{
char[] chiffr = (list[i].Choix).ToCharArray();
if (chiffr[0] == 'F')
{
info++;
}
if (chiffr[0] == 'P')
{
gpmc++;
}
if (chiffr[0] == 'T')
{
gtr++;
}
if (chiffr[0] == 'D')
{
indus++;
}
}
}
//il faut envoyer les nbr par defaut pour les textboxes
//il faut classer les filieres par nbr de demande
////////partie statistique
//variable pour les nombre totale et le reste qui n'a pas choisi les filieres
int nbrTotal = total;
//initialisation des Maxs
for (int i = 0; i < diff; i++)
{
if (info >= indus && info >= gtr && info >= gpmc && !symbol1 && !taken)
{
symbol1 = true;
taken = true;
maxInfo += 1;
}
if (indus >= info && indus >= gtr && indus >= gpmc && !symbol2 && !taken)
{
symbol2 = true;
taken = true;
maxIndus += 1;
}
if (gpmc >= indus && gpmc >= gtr && gpmc >= indus && !symbol3 && !taken)
{
symbol3 = true;
taken = true;
maxGpmc += 1;
}
if (gtr >= indus && gtr >= gpmc && gtr >= info && !symbol4 && !taken)
{
taken = true;
symbol4 = true;
maxGtr += 1; break;
}
taken = false;
}
//changer les maxs si la departement a saisi des valeurs
if (infoMax != null && indusMax != null && gpmcMax != null && gtrMax != null)
{
try
{
maxInfo = Convert.ToInt32(infoMax);
maxIndus = Convert.ToInt32(indusMax);
maxGtr = Convert.ToInt32(gtrMax);
maxGpmc = Convert.ToInt32(gpmcMax);
if (maxInfo + maxIndus + maxGtr + maxGpmc != total)
{
ViewBag.error2 = true;
return(View());
}
}
catch (Exception e)
{
}
}
int indexInfo = 0;
int indexGtr = 0;
int indexIndus = 0;
int indexGpmc = 0;
for (int i = 0; i < list.Count; i++)
{
//verification de l'etudiant si deja a choisi une filiere sinon on va lui attribuer la derniere filiere (gpmc->indus->gtr->info)
if (!list[i].Redoubler)
{
if (list[i].Validated)
{
//parse to a table of chars
char[] choice = list[i].Choix.ToCharArray();
//verify the frst case which is if we have F=info
Boolean choosen = false;
for (int j = 0; j < 3; j++)
{
if (choice[j] == 'F')
{
if (indexInfo < maxInfo)
{
list[i].idFil = 1;
choosen = true;
indexInfo++; break;
}
}
if (choice[j] == 'T')
{
if (indexGtr < maxGtr)
{
list[i].idFil = 2;
choosen = true;
indexGtr++; break;
}
}
if (choice[j] == 'D')
{
if (indexIndus < maxIndus)
{
list[i].idFil = 3;
choosen = true;
indexIndus++; break;
}
}
if (choice[j] == 'P')
{
if (indexGpmc < maxGpmc)
{
list[i].idFil = 4;
choosen = true;
indexGpmc++; break;
}
}
if (choosen)
{
j = 3;
}
if (!choosen && j == 2)
{
list[i].idFil = 4;
choosen = true;
indexGpmc++; break;
}
}
}
else
{
taken = false;
if (info >= indus && info >= gtr && info >= gpmc && !taken && (indexInfo < maxInfo))
{
taken = true;
list[i].idFil = 1;
indexInfo += 1;
}
if (indus >= info && indus >= gtr && indus >= gpmc && !taken && (indexIndus < maxIndus))
{
taken = true;
list[i].idFil = 3;
indexIndus += 1;
}
if (gtr >= indus && gtr >= info && gtr >= gpmc && !taken && (indexGtr < maxGtr))
{
taken = true;
list[i].idFil = 2;
indexGtr += 1;
}
if (gpmc >= indus && gpmc >= gtr && gpmc >= info && !taken && (indexGpmc < maxGpmc))
{
taken = true;
list[i].idFil = 4;
indexGpmc += 1;
}
}
}
}
//list =list.OrderBy(e => (e.noteFstYear+e.noteSndYear)/2);
db.settings.First().Attributted = true;
//envoi d'un msg qui contient la filiere attribuer pour tous chaque etudiants
db.SaveChanges();
EnvoyerLesFilieres();
return(RedirectToAction("AttributionFiliere"));
}
else
{
return(RedirectToAction("Authentification", "User"));
}
}
public ActionResult ImporterEtudiantExcel(HttpPostedFileBase excelFile)
{
if (Request != null)
{
EtudiantContext db = new EtudiantContext();
HttpPostedFileBase file = Request.Files["excelfile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName) && (file.FileName.EndsWith("xls") || file.FileName.EndsWith("xlsx")))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
Console.WriteLine("before entering ......");
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
Console.WriteLine(" entering ......");
Etudiant e = new Etudiant();
e.nom = workSheet.Cells[rowIterator, 1].Value.ToString();
e.prenom = workSheet.Cells[rowIterator, 2].Value.ToString();
//e.nationalite = workSheet.Cells[rowIterator, 3].Value.ToString();
e.cin = workSheet.Cells[rowIterator, 3].Value.ToString();
e.cne = workSheet.Cells[rowIterator, 4].Value.ToString();
/*
* e.email = workSheet.Cells[rowIterator, 6].Value.ToString();
*
* e.phone = workSheet.Cells[rowIterator, 7].Value.ToString();
*
*
* e.gsm = workSheet.Cells[rowIterator, 8].Value.ToString();
*
* e.address = workSheet.Cells[rowIterator, 9].Value.ToString();
*
* e.ville = workSheet.Cells[rowIterator,10].Value.ToString();
*
*
* e.typeBac = workSheet.Cells[rowIterator, 11].Value.ToString();*/
//e.anneeBac = Convert.ToDateTime(DateTime.Now);
//e.anneeBac = Convert.ToDateTime(DateTime.Now);
e.dateNaiss = Convert.ToDateTime(DateTime.Now);
/*
* e.noteBac = Convert.ToDouble(workSheet.Cells[rowIterator, 13].Value);
* e.mentionBac = workSheet.Cells[rowIterator, 14].Value.ToString();
*
* e.lieuNaiss = workSheet.Cells[rowIterator, 16].Value.ToString();
*/
db.etudiants.Add(e);
Console.WriteLine(" out ......");
}
db.settings.First().importEtudiant = true;
db.SaveChanges();
for (int i = 0; i < db.etudiants.ToList().Count; i++)
{
db.etudiants.ToList()[i].Choix = "FDT";
}
db.SaveChanges();
}
}
else
{
ViewBag.errI = true;
return(View("ImporterEtudiants"));
}
}
return(RedirectToAction("Index"));
//return View("Index");
}
public IActionResult Create(Class @class)
{
_context.Update(@class);
_context.SaveChanges();
return(Ok(@class.Id));
}
public void Save(Etudiant e)
{
db.Etudiant.Add(e);
db.SaveChanges();
}
public IActionResult Create(Attendance attendance)
{
_context.Update(attendance);
_context.SaveChanges();
return(Ok(attendance.Id));
}
public IActionResult Create(StudentClass studentClass)
{
_context.Update(studentClass);
_context.SaveChanges();
return(Ok(studentClass.Id));
}