public string Upload() { string result = "Ошибка при загрузке файла"; try { var filePath = Path.GetTempFileName(); foreach (var formFile in Request.Form.Files) { if (formFile.Length > 0) { string fileName = string.Empty; using (var inputStream = new FileStream(filePath, FileMode.Create)) { // read file to stream formFile.CopyTo(inputStream); // stream to byte array byte[] array = new byte[inputStream.Length]; inputStream.Seek(0, SeekOrigin.Begin); inputStream.Read(array, 0, array.Length); // get file name fileName = formFile.FileName; } if (!string.IsNullOrEmpty(fileName) && System.IO.File.Exists(filePath)) { var fileInfo = new System.IO.FileInfo(fileName); var itHasBeenSaved = false; if (fileInfo.Extension == ".txt") { using (StreamReader reader = new StreamReader(filePath)) { string line; while ((line = reader.ReadLine()) != null) { string[] values = line.Split('\t'); if (values.Length == 4) { if (!int.TryParse(values[3], out int employee_Number)) { employee_Number = -1; } _context.Employees.Add(new Employee() { Surname = values[0], Name = values[1], Second_Name = values[2], Employee_Number = employee_Number } ); itHasBeenSaved = true; } } if (itHasBeenSaved) { _context.SaveChanges(); } } } else if (fileInfo.Extension == ".xlsx") { using (ExcelPackage package = new ExcelPackage()) { using (var stream = System.IO.File.OpenRead(filePath)) { package.Load(stream); } var worksheet = package.Workbook.Worksheets.First(); if (worksheet != null) { var currentRow = 1; var valueSurname = string.Empty; var valueName = string.Empty; var valueSecond_Name = string.Empty; int valueEmployee_Number = -1; while (true) { var valueTest = worksheet.Cells[currentRow, 1]; if (valueTest != null && valueTest.Value != null) { valueSurname = valueTest.Value.ToString(); valueName = worksheet.Cells[currentRow, 2].Value.ToString(); valueSecond_Name = worksheet.Cells[currentRow, 3].Value.ToString(); if (!int.TryParse(worksheet.Cells[currentRow, 4].Value.ToString(), out valueEmployee_Number)) { valueEmployee_Number = -1; } _context.Employees.Add(new Employee() { Surname = valueSurname, Name = valueName, Second_Name = valueSecond_Name, Employee_Number = valueEmployee_Number }); itHasBeenSaved = true; currentRow++; } else { break; } } if (itHasBeenSaved) { _context.SaveChanges(); } } } } result = "Файл загружен"; } } } } catch (Exception ex) { result += $" Подробно: {ex.Message}"; } return(result); }