public IEnumerable <Solicitacao> Filtrar(SolicitacaoPesquisar pesquisar)
{
string sql = string.Format(@"select a.SolicitacaoID,
a.DataDeCriacao,
a.DataDeConclusao,
a.Descricao,
a.ClienteID,
a.DepartamentoID,
a.UsuarioID,
a.SolicitanteID,
a.Concluido,
a.Status,
b.Nome as NomeUsuario,
c.Nome as NomeCliente,
d.Nome as NomeDepartamento,
d.Nome as NomeSolicitante
from solicitacao a
inner join usuario b on (a.usuarioID = b.usuarioID)
inner join cliente c on (a.clienteID = c.ClienteID)
inner join departamento d on (a.departamentoID = d.departamentoID)
inner join usuario e on (a.usuarioID = e.usuarioID)
where status={0}", (int)pesquisar.Status);
var cmd = new SqlCommand(sql, this.conexao.ObterConexao());
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
yield return(new Solicitacao(Convert.ToInt32(sqlDataReader["SolicitacaoID"]),
sqlDataReader["Descricao"].ToString(),
Convert.ToDateTime(sqlDataReader["DataDeCriacao"]),
sqlDataReader["DataDeConclusao"],
Convert.ToBoolean(sqlDataReader["Concluido"]),
Convert.ToInt32(sqlDataReader["ClienteID"]),
Convert.ToInt32(sqlDataReader["departamentoID"]),
Convert.ToInt32(sqlDataReader["UsuarioID"]),
Convert.ToInt32(sqlDataReader["SolicitanteID"]),
(StatusSolicitacao)Convert.ToInt32(sqlDataReader["Status"]),
sqlDataReader["NomeUsuario"].ToString(),
sqlDataReader["NomeCliente"].ToString(),
sqlDataReader["NomeDepartamento"].ToString(),
sqlDataReader["NomeSolicitante"].ToString()));
}
}
public IEnumerable <Solicitacao> Filtrar(SolicitacaoPesquisar pesquisar) => this.repository.Filtrar(pesquisar);