/// <summary>
/// Load activities from DB
/// </summary>
public static SiteActivityCollection Load(SiteActivityFilter filter)
{
SiteActivityCollection activities = new SiteActivityCollection();
SiteActivity a;
Data.Sql db = new Data.Sql();
Data.SqlReader reader;
BuildCommand(db, filter);
try {
reader = db.GetReader();
} catch (System.Exception ex) {
Idaho.Exception.Log(ex);
return(null);
}
while (reader.Read())
{
a = new SiteActivity();
a.Type = (SiteActivity.Types)reader.GetInt32("Type");
a.IpAddress = reader.GetIpAddress("IpAddress");
a.Note = reader.GetString("Note");
a.On = reader.GetDateTime("HappenedOn");
activities.Add(a);
}
reader.Close();
db.Finish(true);
return(activities);
}
/// <summary>
/// Construct sorted dictionary from SQL object and key/value field names
/// </summary>
public static SortedDictionary <K, V> Load(Data.Sql sql, string keyField, string valueField)
{
SortedDictionary <K, V> sorted = new SortedDictionary <K, V>();
SqlReader reader = sql.GetReader(true);
while (reader.Read())
{
sorted.Add(reader.GetValue <K>(keyField), reader.GetValue <V>(valueField));
}
return(sorted);
}
/// <summary>
/// Load indicators using SQL object (assumes standard column names)
/// </summary>
public static IndicatorCollection <T> Load(Data.Sql sql)
{
IndicatorCollection <T> list = new IndicatorCollection <T>();
T i;
SqlReader reader = sql.GetReader(true);
while (reader.Read())
{
i = new T();
i.Level = reader.GetInt32("Level");
i.Name = reader.GetString("Name");
i.Description = reader.GetString("Description");
i.Tag = reader.GetString("Abbreviation");
list.Add(i);
}
sql.Finish();
return(list);
}
