public DataTableResponseBase <Item> CardapioMesaDataTable(DataTableBase <Item> dataTableBase, Guid FkEmpresa, EnumTipoItem tipo)
{
var query = _context.Set <Item>()
.Where(x => x.Empresa.Id == FkEmpresa).AsQueryable();
if (dataTableBase.Filter != null && dataTableBase.Filter != string.Empty)
{
query = query.Where(e => e.Nome.Contains(dataTableBase.Filter) || e.Descricao.Contains(dataTableBase.Filter));
}
if (tipo.IsEnumValid())
{
query = query.Where(x => x.Tipo == tipo);
}
//if (tipo.IsEnumValid())
// query = query.Where(x => x.Tipo == tipo);
int count = query.Count();
query = query.OrderBy(x => x.Nome);
query = query.Skip(dataTableBase.PageNumber * dataTableBase.PageView).Take(dataTableBase.PageView);
DataTableResponseBase <Item> resp = new DataTableResponseBase <Item>(count, dataTableBase.PageView, dataTableBase.PageNumber, query.ToList());
return(resp);
}
public DataTableResponseBase <Avaliacao> AvaliacoesEmpresaDataTable(DataTableBase <Avaliacao> dataTableBase, Guid FkEmpresa)
{
{
var query = _context.Set <Avaliacao>()
.Include(x => x.Usuario)
.Where(x => x.Empresa.Id == FkEmpresa).AsQueryable();
int count = query.Count();
query = query.OrderBy(x => x.DataCriacao);
query = query.Skip(dataTableBase.PageNumber * dataTableBase.PageView).Take(dataTableBase.PageView);
DataTableResponseBase <Avaliacao> resp = new DataTableResponseBase <Avaliacao>(count, dataTableBase.PageView, dataTableBase.PageNumber, query.ToList());
return(resp);
}
}
public async Task <Response> Handle(RetornarEmpresasRequest request, CancellationToken cancellationToken)
{
DataTableResponseBase <Entities.Empresa> empresas = _repositoryEmpresa.EmpresasDataTable(request, request.Categoria);
RetornarEmpresasResponse response = new RetornarEmpresasResponse(empresas);
if (empresas != null)
{
Response respo = new Response(this, response);
return(await Task.FromResult(respo));
}
else
{
this.AddNotification("Listar Empresas", "Erro ao Listar Empresas");
}
Response resp = new Response(this);
return(await Task.FromResult(resp));
}
public async Task <Response> Handle(RetornarAvaliacoesEmpresaRequest request, CancellationToken cancellationToken)
{
DataTableResponseBase <Entities.Avaliacao> avaliacoes = _repositoryAvaliacao.AvaliacoesEmpresaDataTable(request, request.FkEmpresa.Value);
RetornarAvaliacoesEmpresaResponse response = new RetornarAvaliacoesEmpresaResponse(avaliacoes);
if (avaliacoes != null)
{
Response respo = new Response(this, response);
return(await Task.FromResult(respo));
}
else
{
this.AddNotification("Listar Avaliações", "Erro ao Listar Avaliaões");
}
Response resp = new Response(this);
return(await Task.FromResult(resp));
}
public async Task <Response> Handle(RetornarItensEmpresaRequest request, CancellationToken cancellationToken)
{
DataTableResponseBase <Entities.Item> Itens = _repositoryItem.ItensEmpresaDatatable(request, request.FkEmpresa.Value, request.Tipo);
RetornarItensEmpresaResponse response = new RetornarItensEmpresaResponse(Itens);
if (Itens != null)
{
Response respo = new Response(this, response);
return(await Task.FromResult(respo));
}
else
{
this.AddNotification("Listar Empresas", "Erro ao Listar Itens");
}
Response resp = new Response(this);
return(await Task.FromResult(resp));
}
public async Task <Response> Handle(RetornarCardapioMesaRequest request, CancellationToken cancellationToken)
{
var mesa = _repositoryMesa.ObterPorId(request.FkMesa.Value);
var empresa = _repositoryEmpresa.ObterPor(x => x.Mesas.Contains(mesa));
DataTableResponseBase <Entities.Item> Itens = _repositoryItem.CardapioMesaDataTable(request, empresa.Id, request.Tipo);
RetornarCardapioMesaResponse response = new RetornarCardapioMesaResponse(Itens, empresa, mesa);
if (Itens != null)
{
Response respo = new Response(this, response);
return(await Task.FromResult(respo));
}
else
{
this.AddNotification("Listar Cardápio", "Erro ao Listar cardápio");
}
Response resp = new Response(this);
return(await Task.FromResult(resp));
}
public DataTableResponseBase <Empresa> EmpresasDataTable(DataTableBase <Empresa> dataTableBase, EnumCategoria categoria)
{
var query = _context.Set <Empresa>()
.Include(x => x.Mesas)
.Where(x => x.Ativo == true).AsQueryable();
if (dataTableBase.Filter != null && dataTableBase.Filter != string.Empty)
{
query = query.Where(e => e.Fantasia.Contains(dataTableBase.Filter) || e.RazaoSocial.Contains(dataTableBase.Filter));
}
if (categoria.IsEnumValid())
{
query = query.Where(x => x.Categoria == categoria);
}
int count = query.Count();
query = query.OrderBy(x => x.DataCadastro);
query = query.Skip(dataTableBase.PageNumber * dataTableBase.PageView).Take(dataTableBase.PageView);
DataTableResponseBase <Empresa> resp = new DataTableResponseBase <Empresa>(count, dataTableBase.PageView, dataTableBase.PageNumber, query.ToList());
return(resp);
}
public RetornarItensEmpresaResponse(DataTableResponseBase <Entities.Item> dataTable) :
base(dataTable.PageSize, dataTable.PageView, dataTable.PageNumber, dataTable.Data.Select(e => new ItemHelper(e)).ToList())
{
}
public RetornarCardapioMesaResponse(DataTableResponseBase <Entities.Item> dataTable, Entities.Empresa empresa, Entities.Mesa mesa) :
base(dataTable.PageSize, dataTable.PageView, dataTable.PageNumber, dataTable.Data.Select(e => new ItemHelper(e)).ToList())
{
this.Empresa = new EmpresaHelper(empresa);
this.Mesa = new MesaHelper(mesa);
}
public RetornarAvaliacoesEmpresaResponse(DataTableResponseBase <Entities.Avaliacao> dataTable) :
base(dataTable.PageSize, dataTable.PageView, dataTable.PageNumber, dataTable.Data.Select(e => new AvaliacaoHelper(e)).ToList())
{
}
public RetornarEmpresasResponse(DataTableResponseBase <Entities.Empresa> dataTable) :
base(dataTable.PageSize, dataTable.PageView, dataTable.PageNumber, dataTable.Data.Select(e => new EmpresaHelper(e)).ToList())
{
}
