public IActionResult GerarExcel(DateTime Inicio, DateTime Fim, string group1)
{
string dtinicio = Convert.ToString(Inicio);
var xt = dtinicio.Split("/");
string dtNascMes = xt[1];
string dtNascDia = xt[0];
string dtNascAno = xt[2].Substring(0, 4);
DateTime dt_inicio = Convert.ToDateTime(dtNascAno + "-" + dtNascMes + "-" + dtNascDia);
string dtFim = Convert.ToString(Fim);
var xtt = dtFim.Split("/");
string dtVendaMes = xtt[1];
string dtVendaDia = xtt[0];
string dtVendaAno = xtt[2].Substring(0, 4);
DateTime dt_fim = Convert.ToDateTime(dtVendaAno + "-" + dtVendaMes + "-" + dtVendaDia);
var DummyData = _propostaAppService.ObterPropostasPorData(dt_inicio, dt_fim);
string name = String.Empty;
if (group1 == "Aprovadas")
{
DummyData = _propostaAppService.ObterPropostasAprovadasPorData(dt_inicio, dt_fim);
name = "Aprovadas";
}
else if (group1 == "Todas")
{
DummyData = _propostaAppService.ObterPropostasPorData(dt_inicio, dt_fim);
name = "Todas";
}
else if (group1 == "Recusadas")
{
DummyData = _propostaAppService.ObterPropostasRecusadasPorData(dt_inicio, dt_fim);
name = "Recusadas";
}
else
{
DummyData = _propostaAppService.ObterPropostasPorData(dt_inicio, dt_fim);
name = "Todas";
}
var comlumHeadrs = new string[]
{
"CPF",
"Nome",
"Data Venda",
"Ocupacao",
"Resultado",
"Pronum",
"Valor Prêmio"
};
byte[] result;
using (var package = new ExcelPackage())
{
// add a new worksheet to the empty workbook
var worksheet = package.Workbook.Worksheets.Add("Propostas"); //Worksheet name
using (var cells = worksheet.Cells[1, 1, 1, 5]) //(1,1) (1,5)
{
cells.Style.Font.Bold = true;
}
//First add the headers
for (var i = 0; i < comlumHeadrs.Count(); i++)
{
worksheet.Cells[1, i + 1].Value = comlumHeadrs[i];
}
//Add values
var j = 2;
foreach (var employee in DummyData)
{
worksheet.Cells["A" + j].Value = employee.CPF;
worksheet.Cells["B" + j].Value = employee.Nome;
worksheet.Cells["C" + j].Value = employee.Dt_venda.ToString("MM/dd/yyyy");
worksheet.Cells["D" + j].Value = employee.Ocupacao;
worksheet.Cells["E" + j].Value = employee.StatusConsulta;
worksheet.Cells["F" + j].Value = employee.Pronum;
worksheet.Cells["G" + j].Value = employee.VlrPremio;
j++;
}
result = package.GetAsByteArray();
}
return(File(result, "application/ms-excel", $"Propostas" + "De " + dt_inicio.ToString("dd/MM/yyyy") + "Até " + dt_fim.ToString("dd/MM/yyyy") + name + ".xlsx"));
}
