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);
}