public async Task <ActionResult> Index(int?page, string busca)
{
var response = new ModeracaoLojaRS();
response.Pagination = new PaginationDTO();
response.Avaliacoes = new List <ModeracaoLojaAvaliacaoDTO>();
response.Pagination.ActualPageNumber = page ?? 1;
response.Pagination.RowsPerPage = 25;
response = await _AvaliacaoService.ModeracaoLojasListar(new ModeracaoLojaRQ
{
ActualPageNumber = response.Pagination.ActualPageNumber,
IdCliente = AppUserManager.Usuario.IdCliente,
Busca = busca
});
response.Pagination.ActualPageNumber = page ?? 1;
var aval = new StaticPagedList <ModeracaoLojaAvaliacaoDTO>(response.Avaliacoes.ToList(), response.Pagination.ActualPageNumber, 25, response.Pagination.TotalRows);
ViewBag.TotalRows = response.Pagination.TotalRows;
ViewBag.Avaliacoes = aval;
return(View(aval));
}
public async Task <ModeracaoLojaRS> AvaliacoesAdminLojasListar(ModeracaoLojaRQ request)
{
var avaliacoes = new ModeracaoLojaRS();
avaliacoes.Mensagens = new List <Mensagem>();
avaliacoes.ProtocoloRetorno = Guid.NewGuid();
avaliacoes.Pagination = new PaginationDTO();
avaliacoes.Avaliacoes = new List <ModeracaoLojaAvaliacaoDTO>();
using (var ctx = new DataBaseContext())
{
object[] xParams =
{
new SqlParameter("@IdCliente", request.IdCliente),
new SqlParameter("@ActualPageNumber", request.ActualPageNumber),
new SqlParameter("@Busca", request.Busca.IfEmptyOrWhiteSpace("")),
new SqlParameter("@IdAvaliacaoStatus", StatusAvaliacaoEnum.Aprovado)
};
var db = await ctx.Database.SqlQuery <AvalialiacaoListarPaginaDataMapper>("exec AvaliacaoLojaListarAdmin @IdCliente, @ActualPageNumber, @Busca, @IdAvaliacaoStatus", xParams).ToListAsync();
if (db.Any())
{
avaliacoes.Pagination.TotalRows = db.FirstOrDefault().totalRows;
avaliacoes.Pagination.ActualPageNumber = request.ActualPageNumber;
avaliacoes.Pagination.RowsPerPage = (int)Math.Ceiling(avaliacoes.Pagination.TotalRows / (double)25);
avaliacoes.Pagination.BtnPaginationName = "btnAvalicaoGetPage";
foreach (var item in db)
{
avaliacoes.Avaliacoes.Add(new ModeracaoLojaAvaliacaoDTO
{
Avaliacao = new AvaliacaoDTO
{
IdAvaliacao = item.IdAvaliacao,
ClienteClassificacao = item.ClienteClassificacao,
ClienteTitulo = item.ClienteTitulo,
ClienteComentario = item.ClienteComentario,
DataAvaliacao = item.ClienteDataAvaliacao,
ClienteLocalizacao = item.ClienteLocalizacao,
ClienteNome = item.ClienteNome,
ClienteEmail = item.ClienteEmail,
ClienteRecomenda = item.ClienteRecomenda,
ClienteVerificado = item.ClienteVerificado,
QtdAjudou = item.QtdAjudou,
QtdNaoAjudou = item.QtdNaoAjudou
},
Loja = new LojaDTO
{
IdCliente = request.IdCliente,
LojaCodigo = item.LojaCodigo,
LojaMarketPlace = item.LojaMarketPlace,
LojaNome = item.LojaNome
}
});
}
}
}
return(avaliacoes);
}
