Пример #1
0
        public IActionResult RunGraphics(BaseBuscaViewModel baseBusca)
        {
            var            indexBase    = baseBusca.Name;
            IList <string> selectFilter = null;
            IEnumerable <Tuple <string, string, string> > filterFilter = null;

            if (baseBusca.ColumnsSelect != null)
            {
                if (baseBusca.ColumnsSelect.Count() > 0)
                {
                    selectFilter = baseBusca.ColumnsSelect.Select(a => a.Descricao).ToList();
                }
            }

            if (baseBusca.ColumnsFilter != null)
            {
                if (baseBusca.ColumnsFilter.Count() > 0)
                {
                    filterFilter = baseBusca.ColumnsFilter.Select(a => new Tuple <string, string, string>(a.Descricao, a.FilterType, a.ValueFilter));
                }
            }

            try
            {
                var resultsDictionarys = this.ArquivoBaseBusiness.QueryGroupData(indexBase, selectFilter, filterFilter, baseBusca.NumberEntries, baseBusca.AllEntries);

                return(Ok(resultsDictionarys));
            }
            catch (Exception erro)
            {
                throw erro;
            }
        }
Пример #2
0
        public IActionResult Run(BaseBuscaViewModel baseBusca)
        {
            var            indexBase    = baseBusca.Name;
            IList <string> selectFilter = null;
            IEnumerable <Tuple <string, string, string> > filterFilter = null;

            if (baseBusca.ColumnsSelect != null)
            {
                if (baseBusca.ColumnsSelect.Count() > 0)
                {
                    selectFilter = baseBusca.ColumnsSelect.Select(a => a.Descricao).ToList();
                }
            }

            if (baseBusca.ColumnsFilter != null)
            {
                if (baseBusca.ColumnsFilter.Count() > 0)
                {
                    filterFilter = baseBusca.ColumnsFilter.Select(a => new Tuple <string, string, string>(a.Descricao, a.FilterType, a.ValueFilter));
                }
            }

            try
            {
                var fileName = this.ArquivoBaseBusiness.ConsultaToCSV(User, indexBase, selectFilter, filterFilter, baseBusca.NumberEntries, baseBusca.AllEntries);
                var guid     = Guid.NewGuid().ToString();

                TempData.Put(guid, new Tuple <string, string>(fileName, $"{indexBase}.csv"));

                return(Ok(new { fileGuid = guid }));
            }
            catch (Exception erro)
            {
                throw erro;
            }
        }