public ActionResult Student_Assessment_Submission(AspNetStudent_Assessment stu_assessment) { int id = Convert.ToInt32(Request.Form["id"]); AspNetStudent_Assessment result = (from p in db.AspNetStudent_Assessment where p.Id == id select p).SingleOrDefault(); var dbTransaction = db.Database.BeginTransaction(); try { HttpPostedFileBase file = Request.Files["document"]; if (ModelState.IsValid) { if (file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/AssessmentSubmission"), fileName); file.SaveAs(path); result.SubmittedFileName = fileName; } } result.SubmissionStatus = true; result.SubmissionDate = DateTime.Now; db.SaveChanges(); dbTransaction.Commit(); } catch (Exception) { dbTransaction.Dispose(); } return(RedirectToAction("Assessment_Detail", new { id = result.AssessmentID })); }
public void SaveAssessmentMarks(List <Marks> marks) { var dbContextTransaction = db.Database.BeginTransaction(); int errorItem = 0; try { foreach (var item in marks) { errorItem = item.Id; AspNetStudent_Assessment student_assessment = new AspNetStudent_Assessment(); student_assessment.Id = item.Id; student_assessment.MarksGot = item.GotMark; var check = db.AspNetStudent_Assessment.Any(x => x.Id == student_assessment.Id); if (check) { AspNetStudent_Assessment student_assess = (from x in db.AspNetStudent_Assessment where x.Id == student_assessment.Id select x).First(); student_assess.MarksGot = student_assessment.MarksGot; } db.SaveChanges(); } dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Dispose(); } }
public FileResult downloadStudentSubmittedFile(int id) { AspNetStudent_Assessment Student_Assessment = db.AspNetStudent_Assessment.Find(id); var filepath = System.IO.Path.Combine(Server.MapPath("~/App_Data/AssessmentSubmission/"), Student_Assessment.SubmittedFileName); return(File(filepath, MimeMapping.GetMimeMapping(filepath), Student_Assessment.SubmittedFileName)); }
public ActionResult Assessment_Detail(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetStudent_Assessment aspNetStudentAssessment = db.AspNetStudent_Assessment.Where(x => x.AssessmentID == id && x.StudentID == StudentID).FirstOrDefault(); if (aspNetStudentAssessment == null) { return(HttpNotFound()); } return(View(aspNetStudentAssessment)); }
public ActionResult Create(AspNetAssessment aspNetAssessment) { HttpPostedFileBase file = Request.Files["attachment"]; if (ModelState.IsValid) { if (file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/Assessments"), fileName); file.SaveAs(path); aspNetAssessment.FileName = fileName; } else { aspNetAssessment.FileName = "-/-"; } db.AspNetAssessments.Add(aspNetAssessment); db.SaveChanges(); int AssessmentID = db.AspNetAssessments.Max(x => x.Id); int subjectID = Convert.ToInt32(db.AspNetSubject_Catalog.Where(x => x.Id == aspNetAssessment.Subject_CatalogID).Select(x => x.SubjectID).FirstOrDefault()); List <string> StudentIDs = db.AspNetStudent_Subject.Where(s => s.SubjectID == subjectID).Select(s => s.StudentID).ToList(); foreach (var item in StudentIDs) { AspNetStudent_Assessment student_assessment = new AspNetStudent_Assessment(); student_assessment.StudentID = item; student_assessment.AssessmentID = AssessmentID; student_assessment.MarksGot = -1; student_assessment.SubmissionStatus = false; student_assessment.SubmittedFileName = "-/-"; db.AspNetStudent_Assessment.Add(student_assessment); db.SaveChanges(); } return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName"); ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName"); ViewBag.Subject_CatalogID = new SelectList(from catalog in db.AspNetCatalogs join subject_catalog in db.AspNetSubject_Catalog on catalog.Id equals subject_catalog.CatalogID select new { catalog.CatalogName, subject_catalog.Id }, "Id", "CatalogName"); return(View(aspNetAssessment)); }