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"); } }