public JsonResult Pesquisar(DatatableParm parm, Veiculo item)
{
try
{
SalvarPesquisa(item, parm);
var items = veiculoService.GetAllByPage(item, parm);
var situacao = Dominio.BuscarSituacao();
return(Json(new
{
ok = true,
sEcho = parm.sEcho,
iTotalRecords = items.Count(),
iTotalDisplayRecords = parm.totalRecords,
aaData = items.Select(x => new
{
IdeVeiculo = x.IdeVeiculo,
CodRenavam = x.CodRenavam,
NumPlaca = x.NumPlaca,
NumAnoFab = x.NumAnoFab,
DscMarcaModelo = x.DscMarcaModelo,
IdcSituacao = situacao.Where(s => s.Key == x.IdcSituacao).FirstOrDefault().Value
})
}));
}
catch (Exception ex)
{
return(Json(CreateMessageDatatable(ex)));
}
}
private void CarregarViewBag()
{
var items = Dominio.BuscarSituacao();
ViewBag.SituacaoVeiculo = items
.Select(x => new SelectListItem()
{
Value = x.Key, Text = x.Value
})
.OrderBy(x => x.Text)
.ToList();
}
private void CarregarViewBag()
{
var colaborador = colaboradorService.BuscarTipoColaborador();
ViewBag.TipoColaborador = colaborador
.Select(x => new SelectListItem()
{
Value = x.IdeTipoColaborador.ToString(), Text = x.DscTipoColaborador
})
.OrderBy(x => x.Text)
.ToList();
var UF = colaboradorService
.BuscarUnidadeFederacao()
.ToList();
ViewBag.UnidadeFederacao = UF
.Select(x => new SelectListItem()
{
Value = x.IdeUnidadeFederacao.ToString(), Text = string.Format("{0} - {1}", x.SigUnidadeFederacao, x.NomUnidadeFederacao)
})
.OrderBy(x => x.Text)
.ToList();
ViewBag.CategoriaCNH = colaboradorService.BuscarCategoriaCNH()
.Select(x => new SelectListItem()
{
Value = x.Value, Text = x.Text
})
.OrderBy(x => x.Text)
.ToList();
ViewBag.Sexo = colaboradorService.BuscarSexo()
.Select(x => new SelectListItem()
{
Value = x.Value, Text = x.Text
})
.OrderBy(x => x.Text)
.ToList();
ViewBag.Situacao = Dominio.BuscarSituacao()
.Select(x => new SelectListItem()
{
Value = x.Key, Text = x.Value
})
.OrderBy(x => x.Text)
.ToList();
}