I need to ignore the Weekend days and other government announced holiday list.
This will used to find the day was a holiday or not in the given date range.
public DataSet ShowHolidays()
{
DataSet ds = new DataSet();
ds.ReadXml(@"D:\\holiday.xml");
return ds;
}
I am maintaining the holiday list xml file2011/07/04 2011/07/05 2011/07/06
ArrayList list = new ArrayList();
public bool IsHolidays(DateTime dt1)
{
DataSet d1 = ShowHolidays();
foreach (DataRow row in d1.Tables[0].Rows)
{
list.Add(Convert.ToDateTime(row["Dates_Text"]).ToShortDateString());
}
return list.Contains(dt.ToShortDateString());
}