/// <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);
}
//private Int64 Save() { return this.Save(this); }
/// <summary>
/// Persist exception data
/// </summary>
/// <returns>Log number</returns>
private Int64 Save()
{
_recurseCount += 1;
// recursively save inner exceptions
if (_inner != null)
{
_innerID = _inner.Save();
_recurseCount -= 1;
}
Data.Sql sql = new Data.Sql();
sql.ProcedureName = "SaveException";
sql.Parameters.IgnoreNull = true;
sql.Parameters.Add("type", (int)_type, SqlDbType.Int);
sql.Parameters.Add("message", _message, SqlDbType.VarChar);
sql.Parameters.Add("stack", _stack, SqlDbType.VarChar);
sql.Parameters.Add("machine", _machineName, SqlDbType.VarChar);
sql.Parameters.Add("process", _process, SqlDbType.VarChar);
if (_recurseCount == 0 && !string.IsNullOrEmpty(_note))
{
// only save note for outermost exception
sql.Parameters.Add("note", _note.SafeForWeb(500), SqlDbType.VarChar);
}
// client
if (_user != null)
{
sql.Parameters.Add("userID", _user.ID, SqlDbType.UniqueIdentifier);
}
if (_userIP != null)
{
sql.Parameters.Add("ipAddress", _userIP.ToInt32(), SqlDbType.Int);
}
sql.Parameters.Add("browser", _browser, SqlDbType.VarChar);
sql.Parameters.Add("cookies", _cookies, SqlDbType.VarChar);
// meta
sql.Parameters.Add("innerID", _innerID, SqlDbType.BigInt);
//sql.Parameters.Add("emailed", ex);
// page
sql.Parameters.Add("context", _pageName, SqlDbType.VarChar);
sql.Parameters.Add("queryString", _queryString, SqlDbType.VarChar);
try { _id = sql.GetReturn(); }
catch { _id = 0; }
finally { sql.Finish(true); }
return(_id);
}
/// <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);
}
