public IActionResult Post([FromBody] FileNameDTO filename)
{
if (filename == null)
{
return(BadRequest());
}
return(Ok(_loadfileservice.LoadFile(filename)));
}
public IEnumerable <ResultsLog> LoadFile(FileNameDTO filepath)
{
_logger.LogInformation($"LoadFile call for {filepath.FileName} made to database");
_context.Database.SetCommandTimeout(3000);
IEnumerable <ResultsLog> results = _context.ResultsLog.FromSqlRaw <ResultsLog>($"dbo.ImportPreFile {filepath.FileName}").ToList();
return(results);
}
/// <summary>
/// Check exists filename in DB
/// </summary>
/// <param name="fileName"></param>
/// <returns></returns>
private static bool CheckExistInDB(string fileName)
{
FileNameDTO fileNameDTO = new FileNameDTO();
FileNameService service = new FileNameService(new EFUnitOfWork());
try
{
fileNameDTO = service.GetEntity(fileName);
}
catch (Exception)
{
fileNameDTO = null;
}
return(fileNameDTO != null);
}
