//
        // GET: /Isentos/

        public ActionResult Index(IsentosListViewModel viewModel, string sort, string direction, int? page)
        {
            viewModel.SetParameters(1, page == null ? 1 : page.Value, sort, direction, Request.Params);

            IsentosListViewModel result = getIsentos(viewModel);
            return View(result);
        }
        public ActionResult exportIsentosToCsv(IsentosListViewModel viewModel, string sort, string direction)
        {
            viewModel.PageSize = 0;
            viewModel.SetParameters(1, 1, sort, direction, Request.Params);

            IsentosListViewModel result = getIsentos(viewModel);

            List<ApoliceIsentoToCsv> isentosCsv = new List<ApoliceIsentoToCsv>();
            foreach (ApoliceIsento apo in result.apolicesIsentos)
                isentosCsv.Add(new ApoliceIsentoToCsv
                {
                    entidade = apo.entidade.nome,
                    matricula = apo.matricula,
                    dataFim = apo.dataFim.ToString(),
                    dataInicio = apo.dataInicio.ToString(),
                    confidencial = apo.confidencial ? "Sim" : "Não",
                    dataModificacao = apo.dataModificacao.ToString()
                });

            CsvExport<ApoliceIsentoToCsv> csv = new CsvExport<ApoliceIsentoToCsv>(isentosCsv);

            byte[] fileBytes = csv.ExportToBytes();
            return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Isentos_" + DateTime.Now.ToShortDateString() + ".csv");
        }