public ActionResult <QuarterAddViewModel> DeleteQuarter(QuarterAddViewModel quarter)
{
QuarterAddViewModel quarterlDelete = new QuarterAddViewModel();
try
{
if (quarter.tableQuarter.SchoolId > 0)
{
quarterlDelete = _markingPeriodService.DeleteQuarter(quarter);
}
else
{
quarterlDelete._token = quarter._token;
quarterlDelete._tenantName = quarter._tenantName;
quarterlDelete._failure = true;
quarterlDelete._message = "Please enter valid school id";
}
}
catch (Exception es)
{
quarterlDelete._failure = true;
quarterlDelete._message = es.Message;
}
return(quarterlDelete);
}
/// <summary>
/// Delete Quarter
/// </summary>
/// <param name="quarter"></param>
/// <returns></returns>
public QuarterAddViewModel DeleteQuarter(QuarterAddViewModel quarter)
{
try
{
var quarterDelete = this.context?.Quarters.FirstOrDefault(x => x.TenantId == quarter.tableQuarter.TenantId && x.SchoolId == quarter.tableQuarter.SchoolId && x.MarkingPeriodId == quarter.tableQuarter.MarkingPeriodId);
var progressPeriod = this.context?.ProgressPeriods.FirstOrDefault(z => z.TenantId == quarterDelete.TenantId && z.SchoolId == quarterDelete.SchoolId && z.QuarterId == quarterDelete.MarkingPeriodId);
if (progressPeriod != null)
{
quarter.tableQuarter = null;
quarter._message = "Quarter cannot be deleted because it has its association";
quarter._failure = true;
}
else
{
this.context?.Quarters.Remove(quarterDelete);
this.context?.SaveChanges();
quarter._failure = false;
quarter._message = "Quarter Deleted Successfully";
}
}
catch (Exception es)
{
quarter._failure = true;
quarter._message = es.Message;
}
return(quarter);
}
/// <summary>
/// Update Quarter
/// </summary>
/// <param name="quarters"></param>
/// <returns></returns>
public QuarterAddViewModel UpdateQuarter(QuarterAddViewModel quarters)
{
try
{
var quarteMaster = this.context?.Quarters.FirstOrDefault(x => x.TenantId == quarters.tableQuarter.TenantId && x.SchoolId == quarters.tableQuarter.SchoolId && x.MarkingPeriodId == quarters.tableQuarter.MarkingPeriodId);
var semester = this.context?.Semesters.FirstOrDefault(x => x.TenantId == quarters.tableQuarter.TenantId && x.SchoolId == quarters.tableQuarter.SchoolId && x.MarkingPeriodId == quarters.tableQuarter.SemesterId);
if (semester.StartDate <= quarters.tableQuarter.StartDate && semester.EndDate >= quarters.tableQuarter.EndDate)
{
quarters.tableQuarter.LastUpdated = DateTime.Now;
quarters.tableQuarter.AcademicYear = semester.AcademicYear;
this.context.Entry(quarteMaster).CurrentValues.SetValues(quarters.tableQuarter);
this.context?.SaveChanges();
quarters._failure = false;
quarters._message = "Quarter Updated Successfully";
}
else
{
quarters._failure = true;
quarters._message = "Start Date And End Date of Quarter Should Be Between Start Date And End Date of Semester";
}
}
catch (Exception ex)
{
quarters.tableQuarter = null;
quarters._failure = true;
quarters._message = ex.Message;
}
return(quarters);
}
/// <summary>
/// View Quarter By Id
/// </summary>
/// <param name="quarter"></param>
/// <returns></returns>
public QuarterAddViewModel ViewQuarter(QuarterAddViewModel quarter)
{
QuarterAddViewModel quarterAddViewModel = new QuarterAddViewModel();
try
{
var quarteMaster = this.context?.Quarters.FirstOrDefault(x => x.TenantId == quarter.tableQuarter.TenantId && x.SchoolId == quarter.tableQuarter.SchoolId && x.MarkingPeriodId == quarter.tableQuarter.MarkingPeriodId);
if (quarteMaster != null)
{
quarterAddViewModel.tableQuarter = quarteMaster;
quarterAddViewModel._tenantName = quarter._tenantName;
quarterAddViewModel._failure = false;
}
else
{
quarterAddViewModel._failure = true;
quarterAddViewModel._message = NORECORDFOUND;
}
}
catch (Exception es)
{
quarterAddViewModel._failure = true;
quarterAddViewModel._message = es.Message;
}
return(quarterAddViewModel);
}
public QuarterAddViewModel AddQuarter(QuarterAddViewModel quarters)
{
try
{
var semester = this.context?.Semesters.FirstOrDefault(x => x.TenantId == quarters.tableQuarter.TenantId && x.SchoolId == quarters.tableQuarter.SchoolId && x.MarkingPeriodId == quarters.tableQuarter.SemesterId);
if (semester.StartDate <= quarters.tableQuarter.StartDate && semester.EndDate >= quarters.tableQuarter.EndDate)
{
int?MarkingPeriodId = Utility.GetMaxPK(this.context, new Func <Quarters, int>(x => x.MarkingPeriodId));
quarters.tableQuarter.MarkingPeriodId = (int)MarkingPeriodId;
quarters.tableQuarter.AcademicYear = semester.AcademicYear;
quarters.tableQuarter.LastUpdated = DateTime.UtcNow;
quarters.tableQuarter.TenantId = quarters.tableQuarter.TenantId;
this.context?.Quarters.Add(quarters.tableQuarter);
this.context?.SaveChanges();
quarters._failure = false;
//quarters.tableQuarter.Semesters = null;
}
else
{
quarters._failure = true;
quarters._message = "Start Date And End Date of Quarter Should Be Between Start Date And End Date of Semester";
}
}
catch (Exception es)
{
quarters._failure = true;
quarters._message = es.Message;
}
return(quarters);
}
/// <summary>
/// Update Quarter
/// </summary>
/// <param name="quarter"></param>
/// <returns></returns>
public QuarterAddViewModel UpdateQuarter(QuarterAddViewModel quarter)
{
QuarterAddViewModel quarterAddViewModel = new QuarterAddViewModel();
if (TokenManager.CheckToken(quarter._tenantName + quarter._userName, quarter._token))
{
quarterAddViewModel = this.markingperiodRepository.UpdateQuarter(quarter);
return(quarterAddViewModel);
}
else
{
quarterAddViewModel._failure = true;
quarterAddViewModel._message = TOKENINVALID;
return(quarterAddViewModel);
}
}
/// <summary>
/// Update Quarter
/// </summary>
/// <param name="quarters"></param>
/// <returns></returns>
public QuarterAddViewModel UpdateQuarter(QuarterAddViewModel quarters)
{
try
{
var quarteMaster = this.context?.Quarters.FirstOrDefault(x => x.TenantId == quarters.tableQuarter.TenantId && x.SchoolId == quarters.tableQuarter.SchoolId && x.MarkingPeriodId == quarters.tableQuarter.MarkingPeriodId);
var semester = this.context?.Semesters.FirstOrDefault(x => x.TenantId == quarters.tableQuarter.TenantId && x.SchoolId == quarters.tableQuarter.SchoolId && x.MarkingPeriodId == quarters.tableQuarter.SemesterId);
if (semester.StartDate <= quarters.tableQuarter.StartDate && semester.EndDate >= quarters.tableQuarter.EndDate)
{
quarteMaster.SchoolId = quarters.tableQuarter.SchoolId;
quarteMaster.TenantId = quarters.tableQuarter.TenantId;
quarteMaster.AcademicYear = semester.AcademicYear;
quarteMaster.SemesterId = quarters.tableQuarter.SemesterId;
quarteMaster.Title = quarters.tableQuarter.Title;
quarteMaster.ShortName = quarters.tableQuarter.ShortName;
quarteMaster.SortOrder = quarters.tableQuarter.SortOrder;
quarteMaster.SortOrder = quarters.tableQuarter.SortOrder;
quarteMaster.StartDate = quarters.tableQuarter.StartDate;
quarteMaster.EndDate = quarters.tableQuarter.EndDate;
quarteMaster.PostStartDate = quarters.tableQuarter.PostStartDate;
quarteMaster.PostEndDate = quarters.tableQuarter.PostEndDate;
quarteMaster.DoesGrades = quarters.tableQuarter.DoesGrades;
quarteMaster.DoesExam = quarters.tableQuarter.DoesExam;
quarteMaster.DoesComments = quarters.tableQuarter.DoesComments;
quarteMaster.RolloverId = quarters.tableQuarter.RolloverId;
quarters.tableQuarter.LastUpdated = DateTime.UtcNow;
quarteMaster.UpdatedBy = quarters.tableQuarter.UpdatedBy;
this.context?.SaveChanges();
quarters._failure = false;
}
else
{
quarters._failure = true;
quarters._message = "Start Date And End Date of Quarter Should Be Between Start Date And End Date of Semester";
}
}
catch (Exception ex)
{
quarters.tableQuarter = null;
quarters._failure = true;
quarters._message = ex.Message;
}
return(quarters);
}
/// <summary>
/// Delete Quarter
/// </summary>
/// <param name="quarter"></param>
/// <returns></returns>
public QuarterAddViewModel DeleteQuarter(QuarterAddViewModel quarter)
{
QuarterAddViewModel quarterListdelete = new QuarterAddViewModel();
try
{
if (TokenManager.CheckToken(quarter._tenantName + quarter._userName, quarter._token))
{
quarterListdelete = this.markingperiodRepository.DeleteQuarter(quarter);
}
else
{
quarterListdelete._failure = true;
quarterListdelete._message = TOKENINVALID;
}
}
catch (Exception es)
{
quarterListdelete._failure = true;
quarterListdelete._message = es.Message;
}
return(quarterListdelete);
}
