public ActionResult <StudentFinalGradeListModel> GetAllStudentFinalGradeList(StudentFinalGradeListModel studentFinalGradeListModel) { StudentFinalGradeListModel studentFinalGradeList = new StudentFinalGradeListModel(); try { studentFinalGradeList = _inputFinalGradeService.GetAllStudentFinalGradeList(studentFinalGradeListModel); } catch (Exception ex) { studentFinalGradeList._message = ex.Message; studentFinalGradeList._failure = true; } return(studentFinalGradeList); }
public ActionResult <StudentFinalGradeListModel> AddUpdateStudentFinalGrade(StudentFinalGradeListModel studentFinalGradeListModel) { StudentFinalGradeListModel studentFinalGradeAdd = new StudentFinalGradeListModel(); try { studentFinalGradeAdd = _inputFinalGradeService.AddUpdateStudentFinalGrade(studentFinalGradeListModel); } catch (Exception ex) { studentFinalGradeAdd._message = ex.Message; studentFinalGradeAdd._failure = true; } return(studentFinalGradeAdd); }
/// <summary> /// Get All Student Final Grade List /// </summary> /// <param name="studentFinalGradeListModel"></param> /// <returns></returns> public StudentFinalGradeListModel GetAllStudentFinalGradeList(StudentFinalGradeListModel studentFinalGradeListModel) { StudentFinalGradeListModel studentFinalGradeList = new StudentFinalGradeListModel(); try { if (TokenManager.CheckToken(studentFinalGradeListModel._tenantName + studentFinalGradeListModel._userName, studentFinalGradeListModel._token)) { studentFinalGradeList = this.inputFinalGradeRepository.GetAllStudentFinalGradeList(studentFinalGradeListModel); } else { studentFinalGradeList._failure = true; studentFinalGradeList._message = TOKENINVALID; } } catch (Exception es) { studentFinalGradeList._failure = true; studentFinalGradeList._message = es.Message; } return(studentFinalGradeList); }
/// <summary> /// Add Update Student Final Grade /// </summary> /// <param name="studentFinalGradeListModel"></param> /// <returns></returns> public StudentFinalGradeListModel AddUpdateStudentFinalGrade(StudentFinalGradeListModel studentFinalGradeListModel) { using (var transaction = this.context.Database.BeginTransaction()) { try { List <StudentFinalGrade> studentFinalGradeList = new List <StudentFinalGrade>(); //List<StudentFinalGradeStandard> studentFinalGradeStandardList = new List<StudentFinalGradeStandard>(); List <StudentFinalGradeComments> studentFinalGradeCommentList = new List <StudentFinalGradeComments>(); int Id = 1; var StudentFinalStandard = this.context?.StudentFinalGradeStandard.ToList(); if (StudentFinalStandard.Count > 0) { Id = Convert.ToInt32(StudentFinalStandard.OrderByDescending(s => s.Id).FirstOrDefault().Id + 1); } int?YrMarkingPeriodId = 0; int?SmstrMarkingPeriodId = 0; int?QtrMarkingPeriodId = 0; if (studentFinalGradeListModel.MarkingPeriodId != null) { var markingPeriodid = studentFinalGradeListModel.MarkingPeriodId.Split("_", StringSplitOptions.RemoveEmptyEntries); if (markingPeriodid.First() == "2") { QtrMarkingPeriodId = Int32.Parse(markingPeriodid.ElementAt(1)); } if (markingPeriodid.First() == "1") { SmstrMarkingPeriodId = Int32.Parse(markingPeriodid.ElementAt(1)); } if (markingPeriodid.First() == "0") { YrMarkingPeriodId = Int32.Parse(markingPeriodid.ElementAt(1)); } } foreach (var studentFinalGrade in studentFinalGradeListModel.studentFinalGradeList) { foreach (var studentFinalGradeStandarddata in studentFinalGrade.StudentFinalGradeStandard) { studentFinalGradeStandarddata.Id = Id; studentFinalGradeStandarddata.QtrMarkingPeriodId = (QtrMarkingPeriodId > 0) ? QtrMarkingPeriodId : null; studentFinalGradeStandarddata.SmstrMarkingPeriodId = (SmstrMarkingPeriodId > 0) ? SmstrMarkingPeriodId : null; studentFinalGradeStandarddata.YrMarkingPeriodId = (YrMarkingPeriodId > 0) ? YrMarkingPeriodId : null; studentFinalGradeStandarddata.CalendarId = studentFinalGradeListModel.CalendarId; studentFinalGradeStandarddata.AcademicYear = studentFinalGradeListModel.AcademicYear; studentFinalGradeStandarddata.TeacherComment = studentFinalGrade.TeacherComment; Id++; } } if (studentFinalGradeListModel.studentFinalGradeList.Count > 0) { var studentFinalGradeData = new List <StudentFinalGrade>(); //if (studentFinalGradeListModel.MarkingPeriodId != null) //{ studentFinalGradeData = this.context?.StudentFinalGrade.Where(e => e.SchoolId == studentFinalGradeListModel.SchoolId && e.TenantId == studentFinalGradeListModel.TenantId && e.CourseId == studentFinalGradeListModel.CourseId && e.CourseSectionId == studentFinalGradeListModel.CourseSectionId && e.CalendarId == studentFinalGradeListModel.CalendarId /*&& (YrMarkingPeriodId > 0 && e.YrMarkingPeriodId == YrMarkingPeriodId || SmstrMarkingPeriodId > 0 && e.SmstrMarkingPeriodId == SmstrMarkingPeriodId || QtrMarkingPeriodId > 0 && e.QtrMarkingPeriodId == QtrMarkingPeriodId)*/).ToList(); //} //else //{ // studentFinalGradeData = this.context?.StudentFinalGrade.Where(e => e.SchoolId == studentFinalGradeListModel.SchoolId && e.TenantId == studentFinalGradeListModel.TenantId && e.CourseId == studentFinalGradeListModel.CourseId && e.CourseSectionId == studentFinalGradeListModel.CourseSectionId && e.CalendarId == studentFinalGradeListModel.CalendarId && e.YrMarkingPeriodId == null && e.SmstrMarkingPeriodId == null && e.QtrMarkingPeriodId == null).ToList(); //} if (studentFinalGradeData.Count > 0) { var containStudentFinalGradeSrlno = studentFinalGradeData.Select(x => x.StudentFinalGradeSrlno).Distinct().ToList(); List <long> studentFinalGradeSrlnos = new List <long> { }; studentFinalGradeSrlnos = containStudentFinalGradeSrlno; var studentFinalGradeStandardData = this.context?.StudentFinalGradeStandard.Where(e => e.SchoolId == studentFinalGradeListModel.SchoolId && e.TenantId == studentFinalGradeListModel.TenantId && e.CalendarId == studentFinalGradeListModel.CalendarId && /*(YrMarkingPeriodId > 0 && e.YrMarkingPeriodId == YrMarkingPeriodId || SmstrMarkingPeriodId > 0 && e.SmstrMarkingPeriodId == SmstrMarkingPeriodId || QtrMarkingPeriodId > 0 && e.QtrMarkingPeriodId == QtrMarkingPeriodId) &&*/ (studentFinalGradeSrlnos == null || (studentFinalGradeSrlnos.Contains(e.StudentFinalGradeSrlno)))).ToList(); if (studentFinalGradeStandardData.Count > 0) { this.context?.StudentFinalGradeStandard.RemoveRange(studentFinalGradeStandardData); } var studentFinalGradeCommentsData = this.context?.StudentFinalGradeComments.Where(e => e.SchoolId == studentFinalGradeListModel.SchoolId && e.TenantId == studentFinalGradeListModel.TenantId && (studentFinalGradeSrlnos == null || (studentFinalGradeSrlnos.Contains(e.StudentFinalGradeSrlno)))).ToList(); if (studentFinalGradeCommentsData.Count > 0) { this.context?.StudentFinalGradeComments.RemoveRange(studentFinalGradeCommentsData); } this.context?.StudentFinalGrade.RemoveRange(studentFinalGradeData); this.context?.SaveChanges(); long?studentFinalGradeSrlno = 1; var studentFinalGradeSrlnoData = this.context?.StudentFinalGrade.Where(x => x.SchoolId == studentFinalGradeListModel.SchoolId && x.TenantId == studentFinalGradeListModel.TenantId).OrderByDescending(x => x.StudentFinalGradeSrlno).FirstOrDefault(); if (studentFinalGradeSrlnoData != null) { studentFinalGradeSrlno = studentFinalGradeSrlnoData.StudentFinalGradeSrlno + 1; } foreach (var studentFinalGrade in studentFinalGradeListModel.studentFinalGradeList) { var studentFinalGradeUpdate = new StudentFinalGrade() { TenantId = studentFinalGradeListModel.TenantId, SchoolId = studentFinalGradeListModel.SchoolId, StudentId = studentFinalGrade.StudentId, CourseId = studentFinalGradeListModel.CourseId, CourseSectionId = studentFinalGradeListModel.CourseSectionId, GradeId = studentFinalGrade.GradeId, GradeScaleId = studentFinalGrade.GradeScaleId, AcademicYear = studentFinalGradeListModel.AcademicYear, CalendarId = studentFinalGradeListModel.CalendarId, YrMarkingPeriodId = (YrMarkingPeriodId > 0) ? YrMarkingPeriodId : null, SmstrMarkingPeriodId = (SmstrMarkingPeriodId > 0) ? SmstrMarkingPeriodId : null, QtrMarkingPeriodId = (QtrMarkingPeriodId > 0) ? QtrMarkingPeriodId : null, IsPercent = studentFinalGradeListModel.IsPercent, PercentMarks = studentFinalGrade.PercentMarks, GradeObtained = studentFinalGrade.GradeObtained, UpdatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy, UpdatedOn = DateTime.UtcNow, StudentFinalGradeSrlno = (long)studentFinalGradeSrlno, BasedOnStandardGrade = studentFinalGrade.BasedOnStandardGrade, TeacherComment = studentFinalGrade.TeacherComment, StudentFinalGradeComments = studentFinalGrade.StudentFinalGradeComments?.Select(c => { c.UpdatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy; c.UpdatedOn = DateTime.UtcNow; return(c); }).ToList(), StudentFinalGradeStandard = studentFinalGrade.StudentFinalGradeStandard?.Select(c => { c.UpdatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy; c.UpdatedOn = DateTime.UtcNow; return(c); }).ToList() }; studentFinalGradeList.Add(studentFinalGradeUpdate); studentFinalGradeSrlno++; } studentFinalGradeListModel._message = "Student Final Grade Updated Succsesfully."; } else { long?studentFinalGradeSrlno = 1; var studentFinalGradeSrlnoData = this.context?.StudentFinalGrade.Where(x => x.SchoolId == studentFinalGradeListModel.SchoolId && x.TenantId == studentFinalGradeListModel.TenantId).OrderByDescending(x => x.StudentFinalGradeSrlno).FirstOrDefault(); if (studentFinalGradeSrlnoData != null) { studentFinalGradeSrlno = studentFinalGradeSrlnoData.StudentFinalGradeSrlno + 1; } foreach (var studentFinalGrade in studentFinalGradeListModel.studentFinalGradeList) { var studentFinalGradeAdd = new StudentFinalGrade() { TenantId = studentFinalGradeListModel.TenantId, SchoolId = studentFinalGradeListModel.SchoolId, StudentId = studentFinalGrade.StudentId, CourseId = studentFinalGradeListModel.CourseId, CourseSectionId = studentFinalGradeListModel.CourseSectionId, GradeId = studentFinalGrade.GradeId, GradeScaleId = studentFinalGrade.GradeScaleId, AcademicYear = studentFinalGradeListModel.AcademicYear, CalendarId = studentFinalGradeListModel.CalendarId, YrMarkingPeriodId = (YrMarkingPeriodId > 0) ? YrMarkingPeriodId : null, SmstrMarkingPeriodId = (SmstrMarkingPeriodId > 0) ? SmstrMarkingPeriodId : null, QtrMarkingPeriodId = (QtrMarkingPeriodId > 0) ? QtrMarkingPeriodId : null, IsPercent = studentFinalGradeListModel.IsPercent, PercentMarks = studentFinalGrade.PercentMarks, GradeObtained = studentFinalGrade.GradeObtained, CreatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy, CreatedOn = DateTime.UtcNow, StudentFinalGradeSrlno = (long)studentFinalGradeSrlno, BasedOnStandardGrade = studentFinalGrade.BasedOnStandardGrade, TeacherComment = studentFinalGrade.TeacherComment, StudentFinalGradeComments = studentFinalGrade.StudentFinalGradeComments?.Select(c => { c.CreatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy; c.CreatedOn = DateTime.UtcNow; return(c); }).ToList(), StudentFinalGradeStandard = studentFinalGrade.StudentFinalGradeStandard?.Select(c => { c.CreatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy; c.CreatedOn = DateTime.UtcNow; return(c); }).ToList() }; studentFinalGradeList.Add(studentFinalGradeAdd); studentFinalGradeSrlno++; } studentFinalGradeListModel._message = "Student Final Grade Added succsesfully."; } this.context?.StudentFinalGrade.AddRange(studentFinalGradeList); //this.context?.StudentFinalGradeStandard.AddRange(studentFinalGradeStandardList); this.context?.SaveChanges(); transaction.Commit(); studentFinalGradeListModel._failure = false; } } catch (Exception es) { transaction.Rollback(); studentFinalGradeListModel._failure = true; studentFinalGradeListModel._message = es.Message; } } return(studentFinalGradeListModel); }
/// <summary> /// Get All Student Final Grade List /// </summary> /// <param name="studentFinalGradeListModel"></param> /// <returns></returns> public StudentFinalGradeListModel GetAllStudentFinalGradeList(StudentFinalGradeListModel studentFinalGradeListModel) { StudentFinalGradeListModel studentFinalGradeList = new StudentFinalGradeListModel(); try { int?YrMarkingPeriodId = 0; int?SmstrMarkingPeriodId = 0; int?QtrMarkingPeriodId = 0; if (studentFinalGradeListModel.MarkingPeriodId != null) { var markingPeriodid = studentFinalGradeListModel.MarkingPeriodId.Split("_", StringSplitOptions.RemoveEmptyEntries); if (markingPeriodid.First() == "2") { QtrMarkingPeriodId = Int32.Parse(markingPeriodid.ElementAt(1)); } if (markingPeriodid.First() == "1") { SmstrMarkingPeriodId = Int32.Parse(markingPeriodid.ElementAt(1)); } if (markingPeriodid.First() == "0") { YrMarkingPeriodId = Int32.Parse(markingPeriodid.ElementAt(1)); } } var studentFinalGradeData = new List <StudentFinalGrade>(); //if (studentFinalGradeListModel.MarkingPeriodId != null) //{ studentFinalGradeData = this.context?.StudentFinalGrade.Include(x => x.StudentFinalGradeStandard).Include(d => d.StudentFinalGradeComments).ThenInclude(y => y.CourseCommentCategory).Where(e => e.SchoolId == studentFinalGradeListModel.SchoolId && e.TenantId == studentFinalGradeListModel.TenantId && e.CourseId == studentFinalGradeListModel.CourseId && e.CourseSectionId == studentFinalGradeListModel.CourseSectionId && e.CalendarId == studentFinalGradeListModel.CalendarId /*&& (YrMarkingPeriodId > 0 && e.YrMarkingPeriodId == YrMarkingPeriodId || SmstrMarkingPeriodId > 0 && e.SmstrMarkingPeriodId == SmstrMarkingPeriodId || QtrMarkingPeriodId > 0 && e.QtrMarkingPeriodId == QtrMarkingPeriodId)*/).ToList(); //} //else //{ // studentFinalGradeData = this.context?.StudentFinalGrade.Include(x => x.StudentFinalGradeStandard).Include(d => d.StudentFinalGradeComments).ThenInclude(y => y.CourseCommentCategory).Where(e => e.SchoolId == studentFinalGradeListModel.SchoolId && e.TenantId == studentFinalGradeListModel.TenantId && e.CourseId == studentFinalGradeListModel.CourseId && e.CourseSectionId == studentFinalGradeListModel.CourseSectionId && e.CalendarId == studentFinalGradeListModel.CalendarId && e.YrMarkingPeriodId == null && e.SmstrMarkingPeriodId == null && e.QtrMarkingPeriodId == null).ToList(); //} if (studentFinalGradeData.Count > 0) { studentFinalGradeList.studentFinalGradeList = studentFinalGradeData; studentFinalGradeList.TenantId = studentFinalGradeListModel.TenantId; studentFinalGradeList.SchoolId = studentFinalGradeListModel.SchoolId; studentFinalGradeList.CalendarId = studentFinalGradeListModel.CalendarId; studentFinalGradeList.CourseId = studentFinalGradeListModel.CourseId; studentFinalGradeList.CourseSectionId = studentFinalGradeListModel.CourseSectionId; studentFinalGradeList.StandardGradeScaleId = studentFinalGradeListModel.StandardGradeScaleId; studentFinalGradeList.MarkingPeriodId = studentFinalGradeListModel.MarkingPeriodId; studentFinalGradeList.AcademicYear = studentFinalGradeListModel.AcademicYear; studentFinalGradeList.IsPercent = studentFinalGradeListModel.IsPercent; studentFinalGradeList.CreatedOrUpdatedBy = studentFinalGradeListModel.CreatedOrUpdatedBy; studentFinalGradeList._userName = studentFinalGradeListModel._userName; studentFinalGradeList._tenantName = studentFinalGradeListModel._tenantName; studentFinalGradeList._token = studentFinalGradeListModel._token; studentFinalGradeList._failure = false; if (studentFinalGradeList.studentFinalGradeList.Count > 0) { //foreach (var studentFinalGrade in studentFinalGradeList.studentFinalGradeList) //{ // foreach (var FinalGrade in studentFinalGrade.StudentFinalGradeComments) // { // FinalGrade.CourseCommentCategory.StudentFinalGradeComments = null; // } //} studentFinalGradeList.studentFinalGradeList.ForEach(f => f.StudentFinalGradeComments.ToList().ForEach(r => r.CourseCommentCategory.StudentFinalGradeComments = null)); } } else { studentFinalGradeList._failure = true; studentFinalGradeList._message = NORECORDFOUND; } } catch (Exception es) { studentFinalGradeList._message = es.Message; studentFinalGradeList._failure = true; } return(studentFinalGradeList); }