public IActionResult Get(string id)
{
try
{
using (XTEC_DigitalContext db = new XTEC_DigitalContext())
{
var estudiantes = db.Set <NotasProfesorV>().FromSqlRaw("EXEC VerNotasProfesor {0}", id).ToList();
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add(id);
var currentRow = 1;
#region Header
worksheet.Cell(currentRow, 1).Value = "Carnet";
worksheet.Cell(currentRow, 2).Value = "Rubro";
worksheet.Cell(currentRow, 3).Value = "Porcentaje Del Rubro";
worksheet.Cell(currentRow, 4).Value = "Nombre De Evaluacion";
worksheet.Cell(currentRow, 5).Value = "Porcentaje De Evaluacion";
worksheet.Cell(currentRow, 6).Value = "Nota";
#endregion
#region Body
foreach (var estudiante in estudiantes)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = estudiante.Carnet;
worksheet.Cell(currentRow, 2).Value = estudiante.Rubro;
worksheet.Cell(currentRow, 3).Value = estudiante.PorcentajeDelRubro;
worksheet.Cell(currentRow, 4).Value = estudiante.NombreDeEvaluacion;
worksheet.Cell(currentRow, 5).Value = estudiante.PorcentajeDeEvaluacion;
worksheet.Cell(currentRow, 6).Value = estudiante.Nota;
}
#endregion
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(
content,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"NotasEstudiantes.xlsx"
));
}
}
//return Ok(x);
}
//return Ok();
}
catch
{
return(BadRequest());
}
}
public IActionResult Get(string id)
{
try
{
using (XTEC_DigitalContext db = new XTEC_DigitalContext())
{
var estudiantes = db.Set <MatriculadosV>().FromSqlRaw("EXEC VerMatriculados {0}", id).ToList();
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add(id);
var currentRow = 1;
#region Header
worksheet.Cell(currentRow, 1).Value = "Carnet";
worksheet.Cell(currentRow, 2).Value = "Nombre";
worksheet.Cell(currentRow, 3).Value = "Email";
worksheet.Cell(currentRow, 4).Value = "Numero";
#endregion
#region Body
foreach (var estudiante in estudiantes)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = estudiante.EstudianteId;
}
#endregion
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(
content,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"Estudiantes.xlsx"
));
}
}
//return Ok(x);
}
//return Ok();
}
catch
{
return(BadRequest());
}
}
