public IActionResult LoadMessages(MessageQueryFilter filter, DataTableQueryRequest request)
        {
            filter.BuildQueryFilter(request);
            IEnumerable <SubscribeMessage> messages;
            int totalCount = 0;

            if (filter.OnlyFailedMessage.HasValue && filter.OnlyFailedMessage.Value)
            {
                messages = MessageSvc.LoadFailedMessages(filter, out totalCount);
            }
            else
            {
                messages = MessageSvc.LoadMessages(filter, out totalCount);
            }

            var data = new
            {
                Success              = true,
                sEcho                = 0,
                iTotalRecords        = totalCount,
                iTotalDisplayRecords = totalCount,
                aaData               = messages
            };

            return(Json(data));
        }