public ActionResult <StudentEffortGradeListModel> GetAllStudentEffortGradeList(StudentEffortGradeListModel studentEffortGradeListModel) { StudentEffortGradeListModel studentEffortGradeList = new StudentEffortGradeListModel(); try { studentEffortGradeList = _studentEffortGradeService.GetAllStudentEffortGradeList(studentEffortGradeListModel); } catch (Exception ex) { studentEffortGradeList._message = ex.Message; studentEffortGradeList._failure = true; } return(studentEffortGradeList); }
public ActionResult <StudentEffortGradeListModel> AddUpdateStudentEffortGrade(StudentEffortGradeListModel studentEffortGradeListModel) { StudentEffortGradeListModel studentEffortGradeAdd = new StudentEffortGradeListModel(); try { studentEffortGradeAdd = _studentEffortGradeService.AddUpdateStudentEffortGrade(studentEffortGradeListModel); } catch (Exception ex) { studentEffortGradeAdd._message = ex.Message; studentEffortGradeAdd._failure = true; } return(studentEffortGradeAdd); }
/// <summary> /// Get All Student Effort Grade List /// </summary> /// <param name="studentEffortGradeListModel"></param> /// <returns></returns> public StudentEffortGradeListModel GetAllStudentEffortGradeList(StudentEffortGradeListModel studentEffortGradeListModel) { StudentEffortGradeListModel studentEffortGradeList = new StudentEffortGradeListModel(); try { if (TokenManager.CheckToken(studentEffortGradeListModel._tenantName + studentEffortGradeListModel._userName, studentEffortGradeListModel._token)) { studentEffortGradeList = this.studentEffortGradeRepository.GetAllStudentEffortGradeList(studentEffortGradeListModel); } else { studentEffortGradeList._failure = true; studentEffortGradeList._message = TOKENINVALID; } } catch (Exception es) { studentEffortGradeList._failure = true; studentEffortGradeList._message = es.Message; } return(studentEffortGradeList); }
/// <summary> /// Add Update Student Effort Grade /// </summary> /// <param name="studentEffortGradeListModel"></param> /// <returns></returns> public StudentEffortGradeListModel AddUpdateStudentEffortGrade(StudentEffortGradeListModel studentEffortGradeListModel) { using (var transaction = this.context.Database.BeginTransaction()) { try { List <StudentEffortGradeMaster> studentEffortGradeList = new List <StudentEffortGradeMaster>(); long Id = 1; var StudentEffortDetails = this.context?.StudentEffortGradeDetail.ToList(); if (StudentEffortDetails.Count > 0) { Id = StudentEffortDetails.OrderByDescending(s => s.Id).FirstOrDefault().Id + 1; } int?YrMarkingPeriodId = 0; int?SmstrMarkingPeriodId = 0; int?QtrMarkingPeriodId = 0; if (studentEffortGradeListModel.MarkingPeriodId != null) { var markingPeriodid = studentEffortGradeListModel.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)); } } if (studentEffortGradeListModel.studentEffortGradeList.Count > 0) { foreach (var studentEffortGrade in studentEffortGradeListModel.studentEffortGradeList) { if (studentEffortGrade.StudentEffortGradeDetail.ToList().Count() > 0 || studentEffortGrade.StudentEffortGradeDetail != null) { foreach (var studentEffortGradeDetaildata in studentEffortGrade.StudentEffortGradeDetail) { studentEffortGradeDetaildata.Id = Id; Id++; } } } var studentEffortGradeData = new List <StudentEffortGradeMaster>(); studentEffortGradeData = this.context?.StudentEffortGradeMaster.Where(e => e.SchoolId == studentEffortGradeListModel.SchoolId && e.TenantId == studentEffortGradeListModel.TenantId && e.CalendarId == studentEffortGradeListModel.CalendarId && e.CourseId == studentEffortGradeListModel.CourseId && e.CourseSectionId == studentEffortGradeListModel.CourseSectionId).ToList(); if (studentEffortGradeData.Count > 0) { var containStudentEffortGradeSrlno = studentEffortGradeData.Select(x => x.StudentEffortGradeSrlno).Distinct().ToList(); List <long> studentEffortGradeSrlnos = new List <long> { }; studentEffortGradeSrlnos = containStudentEffortGradeSrlno; var studentEffortGradeDetailsData = this.context?.StudentEffortGradeDetail.Where(e => e.SchoolId == studentEffortGradeListModel.SchoolId && e.TenantId == studentEffortGradeListModel.TenantId && (studentEffortGradeSrlnos == null || (studentEffortGradeSrlnos.Contains(e.StudentEffortGradeSrlno)))).ToList(); if (studentEffortGradeDetailsData.Count > 0) { this.context?.StudentEffortGradeDetail.RemoveRange(studentEffortGradeDetailsData); } this.context?.StudentEffortGradeMaster.RemoveRange(studentEffortGradeData); this.context?.SaveChanges(); long?studentEffortGradeSrlno = 1; var studentFinalGradeSrlnoData = this.context?.StudentEffortGradeMaster.Where(x => x.SchoolId == studentEffortGradeListModel.SchoolId && x.TenantId == studentEffortGradeListModel.TenantId).OrderByDescending(x => x.StudentEffortGradeSrlno).FirstOrDefault(); if (studentFinalGradeSrlnoData != null) { studentEffortGradeSrlno = studentFinalGradeSrlnoData.StudentEffortGradeSrlno + 1; } foreach (var studentEffortGrade in studentEffortGradeListModel.studentEffortGradeList) { var studentEffortGradeUpdate = new StudentEffortGradeMaster() { TenantId = studentEffortGradeListModel.TenantId, SchoolId = studentEffortGradeListModel.SchoolId, StudentId = studentEffortGrade.StudentId, CourseId = studentEffortGradeListModel.CourseId, CourseSectionId = studentEffortGradeListModel.CourseSectionId, AcademicYear = studentEffortGradeListModel.AcademicYear, CalendarId = studentEffortGradeListModel.CalendarId, YrMarkingPeriodId = (YrMarkingPeriodId > 0) ? YrMarkingPeriodId : null, SmstrMarkingPeriodId = (SmstrMarkingPeriodId > 0) ? SmstrMarkingPeriodId : null, QtrMarkingPeriodId = (QtrMarkingPeriodId > 0) ? QtrMarkingPeriodId : null, UpdatedBy = studentEffortGradeListModel.CreatedOrUpdatedBy, UpdatedOn = DateTime.UtcNow, StudentEffortGradeSrlno = (long)studentEffortGradeSrlno, TeacherComment = studentEffortGrade.TeacherComment, StudentEffortGradeDetail = studentEffortGrade.StudentEffortGradeDetail?.Select(c => { c.UpdatedBy = studentEffortGradeListModel.CreatedOrUpdatedBy; c.UpdatedOn = DateTime.UtcNow; return(c); }).ToList() }; studentEffortGradeList.Add(studentEffortGradeUpdate); studentEffortGradeSrlno++; } studentEffortGradeListModel._message = "Student Effort Grade Updated Succsesfully."; } else { long?studentEffortGradeSrlno = 1; var studentEffortGradeSrlnoData = this.context?.StudentEffortGradeMaster.Where(x => x.SchoolId == studentEffortGradeListModel.SchoolId && x.TenantId == studentEffortGradeListModel.TenantId).OrderByDescending(x => x.StudentEffortGradeSrlno).FirstOrDefault(); if (studentEffortGradeSrlnoData != null) { studentEffortGradeSrlno = studentEffortGradeSrlnoData.StudentEffortGradeSrlno + 1; } foreach (var studentEffortGrade in studentEffortGradeListModel.studentEffortGradeList) { var studentEffortGradeAdd = new StudentEffortGradeMaster() { TenantId = studentEffortGradeListModel.TenantId, SchoolId = studentEffortGradeListModel.SchoolId, StudentId = studentEffortGrade.StudentId, CourseId = studentEffortGradeListModel.CourseId, CourseSectionId = studentEffortGradeListModel.CourseSectionId, AcademicYear = studentEffortGradeListModel.AcademicYear, CalendarId = studentEffortGradeListModel.CalendarId, YrMarkingPeriodId = (YrMarkingPeriodId > 0) ? YrMarkingPeriodId : null, SmstrMarkingPeriodId = (SmstrMarkingPeriodId > 0) ? SmstrMarkingPeriodId : null, QtrMarkingPeriodId = (QtrMarkingPeriodId > 0) ? QtrMarkingPeriodId : null, CreatedBy = studentEffortGradeListModel.CreatedOrUpdatedBy, CreatedOn = DateTime.UtcNow, StudentEffortGradeSrlno = (long)studentEffortGradeSrlno, TeacherComment = studentEffortGrade.TeacherComment, StudentEffortGradeDetail = studentEffortGrade.StudentEffortGradeDetail?.Select(c => { c.CreatedBy = studentEffortGradeListModel.CreatedOrUpdatedBy; c.CreatedOn = DateTime.UtcNow; return(c); }).ToList() }; studentEffortGradeList.Add(studentEffortGradeAdd); studentEffortGradeSrlno++; } studentEffortGradeListModel._message = "Student Effort Grade Added succsesfully."; } this.context?.StudentEffortGradeMaster.AddRange(studentEffortGradeList); this.context?.SaveChanges(); transaction.Commit(); studentEffortGradeListModel._failure = false; } } catch (Exception es) { transaction.Rollback(); studentEffortGradeListModel._failure = true; studentEffortGradeListModel._message = es.Message; } } return(studentEffortGradeListModel); }
/// <summary> /// Get All Student Effort Grade List /// </summary> /// <param name="studentEffortGradeListModel"></param> /// <returns></returns> public StudentEffortGradeListModel GetAllStudentEffortGradeList(StudentEffortGradeListModel studentEffortGradeListModel) { StudentEffortGradeListModel studentEffortGradeList = new StudentEffortGradeListModel(); try { int?YrMarkingPeriodId = 0; int?SmstrMarkingPeriodId = 0; int?QtrMarkingPeriodId = 0; if (studentEffortGradeListModel.MarkingPeriodId != null) { var markingPeriodid = studentEffortGradeListModel.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 studentEffortGradeData = new List <StudentEffortGradeMaster>(); studentEffortGradeData = this.context?.StudentEffortGradeMaster.Include(x => x.StudentEffortGradeDetail).Where(e => e.SchoolId == studentEffortGradeListModel.SchoolId && e.TenantId == studentEffortGradeListModel.TenantId && e.CalendarId == studentEffortGradeListModel.CalendarId && e.CourseId == studentEffortGradeListModel.CourseId && e.CourseSectionId == studentEffortGradeListModel.CourseSectionId).ToList(); if (studentEffortGradeData.Count > 0) { studentEffortGradeList.studentEffortGradeList = studentEffortGradeData; studentEffortGradeList.TenantId = studentEffortGradeListModel.TenantId; studentEffortGradeList.SchoolId = studentEffortGradeListModel.SchoolId; studentEffortGradeList.CourseId = studentEffortGradeListModel.CourseId; studentEffortGradeList.CourseSectionId = studentEffortGradeListModel.CourseSectionId; studentEffortGradeList.CalendarId = studentEffortGradeListModel.CalendarId; studentEffortGradeList.MarkingPeriodId = studentEffortGradeListModel.MarkingPeriodId; studentEffortGradeList.AcademicYear = studentEffortGradeListModel.AcademicYear; studentEffortGradeList.CreatedOrUpdatedBy = studentEffortGradeListModel.CreatedOrUpdatedBy; studentEffortGradeList._userName = studentEffortGradeListModel._userName; studentEffortGradeList._tenantName = studentEffortGradeListModel._tenantName; studentEffortGradeList._token = studentEffortGradeListModel._token; studentEffortGradeList._failure = false; } else { studentEffortGradeList.studentEffortGradeList = studentEffortGradeData; studentEffortGradeList._failure = true; studentEffortGradeList._message = NORECORDFOUND; } } catch (Exception es) { studentEffortGradeList._message = es.Message; studentEffortGradeList._failure = true; } return(studentEffortGradeList); }