public Info GetInfo(int studentId)
{
var db = new DBModel();
Info myInfo = new Info
{
best = new List <LessonDTO>(),
worst = new List <LessonDTO>()
};
try
{
myInfo.lessonsCompleted = StatisticsController.LessonsCompleted(studentId);
myInfo.qCorrAnswered = StatisticsController.QCorrAnswered(studentId);
var query = from rl in db.ResultInLessons
where rl.StudentId == studentId
join l in db.Lessons on rl.LessonId equals l.Id
group rl by new
{
l.Id,
l.Category,
l.Name
} into lessonRes
select new LessonDTO
{
Id = lessonRes.Key.Id,
Category = lessonRes.Key.Category,
Name = lessonRes.Key.Name,
Result = lessonRes.Max(x => x.Result)
};
myInfo.best = query.OrderByDescending(x => x.Result).Take(3).ToList();
var query2 = from rl in db.ResultInLessons
where rl.StudentId == studentId
join l in db.Lessons on rl.LessonId equals l.Id
group rl by new
{
l.Id,
l.Category,
l.Name
} into lessonRes
select new LessonDTO
{
Id = lessonRes.Key.Id,
Category = lessonRes.Key.Category,
Name = lessonRes.Key.Name,
Result = lessonRes.Min(x => x.Result)
};
myInfo.worst = query2.OrderBy(x => x.Result).Take(3).ToList();
return(myInfo);
}
catch (Exception ex)
{
throw ex;
};
}
public StudentProfile StudentProfilePage(string userName)
{
try
{
LoginController.checkOnAccess(this.Request.Headers);
}
catch (Exception ex)
{
throw ex;
};
StudentProfile profile = new StudentProfile
{
sCourses = new List <SCourses>(),
sClasses = new List <SClasses>(),
Badges = new bool[] { false, false, false, false, false, false, false, false, false }
};
int studentId = LoginController.GetUserID(userName, "student");
var db = new DBModel();
try
{
//Courses tab
var query = from sc in db.StudentsToClasses
where sc.StudentId == studentId
join c in db.ClassGroups on sc.ClassId equals c.Id
select c;
foreach (var item in query)
{
profile.sCourses.Add(new SCourses
{
CourseId = item.Id,
Category = item.Category,
Grade = item.Grade
});
}
;
var query2 = from sc in db.StudentsToClasses
join c in db.ClassGroups on sc.ClassId equals c.Id
join pc in db.ProgressInClasses on c.Id equals pc.ClassId
where sc.StudentId == studentId && pc.StudentId == studentId
orderby c.Grade descending, pc.Result
select pc;
foreach (var item in query2)
{
foreach (var item2 in profile.sCourses)
{
if (item.ClassId == item2.CourseId)
{
item2.Result = item.Result;
break;
}
;
}
;
}
;
//Clases and assignments tab
var query3 = from sc in db.StudentsToClasses
join lc in db.LessonsToClasses on sc.ClassId equals lc.ClassId
where sc.StudentId == studentId && lc.IsActive == true
join l in db.Lessons on lc.LessonId equals l.Id
orderby l.SeqNum descending
select new { lc, l };
foreach (var item in query3.ToList())
{
var query4 = from rl in db.ResultInLessons
where rl.StudentId == studentId && rl.LessonId == item.l.Id
orderby rl.Result descending
select rl.Result;
profile.sClasses.Add(new SClasses
{
CourseId = item.lc.ClassId,
Category = item.l.Category,
LessonNum = item.l.SeqNum,
Name = item.l.Name,
Description = item.l.Description,
Attempts = query4.Count(),
BestRes = query4.FirstOrDefault()
});
}
;
profile.sClasses.OrderByDescending(x => x.LessonNum).OrderBy(y => y.Attempts);
//Achievements tab
profile.qCorrAnswered = StatisticsController.QCorrAnswered(studentId);
profile.lessonsCompleted = StatisticsController.LessonsCompleted(studentId);
var query5 = from pc in db.ProgressInClasses
where pc.StudentId == studentId && pc.Result != 0
orderby pc.Result descending
select pc;
//If a record for the student in the class exists
if (query5.Any())
{
profile.avgCourseRes = query5.Average(x => x.Result);
profile.bestCourseRes = query5.First().Result;
}
//If no previous record exists
else
{
profile.avgCourseRes = profile.bestCourseRes = 0;
};
profile.Picture = (from u in db.Users
where u.UserName == userName
select u.Picture).First();
//Badges
//---1
var tempQuery = (from rq in db.ResultInQuestions
where rq.StudentId == studentId && rq.Result
group rq by new
{
rq.LessonId,
rq.QuestionNum
} into question
select question).Count();
profile.Badges[0] = (tempQuery >= QUESTIONS_CORRECT_ANSWER) ? true : false;
//--2
var tempQuery2 = from rl in db.ResultInLessons
where rl.StudentId == studentId
join lc in db.LessonsToClasses on rl.LessonId equals lc.LessonId
join c in db.ClassGroups on lc.ClassId equals c.Id
where c.Category == "Math"
group rl by rl.LessonId into lesRes
select lesRes;
if (tempQuery2.Count() == NUM_OF_LESSONS_IN_CLASS)
{
foreach (var les in tempQuery2)
{
profile.Badges[1] = (les.Max(x => x.Result) >= StudyController.MIN_RES_TO_PASS) ? true : false;
}
;
}
;
//--3
tempQuery2 = from rl in db.ResultInLessons
where rl.StudentId == studentId
join lc in db.LessonsToClasses on rl.LessonId equals lc.LessonId
join c in db.ClassGroups on lc.ClassId equals c.Id
where c.Category == "Science"
group rl by rl.LessonId into lesRes
select lesRes;
if (tempQuery2.Count() == NUM_OF_LESSONS_IN_CLASS)
{
foreach (var les in tempQuery2)
{
profile.Badges[2] = (les.Max(x => x.Result) >= StudyController.MIN_RES_TO_PASS) ? true : false;
}
;
}
;
//--4,5,6,9
profile.Badges[3] = profile.Badges[4] = profile.Badges[5] = profile.Badges[8] = false;
//--7
var tempQuery3 = from rl in db.ResultInLessons
where rl.StudentId == studentId
join lc in db.LessonsToClasses on rl.LessonId equals lc.LessonId
group new { lc, rl } by lc.ClassId into classRes
select classRes;
foreach (var classR in tempQuery3)
{
if (classR.Min(x => x.rl.Result) >= StudyController.MIN_RES_TO_PASS && classR.Select(x => x.lc.LessonId).Distinct().Count() == NUM_OF_LESSONS_IN_CLASS)
{
profile.Badges[6] = true;
break;
}
;
}
;
//--8
var tempQuery4 = from rl in db.ResultInLessons
where rl.StudentId == studentId
join lc in db.LessonsToClasses on rl.LessonId equals lc.LessonId
group new { lc, rl } by lc.ClassId into classRes
select classRes;
int temp = 0;
foreach (var classR in tempQuery4)
{
if (classR.Average(x => x.rl.Result) == MAX_RES && classR.Select(x => x.lc.LessonId).Distinct().Count() == NUM_OF_LESSONS_IN_CLASS)
{
temp++;
}
;
}
;
if (temp >= BADGE_8_REQ)
{
profile.Badges[7] = true;
}
;
}
catch (Exception ex)
{
throw ex;
};
return(profile);
}