public List<AuditTrailEvent> SelectAuditTrailEvents(AuditTrailFilter filter)
{
return _eventManagement.SelectAuditTrailEvents(filter);
}
public List<AuditTrailEvent> SelectAuditTrailEvents(AuditTrailFilter filter)
{
const string q = @"SELECT * FROM dbo.AuditTrailEvents(@from, @to, @user_id, @branch_id, @types, @del)";
List<AuditTrailEvent> retval = new List<AuditTrailEvent>();
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@from", filter.From);
c.AddParam("@to", filter.To);
c.AddParam("@user_id", filter.UserId);
c.AddParam("@branch_id", filter.BranchId);
c.AddParam("@types", filter.Types);
c.AddParam("@del", filter.IncludeDeleted);
using (OpenCbsReader r = c.ExecuteReader())
{
if (r.Empty) return retval;
while (r.Read())
{
AuditTrailEvent e = new AuditTrailEvent
{
Code = r.GetString("event_type"),
Description = r.GetString("description"),
UserName = r.GetString("user_name"),
UserRole = r.GetString("user_role"),
Date = r.GetDateTime("event_date"),
EntryDate = r.GetDateTime("entry_date"),
BranchName = r.GetString("branch_name")
};
retval.Add(e);
}
}
}
return retval;
}
