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