public ActionResult DownloadFileOfAssignment(int id)
{
AspnetStudentAssignmentSubmission studentAssignment = db.AspnetStudentAssignmentSubmissions.Find(id);
var filepath = System.IO.Path.Combine(Server.MapPath("~/Content/StudentAssignments/"), studentAssignment.AssignmentFileName);
return(File(filepath, MimeMapping.GetMimeMapping(filepath), studentAssignment.AssignmentFileName));
}
public ActionResult StudentAssignmentSubmission(int LessonID)
{
var File = Request.Files["file"];
var fileName = "";
if (File.ContentLength > 0)
{
fileName = Path.GetFileName(File.FileName);
File.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName);
}
AspnetStudentAssignmentSubmission AssignmentSubmission = new AspnetStudentAssignmentSubmission();
int?TopicId = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault().TopicId;
int?SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId;
// db.AspnetSubjectTopics.Where(x => x.Id == LessonID);
var Subject = db.AspNetSubjects.Where(x => x.Id == SubjectId).FirstOrDefault();
var id = User.Identity.GetUserId();
var UserId = db.AspNetUsers.Where(x => x.Id == id).FirstOrDefault().Id;
int StudentId = db.AspNetStudents.Where(x => x.StudentID == UserId).FirstOrDefault().Id;
var AssignmentDueDate = db.AspnetStudentAssignments.Where(x => x.LessonId == LessonID).FirstOrDefault().DueDate;
TimeZone time2 = TimeZone.CurrentTimeZone;
DateTime test = time2.ToUniversalTime(DateTime.Now);
var pakistan = TimeZoneInfo.FindSystemTimeZoneById("Pakistan Standard Time");
DateTime pakistantime = TimeZoneInfo.ConvertTimeFromUtc(test, pakistan);
AssignmentSubmission.LessonId = LessonID;
AssignmentSubmission.TopicId = TopicId;
AssignmentSubmission.SubjectId = SubjectId;
AssignmentSubmission.ClassId = Subject.ClassID;
AssignmentSubmission.CourseType = Subject.CourseType;
AssignmentSubmission.StudentId = StudentId;
AssignmentSubmission.AssignmentSubmittedDate = pakistantime;
AssignmentSubmission.AssignmentDueDate = AssignmentDueDate;
AssignmentSubmission.AssignmentFileName = fileName;
db.AspnetStudentAssignmentSubmissions.Add(AssignmentSubmission);
db.SaveChanges();
return(Json("Submitted Successfully", JsonRequestBehavior.AllowGet));
}// Student Assignment Submission
public ActionResult TeacherComments(int id)
{
ViewBag.Id = id;
AspnetStudentAssignmentSubmission StudentAssignmentSubmission = db.AspnetStudentAssignmentSubmissions.Where(x => x.Id == id).FirstOrDefault();
if (StudentAssignmentSubmission != null)
{
ViewBag.TeacherComments = StudentAssignmentSubmission.TeacherComments;
}
else
{
ViewBag.TeacherComments = null;
}
return(View());
}
public ActionResult TeacherCommentsMethod(int id, string TeacherComments)
{
AspnetStudentAssignmentSubmission assignmentSubmission = db.AspnetStudentAssignmentSubmissions.Where(x => x.Id == id).FirstOrDefault();
assignmentSubmission.TeacherComments = TeacherComments;
db.SaveChanges();
int?LessonId = assignmentSubmission.LessonId;
int?StudentId = assignmentSubmission.StudentId;
var StudentIdInString = db.AspNetStudents.Where(x => x.Id == StudentId).FirstOrDefault().StudentID;
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == LessonId && x.StudentId == StudentIdInString).FirstOrDefault();
if (LessonTracking != null)
{
LessonTracking.Assignment_Status = "Approved";
db.SaveChanges();
}
return(Json("", JsonRequestBehavior.AllowGet));
}
