Work Calendar (Calendars)

By Acty, November 13, 2013

Description

Work Calendar is working calendar (or business calendar) algorithm for .Net framework, give a start time and duration(such as 10 hours or 30 minutes) then it calculate the end time skip the non-working time such as saturday, sunday and holidays.

Features

1. Add duration to time, skip the non-working time
2. Calculate duration, only contain working time
3. Get nearest working time, skip the non-working time
4. Define a work calendar in xml format

Package Content

Folder

• src —–—–—–—–—– source code and unit test.
• bin —–—–—–—–—– binary file.

How to define work calendar

Calendar is define in xml, it contain the three type day: normal day, work day and holiday.
Sample calendar:

    <?xml version="1.0" encoding="UTF-8"?>
    <business-calendar hoursperday="6.5">
        <monday    hours="9:00-12:00 "/>
        <tuesday   hours="9:00-12:00 and 12:30-17:00 and 19:00 - 20:00"/>
        <wednesday hours="9:00-12:00 and 12:30-17:00"/>
        <thursday  hours="9:00-12:00 and 12:30-17:00"/>
        <friday    hours="9:00-12:00 and 12:30-17:00"/>

        <workday period="2/28/2013" hours="9:00-11:00" />
        <workday period="3/2/2013" hours="9:00-12:00" />

        <holiday period="3/5/2013 - 3/7/2013"/>
        <holiday period="3/14/2013"/>
    </business-calendar>

How to use it

• parse calendar xml to calendar object

  string calendarFilePath = @"calendar.xml";
  string calendarXml = "";
  using (StreamReader sr = new StreamReader(calendarFilePath))
  {
      calendarXml = sr.ReadToEnd();
  }
  CalendarParser parser = new CalendarParser();
  ICalendar calendar = parser.Parse(calendarXml);
  

• Add duration to time, skip the non-working time

  DateTime startTime = DateTime.Now;
  long seconds = 3600;
  DateTime endTime = calendar.Add(startTime, seconds);
  

• Calculate duration, only contain working time

  startTime = new DateTime(2013, 1, 1, 8, 30, 0);
  endTime = new DateTime(2013, 1, 5, 10, 30, 0);
  long duration = calendar.CalculateDuration(startTime, endTime);
  

• get nearest working time, skip the non-working time

  startTime = new DateTime(2013, 1, 1, 8, 0, 0);
  DateTime workingTime = calendar.GetNearestWorkingTime(startTime);
  

Support

Once again, As I said at the beginning, I’d be glad to help you if you have any questions relating to this code. I’ll do my best to assist. Thanks so much!.