public ActionResult <ProgressPeriodAddViewModel> DeleteProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
ProgressPeriodAddViewModel progressPeriodDelete = new ProgressPeriodAddViewModel();
try
{
if (progressPeriod.tableProgressPeriods.SchoolId > 0)
{
progressPeriodDelete = _markingPeriodService.DeleteProgressPeriod(progressPeriod);
}
else
{
progressPeriodDelete._token = progressPeriod._token;
progressPeriodDelete._tenantName = progressPeriod._tenantName;
progressPeriodDelete._failure = true;
progressPeriodDelete._message = "Please enter valid school id";
}
}
catch (Exception es)
{
progressPeriodDelete._failure = true;
progressPeriodDelete._message = es.Message;
}
return(progressPeriodDelete);
}
public ProgressPeriodAddViewModel UpdateProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
try
{
var progressUpdate = this.context?.ProgressPeriods.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.MarkingPeriodId);
var Quarter = this.context?.Quarters.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.QuarterId);
if (Quarter.StartDate <= progressPeriod.tableProgressPeriods.StartDate && Quarter.EndDate >= progressPeriod.tableProgressPeriods.EndDate)
{
progressPeriod.tableProgressPeriods.LastUpdated = DateTime.Now;
progressPeriod.tableProgressPeriods.AcademicYear = (decimal)Quarter.AcademicYear;
this.context.Entry(progressUpdate).CurrentValues.SetValues(progressPeriod.tableProgressPeriods);
this.context?.SaveChanges();
progressPeriod._failure = false;
progressPeriod._message = "Progress Period Updated Successfully";
}
else
{
progressPeriod._failure = false;
progressPeriod._message = "Start Date And End Date of ProgressPeriod Should Be Between Start Date And End Date of Quarter";
}
}
catch (Exception ex)
{
progressPeriod.tableProgressPeriods = null;
progressPeriod._failure = true;
progressPeriod._message = ex.Message;
}
return(progressPeriod);
}
public ProgressPeriodAddViewModel AddProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
var Quarter = this.context?.Quarters.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.QuarterId);
if (Quarter.StartDate <= progressPeriod.tableProgressPeriods.StartDate && Quarter.EndDate >= progressPeriod.tableProgressPeriods.EndDate)
{
//int? MasterMarkingPeriodId = Utility.GetMaxPK(this.context, new Func<ProgressPeriods, int>(x => x.MarkingPeriodId));
int?MarkingPeriodId = 1;
var progressPeriodData = this.context?.ProgressPeriods.Where(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId).OrderByDescending(x => x.MarkingPeriodId).FirstOrDefault();
if (progressPeriodData != null)
{
MarkingPeriodId = progressPeriodData.MarkingPeriodId + 1;
}
progressPeriod.tableProgressPeriods.MarkingPeriodId = (int)MarkingPeriodId;
progressPeriod.tableProgressPeriods.AcademicYear = (decimal)Quarter.AcademicYear;
progressPeriod.tableProgressPeriods.LastUpdated = DateTime.UtcNow;
this.context?.ProgressPeriods.Add(progressPeriod.tableProgressPeriods);
this.context?.SaveChanges();
progressPeriod._failure = false;
progressPeriod._message = "Progress Period Added Successfully";
//progressPeriod.tableProgressPeriods.Quarters = null;
}
else
{
progressPeriod._failure = true;
progressPeriod._message = "Start Date And End Date of ProgressPeriod Should Be Between Start Date And End Date of Quarter";
}
return(progressPeriod);
}
public ProgressPeriodAddViewModel ViewProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
ProgressPeriodAddViewModel progressPeriodView = new ProgressPeriodAddViewModel();
if (TokenManager.CheckToken(progressPeriod._tenantName + progressPeriod._userName, progressPeriod._token))
{
progressPeriodView = this.markingperiodRepository.ViewProgressPeriod(progressPeriod);
return(progressPeriodView);
}
else
{
progressPeriodView._failure = true;
progressPeriodView._message = TOKENINVALID;
return(progressPeriodView);
}
}
public ProgressPeriodAddViewModel UpdateProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
try
{
var progressUpdate = this.context?.ProgressPeriods.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.MarkingPeriodId);
var Quarter = this.context?.Quarters.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.QuarterId);
if (Quarter.StartDate <= progressPeriod.tableProgressPeriods.StartDate && Quarter.EndDate >= progressPeriod.tableProgressPeriods.EndDate)
{
progressUpdate.TenantId = progressPeriod.tableProgressPeriods.TenantId;
progressUpdate.SchoolId = progressPeriod.tableProgressPeriods.SchoolId;
progressUpdate.MarkingPeriodId = progressPeriod.tableProgressPeriods.MarkingPeriodId;
progressUpdate.AcademicYear = (decimal)Quarter.AcademicYear;
progressUpdate.QuarterId = progressPeriod.tableProgressPeriods.QuarterId;
progressUpdate.Title = progressPeriod.tableProgressPeriods.Title;
progressUpdate.ShortName = progressPeriod.tableProgressPeriods.ShortName;
progressUpdate.SortOrder = progressPeriod.tableProgressPeriods.SortOrder;
progressUpdate.StartDate = progressPeriod.tableProgressPeriods.StartDate;
progressUpdate.EndDate = progressPeriod.tableProgressPeriods.EndDate;
progressUpdate.PostStartDate = progressPeriod.tableProgressPeriods.PostStartDate;
progressUpdate.PostEndDate = progressPeriod.tableProgressPeriods.PostEndDate;
progressUpdate.DoesGrades = progressPeriod.tableProgressPeriods.DoesGrades;
progressUpdate.DoesExam = progressPeriod.tableProgressPeriods.DoesExam;
progressUpdate.DoesComments = progressPeriod.tableProgressPeriods.DoesComments;
progressUpdate.RolloverId = progressPeriod.tableProgressPeriods.RolloverId;
progressUpdate.LastUpdated = progressPeriod.tableProgressPeriods.LastUpdated;
progressUpdate.UpdatedBy = progressPeriod.tableProgressPeriods.UpdatedBy;
this.context?.SaveChanges();
progressPeriod._failure = false;
}
else
{
progressPeriod._failure = false;
progressPeriod._message = "Start Date And End Date of ProgressPeriod Should Be Between Start Date And End Date of Quarter";
}
}
catch (Exception ex)
{
progressPeriod.tableProgressPeriods = null;
progressPeriod._failure = true;
progressPeriod._message = ex.Message;
}
return(progressPeriod);
}
public ProgressPeriodAddViewModel DeleteProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
try
{
var progressPeriodDelete = this.context?.ProgressPeriods.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.MarkingPeriodId);
this.context?.ProgressPeriods.Remove(progressPeriodDelete);
this.context?.SaveChanges();
progressPeriod._failure = false;
progressPeriod._message = "Progress Period Deleted Successfully";
}
catch (Exception es)
{
progressPeriod._failure = true;
progressPeriod._message = es.Message;
}
return(progressPeriod);
}
public ProgressPeriodAddViewModel DeleteProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
ProgressPeriodAddViewModel progressPeriodDelete = new ProgressPeriodAddViewModel();
try
{
if (TokenManager.CheckToken(progressPeriod._tenantName + progressPeriod._userName, progressPeriod._token))
{
progressPeriodDelete = this.markingperiodRepository.DeleteProgressPeriod(progressPeriod);
}
else
{
progressPeriodDelete._failure = true;
progressPeriodDelete._message = TOKENINVALID;
}
}
catch (Exception es)
{
progressPeriodDelete._failure = true;
progressPeriodDelete._message = es.Message;
}
return(progressPeriodDelete);
}
public ProgressPeriodAddViewModel ViewProgressPeriod(ProgressPeriodAddViewModel progressPeriod)
{
ProgressPeriodAddViewModel ProgressPeriodView = new ProgressPeriodAddViewModel();
try
{
var ProgressPeriodById = this.context?.ProgressPeriods.FirstOrDefault(x => x.TenantId == progressPeriod.tableProgressPeriods.TenantId && x.SchoolId == progressPeriod.tableProgressPeriods.SchoolId && x.MarkingPeriodId == progressPeriod.tableProgressPeriods.MarkingPeriodId);
if (ProgressPeriodById != null)
{
ProgressPeriodView.tableProgressPeriods = ProgressPeriodById;
}
else
{
ProgressPeriodView._failure = true;
ProgressPeriodView._message = NORECORDFOUND;
}
}
catch (Exception es)
{
progressPeriod._failure = true;
progressPeriod._message = es.Message;
}
return(ProgressPeriodView);
}
