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