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