public ActionResult <SemesterAddViewModel> DeleteSemester(SemesterAddViewModel semester)
{
SemesterAddViewModel semesterDelete = new SemesterAddViewModel();
try
{
if (semester.tableSemesters.SchoolId > 0)
{
semesterDelete = _markingPeriodService.DeleteSemester(semester);
}
else
{
semesterDelete._token = semester._token;
semesterDelete._tenantName = semester._tenantName;
semesterDelete._failure = true;
semesterDelete._message = "Please enter valid school id";
}
}
catch (Exception es)
{
semesterDelete._failure = true;
semesterDelete._message = es.Message;
}
return(semesterDelete);
}
public SemesterAddViewModel DeleteSemester(SemesterAddViewModel semester)
{
try
{
var semesterDelete = this.context?.Semesters.FirstOrDefault(x => x.TenantId == semester.tableSemesters.TenantId && x.SchoolId == semester.tableSemesters.SchoolId && x.MarkingPeriodId == semester.tableSemesters.MarkingPeriodId);
var QuatersExist = this.context?.Quarters.FirstOrDefault(x => x.TenantId == semesterDelete.TenantId && x.SchoolId == semesterDelete.SchoolId && x.SemesterId == semesterDelete.MarkingPeriodId);
if (QuatersExist != null)
{
semester.tableSemesters = null;
semester._message = "Semester cannot be deleted because it has its association";
semester._failure = true;
}
else
{
this.context?.Semesters.Remove(semesterDelete);
this.context?.SaveChanges();
semester._failure = false;
semester._message = "Semester Deleted Successfully";
}
}
catch (Exception es)
{
semester._failure = true;
semester._message = es.Message;
}
return(semester);
}
public SemesterAddViewModel UpdateSemester(SemesterAddViewModel semester)
{
try
{
var semesterUpdate = this.context?.Semesters.FirstOrDefault(x => x.TenantId == semester.tableSemesters.TenantId && x.SchoolId == semester.tableSemesters.SchoolId && x.MarkingPeriodId == semester.tableSemesters.MarkingPeriodId);
var SchoolYear = this.context?.SchoolYears.FirstOrDefault(x => x.TenantId == semesterUpdate.TenantId && x.SchoolId == semesterUpdate.SchoolId && x.MarkingPeriodId == semesterUpdate.YearId);
if (SchoolYear.StartDate <= semester.tableSemesters.StartDate && SchoolYear.EndDate >= semester.tableSemesters.EndDate)
{
semester.tableSemesters.LastUpdated = DateTime.Now;
semester.tableSemesters.AcademicYear = SchoolYear.AcademicYear;
this.context.Entry(semesterUpdate).CurrentValues.SetValues(semester.tableSemesters);
this.context?.SaveChanges();
semester._failure = false;
semester._message = "Semester Updated Successfully";
}
else
{
semester._failure = true;
semester._message = "Start Date And End Date of Semester Should Be Between Start Date And End Date of SchoolYear";
}
}
catch (Exception ex)
{
semester.tableSemesters = null;
semester._failure = true;
semester._message = ex.Message;
}
return(semester);
}
public SemesterAddViewModel AddSemester(SemesterAddViewModel semester)
{
try
{
var SchoolYear = this.context?.SchoolYears.FirstOrDefault(x => x.TenantId == semester.tableSemesters.TenantId && x.SchoolId == semester.tableSemesters.SchoolId && x.MarkingPeriodId == semester.tableSemesters.YearId);
if (SchoolYear.StartDate <= semester.tableSemesters.StartDate && SchoolYear.EndDate >= semester.tableSemesters.EndDate)
{
int?MasterMarkingPeriodId = Utility.GetMaxPK(this.context, new Func <Semesters, int>(x => x.MarkingPeriodId));
semester.tableSemesters.MarkingPeriodId = (int)MasterMarkingPeriodId;
semester.tableSemesters.AcademicYear = SchoolYear.AcademicYear;
semester.tableSemesters.LastUpdated = DateTime.UtcNow;
this.context?.Semesters.Add(semester.tableSemesters);
this.context?.SaveChanges();
semester._failure = false;
//semester.tableSemesters.SchoolYears = null;
}
else
{
semester._failure = true;
semester._message = "Start Date And End Date of Semester Should Be Between Start Date And End Date of SchoolYear";
}
}
catch (Exception ex)
{
semester.tableSemesters = null;
semester._failure = true;
semester._message = NORECORDFOUND;
}
return(semester);
}
public SemesterAddViewModel ViewSemester(SemesterAddViewModel semester)
{
SemesterAddViewModel semesterView = new SemesterAddViewModel();
if (TokenManager.CheckToken(semester._tenantName + semester._userName, semester._token))
{
semesterView = this.markingperiodRepository.ViewSemester(semester);
return(semesterView);
}
else
{
semesterView._failure = true;
semesterView._message = TOKENINVALID;
return(semesterView);
}
}
public SemesterAddViewModel UpdateSemester(SemesterAddViewModel semester)
{
try
{
var semesterUpdate = this.context?.Semesters.FirstOrDefault(x => x.TenantId == semester.tableSemesters.TenantId && x.SchoolId == semester.tableSemesters.SchoolId && x.MarkingPeriodId == semester.tableSemesters.MarkingPeriodId);
var SchoolYear = this.context?.SchoolYears.FirstOrDefault(x => x.TenantId == semesterUpdate.TenantId && x.SchoolId == semesterUpdate.SchoolId && x.MarkingPeriodId == semesterUpdate.YearId);
if (SchoolYear.StartDate <= semester.tableSemesters.StartDate && SchoolYear.EndDate >= semester.tableSemesters.EndDate)
{
semesterUpdate.TenantId = semester.tableSemesters.TenantId;
semesterUpdate.SchoolId = semester.tableSemesters.SchoolId;
semesterUpdate.MarkingPeriodId = semester.tableSemesters.MarkingPeriodId;
semesterUpdate.AcademicYear = SchoolYear.AcademicYear;
semesterUpdate.YearId = semester.tableSemesters.YearId;
semesterUpdate.Title = semester.tableSemesters.Title;
semesterUpdate.ShortName = semester.tableSemesters.ShortName;
semesterUpdate.SortOrder = semester.tableSemesters.SortOrder;
semesterUpdate.StartDate = semester.tableSemesters.StartDate;
semesterUpdate.EndDate = semester.tableSemesters.EndDate;
semesterUpdate.PostStartDate = semester.tableSemesters.PostStartDate;
semesterUpdate.PostEndDate = semester.tableSemesters.PostEndDate;
semesterUpdate.DoesGrades = semester.tableSemesters.DoesGrades;
semesterUpdate.DoesExam = semester.tableSemesters.DoesExam;
semesterUpdate.DoesComments = semester.tableSemesters.DoesComments;
semesterUpdate.RolloverId = semester.tableSemesters.RolloverId;
semesterUpdate.LastUpdated = semester.tableSemesters.LastUpdated;
semesterUpdate.UpdatedBy = semester.tableSemesters.UpdatedBy;
this.context?.SaveChanges();
semester._failure = false;
}
else
{
semester._failure = true;
semester._message = "Start Date And End Date of Semester Should Be Between Start Date And End Date of SchoolYear";
}
}
catch (Exception ex)
{
semester.tableSemesters = null;
semester._failure = true;
semester._message = ex.Message;
}
return(semester);
}
public SemesterAddViewModel DeleteSemester(SemesterAddViewModel semester)
{
SemesterAddViewModel semesterDelete = new SemesterAddViewModel();
try
{
if (TokenManager.CheckToken(semester._tenantName + semester._userName, semester._token))
{
semesterDelete = this.markingperiodRepository.DeleteSemester(semester);
}
else
{
semesterDelete._failure = true;
semesterDelete._message = TOKENINVALID;
}
}
catch (Exception es)
{
semesterDelete._failure = true;
semesterDelete._message = es.Message;
}
return(semesterDelete);
}
public SemesterAddViewModel ViewSemester(SemesterAddViewModel semester)
{
SemesterAddViewModel semesterView = new SemesterAddViewModel();
try
{
var semesterById = this.context?.Semesters.FirstOrDefault(x => x.TenantId == semester.tableSemesters.TenantId && x.SchoolId == semester.tableSemesters.SchoolId && x.MarkingPeriodId == semester.tableSemesters.MarkingPeriodId);
if (semesterById != null)
{
semesterView.tableSemesters = semesterById;
}
else
{
semesterView._failure = true;
semesterView._message = NORECORDFOUND;
}
}
catch (Exception es)
{
semester._failure = true;
semester._message = es.Message;
}
return(semesterView);
}
