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