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