Example #1
0
        /// <summary>
        /// Monta a clausula Order By
        /// </summary>
        /// <param name="advancedFilter"></param>
        /// <returns></returns>
        private string BuildOrderBy(FilterTemplateRequest advancedFilter)
        {
            var orderByClause = new StringBuilder();

            orderByClause.Append("ORDER BY " + advancedFilter.OrderBy + " " + advancedFilter.Direction);

            return(orderByClause.ToString());
        }
Example #2
0
        /// <summary>
        /// Monta as clausulas Offset e Fetch Next
        /// </summary>
        /// <param name="advancedFilter"></param>
        /// <returns></returns>
        private static string BuildOffSetNumRows(FilterTemplateRequest advancedFilter)
        {
            if (advancedFilter.NumRows == 0)
            {
                return(string.Empty);
            }

            var offSetNumRowsClauses = new StringBuilder();

            offSetNumRowsClauses.Append(" OFFSET " + advancedFilter.OffSet + " ROWS");
            offSetNumRowsClauses.Append(" FETCH NEXT " + advancedFilter.NumRows + " ROWS ONLY");

            return(offSetNumRowsClauses.ToString());
        }
Example #3
0
        /// <summary>
        /// Monta a query
        /// </summary>
        /// <param name="advancedFilter"></param>
        /// <returns></returns>
        private string RecuperarQuery(FilterTemplateRequest advancedFilter)
        {
            var sql           = new StringBuilder();
            var selectClause  = string.Empty;
            var orderByClause = string.Empty;
            var offSetNumRows = string.Empty;

            selectClause  = selectQuery;
            orderByClause = BuildOrderBy(advancedFilter);
            offSetNumRows = BuildOffSetNumRows(advancedFilter);

            sql.Append(selectClause);
            sql.Append(orderByClause);
            sql.Append(offSetNumRows);

            return(sql.ToString());
        }
        //[AllowAnonymous]
        public IHttpActionResult GetAllPaged(FilterTemplateRequest advancedFilter)
        {
            try
            {
                var result = _templateRespostaBusiness.GetAllPaged(advancedFilter);

                var lista       = result.Templates.ToList().Select(Mapper.Map <TemplateResposta, TemplateRespostaResponse>);
                var totalGeral  = result.TotalGeral;
                var totalLinhas = lista.Count();

                //Monta response
                _result = Ok(Retorno <IEnumerable <TemplateRespostaResponse> > .Criar(true, "Consulta Realizada Com Sucesso", lista, totalGeral));

                //Retorna o response
                return(_result);
            }
            catch (Exception)
            {
                throw new HttpResponseException(HttpStatusCode.InternalServerError);
            }
        }
Example #5
0
        /// <summary>
        /// Recupera de forma paginada os templates
        /// </summary>
        /// <param name="advancedFilter"></param>
        /// <returns></returns>
        public TemplatesResponse GetAllPaged(FilterTemplateRequest advancedFilter)
        {
            var result   = new TemplatesResponse();
            var sql      = string.Empty;
            var sqlCount = string.Empty;

            try
            {
                using (var conn = CreateConnection())
                {
                    result.TotalGeral = (int)conn.ExecuteScalar("SELECT COUNT(*) FROM Template_Resposta");

                    sql = RecuperarQuery(advancedFilter);

                    result.Templates = conn.Query <TemplateResposta>(sql).Distinct().ToList();
                }

                return(result);
            }
            catch (Exception)
            {
                throw;
            }
        }
 public TemplatesResponse GetAllPaged(FilterTemplateRequest advancedFilter)
 {
     return(_repository.GetAllPaged(advancedFilter));
 }