public async Task <IActionResult> MensalidadeAsync(Guid?id, string status, int?ano, int?tipo, jQueryDataTableRequestModel request)
{
try
{
var lista = (await _repositorio.ObterMensalidadesPorAlunoAsync(id, status, ano, tipo)).AsQueryable();
if (request.sSearch != null && request.sSearch.Length > 0)
{
lista = lista.Where(x => x.AlunoNome.ToUpper().Contains(request.sSearch.ToUpper()));
}
var model = (from r in lista
select new
{
r.AlunoNome,
r.MensalidadeId,
r.TipoMensalidade,
//Foto = $" <img class=\"rounded img-thumbnail\" style=\" height: 50px;\" src=\"/images/avatars/Funcionario/{r.Foto}\">",
r.Parcela,
r.Valor,
total = r.Valor - r.Desconto,
dataVencimento = r.DataVencimento.ToShortDateString(),
r.Desconto,
Pago = (r.Estorno && !r.Pago) ? $"<span class=\"badge badge-warning\"> Estornado - {r.DataEstorno.ToShortDateString()} </ span>" : (r.Pago ? $"<span class=\"badge badge-success\"> Pago - {Convert.ToDateTime(r.DataPagamento).ToShortDateString()} </ span > " : " <span class=\"badge badge-danger\"> Pendente</ span >"),
acao = ObterMenuAcaoDataTable(r)
})
.DataTableResponse(request);
return(Ok(model));
}
catch (System.Exception ex)
{
throw;
}
}