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));
}
