public ActionResult UpdateStudentLessonTracking(int LessonId)
{
var UserId = User.Identity.GetUserId();
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == LessonId && x.StudentId == UserId).FirstOrDefault();
if (LessonTracking == null)
{
StudentLessonTracking lessonTracking = new StudentLessonTracking();
lessonTracking.LessonId = LessonId;
lessonTracking.IsCompleted = true;
TimeZone time2 = TimeZone.CurrentTimeZone;
DateTime test = time2.ToUniversalTime(DateTime.Now);
var pakistan = TimeZoneInfo.FindSystemTimeZoneById("Pakistan Standard Time");
DateTime pakistantime = TimeZoneInfo.ConvertTimeFromUtc(test, pakistan);
lessonTracking.StartDate = pakistantime;
lessonTracking.StudentId = User.Identity.GetUserId();
lessonTracking.Assignment_Status = "Pending";
db.StudentLessonTrackings.Add(lessonTracking);
db.SaveChanges();
}
return(Json("", JsonRequestBehavior.AllowGet));
}
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));
}
public ActionResult StudentAssignmentSubmission(int LessonID)
{
var IsSubmitted = "";
var UserId1 = User.Identity.GetUserId();
AspNetStudent Student = db.AspNetStudents.Where(x => x.StudentID == UserId1).FirstOrDefault();
AspnetStudentAssignmentSubmission StudentAssignmentSubmission = db.AspnetStudentAssignmentSubmissions.Where(x => x.LessonId == LessonID && x.StudentId == Student.Id).FirstOrDefault();
if (StudentAssignmentSubmission == null)
{
IsSubmitted = "Submit Assignment Successfully";
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.GenericSubjects.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;
int?ClassId = db.AspNetStudents.Where(x => x.StudentID == UserId).FirstOrDefault().ClassID;
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 = ClassId;
AssignmentSubmission.CourseType = Subject.SubjectType;
AssignmentSubmission.StudentId = StudentId;
AssignmentSubmission.AssignmentSubmittedDate = pakistantime;
AssignmentSubmission.AssignmentDueDate = AssignmentDueDate;
AssignmentSubmission.AssignmentFileName = fileName;
db.AspnetStudentAssignmentSubmissions.Add(AssignmentSubmission);
db.SaveChanges();
}
else
{
IsSubmitted = "Submit Assignment failed, you have already Submited Assignment";
}
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == LessonID && x.StudentId == UserId1).FirstOrDefault();
if (LessonTracking != null)
{
LessonTracking.Assignment_Status = "Submitted";
db.SaveChanges();
}
return(Json(IsSubmitted, JsonRequestBehavior.AllowGet));
}// Student Assignment Submission
public ActionResult GetCourseContent(int LessonID)
{
var UserId = User.Identity.GetUserId();
var TopicId = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault().TopicId;
var SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId;
var SubjectsTopics = db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId).ToList();
List <Topic> TopicListObj = new List <Topic>();
int Count = 0;
foreach (var a in SubjectsTopics)
{
int count1 = 0;
Topic TopicObj = new Topic();
//var list = db.AspnetLessons.Where(x => x.TopicId == a.Id).ToList();
var UserId1 = User.Identity.GetUserId();
var userSessionId = db.AspNetUsers_Session.Where(x => x.UserID == UserId1).FirstOrDefault().SessionID;
TopicObj.TopicId = a.Id;
TopicObj.TopicName = a.Name;
var today = DateTime.Today;
var LessonList = (from Lesson in db.AspnetLessons
join LessonSession in db.Lesson_Session on Lesson.Id equals LessonSession.LessonId
where Lesson.TopicId == a.Id && Lesson.IsActive == true && LessonSession.SessionId == userSessionId && LessonSession.StartDate <= today && today <= LessonSession.DueDate
select Lesson).ToList();
List <Lesson> LessonsList = new List <Lesson>();
foreach (var lesson in LessonList)
{
var LessonExist = "";
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == lesson.Id && x.StudentId == UserId).FirstOrDefault();
if (LessonTracking == null)
{
LessonExist = "No";
}
else
{
LessonExist = "Yes";
}
Lesson lessonobj = new Lesson();
lessonobj.LessonId = lesson.Id;
lessonobj.LessonName = lesson.Name;
lessonobj.LessonDuration = lesson.Duration;
lessonobj.LessonExistInTrackingTable = LessonExist;
LessonsList.Add(lessonobj);
Count++;
count1++;
}
List <Lesson> OrderByLessons = LessonsList.OrderBy(x => x.LessonName).ToList();
TopicObj.LessonList = OrderByLessons;
TopicObj.TotalLessons = Count;
TopicObj.TotalLessons1 = count1;
TopicListObj.Add(TopicObj);
}
// return Json(TopicListObj, JsonRequestBehavior.AllowGet);
return(Json(TopicListObj.OrderBy(x => x.TopicName).ToList(), JsonRequestBehavior.AllowGet));
}
public ActionResult GetSubjectTopicsAndLessons(int SubjectId)
{
try
{
var UserId = User.Identity.GetUserId();
var userSessionId = db.AspNetUsers_Session.Where(x => x.UserID == UserId).FirstOrDefault().SessionID;
// var SubjectTopics = db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId).ToList();
//var AllSubjectTopicsLessons = from SubjectTopic in db.AspnetSubjectTopics
// join Lesson in db.AspnetLessons on SubjectTopic.Id equals Lesson.TopicId
// where SubjectTopic.SubjectId == SubjectId
// select new
// {
// TopicId = SubjectTopic.Id,
// TopicName = SubjectTopic.Name,
// LessonId = Lesson.Id,
// LessonName = Lesson.Name,
// Lesson.Duration,
// Lesson.Description
// };
var SubjectsTopics = db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId).ToList();
List <Topic> TopicListObj = new List <Topic>();
int Count = 0;
foreach (var a in SubjectsTopics)
{
int count1 = 0;
Topic TopicObj = new Topic();
// var list = db.AspnetLessons.Where(x => x.TopicId == a.Id).Where(x=>x.IsActive== true).ToList();
var today = DateTime.Today;
var LessonList = (from Lesson in db.AspnetLessons
join LessonSession in db.Lesson_Session on Lesson.Id equals LessonSession.LessonId
where Lesson.TopicId == a.Id && Lesson.IsActive == true && LessonSession.SessionId == userSessionId && LessonSession.StartDate <= today && today <= LessonSession.DueDate
select Lesson).ToList();
TopicObj.TopicId = a.Id;
TopicObj.TopicName = a.Name;
List <Lesson> LessonsList = new List <Lesson>();
foreach (var lesson in LessonList)
{
var LessonExist = "";
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == lesson.Id & x.StudentId == UserId).FirstOrDefault();
if (LessonTracking == null)
{
LessonExist = "No";
}
else
{
LessonExist = "Yes";
}
Lesson lessonobj = new Lesson();
lessonobj.LessonId = lesson.Id;
lessonobj.LessonName = lesson.Name;
lessonobj.LessonDuration = lesson.Duration;
lessonobj.LessonExistInTrackingTable = LessonExist;
lessonobj.EncryptedID = lesson.EncryptedID;
LessonsList.Add(lessonobj);
Count++;
count1++;
}
List <Lesson> OrderByLessons = LessonsList.OrderBy(x => x.LessonName).ToList();
TopicObj.LessonList = OrderByLessons;
TopicObj.TotalLessons = Count;
TopicObj.TotalLessons1 = count1;
TopicListObj.Add(TopicObj);
}
return(Json(TopicListObj.OrderBy(x => x.TopicName).ToList(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var a = ex.Message;
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult GetCourseContent(int LessonID)
{
var UserId = User.Identity.GetUserId();
var TopicId = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault().TopicId;
var SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId;
var SubjectsTopics = db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId).ToList();
List <Topic> TopicListObj = new List <Topic>();
int Count = 0;
foreach (var a in SubjectsTopics)
{
int count1 = 0;
Topic TopicObj = new Topic();
var list = db.AspnetLessons.Where(x => x.TopicId == a.Id).ToList();
TopicObj.TopicId = a.Id;
TopicObj.TopicName = a.Name;
List <Lesson> LessonsList = new List <Lesson>();
foreach (var lesson in list)
{
var LessonExist = "";
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == lesson.Id && x.StudentId == UserId).FirstOrDefault();
if (LessonTracking == null)
{
LessonExist = "No";
}
else
{
LessonExist = "Yes";
}
Lesson lessonobj = new Lesson();
lessonobj.LessonId = lesson.Id;
lessonobj.LessonName = lesson.Name;
lessonobj.LessonDuration = lesson.Duration;
lessonobj.LessonExistInTrackingTable = LessonExist;
LessonsList.Add(lessonobj);
Count++;
count1++;
}
List <Lesson> OrderByLessons = LessonsList.OrderBy(x => x.LessonName).ToList();
TopicObj.LessonList = OrderByLessons;
TopicObj.TotalLessons = Count;
TopicObj.TotalLessons1 = count1;
TopicListObj.Add(TopicObj);
}
// return Json(TopicListObj, JsonRequestBehavior.AllowGet);
return(Json(TopicListObj.OrderBy(x => x.TopicName).ToList(), JsonRequestBehavior.AllowGet));
}
public ActionResult GetSubjectTopicsAndLessons(int SubjectId)
{
// var SubjectTopics = db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId).ToList();
//var AllSubjectTopicsLessons = from SubjectTopic in db.AspnetSubjectTopics
// join Lesson in db.AspnetLessons on SubjectTopic.Id equals Lesson.TopicId
// where SubjectTopic.SubjectId == SubjectId
// select new
// {
// TopicId = SubjectTopic.Id,
// TopicName = SubjectTopic.Name,
// LessonId = Lesson.Id,
// LessonName = Lesson.Name,
// Lesson.Duration,
// Lesson.Description
// };
var SubjectsTopics = db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId).ToList();
var UserId = User.Identity.GetUserId();
List <Topic> TopicListObj = new List <Topic>();
int Count = 0;
foreach (var a in SubjectsTopics)
{
int count1 = 0;
Topic TopicObj = new Topic();
var list = db.AspnetLessons.Where(x => x.TopicId == a.Id).ToList();
TopicObj.TopicId = a.Id;
TopicObj.TopicName = a.Name;
List <Lesson> LessonsList = new List <Lesson>();
foreach (var lesson in list)
{
var LessonExist = "";
StudentLessonTracking LessonTracking = db.StudentLessonTrackings.Where(x => x.LessonId == lesson.Id & x.StudentId == UserId).FirstOrDefault();
if (LessonTracking == null)
{
LessonExist = "No";
}
else
{
LessonExist = "Yes";
}
Lesson lessonobj = new Lesson();
lessonobj.LessonId = lesson.Id;
lessonobj.LessonName = lesson.Name;
lessonobj.LessonDuration = lesson.Duration;
lessonobj.LessonExistInTrackingTable = LessonExist;
LessonsList.Add(lessonobj);
Count++;
count1++;
}
List <Lesson> OrderByLessons = LessonsList.OrderBy(x => x.LessonName).ToList();
TopicObj.LessonList = OrderByLessons;
TopicObj.TotalLessons = Count;
TopicObj.TotalLessons1 = count1;
TopicListObj.Add(TopicObj);
}
return(Json(TopicListObj.OrderBy(x => x.TopicName).ToList(), JsonRequestBehavior.AllowGet));
}