private static void HolidaysToSql()
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
if (TableRowCount(con, "Holiday") > 0)
{
return;
}
SqlTransaction tx = con.BeginTransaction();
SqlCommand cmd = new SqlCommand("INSERT INTO Holiday (Date) VALUES (@date)", con, tx);
SqlParameter date = cmd.Parameters.Add("@date", SqlDbType.DateTimeOffset);
foreach (int year in SeasonYears)
{
foreach (DateTime holiday in Holidays.PublicHolidays(year))
{
date.Value = new DateTimeOffset(holiday);
cmd.ExecuteNonQuery();
}
}
tx.Commit();
}
}
public static bool IsHoliday(this DateTime originalDate)
{
// INSERT YOUR HOLIDAY-CODE HERE!
if (_holidayCalendar.PublicHolidays(originalDate.Year).Contains(originalDate.Date))
{
return(true);
}
return(false);
}
public void TestPublicHolidayInformation()
{
var usaPublicHoliday = new USAPublicHoliday();
var hols = usaPublicHoliday.PublicHolidays(2017);
var infos = usaPublicHoliday.PublicHolidaysInformation(2017);
Assert.AreEqual(hols.Count, infos.Count);
foreach (var info in infos)
{
Assert.IsTrue(hols.Contains(info), "observed date is implicitly in both lists");
}
}
