public FileResult Export4eme() { Projet_ContextBD entities = new Projet_ContextBD(); DataTable dt = new DataTable("Grid"); dt.Columns.AddRange(new DataColumn[5] { new DataColumn("CIN"), new DataColumn("CNE"), new DataColumn("prenom"), new DataColumn("nom"), new DataColumn("n_dossier") }); var list_can = this.preselectionCalculeget4eme(Convert.ToInt32(Session["id_fil"]), Convert.ToString(Session["nom_dip"]), Convert.ToDouble(Session["n1"]), Convert.ToInt32(Session["n2"]), Convert.ToInt32(Session["n3"]), Convert.ToInt32(Session["n4"]), Convert.ToInt32(Session["n5"]), Convert.ToInt32(Session["n6"]), Convert.ToInt32(Session["bac"]), Convert.ToDouble(Session["seuil"])); foreach (var cand3 in list_can) { dt.Rows.Add(cand3.CIN, cand3.CNE, cand3.prenom, cand3.nom, cand3.n_dossier); } using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt); using (MemoryStream stream = new MemoryStream()) { wb.SaveAs(stream); return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Results4eme.xlsx")); } } }
public ActionResult Authorise(Candidat user) { if (ModelState.IsValid) { using (Projet_ContextBD db = new Projet_ContextBD()) { var userDetail = db.Candidats.Where(x => x.CIN == user.CIN && x.password == user.password).FirstOrDefault(); if ((userDetail == null) && (ModelState.IsValid)) { // user.LoginErrorMsg = "Invalid UserName or Password"; Response.Write("<script>alert(\'données incorrect\');</" + "script>"); return(View("Index", user)); } else { CandidatsController.id = (string)Session["CIN"]; Session["CIN"] = userDetail.CIN; Session["prenom"] = userDetail.prenom; return(RedirectToAction("Edit", new RouteValueDictionary(new { Controller = "Candidats", Action = "Edit", id = Session["CIN"] }))); } } } else { return(View("Index")); } }
public JsonResult RegisterConfirm(String regId) { using (var ddb = new Projet_ContextBD()) { Candidat Data = ddb.Candidats.Where(x => x.CIN == regId).FirstOrDefault(); Data.EmailConfirmed = true; db.SaveChanges(); var msg = "Your Email Is Verified!"; return(Json(msg, JsonRequestBehavior.AllowGet)); } }
public ActionResult Authorise(string login, string password) { //if (ModelState.IsValid) // { using (Projet_ContextBD db = new Projet_ContextBD()) { var userDetail = db.Admins.Where(x => x.Login == login && x.password == password).FirstOrDefault(); if (userDetail == null) { // user.LoginErrorMsg = "Invalid UserName or Password"; Response.Write("<script>alert(\'données incorrect\');</" + "script>"); return(View("LoginAdmin")); } else { Session["login"] = userDetail.Login; Session["password"] = userDetail.password; int nb3eme = 0; int nb4eme = 0; int nbIns = 0; foreach (var cand in db.Candidats.ToArray()) { if (cand.niveau.Equals("4eme")) { nb4eme++; } else if (cand.niveau.Equals("3eme")) { nb3eme++; } nbIns++; } int msgnonVue = 0; foreach (var msg in db.message.ToList()) { if (msg.vue.Equals(0)) { msgnonVue++; } } ViewBag.Msg = Convert.ToString(msgnonVue); ViewBag.niv3 = Convert.ToString(nb3eme); ViewBag.niv4 = Convert.ToString(nb4eme); ViewBag.ut = Convert.ToString(nbIns.ToString()); return(View("Index")); } } }
public ActionResult Authorise(Candidat user) { using (Projet_ContextBD db = new Projet_ContextBD()) { var userDetail = db.Candidats.Where(x => x.CIN == user.CIN && x.password == user.password).FirstOrDefault(); if (userDetail == null) { // user.LoginErrorMsg = "Invalid UserName or Password"; return(View("Index", user)); } else { Session["CIN"] = user.CIN; ViewBag.cin = user.CIN; Session["prenom"] = user.prenom; return(RedirectToAction("Edit", "Candidats")); } } }