/// <summary>
/// This is the CSVRowItem constructor.
/// </summary>
/// <param name="item">The row item.</param>
public CalendarDate(CSVRowItem item)
{
//service_id,date,exception_type
mServiceID = item.ValidateNotEmptyOrNull("service_id");
mDate = item["date"].ToDate();
mExceptionType = item["exception_type"].ToCalendarExceptionType();
}
/// <summary>
/// This is the CSVRowItem constructor.
/// </summary>
/// <param name="item">The row item.</param>
public CalendarDate(CSVRowItem item)
{
//service_id,date,exception_type
mServiceID = item.ValidateNotEmptyOrNull("service_id");
mDate = item["date"].ToDate();
mExceptionType=item["exception_type"].ToCalendarExceptionType();
}
/// <summary>
/// The struct constructor.
/// </summary>
/// <param name="ServiceID"></param>
/// <param name="Date"></param>
/// <param name="ExceptionType"></param>
public CalendarDate(
string ServiceID,
DateTime Date,
CalendarExceptionType ExceptionType
)
{
mServiceID = ServiceID;
mDate = Date;
mExceptionType = ExceptionType;
}
/// <summary>
/// The struct constructor.
/// </summary>
/// <param name="ServiceID"></param>
/// <param name="Date"></param>
/// <param name="ExceptionType"></param>
public CalendarDate(
string ServiceID,
DateTime Date,
CalendarExceptionType ExceptionType
)
{
mServiceID = ServiceID;
mDate=Date ;
mExceptionType = ExceptionType;
}
private static void CacheExceptionsTable(ref SQLiteDataReader reader,
ref int processedRowCount, Stopwatch timeSoFar, ref string current_table_name,
Action displayTableName, Action <int, Stopwatch> updateTimeUI,
ref Dictionary <string, Dictionary <DateTime, CalendarExceptionType> > calExceptions)
{
// Update the table name shown on the progress form
if (displayTableName != null)
{
displayTableName();
}
// Loop through the calendar_dates table and add the information to a dictionary keyed by service_id
try
{
while (reader.Read())
{
++processedRowCount;
if (updateTimeUI != null)
{
updateTimeUI(processedRowCount, timeSoFar);
}
String sDate = reader["date"].ToString();
DateTime Date = DateTime.ParseExact(sDate,
"yyyyMMdd",
System.Globalization.CultureInfo.InvariantCulture,
System.Globalization.DateTimeStyles.None);
Int16 exception_type_int = Convert.ToInt16(reader["exception_type"].ToString());
CalendarExceptionType exception_type = (CalendarExceptionType)exception_type_int;
string service_id = reader["service_id"].ToString();
// Add the exception to the dictionary under the appropriate service_id.
if (calExceptions.ContainsKey(service_id))
{
calExceptions[service_id].Add(Date, exception_type);
}
else
{
calExceptions.Add(service_id, new Dictionary <DateTime, CalendarExceptionType> {
{ Date, exception_type }
});
}
}
}
catch (Exception e)
{
throw new Exception("Error caching calendar exceptions. Error: " + e.Message, e);
}
}
