public AccountController(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
ForSchoolsDBContext context,
IEmailSender emailSender,
ILogger <AccountController> logger)
{
_userManager = userManager;
_signInManager = signInManager;
_context = context;
_emailSender = emailSender;
_logger = logger;
}
public ResultViewModel(ForSchoolsDBContext context, int ClassID, int SubjectID, int SessionTermID)
{
_context = context;
TotalGrade = new List <TotalGrade>();
Exam = _context.Exam.Where(e => e.ClassId == ClassID && e.SubjectId == SubjectID && e.SessionTermId == SessionTermID);
PsycomotResult = _context.PsycomotResult.Where(a => a.ClassId == ClassID && a.SessionTermId == SessionTermID);
CEResult = _context.CeResult.Where(b => b.ClassId == ClassID && b.SubjectId == SubjectID && b.SessionTermId == SessionTermID);
AssignmentResult = _context.AssignmentResult.Where(c => c.ClassId == ClassID && c.SubjectId == SubjectID && c.SessionTermId == SessionTermID);
AffectiveResult = _context.AffectiveResult.Where(d => d.ClassId == ClassID && d.SessionTermId == SessionTermID);
CAResult = _context.CaResult.Where(f => f.ClassId == ClassID && f.SubjectId == SubjectID && f.SessionTermId == SessionTermID);
Students = _context.SCSt.Include(y => y.Student).Where(z => z.ClassId == ClassID && z.SessionTermId == SessionTermID).Select(p => p.Student);
IEnumerable <Grade> grade = _context.Grade.Where(v => v.SchoolId == _context.Class.Find(ClassID).SchoolId);
foreach (var student in Students)
{
TotalGrade tg = new TotalGrade
{
StudentId = student.Id,
Total = (Exam.FirstOrDefault(a => a.StudentId == student.Id).Score +
CAResult.FirstOrDefault(a => a.StudentId == student.Id).FirstCa +
CAResult.FirstOrDefault(a => a.StudentId == student.Id).SecondCa +
CAResult.FirstOrDefault(a => a.StudentId == student.Id).ThirdCa +
CAResult.FirstOrDefault(a => a.StudentId == student.Id).FourthCa +
CAResult.FirstOrDefault(a => a.StudentId == student.Id).FifthCa +
AssignmentResult.FirstOrDefault(a => a.StudentId == student.Id).Assignment1 +
AssignmentResult.FirstOrDefault(a => a.StudentId == student.Id).Assignment2 +
AssignmentResult.FirstOrDefault(a => a.StudentId == student.Id).Assignment3 +
AssignmentResult.FirstOrDefault(a => a.StudentId == student.Id).Assignment4 +
AssignmentResult.FirstOrDefault(a => a.StudentId == student.Id).Assignment5 +
CEResult.FirstOrDefault(a => a.StudentId == student.Id).ClassExercise1 +
CEResult.FirstOrDefault(a => a.StudentId == student.Id).ClassExercise2 +
CEResult.FirstOrDefault(a => a.StudentId == student.Id).ClassExercise3 +
CEResult.FirstOrDefault(a => a.StudentId == student.Id).ClassExercise4 +
CEResult.FirstOrDefault(a => a.StudentId == student.Id).ClassExercise5)
};
tg.Grade = grade.FirstOrDefault(u => u.UpperLimit >= tg.Total && u.LowerLimit <= tg.Total).Name;
TotalGrade.Add(tg);
}
}
public StudentsController(ForSchoolsDBContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public SessionCRUD(ForSchoolsDBContext context)
{
_context = context;
}
//For Current SessionTerm
public UploadResult(ForSchoolsDBContext context, int classID, int institutionID)
{
_context = context;
//int sessionID = db.Sessions.FirstOrDefault(u => u.Status == true).ID;
//int termID = db.Terms.FirstOrDefault(d => d.Status == true && d.InstitutionID == institutionID).ID;
//SessionAndTerm SAT = new SessionAndTerm();
//int sessionTermID = db.SessionTerms.FirstOrDefault(v => v.SessionID == sessionID && v.TermID == termID && v.InstitutionID == institutionID).ID;
var students = _context.Student.Where(w => w.ClassId == classID);
URVM = new List <UploadResultViewModel>();
Columns = new List <string> {
"StudentId", "Name", "Exam"
};
foreach (var student in students)
{
UploadResultViewModel model = new UploadResultViewModel
{
StudentId = String.Format("{0}/STUD/{1}", _context.Institution.Find(institutionID).ShortName, student.Id),
Name = student.LastName + student.FirstName + student.OtherNames
};
URVM.Add(model);
}
int ca = (_context.ResultType.FirstOrDefault(c => c.SchoolId == 1 && c.AssessmentTypeId == 1).NoOfItems) ?? 0;
int ass = (_context.ResultType.FirstOrDefault(c => c.SchoolId == 1 && c.AssessmentTypeId == 2).NoOfItems) ?? 0;
int ce = (_context.ResultType.FirstOrDefault(c => c.SchoolId == 1 && c.AssessmentTypeId == 3).NoOfItems) ?? 0;
if (ca != 0 && ca < 6)
{
switch (ca)
{
case 1: Columns.Add("FirstCa"); break;
case 2: Columns.AddRange(new List <string> {
"FirstCa", "SecondCa"
}); break;
case 3: Columns.AddRange(new List <string> {
"FirstCa", "SecondCa", "ThirdCa"
}); break;
case 4: Columns.AddRange(new List <string> {
"FirstCa", "SecondCa", "ThirdCa", "FourthCa"
}); break;
default: Columns.AddRange(new List <string> {
"FirstCa", "SecondCa", "ThirdCa", "FourthCa", "FifthCa"
}); break;
}
}
if (ass != 0 && ass < 6)
{
switch (ass)
{
case 1: Columns.Add("Assignment1"); break;
case 2: Columns.AddRange(new List <string> {
"Assignment1", "Assignment2"
}); break;
case 3: Columns.AddRange(new List <string> {
"Assignment1", "Assignment2", "Assignment3"
}); break;
case 4: Columns.AddRange(new List <string> {
"Assignment1", "Assignment2", "Assignment3", "Assignment4"
}); break;
default: Columns.AddRange(new List <string> {
"Assignment1", "Assignment2", "Assignment3", "Assignment4", "Assignment5"
}); break;
}
}
if (ce != 0 && ce < 6)
{
switch (ce)
{
case 1: Columns.Add("ClassExercise1"); break;
case 2: Columns.AddRange(new List <string> {
"ClassExercise1", "ClassExercise2"
}); break;
case 3: Columns.AddRange(new List <string> {
"ClassExercise1", "ClassExercise2", "ClassExercise3"
}); break;
case 4: Columns.AddRange(new List <string> {
"ClassExercise1", "ClassExercise2", "ClassExercise3", "ClassExercise4"
}); break;
default: Columns.AddRange(new List <string> {
"ClassExercise1", "ClassExercise2", "ClassExercise3", "ClassExercise4", "ClassExercise5"
}); break;
}
}
}
public SessionsController(ForSchoolsDBContext context)
{
_context = context;
}
public UserExcelExportHelper(ForSchoolsDBContext context)
{
_context = context;
}
public SessionAndTerm(ForSchoolsDBContext context)
{
_context = context;
}
public ResultTypeGradeViewModel(ForSchoolsDBContext context)
{
_context = context;
Grades = _context.Grade.ToList();
ResultTypes = _context.ResultType.ToList();
}
public ResultTypesController(ForSchoolsDBContext context, UserManager<ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public ResultViewModel(ForSchoolsDBContext context, int ClassID, int SessionTermID)
{
_context = context;
TotalGrade = new List <TotalGrade>();
S_C_ST = _context.SCSt.Where(z => z.ClassId == ClassID && z.SessionTermId == SessionTermID);
Students = _context.SCSt.Include(y => y.Student).Where(z => z.ClassId == ClassID && z.SessionTermId == SessionTermID).Select(p => p.Student);
Exam = _context.Exam.Where(e => e.ClassId == ClassID && e.SessionTermId == SessionTermID);
PsycomotResult = _context.PsycomotResult.Where(a => a.ClassId == ClassID && a.SessionTermId == SessionTermID);
CEResult = _context.CeResult.Where(b => b.ClassId == ClassID && b.SessionTermId == SessionTermID);
AssignmentResult = _context.AssignmentResult.Where(c => c.ClassId == ClassID && c.SessionTermId == SessionTermID);
AffectiveResult = _context.AffectiveResult.Where(d => d.ClassId == ClassID && d.SessionTermId == SessionTermID);
CAResult = _context.CaResult.Where(f => f.ClassId == ClassID && f.SessionTermId == SessionTermID);
foreach (var student in Students)
{
TotalGrade tg = new TotalGrade
{
StudentId = student.Id,
NoOfSubjects = _context.Exam.Where(k => k.StudentId == student.Id && k.SessionTermId == SessionTermID && k.Score != null).Count()
};
IEnumerable <Subject> subjects = _context.Exam.Include(q => q.Subject).Where(k => k.StudentId == student.Id && k.SessionTermId == SessionTermID && k.Score != null).Select(g => g.Subject);
Exam = Exam.Where(e => e.StudentId == student.Id);
PsycomotResult = PsycomotResult.Where(a => a.StudentId == student.Id);
CEResult = CEResult.Where(b => b.StudentId == student.Id);
AssignmentResult = AssignmentResult.Where(c => c.StudentId == student.Id);
AffectiveResult = AffectiveResult.Where(d => d.StudentId == student.Id);
CAResult = CAResult.Where(f => f.StudentId == student.Id);
foreach (var subject in subjects)
{
tg.Total = tg.Total + (Exam.FirstOrDefault(a => a.SubjectId == subject.Id).Score +
CAResult.FirstOrDefault(a => a.SubjectId == subject.Id).FirstCa +
CAResult.FirstOrDefault(a => a.SubjectId == subject.Id).SecondCa +
CAResult.FirstOrDefault(a => a.SubjectId == subject.Id).ThirdCa +
CAResult.FirstOrDefault(a => a.SubjectId == subject.Id).FourthCa +
CAResult.FirstOrDefault(a => a.SubjectId == subject.Id).FifthCa +
AssignmentResult.FirstOrDefault(a => a.SubjectId == subject.Id).Assignment1 +
AssignmentResult.FirstOrDefault(a => a.SubjectId == subject.Id).Assignment2 +
AssignmentResult.FirstOrDefault(a => a.SubjectId == subject.Id).Assignment3 +
AssignmentResult.FirstOrDefault(a => a.SubjectId == subject.Id).Assignment4 +
AssignmentResult.FirstOrDefault(a => a.SubjectId == subject.Id).Assignment5 +
CEResult.FirstOrDefault(a => a.SubjectId == subject.Id).ClassExercise1 +
CEResult.FirstOrDefault(a => a.SubjectId == subject.Id).ClassExercise2 +
CEResult.FirstOrDefault(a => a.SubjectId == subject.Id).ClassExercise3 +
CEResult.FirstOrDefault(a => a.SubjectId == subject.Id).ClassExercise4 +
CEResult.FirstOrDefault(a => a.SubjectId == subject.Id).ClassExercise5);
}
if (tg.NoOfSubjects == 0)
{
tg.Average = 0;
}
else
{
tg.Average = tg.Total / tg.NoOfSubjects;
}
Avg = Avg + tg.Average;
TotalGrade.Add(tg);
}
if (Students.Count() == 0)
{
Avg = 0;
}
else
{
Avg = Avg / Students.Count();
}
}
public ResultViewModel(ForSchoolsDBContext context)
{
_context = context;
}
