public ActionResult Index(int?page)
{
var pagination = new PaginationDTO();
pagination.ActualPageNumber = (page ?? 1);
var model = new RelatoriosDeLojas();
model.Lojas = new List <LojaModel>();
model.TopMaisAvaliado = new List <LojaModel>();
model.TopMenosAvaliado = new List <LojaModel>();
model = relRepo.RelTopLojas(AppUserManager.Usuario.IdCliente, 1);
if (model.Lojas != null && model.Lojas.Any())
{
pagination.RowsPerPage = model.Lojas.FirstOrDefault().RowsPerPage;
pagination.TotalRows = model.Lojas.FirstOrDefault().TotalRows;
var lojas = new StaticPagedList <LojaModel>(model.Lojas.ToList(), pagination.ActualPageNumber, pagination.RowsPerPage, pagination.TotalRows);
ViewBag.Lojas = lojas;
}
else
{
ViewBag.Lojas = new List <LojaModel>();;
ViewBag.Lojas = new StaticPagedList <LojaModel>(model.Lojas.ToList(), 1, 1, pagination.TotalRows);
}
return(View(model));
}
public RelatoriosDeLojas RelTopLojas(int?idCliente, int page)
{
var model = new RelatoriosDeLojas();
model.Lojas = new List <LojaModel>();
model.TopMaisAvaliado = new List <LojaModel>();
model.TopMenosAvaliado = new List <LojaModel>();
using (var ctx = new DataBaseContext())
{
var cmd = ctx.Database.Connection.CreateCommand();
cmd.CommandText = "exec RelLojas 1,1";
ctx.Database.Connection.Open();
var reader = cmd.ExecuteReader();
model.TopMaisAvaliado = ((IObjectContextAdapter)ctx).ObjectContext.Translate <LojaModel>(reader).ToList();
model.TopMaisAvaliado.ForEach(x =>
{
x.MediaTotal = StringExtensions.RetornaClassificacaoGeral(x.s1, x.s2, x.s3, x.s4, x.s5, x.TotalAvaliacoes);
});
reader.NextResult();
model.TopMenosAvaliado = ((IObjectContextAdapter)ctx).ObjectContext.Translate <LojaModel>(reader).ToList();
model.TopMenosAvaliado.ForEach(x =>
{
x.MediaTotal = StringExtensions.RetornaClassificacaoGeral(x.s1, x.s2, x.s3, x.s4, x.s5, x.TotalAvaliacoes);
});
reader.NextResult();
model.Lojas = ((IObjectContextAdapter)ctx).ObjectContext.Translate <LojaModel>(reader).ToList();
model.Lojas.ForEach(x =>
{
x.MediaTotal = StringExtensions.RetornaClassificacaoGeral(x.s1, x.s2, x.s3, x.s4, x.s5, x.TotalAvaliacoes);
});
ctx.Database.Connection.Close();
}
return(model);
}
