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 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);
}