public async Task <IActionResult> Create([Bind("Id,CountryId,TeamId,Name,Birthdate")] Player player)
{
if (ModelState.IsValid)
{
if (!Valid.IsAllLetters(player.Name))
{
return(RedirectToAction(nameof(Index)));
}
_context.Add(player);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CountryId"] = new SelectList(_context.Countries, "Id", "Name", player.CountryId);
ViewData["TeamId"] = new SelectList(_context.Teams, "Id", "Name", player.TeamId);
return(View(player));
}
public async Task <IActionResult> Import(IFormFile fileExcel)
{
if (ModelState.IsValid)
{
if (fileExcel != null)
{
using (var stream = new FileStream(fileExcel.FileName, FileMode.Create))
{
await fileExcel.CopyToAsync(stream);
using (XLWorkbook workBook = new XLWorkbook(stream, XLEventTracking.Disabled))
{
foreach (IXLWorksheet worksheet in workBook.Worksheets)
{
if (!Valid.IsAllLetters(worksheet.Name))
{
continue;
}
Country newcoun;
var c = (from coun in _context.Countries
where coun.Name.Contains(worksheet.Name)
select coun).ToList();
if (c.Count > 0)
{
newcoun = c[0];
}
else
{
newcoun = new Country();
newcoun.Name = worksheet.Name;
_context.Countries.Add(newcoun);
}
foreach (IXLRow row in worksheet.RowsUsed().Skip(1))
{
try
{
Organisation organisation = new Organisation();
organisation.Name = row.Cell(1).Value.ToString();
organisation.CreationDate = DateTime.Parse(row.Cell(2).Value.ToString());
if (!Valid.Datecheck(organisation.CreationDate))
{
continue;
}
//int Day = Int.Parse(row.Cell(2).Value.ToString());
//int Mounth = Int.Parse(row.Cell(3).Value.ToString());
//int Year = Int.Parse(row.Cell(4).Value.ToString());
//organisation.CreationDate = new DateTime(Year, Mounth, Day);
organisation.Country = newcoun;
var dcp = (from org in _context.Organisations
where org.Name.Contains(organisation.Name)
select org).ToList();
if (dcp.Count > 0)
{
continue;
}
_context.Organisations.Add(organisation);
}
catch (Exception e)
{
}
}
}
}
}
}
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(Index)));
}
