public void Post(IFormFile file)
{
if (AuthRepo.IsAuthenticated())
{
if (file != null && file.ContentType == "application/octet-stream" && file.FileName.Contains(".xlsx"))
{
var filename = Path.GetFileNameWithoutExtension(Path.GetTempFileName()) + ".xlsx";
var filePath = Path.Combine(Path.GetTempPath(), filename);
if (file.Length > 0)
{
using (var stream = new FileStream(filePath, FileMode.Create, FileAccess.ReadWrite))
{
file.CopyTo(stream);
stream.Flush();
}
}
FileStream streamNew = null;
try
{
streamNew = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite);
}
catch (Exception)
{
Response.StatusCode = 500;
return;
}
ExcelPackage excelFile = new ExcelPackage(streamNew);
ExcelWorksheet worksheet = excelFile.Workbook.Worksheets[1];
if (!AppRepo.AddRecordsFromExcel(AppRepo.GetUserById(AuthRepo.CurrentUserId), worksheet))
{
Response.StatusCode = 500;
}
return;
}
Response.StatusCode = 415;
return;
}
Response.StatusCode = 401;
}
