public static List <FactAlert> GetAlerts(this DatabaseWrapper conn)
{
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM Fact_Alert;";
List <FactAlert> data = new List <FactAlert>();
using (IDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
FactAlert obj = new FactAlert();
obj.Alerttime = (DateTime)reader["alerttime"];
obj.Alerttype = (string)reader["alerttype"];
obj.Alertruleid = (long)reader["alertruleid"];
obj.Trackerserial = (string)reader["trackerserial"];
obj.Severity = (string)reader["severity"];
obj.Alerttitle = (DBNull.Value == reader["alerttitle"]) ? null : (string)reader["alerttitle"];
obj.Alertactivity = (long)reader["alertactivity"];
obj.Rulerecid = (long)reader["rulerecid"];
obj.Alertclear = (DBNull.Value == reader["alertclear"]) ? null : (DateTime?)reader["alertclear"];
data.Add(obj);
}
}
return(data);
}
public bool Equals(FactAlert other)
{
return(Alerttime == other.Alerttime &&
Alerttype == other.Alerttype &&
Alertruleid == other.Alertruleid &&
Trackerserial == other.Trackerserial &&
Severity == other.Severity &&
Alerttitle == other.Alerttitle &&
Alertactivity == other.Alertactivity &&
Rulerecid == other.Rulerecid &&
Alertclear == other.Alertclear);
}
