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);
}
