public void ApproveTeacher(string username) { using (XorHubEntities db = new XorHubEntities()) { db.LoginInfoes.Where(l => l.Username.Equals(username)).FirstOrDefault().Stat = true; db.SaveChanges(); } }
public ActionResult Reject(Solution sol) { using (XorHubEntities db = new XorHubEntities()) { var soln = db.Solutions.Where(s => s.SolutionId == sol.SolutionId).FirstOrDefault(); soln.Stat = "R"; soln.Comment = sol.Comment; db.SaveChanges(); } return(RedirectToAction("TeacherResponse", new { id = sol.AssignmentId })); }
public ActionResult Register(int BatchId, LoginInfo model) { using (XorHubEntities db = new XorHubEntities()) { List <SelectListItem> list = new List <SelectListItem>(); foreach (var item in db.Batches) { list.Add(new SelectListItem { Text = item.Name, Value = item.BatchId.ToString() }); } ViewData["BatchList"] = list; } if (ModelState["Name"].Errors.Count > 0 || ModelState["Username"].Errors.Count > 0 || ModelState["Passwd"].Errors.Count > 0) { return(View("Index", model)); } if (model.Usertype.Equals("T")) { model.BatchId = null; model.Stat = false; } else { model.Stat = true; } using (XorHubEntities db = new XorHubEntities()) { db.LoginInfoes.Add(model); db.SaveChanges(); } ViewBag.Message = "User Registered Successfully!! "; ModelState.Clear(); return(View("Index")); }
public ActionResult PostQuestion(HttpPostedFileBase QueFile, Assignment assignment) { assignment.PostedDate = DateTime.Now; if (assignment.Deadline < assignment.PostedDate) { return(RedirectToAction("Teacher", "Home", new { id = 4 })); } assignment.TeacherName = Session["username"].ToString(); if (!Directory.Exists(Server.MapPath("~/Database/Questions/"))) { Directory.CreateDirectory(Server.MapPath("~/Database/Questions/")); } using (XorHubEntities db = new XorHubEntities()) { db.Assignments.Add(assignment); db.SaveChanges(); } try { QueFile.SaveAs(Path.Combine(Server.MapPath("~/Database/Questions"), assignment.AssignmentId.ToString() + ".pdf")); } catch (Exception ex) { return(RedirectToAction("Teacher", "Home", new { id = 1 })); } ViewBag.Message = "Question Successfully uploaded!"; return(RedirectToAction("Teacher", "Home")); }
public ActionResult Submit(HttpPostedFileBase solutionDoc, AssignmentSolutionModel asModel) { if (asModel.Assignment.Deadline < DateTime.Now) { ViewBag.Message = "Deadline crossed! Cannot Submit Solution"; ViewBag.filePath = "~/Database/Questions/" + asModel.Assignment.AssignmentId + ".pdf"; return(View("StudentResponse", asModel)); } if (!Directory.Exists(Server.MapPath("~/Database/Solutions/" + Session["username"].ToString()))) { Directory.CreateDirectory(Server.MapPath("~/Database/Solutions/" + Session["username"].ToString())); } try { solutionDoc.SaveAs(Path.Combine(Server.MapPath("~/Database/Solutions/" + Session["username"].ToString() + "/"), asModel.Assignment.AssignmentId + ".pdf")); } catch (Exception ex) { ViewBag.Message = "Please Select File!"; ViewBag.filePath = "~/Database/Questions/" + asModel.Assignment.AssignmentId + ".pdf"; return(View("StudentResponse", asModel)); } Solution soln = new Solution() { AssignmentId = asModel.Assignment.AssignmentId, Username = Session["username"].ToString(), Stat = "P", UploadedOn = DateTime.Now, Document = asModel.Assignment.AssignmentId + ".pdf", Comment = "" }; using (XorHubEntities db = new XorHubEntities()) { try { string userName = Session["username"].ToString(); if (db.Solutions.Any(s => s.Username.Equals(userName) && s.AssignmentId == asModel.Assignment.AssignmentId)) { var tmp = db.Solutions.Where(s => s.Username.Equals(userName) && s.AssignmentId == asModel.Assignment.AssignmentId).FirstOrDefault(); tmp = soln; db.SaveChanges(); } else { db.Solutions.Add(soln); db.SaveChanges(); } } catch (DbEntityValidationException e) { } } return(RedirectToRoute(new { Controller = "Home", Action = "Student", id = 3 } )); }