public static object AddBusinessDays(PXGraph graph, string calendarID, DateTime date, int daysToAdd)
{
CSCalendar calendar = PXSelect <CSCalendar> .Search <CSCalendar.calendarID>(graph, calendarID);
CSCalendarExt calendarExt = calendar.GetExtension <CSCalendarExt>();
if (calendar == null)
{
throw new InvalidOperationException(PX.Objects.CR.Messages.FailedToSelectCalenderId);
}
else if (calendar.SunGoodsMoves == false && calendar.MonGoodsMoves == false && calendar.TueGoodsMoves == false && calendar.WedGoodsMoves == false && calendar.ThuGoodsMoves == false && calendar.FriGoodsMoves == false && calendar.SatGoodsMoves == false && calendar.SunGoodsMoves == false)
{
throw new InvalidOperationException(Messages.CalendarGoodsMoveDaysNotConfigured);
}
//Load upcoming exceptions for next 60 days
var calendarExceptions = PXSelect <CSCalendarExceptions,
Where <CSCalendarExceptions.date, Between <Required <CSCalendarExceptions.date>, Required <CSCalendarExceptions.date> > > > .Select(graph, date, date.AddDays(60))
.RowCast <CSCalendarExceptions>();
//Based on cutoff time and exceptions, find how soon this order will ship
while (daysToAdd > 0)
{
date = date.AddDays(1);
if (IsWarehouseDay(calendar, calendarExceptions, date))
{
daysToAdd--;
}
}
return(date);
}
public static DateTime GetClosestWarehouseDay(PXGraph graph, string calendarID, DateTime date)
{
CSCalendar calendar = PXSelect <CSCalendar> .Search <CSCalendar.calendarID>(graph, calendarID);
CSCalendarExt calendarExt = calendar.GetExtension <CSCalendarExt>();
if (calendar == null)
{
throw new InvalidOperationException(PX.Objects.CR.Messages.FailedToSelectCalenderId);
}
else if (calendar.SunGoodsMoves == false && calendar.MonGoodsMoves == false && calendar.TueGoodsMoves == false && calendar.WedGoodsMoves == false && calendar.ThuGoodsMoves == false && calendar.FriGoodsMoves == false && calendar.SatGoodsMoves == false && calendar.SunGoodsMoves == false)
{
throw new InvalidOperationException(Messages.CalendarGoodsMoveDaysNotConfigured);
}
//Identify cutoff time for order processing (we look at the time order was _placed_ to determine if it's before or after cutoff)
TimeSpan?cutoffTime = null;
switch (date.DayOfWeek)
{
case DayOfWeek.Sunday:
cutoffTime = calendarExt.UsrSunCutoffTime?.TimeOfDay;
break;
case DayOfWeek.Monday:
cutoffTime = calendarExt.UsrMonCutoffTime?.TimeOfDay;
break;
case DayOfWeek.Tuesday:
cutoffTime = calendarExt.UsrTueCutoffTime?.TimeOfDay;
break;
case DayOfWeek.Wednesday:
cutoffTime = calendarExt.UsrWedCutoffTime?.TimeOfDay;
break;
case DayOfWeek.Thursday:
cutoffTime = calendarExt.UsrThuCutoffTime?.TimeOfDay;
break;
case DayOfWeek.Friday:
cutoffTime = calendarExt.UsrFriCutoffTime?.TimeOfDay;
break;
case DayOfWeek.Saturday:
cutoffTime = calendarExt.UsrSatCutoffTime?.TimeOfDay;
break;
}
DateTime closestWarehouseDay;
if (cutoffTime != null && date.TimeOfDay > cutoffTime)
{
closestWarehouseDay = date.AddDays(1).Date;
}
else
{
closestWarehouseDay = date.Date;
}
//Load upcoming exceptions for next 60 days
var calendarExceptions = PXSelect <CSCalendarExceptions,
Where <CSCalendarExceptions.date, Between <Required <CSCalendarExceptions.date>, Required <CSCalendarExceptions.date> > > > .Select(graph, closestWarehouseDay, closestWarehouseDay.AddDays(60))
.RowCast <CSCalendarExceptions>();
//Based on cutoff time and exceptions, find how soon this order will ship
bool isWarehouseDay = false;
while (!isWarehouseDay)
{
isWarehouseDay = IsWarehouseDay(calendar, calendarExceptions, closestWarehouseDay);
if (!isWarehouseDay)
{
closestWarehouseDay = closestWarehouseDay.AddDays(1);
}
}
return(closestWarehouseDay);
}
