public List <OrcamentoViewModel> getListaOrcamentos(OrcamentoFilterViewModel filter)
{
var searchData = new OrcamentoSearchData()
{
Cliente = filter.Cliente,
DataEmissaoInicio = filter.DataEmissaoInicio,
DataEmissaoFim = filter.DataEmissaoFim,
EhServico = filter.EhServico,
Status = filter.Status
};
return(OrcamentoService.getOrcamentos(searchData).Select(c => LoadOrcamentoModel(c)).ToList());
}
public List <Orcamentos> getOrcamentos(OrcamentoSearchData searchData)
{
MarteUpdatesContext.Configuration.LazyLoadingEnabled = false;
var query = (from oData in MarteUpdatesContext.Orcamentos select oData);
if (searchData.Cliente.HasValue)
{
query = query.Where(c => c.IDCliente.Equals(searchData.Cliente.Value));
}
if (searchData.DataEmissaoInicio.HasValue)
{
query = query.Where(c => c.DataEmissao > searchData.DataEmissaoInicio.Value);
}
if (searchData.DataEmissaoFim.HasValue)
{
var dataEmissaoFim = searchData.DataEmissaoFim.Value.AddDays(1).AddSeconds(-1);
query = query.Where(c => c.DataEmissao < dataEmissaoFim);
}
if (searchData.EhServico.HasValue)
{
query = query.Where(c => c.Servico == searchData.EhServico);
}
if (searchData.Status.HasValue)
{
query = query.Where(c => c.Status == searchData.Status);
}
query = query.OrderBy(c => c.DataEmissao);
query = query.Include(c => c.ItensOrcamento);
query = query.Include(c => c.Clientes);
return(query.ToList());
}
public List <Orcamentos> getOrcamentos(OrcamentoSearchData searchData)
{
return(OrcamentoDAO.getOrcamentos(searchData));
}
