public IActionResult AddRateByExcel(int id, int PolicyYear, [FromForm(Name = "file")] IFormFile formFile)
{
try
{
if (formFile == null || formFile.Length <= 0)
{
return(BadRequest(new { error = "file is empty" }));
}
if (!Path.GetExtension(formFile.FileName).Equals(".xlsx", StringComparison.OrdinalIgnoreCase))
{
if (!Path.GetExtension(formFile.FileName).Equals(".xls", StringComparison.OrdinalIgnoreCase))
{
return(BadRequest(new { error = "Not Support file extension" }));
}
}
using (var stream = new MemoryStream())
{
formFile.CopyTo(stream);
var data = _itemService.UploadRatesByAge(id, PolicyYear, stream, GetNameClaim());
//var data = _itemService.UpLoadRate(InsuranceCompanyId, PolicyYear, stream);
return(Ok(data));
}
// add list to db ..
// here just read and return
}
catch (AppException ex)
{
return(DefaultError(ex.Message));
}
}