private static void CalcRunDatesWeekly(Schedule schedule, ScheduleDet occurrence) { DateTime?nextRunDateL = schedule.NextRunDate; DateTime?iteratorDate = schedule.NextRunDate; DateTime?scheduledDateL = null; do { DayOfWeek dayOfWeek = ((DateTime)iteratorDate).DayOfWeek; if (schedule.WeeklyOnDay1 == true && dayOfWeek == DayOfWeek.Sunday || schedule.WeeklyOnDay2 == true && dayOfWeek == DayOfWeek.Monday || schedule.WeeklyOnDay3 == true && dayOfWeek == DayOfWeek.Tuesday || schedule.WeeklyOnDay4 == true && dayOfWeek == DayOfWeek.Wednesday || schedule.WeeklyOnDay5 == true && dayOfWeek == DayOfWeek.Thursday || schedule.WeeklyOnDay6 == true && dayOfWeek == DayOfWeek.Friday) { if (scheduledDateL == null) { scheduledDateL = iteratorDate; } else { nextRunDateL = iteratorDate; } } else if (dayOfWeek == DayOfWeek.Saturday) { if (schedule.WeeklyOnDay7 == true) { if (scheduledDateL == null) { scheduledDateL = iteratorDate; } else { nextRunDateL = iteratorDate; } } if (nextRunDateL == schedule.NextRunDate) { iteratorDate = ((DateTime)iteratorDate).AddDays(7 * ((short)schedule.WeeklyFrequency - 1) + 1); continue; } } iteratorDate = ((DateTime)iteratorDate).AddDays(1); }while (nextRunDateL == schedule.NextRunDate); schedule.NextRunDate = nextRunDateL; occurrence.ScheduledDate = scheduledDateL; }
private static void CalcRunDatesWeekly(Schedule s, ScheduleDet d) { DateTime?nextRunDateL = s.NextRunDate, iteratorDate = s.NextRunDate; DateTime?scheduledDateL = null; do { DayOfWeek dow = ((DateTime)iteratorDate).DayOfWeek; if ((bool)s.WeeklyOnDay1 && dow == DayOfWeek.Sunday || (bool)s.WeeklyOnDay2 && dow == DayOfWeek.Monday || (bool)s.WeeklyOnDay3 && dow == DayOfWeek.Tuesday || (bool)s.WeeklyOnDay4 && dow == DayOfWeek.Wednesday || (bool)s.WeeklyOnDay5 && dow == DayOfWeek.Thursday || (bool)s.WeeklyOnDay6 && dow == DayOfWeek.Friday) { if (scheduledDateL == null) { scheduledDateL = iteratorDate; } else { nextRunDateL = iteratorDate; } } else if (dow == DayOfWeek.Saturday) { if ((bool)s.WeeklyOnDay7) { if (scheduledDateL == null) { scheduledDateL = iteratorDate; } else { nextRunDateL = iteratorDate; } } if (nextRunDateL == s.NextRunDate) { iteratorDate = ((DateTime)iteratorDate).AddDays(7 * ((short)s.WeeklyFrequency - 1) + 1); continue; } } iteratorDate = ((DateTime)iteratorDate).AddDays(1); } while (nextRunDateL == s.NextRunDate); s.NextRunDate = nextRunDateL; d.ScheduledDate = scheduledDateL; }
public static List <ScheduleDet> MakeSchedule(PXGraph graph, Schedule s, short Times, DateTime runDate) { List <ScheduleDet> ret = new List <ScheduleDet>(); if (s.NextRunDate == null && s.LastRunDate == null) { s.NextRunDate = s.StartDate; } else if (s.NextRunDate == null) { s.NextRunDate = s.LastRunDate; } int i = 0; short oldRunCntr = s.RunCntr ?? 0; do { ScheduleDet d = new ScheduleDet(); do { switch (s.ScheduleType) { case "D": d.ScheduledDate = s.NextRunDate; s.NextRunDate = ((DateTime)s.NextRunDate).AddDays((short)s.DailyFrequency); break; case "W": CalcRunDatesWeekly(s, d); break; case "P": try { switch (s.PeriodDateSel) { case "S": d.ScheduledDate = FinPeriodIDAttribute.PeriodStartDate(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate)); s.NextRunDate = FinPeriodIDAttribute.PeriodStartDate(graph, FinPeriodIDAttribute.PeriodPlusPeriod(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate), (short)s.PeriodFrequency)); break; case "E": d.ScheduledDate = FinPeriodIDAttribute.PeriodEndDate(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate)); s.NextRunDate = FinPeriodIDAttribute.PeriodEndDate(graph, FinPeriodIDAttribute.PeriodPlusPeriod(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate), (short)s.PeriodFrequency)); break; case "D": d.ScheduledDate = FinPeriodIDAttribute.PeriodStartDate(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate)).AddDays((short)s.PeriodFixedDay - 1); if (((DateTime)d.ScheduledDate).CompareTo(FinPeriodIDAttribute.PeriodEndDate(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate))) > 0) { d.ScheduledDate = FinPeriodIDAttribute.PeriodEndDate(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate)); } DateTime?OldNextRunDate = s.NextRunDate; s.NextRunDate = FinPeriodIDAttribute.PeriodStartDate(graph, FinPeriodIDAttribute.PeriodPlusPeriod(graph, FinPeriodIDAttribute.PeriodFromDate(graph, s.NextRunDate), (short)s.PeriodFrequency)).AddDays((short)s.PeriodFixedDay - 1); if (((DateTime)s.NextRunDate).CompareTo(FinPeriodIDAttribute.PeriodEndDate(graph, FinPeriodIDAttribute.PeriodPlusPeriod(graph, FinPeriodIDAttribute.PeriodFromDate(graph, OldNextRunDate), (short)s.PeriodFrequency))) > 0) { s.NextRunDate = FinPeriodIDAttribute.PeriodEndDate(graph, FinPeriodIDAttribute.PeriodPlusPeriod(graph, FinPeriodIDAttribute.PeriodFromDate(graph, OldNextRunDate), (short)s.PeriodFrequency)); } break; } } catch (PXFinPeriodException) { if (d.ScheduledDate != null && (bool)s.NoRunLimit == false && s.RunCntr + 1 == s.RunLimit) { s.NextRunDate = null; } else { s.RunCntr = oldRunCntr; throw; } } break; case "M": switch (s.MonthlyDaySel) { case "D": d.ScheduledDate = new PXDateTime((short)((DateTime)s.NextRunDate).Year, (short)((DateTime)s.NextRunDate).Month, (short)s.MonthlyOnDay); s.NextRunDate = PXDateTime.DatePlusMonthSetDay((DateTime)d.ScheduledDate, (short)s.MonthlyFrequency, (short)s.MonthlyOnDay); break; case "W": d.ScheduledDate = PXDateTime.MakeDayOfWeek((short)((DateTime)s.NextRunDate).Year, (short)((DateTime)s.NextRunDate).Month, (short)s.MonthlyOnWeek, (short)s.MonthlyOnDayOfWeek); //s.NextRunDate = ((DateTime)d.ScheduledDate).AddMonths((short)s.MonthlyFrequency); s.NextRunDate = new PXDateTime(((DateTime)d.ScheduledDate).Year, ((DateTime)d.ScheduledDate).Month, 1).AddMonths((short)s.MonthlyFrequency); s.NextRunDate = PXDateTime.MakeDayOfWeek((short)((DateTime)s.NextRunDate).Year, (short)((DateTime)s.NextRunDate).Month, (short)s.MonthlyOnWeek, (short)s.MonthlyOnDayOfWeek); break; } break; default: throw new PXException(); } } while (d.ScheduledDate == s.LastRunDate); if (d.ScheduledDate != null && ((DateTime)d.ScheduledDate).CompareTo(s.StartDate) >= 0 && ((bool)s.NoEndDate || ((DateTime)d.ScheduledDate).CompareTo(s.EndDate) <= 0) && (((DateTime)d.ScheduledDate).CompareTo(runDate) <= 0) && ((bool)s.NoRunLimit || s.RunCntr < s.RunLimit)) { try { d.ScheduledPeriod = FinPeriodIDAttribute.PeriodFromDate(graph, d.ScheduledDate); } catch { s.RunCntr = oldRunCntr; throw; } ret.Add(d); s.RunCntr++; if ((bool)s.NoRunLimit == false && s.RunCntr >= s.RunLimit || (s.NextRunDate != null) && (bool)s.NoEndDate == false && ((DateTime)s.NextRunDate).CompareTo(s.EndDate) > 0) { s.Active = false; s.NextRunDate = null; } if (s.NextRunDate == null) { break; } if (++i >= Times) { return(ret); } } else { if (d.ScheduledDate != null) { s.NextRunDate = d.ScheduledDate; } break; } } while (true); return(ret); }
public virtual IEnumerable <ScheduleDet> MakeSchedule( Schedule scheduleParameters, short numberOccurrences, DateTime?runDate = null) { runDate = runDate ?? _graph.Accessinfo.BusinessDate; List <ScheduleDet> scheduleOccurrences = new List <ScheduleDet>(); if (scheduleParameters.NextRunDate == null && scheduleParameters.LastRunDate == null) { scheduleParameters.NextRunDate = scheduleParameters.StartDate; } else if (scheduleParameters.NextRunDate == null) { scheduleParameters.NextRunDate = scheduleParameters.LastRunDate; } int occurrencesCreated = 0; short oldRunCounter = scheduleParameters.RunCntr ?? 0; do { ScheduleDet occurrence = new ScheduleDet(); do { switch (scheduleParameters.ScheduleType) { case GLScheduleType.Daily: occurrence.ScheduledDate = scheduleParameters.NextRunDate; scheduleParameters.NextRunDate = ((DateTime)scheduleParameters.NextRunDate).AddDays((short)scheduleParameters.DailyFrequency); break; case GLScheduleType.Weekly: CalcRunDatesWeekly(scheduleParameters, occurrence); break; case GLScheduleType.Periodically: try { switch (scheduleParameters.PeriodDateSel) { case PeriodDateSelOption.PeriodStart: occurrence.ScheduledDate = _financialPeriodProvider.PeriodStartDate(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate)); scheduleParameters.NextRunDate = _financialPeriodProvider.PeriodStartDate(_graph, _financialPeriodProvider.PeriodPlusPeriod(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate), (short)scheduleParameters.PeriodFrequency)); break; case PeriodDateSelOption.PeriodEnd: occurrence.ScheduledDate = _financialPeriodProvider.PeriodEndDate(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate)); scheduleParameters.NextRunDate = _financialPeriodProvider.PeriodEndDate(_graph, _financialPeriodProvider.PeriodPlusPeriod(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate), (short)scheduleParameters.PeriodFrequency)); break; case PeriodDateSelOption.PeriodFixedDate: occurrence.ScheduledDate = _financialPeriodProvider.PeriodStartDate(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate)).AddDays((short)scheduleParameters.PeriodFixedDay - 1); if (((DateTime)occurrence.ScheduledDate).CompareTo(_financialPeriodProvider.PeriodEndDate(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate))) > 0) { occurrence.ScheduledDate = _financialPeriodProvider.PeriodEndDate(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate)); } DateTime?OldNextRunDate = scheduleParameters.NextRunDate; scheduleParameters.NextRunDate = _financialPeriodProvider.PeriodStartDate(_graph, _financialPeriodProvider.PeriodPlusPeriod(_graph, _financialPeriodProvider.PeriodFromDate(_graph, scheduleParameters.NextRunDate), (short)scheduleParameters.PeriodFrequency)).AddDays((short)scheduleParameters.PeriodFixedDay - 1); if (((DateTime)scheduleParameters.NextRunDate).CompareTo(_financialPeriodProvider.PeriodEndDate(_graph, _financialPeriodProvider.PeriodPlusPeriod(_graph, _financialPeriodProvider.PeriodFromDate(_graph, OldNextRunDate), (short)scheduleParameters.PeriodFrequency))) > 0) { scheduleParameters.NextRunDate = _financialPeriodProvider.PeriodEndDate(_graph, _financialPeriodProvider.PeriodPlusPeriod(_graph, _financialPeriodProvider.PeriodFromDate(_graph, OldNextRunDate), (short)scheduleParameters.PeriodFrequency)); } break; } } catch (PXFinPeriodException financialPeriodException) { if (occurrence.ScheduledDate != null && (bool)scheduleParameters.NoRunLimit == false && scheduleParameters.RunCntr + 1 == scheduleParameters.RunLimit && scheduleParameters.NextRunDate != null) { scheduleParameters.NextRunDate = null; } else { scheduleParameters.RunCntr = oldRunCounter; throw new PXFinPeriodException( financialPeriodException, Messages.NoFinancialPeriodForNextExecutionDate); } } break; case GLScheduleType.Monthly: switch (scheduleParameters.MonthlyDaySel) { case "D": occurrence.ScheduledDate = new PXDateTime((short)((DateTime)scheduleParameters.NextRunDate).Year, (short)((DateTime)scheduleParameters.NextRunDate).Month, (short)scheduleParameters.MonthlyOnDay); scheduleParameters.NextRunDate = PXDateTime.DatePlusMonthSetDay((DateTime)occurrence.ScheduledDate, (short)scheduleParameters.MonthlyFrequency, (short)scheduleParameters.MonthlyOnDay); break; case "W": occurrence.ScheduledDate = PXDateTime.MakeDayOfWeek((short)((DateTime)scheduleParameters.NextRunDate).Year, (short)((DateTime)scheduleParameters.NextRunDate).Month, (short)scheduleParameters.MonthlyOnWeek, (short)scheduleParameters.MonthlyOnDayOfWeek); scheduleParameters.NextRunDate = new PXDateTime(((DateTime)occurrence.ScheduledDate).Year, ((DateTime)occurrence.ScheduledDate).Month, 1).AddMonths((short)scheduleParameters.MonthlyFrequency); scheduleParameters.NextRunDate = PXDateTime.MakeDayOfWeek((short)((DateTime)scheduleParameters.NextRunDate).Year, (short)((DateTime)scheduleParameters.NextRunDate).Month, (short)scheduleParameters.MonthlyOnWeek, (short)scheduleParameters.MonthlyOnDayOfWeek); break; } break; default: throw new PXException(); } } while (occurrence.ScheduledDate == scheduleParameters.LastRunDate); if (occurrence.ScheduledDate != null && ((DateTime)occurrence.ScheduledDate).CompareTo(scheduleParameters.StartDate) >= 0 && ((bool)scheduleParameters.NoEndDate || ((DateTime)occurrence.ScheduledDate).CompareTo(scheduleParameters.EndDate) <= 0) && (((DateTime)occurrence.ScheduledDate).CompareTo(runDate) <= 0) && ((bool)scheduleParameters.NoRunLimit || scheduleParameters.RunCntr < scheduleParameters.RunLimit)) { try { occurrence.ScheduledPeriod = _financialPeriodProvider.PeriodFromDate(_graph, occurrence.ScheduledDate); } catch (PXFinPeriodException financialPeriodException) { scheduleParameters.RunCntr = oldRunCounter; throw new PXFinPeriodException( financialPeriodException, Messages.NoFinancialPeriodForNextExecutionDate); } scheduleOccurrences.Add(occurrence); scheduleParameters.RunCntr++; if ((bool)scheduleParameters.NoRunLimit == false && scheduleParameters.RunCntr >= scheduleParameters.RunLimit || (scheduleParameters.NextRunDate != null) && (bool)scheduleParameters.NoEndDate == false && ((DateTime)scheduleParameters.NextRunDate).CompareTo(scheduleParameters.EndDate) > 0) { scheduleParameters.Active = false; scheduleParameters.NextRunDate = null; } if (scheduleParameters.NextRunDate == null) { break; } if (++occurrencesCreated >= numberOccurrences) { return(scheduleOccurrences); } } else { if (((DateTime)occurrence.ScheduledDate).CompareTo(scheduleParameters.StartDate) < 0) { continue; } if (occurrence.ScheduledDate != null) { scheduleParameters.NextRunDate = occurrence.ScheduledDate; } break; } } while (true); return(scheduleOccurrences); }