Calculate Business Hours

filter.CollectingHours.Add( new HourRange( new Time( 9 ), new Time( 17, 30 ) ) );

// ----------------------------------------------------------------------
public void BusinessHoursSample()
{
  TimeRange timeRange = new TimeRange(
    new DateTime( 2012, 4, 05, 10, 30, 00 ), // start calc at 10:30 AM
    new DateTime( 2012, 4, 10, 23, 59, 59 ) );

  CalendarDateDiff dateDiff = new CalendarDateDiff();
  dateDiff.WorkingHours.Add( new HourRange( 8, 18 ) );
  dateDiff.AddWorkingWeekDays();
  TimeSpan nonBusinessHours = dateDiff.Difference( timeRange.Start, timeRange.End );

  double businessHours = timeRange.Duration.TotalHours - nonBusinessHours.TotalHours;
  Console.WriteLine( "business hours: " + businessHours );
  // > business hours: 37.5
} // BusinessHoursSample

// ----------------------------------------------------------------------
public void CalendarDateAddSample()
{
  CalendarDateAdd calendarDateAdd = new CalendarDateAdd();
  // weekdays
  calendarDateAdd.AddWorkingWeekDays();
  // holidays
  calendarDateAdd.ExcludePeriods.Add( new Day( 2012, 4, 9, calendarDateAdd.Calendar ) );
  // working hours
  calendarDateAdd.WorkingHours.Add( new HourRange( new Time( 8 ), new Time( 18 ) ) );

  DateTime start = new DateTime( 2011, 4, 6, 6, 0, 0 );
  TimeSpan offset = new TimeSpan( 40, 0, 0 ); // 40 hours
  DateTime? end = calendarDateAdd.Add( start, offset );
  Console.WriteLine( "end: {0}", end );
} // CalendarDateAddSample

bc2m wrote:

Ps: I really appreciate guys like yourself who help and publish on the web. I try to do the same myself with asp.net, c# etc.

public double CalculateBusinessHours()
    {
        TimeRange timeRange = new TimeRange(new DateTime(2012, 4, 10, 10, 00, 00), new DateTime(2012, 4, 15, 13, 00, 00));

        CalendarDateDiff dateDiff = new CalendarDateDiff();
        // working days
        dateDiff.WeekDays.Add(DayOfWeek.Sunday);
        dateDiff.WeekDays.Add(DayOfWeek.Monday);
        dateDiff.WeekDays.Add(DayOfWeek.Tuesday);
        dateDiff.WeekDays.Add(DayOfWeek.Wednesday);
        dateDiff.WeekDays.Add(DayOfWeek.Thursday);
        // working hours
        dateDiff.WorkingHours.Add(new HourRange(new Time(7, 30), new Time(15, 30)));
        // setup holidays to exclude
        var getHolidays = from h in tblHolidays
                          select h;
        foreach (var holiday in getHolidays)
        {
            DateTime startHoliday = holiday.StartDate;
            DateTime endHoliday = holiday.EndDate.AddDays(1);
            //dateDiff.ExcludePeriods.Add(new TimeRange(new DateTime(startHoliday.Year, startHoliday.Month, startHoliday.Day), new DateTime(endHoliday.Year, endHoliday.Month, endHoliday.Day)));
        }

        TimeSpan nonBusinessHours = dateDiff.Difference(timeRange.Start, timeRange.End);
        double businessHours = timeRange.Duration.TotalHours - nonBusinessHours.TotalHours;

        return businessHours;
    }

foreach ( ITimePeriod holiday in holidays )
{
  DateTime day = holiday.Start;
  calendarDateAdd.ExcludePeriods.Add( 
    new Day( day.Year, day.Month, day.Day, calendarDateAdd.Calendar ) );
}

foreach ( ITimePeriod holiday in holidays )
{
  DateTime startDay = holiday.Start;
  int days = holiday.Duration.Days;
  calendarDateAdd.ExcludePeriods.Add( 
    new Days( startDay.Year, startDay.Month, startDay.Day, days, calendarDateAdd.Calendar ) );
}

// ----------------------------------------------------------------------
public void BusinessHoursSample()
{
  TimeRange timeRange = new TimeRange(
    new DateTime( 2012, 4, 06, 10, 30, 00 ),
    new DateTime( 2012, 4, 06, 18, 00, 00 ) );
  double businessHours = CalculateBusinessHours( timeRange );
  Console.WriteLine( "business hours: " + businessHours );
} // BusinessHoursSample

// ----------------------------------------------------------------------
private double CalculateBusinessHours( ITimePeriod timePeriod )
{
  double businessHours = 0;

  // collect filter
  CalendarPeriodCollectorFilter filter = new CalendarPeriodCollectorFilter();
  filter.AddWorkingWeekDays();
  filter.CollectingHours.Add( new HourRange( 8, 18 ) );
  filter.ExcludePeriods.Add( new Day( 2012, 4, 6 ) );
  // mor exclude periods

  // collect the working hours
  TimeRange collectorTimeRange = new TimeRange( timePeriod.Start.Date, timePeriod.End.Date.AddDays( 1 ) );
  TimeCalendar calendar = new TimeCalendar( new TimeCalendarConfig { EndOffset = TimeSpan.Zero } );
  CalendarPeriodCollector collector = new CalendarPeriodCollector( filter, collectorTimeRange, SeekDirection.Forward, calendar );
  collector.CollectHours();
  if ( collector.Periods.Count > 0 )
  {
    // calculate the business hour periods
    collector.Periods.Add( timePeriod ); // add source period to find the intersections
    TimePeriodIntersector<TimeRange> intersector = new TimePeriodIntersector<TimeRange>();
    ITimePeriodCollection businessHourPeriods = intersector.IntersectPeriods( collector.Periods );

    // collect the business hours
    foreach ( TimeRange businessHourPeriod in businessHourPeriods )
    {
      businessHours += businessHourPeriod.Duration.TotalHours;
    }
  }

  return businessHours;
} // CalculateBusinessHours