public List <DateTime> GetCalendarNonSetttlementDates(CalendarNonSettlementDateRequest request)
{
var sql = string.Format("select distinct holidaydate from [HELIUM].[marketdata].[dbo].ve_Holiday where [holiday description] = '{2}' and holidaydate between '{0:ddMMMyyyy}' and '{1:ddMMMyyyy}' order by 1", request.CalendarStartDate, request.CalendarEndDate, new TorontoViewController().MapBloombergCalendarCodeToTorontoHolidayDescription(request.SettlementCalendarCode));
var ret = Utils.DbController.GetList <DateTime>(sql);
return(ret);
}
public void EnsureCalendarNonSettlementDateRequestConstructionIsCorrect()
{
var request = new CalendarNonSettlementDateRequest("CALENDAR_NON_SETTLEMENT_DATES[CALENDAR_START_DATE,20131205,CALENDAR_END_DATE,20180123,SETTLEMENT_CALENDAR_CODE,EN]");
Assert.AreEqual(new DateTime(2013, 12, 05), request.CalendarStartDate);
Assert.AreEqual(DateTime.Parse("23jan18"), request.CalendarEndDate);
Assert.AreEqual("EN", request.SettlementCalendarCode);
request = new CalendarNonSettlementDateRequest();
Assert.AreEqual(null, request.SettlementCalendarCode);
Assert.AreEqual(DateTime.MinValue, request.CalendarEndDate);
Assert.AreEqual(DateTime.MinValue, request.CalendarStartDate);
}
