public async Task <IList <EditalListViewModel> > GetAllEditaisAsync(EditalFilterViewModel filter)
{
var filterRepositorio = new ProjetoGraacc.Data.Models.Filters.EditalFilterViewModel
{
UF = filter.UF,
Municipio = filter.Municipio,
Orgao = filter.Orgao,
Favoritas = filter.Favoritas,
Pesquisa = filter.Pesquisa
};
var result = await _editalRespositorio.ListEditaisAsync(filterRepositorio);
return(result.Select(m =>
new EditalListViewModel
{
Id = m.id.ToString(),
NrEdital = m.num_edital,
UF = m.uf,
Municipio = m.municipio,
Orgao = m.orgao,
DtPublicacao = m.data_publicacao.ToShortDateString(),
Status = m.status.ToString(),
Favorito = m.favorito,
vlPeiteado = m.valor_pleiteado,
vlRecebido = m.valor_recebido,
dtNotificacao = m.data_notificacao.HasValue ? m.data_notificacao.Value.ToShortDateString() : null
}).ToList());
}
public async Task <IList <Edital> > ListEditaisAsync(EditalFilterViewModel filter)
{
IEnumerable <Edital> itens;
using (var connection = new MySqlConnection(_connectionString.MySQL))
{
await connection.OpenAsync();
var sql = "select * from edital";
itens = await connection.QueryAsync <Edital>(sql);
await connection.CloseAsync();
}
if (filter.Pesquisa)
{
if (!string.IsNullOrEmpty(filter.UF))
{
itens = itens.Where(x => x.uf.ToUpper() == filter.UF.ToUpper());
}
if (!string.IsNullOrEmpty(filter.Municipio))
{
itens = itens.Where(x => x.municipio.ToUpper() == filter.Municipio.ToUpper());
}
if (!string.IsNullOrEmpty(filter.Orgao))
{
itens = itens.Where(x => x.orgao.ToUpper() == filter.Orgao.ToUpper());
}
if (!string.IsNullOrEmpty(filter.Favoritas))
{
itens = itens.Where(x => x.favorito == true);
}
}
return(itens.ToList());
}
public async Task <IActionResult> Editais(EditalFilterViewModel filter)
{
var model = await _editalService.GetAllEditaisAsync(filter);
return(View(model));
}
