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