public ActionResult AddQuestion(Question question) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(EId => EId.Id == question.ExamID); exam.TotalQues = (int)exam.TotalQues + 1; question.QuestionNumber = exam.TotalQues; context.Exams.Attach(exam); var entry = context.Entry(exam); entry.Property(e => e.TotalQues).IsModified = true; context.SaveChanges(); context.Questions.Add(question); context.SaveChanges(); return(RedirectToAction("CreateQuestion", new { id = question.ExamID })); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult CreateExam(Exam exam) { //if (Session["Userid"] != null && Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { //if (ModelState.IsValid) //{ using (TsmsDBContext context = new TsmsDBContext()) { exam.QuestionMaker = (string)Session["Userid"]; exam.TotalQues = 0; context.Exams.Add(exam); context.SaveChanges(); return(RedirectToAction("ExamDetail", new { id = exam.Id })); } // } // else // { // return View(); // } // } // else // { // return RedirectToAction("Index", "Exam"); // } // } // else // { // return RedirectToAction("Index", "Exam"); }
public ActionResult DeleteExamPost(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(EId => EId.Id == id); context.Exams.Attach(exam); context.Exams.Remove(exam); context.SaveChanges(); return(RedirectToAction("Index")); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult AddQuestion(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(EId => EId.Id == id); // if (exam.QuestionMaker == (string)Session["Userid"]) // { ViewBag.ExamId = id; ViewBag.Total = exam.TotalQues + 1; ViewBag.Mark = Convert.ToString(exam.MarkPerQues); return(View()); //} //else //{ // return RedirectToAction("Index", "Exam"); //} } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult DeleteAssignStudentPost(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { ExamAssign assign = context.ExamAssigns.SingleOrDefault(p => p.Id == id); int examid = assign.ExamID; context.ExamAssigns.Remove(assign); context.SaveChanges(); return(RedirectToAction("AssaignCourse", new { id = examid })); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult StudentResult(string a) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { if (a != null) { using (TsmsDBContext context = new TsmsDBContext()) { ViewBag.Name = context.UserDetails.SingleOrDefault(p => p.UserId == a).fullname; List <ExamAssign> exam = context.ExamAssigns.Where(EId => EId.StudentID == a).ToList(); return(View(exam)); } } else { return(View()); } // } // else // { // return RedirectToAction("Index", "Exam"); // } // } // else // { // return RedirectToAction("Index", "Exam"); // } }
public ActionResult EditExam(Exam exam) { //if (Session["Userid"] != null && Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { context.Exams.Attach(exam); var entry = context.Entry(exam); entry.Property(e => e.Course).IsModified = true; entry.Property(e => e.Date).IsModified = true; entry.Property(e => e.ExamState).IsModified = true; entry.Property(e => e.FinishTime).IsModified = true; entry.Property(e => e.MarkPerQues).IsModified = true; entry.Property(e => e.Name).IsModified = true; entry.Property(e => e.StartTime).IsModified = true; entry.Property(e => e.Type).IsModified = true; context.SaveChanges(); return(RedirectToAction("ExamDetail", new { id = exam.Id })); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult EditQuestion(Question ques) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { context.Questions.Attach(ques); var entry = context.Entry(ques); entry.Property(e => e.QuestionTitle).IsModified = true; entry.Property(e => e.Option1).IsModified = true; entry.Property(e => e.Option2).IsModified = true; entry.Property(e => e.Option3).IsModified = true; entry.Property(e => e.Option4).IsModified = true; entry.Property(e => e.Option5).IsModified = true; entry.Property(e => e.CorrectAns).IsModified = true; context.SaveChanges(); return(RedirectToAction("CreateQuestion", new { id = ques.ExamID })); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult DeleteQuestionPost(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Question ques = context.Questions.SingleOrDefault(p => p.Id == id); context.Questions.Remove(ques); context.SaveChanges(); Exam exam = context.Exams.SingleOrDefault(p => p.Id == ques.ExamID); exam.TotalQues = exam.TotalQues - 1; context.Exams.Attach(exam); var entry = context.Entry(exam); entry.Property(e => e.TotalQues).IsModified = true; context.SaveChanges(); return(RedirectToAction("CreateQuestion", new { id = ques.ExamID })); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); // } }
protected void Application_Start() { Database.SetInitializer(new DBSeeder()); AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBuldles(BundleTable.Bundles); TsmsDBContext db = new TsmsDBContext(); db.Users.ToList(); }
public ActionResult ShowQuestion(FormCollection form) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ using (TsmsDBContext context = new TsmsDBContext()) { int examId = Convert.ToInt32(Request.Form["hidden"]); Exam exam = context.Exams.SingleOrDefault(p => p.Id == examId); for (int i = 1; i <= exam.TotalQues; i++) { Answer ans = new Answer(); ans.StudentId = (string)Session["Userid"]; ans.StuAns = Convert.ToInt32(Request.Form[i.ToString()]); ans.ExamId = examId; ans.QuestionId = Convert.ToInt32(Request.Form["QuesId" + i.ToString()]); Question ques = context.Questions.SingleOrDefault(p => p.Id == ans.QuestionId); if (ans.StuAns == ques.CorrectAns) { ans.Result = true; } else { ans.Result = false; } context.Answers.Add(ans); context.SaveChanges(); } List <Answer> answers = context.Answers.Where(p => p.ExamId == examId && p.StudentId == (string)Session["Userid"]).ToList(); float achived = 0; foreach (Answer answer in answers) { if (answer.Result == true) { achived++; } } Exam examOb = context.Exams.SingleOrDefault(p => p.Id == examId); float Marks = achived * examOb.MarkPerQues; ExamAssign assign = context.ExamAssigns.SingleOrDefault(p => p.ExamID == examId && p.StudentID == Convert.ToString(Session["Userid"])); assign.gotMark = Marks.ToString(); context.ExamAssigns.Attach(assign); var entry = context.Entry(assign); entry.Property(e => e.gotMark).IsModified = true; context.SaveChanges(); float totalmarks = examOb.TotalQues * examOb.MarkPerQues; return(RedirectToAction("ShowResult", new { id = examId, total = totalmarks, achieved = Marks })); } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult Index() { User CurrentUser = (User)Session["CurrentUser"]; if (CurrentUser.level == "admin") { using (TsmsDBContext context = new TsmsDBContext()) { string user = CurrentUser.UserId.ToString(); List <Exam> exam = context.Exams.Where(p => p.QuestionMaker == user).ToList(); return(View(exam)); } } else { return(RedirectToAction("Index", "Admin")); } }
public ActionResult ExamResult(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { List <ExamAssign> exam = context.ExamAssigns.Where(EId => EId.ExamID == id).ToList(); return(View(exam)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult AssaignStudent(FormCollection form) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { List <ExamAssign> all = context.ExamAssigns.Where(p => p.StudentID == Request.Form["stuName"] && p.ExamID == Convert.ToInt32(Request.Form["ExamId"])).ToList(); if (all == null) { ViewBag.ExamId = Convert.ToInt32(Request.Form["ExamId"]); ExamAssign assign = new ExamAssign(); assign.ExamID = Convert.ToInt32(Request.Form["ExamId"]); assign.StudentID = Request.Form["stuName"]; context.ExamAssigns.Add(assign); context.SaveChanges(); List <ExamAssign> assaign = context.ExamAssigns.Where(p => p.ExamID == Convert.ToInt32(Request.Form["ExamId"])).ToList(); return(View(assaign)); } else { ViewBag.ExamId = Convert.ToInt32(Request.Form["ExamId"]); List <ExamAssign> assaign = context.ExamAssigns.Where(p => p.ExamID == Convert.ToInt32(Request.Form["ExamId"])).ToList(); return(View(assaign)); } } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult EditQuestion(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Question ques = context.Questions.SingleOrDefault(p => p.Id == id); return(View(ques)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult DeleteExam(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(EId => EId.Id == id); ViewBag.QuestionMakerName = context.UserDetails.Where(p => p.UserId == exam.QuestionMaker).Select(y => y.fullname); return(View(exam)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult DeleteAssignStudent(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { ExamAssign assign = context.ExamAssigns.SingleOrDefault(p => p.Id == id); return(View(assign)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult ExamDetail(int id) { if ((string)Session["Userid"] != null && (string)Session["Level"] != null) { if ((string)Session["Level"] == "student") { using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(EId => EId.Id == id); ViewBag.QuestionMakerName = context.UserDetails.Where(p => p.UserId == exam.QuestionMaker).Select(y => y.fullname); return(View(exam)); } } else { return(RedirectToAction("Index", "Exam")); } } else { return(RedirectToAction("Index", "Exam")); } }
public ActionResult DeleteQuestion(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(EId => EId.Id == id); Question ques = context.Questions.SingleOrDefault(p => p.ExamID == id && p.QuestionNumber == exam.TotalQues); return(View(ques)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult Index() { User CurrentUser = (User)Session["CurrentUser"]; // Session["Userid"] = "13-25519-2"; //Session["Level"] = "student"; // if ((string)Session["Level"] == "student") //{ using (TsmsDBContext context = new TsmsDBContext()) { List <ExamAssign> assign = context.ExamAssigns.Where(p => p.StudentID == CurrentUser.UserId.ToString()).ToList(); return(View(assign)); } // // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult AssaignCourse(int id) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { ViewBag.ExamId = id; List <ExamAssign> assaign = context.ExamAssigns.Where(p => p.ExamID == id).ToList(); return(View(assaign)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult ShowResult(int id, float total, float achieved) { //if ((string)Session["Userid"] != null && (string)Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { ViewBag.ExamId = id; ViewBag.TotalMarks = total; ViewBag.achieved = achieved; return(View()); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult GetStudents(string term) { //if (Session["Userid"] != null && Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { List <string> students = context.Users.Where(x => x.UserId.StartsWith(term)). Select(y => y.UserId).ToList(); return(Json(students, JsonRequestBehavior.AllowGet)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult GetCourses(string term) { //if (Session["Userid"] != null && Session["Level"] != null) //{ // if ((string)Session["Level"] == "admin") // { using (TsmsDBContext context = new TsmsDBContext()) { List <string> courses = context.Courses.Where(x => x.name.Contains(term)). Select(y => y.name).ToList(); return(Json(courses, JsonRequestBehavior.AllowGet)); } // } // else // { // return RedirectToAction("Index", "Exam"); // } //} //else //{ // return RedirectToAction("Index", "Exam"); //} }
public ActionResult ShowQuestion(int id) { User CurrentUser = (User)Session["CurrentUser"]; //if (Session["Userid"] != null) //{ using (TsmsDBContext context = new TsmsDBContext()) { Exam exam = context.Exams.SingleOrDefault(p => p.Id == id); if (CurrentUser.level == "admin") { Answer ans = context.Answers.SingleOrDefault(p => p.ExamId == id && p.StudentId == CurrentUser.UserId); if (ans == null) { ViewBag.ExamId = id; ViewBag.Total = exam.TotalQues; var src = DateTime.Now; string hour = src.Hour.ToString(); string min = src.Minute.ToString(); string end = exam.FinishTime; char[] d = { ' ', ':' }; string[] words = end.Split(d, System.StringSplitOptions.RemoveEmptyEntries); string endHour = words[0]; string endMin = words[1]; ViewBag.duration = ((Convert.ToInt32(endHour) * 60 + Convert.ToInt32(endMin)) - (Convert.ToInt32(hour) * 60 + Convert.ToInt32(min))) * 60 * 1000; ViewBag.CountDown = exam.Date + " " + end + ":00"; List <Question> questions = context.Questions.Where(p => p.ExamID == id).ToList(); return(View(questions)); } else { List <Answer> answers = context.Answers.Where(p => p.ExamId == id && p.StudentId == Convert.ToString(Session["Userid"])).ToList(); foreach (Answer ansob in answers) { context.Answers.Attach(ansob); context.Answers.Remove(ansob); context.SaveChanges(); } ViewBag.ExamId = id; ViewBag.Total = exam.TotalQues; var src = DateTime.Now; string hour = src.Hour.ToString(); string min = src.Minute.ToString(); string end = exam.FinishTime; char[] d = { ' ', ':' }; string[] words = end.Split(d, System.StringSplitOptions.RemoveEmptyEntries); string endHour = words[0]; string endMin = words[1]; ViewBag.duration = ((Convert.ToInt32(endHour) * 60 + Convert.ToInt32(endMin)) - (Convert.ToInt32(hour) * 60 + Convert.ToInt32(min))) * 60 * 1000; ViewBag.CountDown = exam.Date + " " + end + ":00"; List <Question> questions = context.Questions.Where(p => p.ExamID == id).ToList(); return(View(questions)); } } else { if (exam.ExamState == "open") { ExamAssign assign = context.ExamAssigns.SingleOrDefault(p => p.StudentID == (string)Session["Userid"] && p.Id == id); if (assign != null) { Answer ans = context.Answers.SingleOrDefault(p => p.ExamId == id && p.StudentId == Convert.ToString(Session["Userid"])); if (ans == null) { ViewBag.ExamId = id; ViewBag.Total = exam.TotalQues; var src = DateTime.Now; string hour = src.Hour.ToString(); string min = src.Minute.ToString(); string end = exam.FinishTime; char[] d = { ' ', ':' }; string[] words = end.Split(d, System.StringSplitOptions.RemoveEmptyEntries); string endHour = words[0]; string endMin = words[1]; ViewBag.duration = ((Convert.ToInt32(endHour) * 60 + Convert.ToInt32(endMin)) - (Convert.ToInt32(hour) * 60 + Convert.ToInt32(min))) * 60 * 1000; ViewBag.CountDown = exam.Date + " " + end + ":00"; List <Question> questions = context.Questions.Where(p => p.ExamID == id).ToList(); return(View(questions)); } else { return(RedirectToAction("Index", "Exam")); } } else { return(RedirectToAction("Index", "Exam")); } } else { return(RedirectToAction("Index", "Exam")); } } } // } //else //{ // return RedirectToAction("Index", "Exam"); //} }