public ActionResult Index(QuestionViewModel ques)
{
try
{
if (ModelState.IsValid)
{
using (Varsity_Admission db = new Varsity_Admission())
{
Question question = new Question();
question.E_Year = ques.E_Year;
question.Q_Body = ques.Q_Body;
question.Op_1 = ques.Op_1;
question.Op_2 = ques.Op_2;
question.Op_3 = ques.Op_3;
question.Op_4 = ques.Op_4;
question.Op_5 = ques.Op_5;
question.Q_Answer = ques.Q_Answer;
db.Questions.Add(question);
db.SaveChanges();
ViewBag.success_insert = "Data inserted successfully";
ModelState.Clear();
return(View());
}
}
}
catch (Exception e)
{
throw e;
}
return(View());
}
public ActionResult Edit(int?id)
{
Varsity_Admission queEntity = new Varsity_Admission();
Question que = queEntity.Questions.Find(id);
return(View(que));
}
// GET: Admin
public ActionResult Index()
{
Varsity_Admission examEntity = new Varsity_Admission();
var getYear = examEntity.Exams.ToList();
SelectList list = new SelectList(getYear, "E_Id", "E_Year");
ViewBag.year = list;
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
Varsity_Admission queEntity = new Varsity_Admission();
Question qs = queEntity.Questions.Find(id);
int yr = qs.E_Year;
queEntity.Questions.Remove(qs);
queEntity.SaveChanges();
return(RedirectToAction("SeeQues", new { Id = yr }));
//return RedirectToAction("Index");
}
public ActionResult Index(StudentViewModel student)
{
try
{
if (ModelState.IsValid)
{
using (Varsity_Admission db = new Varsity_Admission())
{
var userWithSameEmail = db.Students.Where(m => m.S_Email == student.S_Email).SingleOrDefault();
if (userWithSameEmail == null)
{
Student stud = new Student();
stud.S_Name = student.S_Name;
stud.S_Email = student.S_Email;
stud.S_Phone = student.S_Phone;
db.Students.Add(stud);
db.SaveChanges();
string mail = stud.S_Email;
Login log_instance = new Login();
log_instance.L_Email = mail;
log_instance.L_Password = student.L_Password;
log_instance.L_Designation = "student";
db.Logins.Add(log_instance);
db.SaveChanges();
ViewBag.success_msg = "Registration Successful";
return(View());
}
else
{
//ModelState.AddModelError("", "Email already exists !");
ViewBag.error_msg = "Email already exists !";
return(View(student));
}
}
}
}
catch (Exception e)
{
throw e;
}
//return View();
return(RedirectToAction("Index"));
//return View(student);
}
public ActionResult SeeQues(int id)
{
Varsity_Admission queEntity = new Varsity_Admission();
var ques = queEntity.Questions
.Where(q => q.E_Year == id);
var queList = ques.ToList();
if (!queList.Any())
{
ViewBag.empty = "No Data Found! ";
}
return(View(queList));
}
public ActionResult Delete(int?id)
{
Varsity_Admission queEntity = new Varsity_Admission();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Employee employee = db.Employees.Find(id);
Question que = queEntity.Questions.Find(id);
if (que == null)
{
return(HttpNotFound());
}
return(View(que));
}
public ActionResult Edit([Bind(Include = "Q_Id,E_Year,Q_Body,Op_1,Op_2,Op_3,Op_4,Op_5,Q_Answer")] Question qstn)
{
Varsity_Admission queEntity = new Varsity_Admission();
int yr;
if (ModelState.IsValid)
{
queEntity.Entry(qstn).State = EntityState.Modified;
queEntity.SaveChanges();
yr = qstn.E_Year;
return(RedirectToAction("SeeQues", new { Id = yr }));
}
// return View(prson);
else
{
return(View());
}
}
public ActionResult Index(Login logs)
{
try
{
string email;
string Sname;
string Settername;
string designation;
using (Varsity_Admission db = new Varsity_Admission())
{
//Login logusr = new Login();
var usr = db.Logins.Single(u => u.L_Email == logs.L_Email && u.L_Password == logs.L_Password);
//if (usr != null && logs.L_Designation == "student")
if (usr != null)
{
designation = usr.L_Designation.ToString();
if (designation == "student")
{
Session["studentlogin"] = true;
email = usr.L_Email.ToString();
Session["student_id"] = usr.L_Id.ToString();
Session["student_mail"] = email;
//return RedirectToAction("LoggedIn");
var usr2 = db.Students.Where(u => u.S_Email == email).Select(u => new
{
S_name = u.S_Name
}).Single();
Sname = usr2.S_name.ToString();
Session["student_name"] = Sname;
return(RedirectToAction("Index", "Student"));
}
if (designation == "setter")
{
Session["setterlogin"] = true;
email = usr.L_Email.ToString();
Session["setter_id"] = usr.L_Id.ToString();
Session["setter_mail"] = email;
//return RedirectToAction("LoggedIn");
var usr2 = db.Setters.Where(u => u.Se_Email == email).Select(u => new
{
Setter_name = u.Se_Name
}).Single();
Settername = usr2.Setter_name.ToString();
Session["setter_name"] = Settername;
return(RedirectToAction("Index", "Setter"));
}
if (designation == "admin")
{
Session["adminlogin"] = true;
return(RedirectToAction("Index", "Admin"));
}
}
else
{
ModelState.AddModelError("", "Email or password is wrong!");
return(View());
}
}
}
catch (Exception e)
{
//throw e;
ModelState.AddModelError("", "Email or password is wrong!");
return(View());
}
//return RedirectToAction("Index");
return(RedirectToAction("LoggedIn"));
}