public FileResult downloadAssessmentFile(int id) { AspNetAssessment Assessment = db.AspNetAssessments.Find(id); var filepath = System.IO.Path.Combine(Server.MapPath("~/App_Data/Assessments/"), Assessment.FileName); return(File(filepath, MimeMapping.GetMimeMapping(filepath), Assessment.FileName)); }
public ActionResult DeleteConfirmed(int id) { AspNetAssessment aspNetAssessment = db.AspNetAssessments.Find(id); db.AspNetAssessments.Remove(aspNetAssessment); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: AspNetAssessment/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetAssessment aspNetAssessment = db.AspNetAssessments.Find(id); if (aspNetAssessment == null) { return(HttpNotFound()); } return(View(aspNetAssessment)); }
public ActionResult Edit([Bind(Include = "Id,Subject_CatalogID,Title,Description,PublishDate,DueDate,TotalMarks,Weightage,FileName,AcceptSubmission")] AspNetAssessment aspNetAssessment) { if (ModelState.IsValid) { db.Entry(aspNetAssessment).State = EntityState.Modified; 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)); }
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)); }
// GET: AspNetAssessment/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetAssessment aspNetAssessment = db.AspNetAssessments.Find(id); if (aspNetAssessment == null) { return(HttpNotFound()); } 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)); }