public List <ExelData> getExelData()
{
string testData = "";
string filePath = @"SkietbaanTestData.xlsx";
FileInfo file = new FileInfo(filePath);
List <ExelData> exelDataList = new List <ExelData>();
using (ExcelPackage package = new ExcelPackage(file))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
var rawText = string.Empty;
for (int row = 2; row <= rowCount; row++)
{
ExelData exelData = new ExelData();
exelData.CompetitionName = validateText(worksheet.Cells[row, 1].Value.ToString());
exelData.Score = int.Parse(validateNumber(worksheet.Cells[row, 2].Value.ToString()));
exelData.Name = validateText(worksheet.Cells[row, 3].Value.ToString());
exelData.Surname = validateText(worksheet.Cells[row, 4].Value.ToString());
exelData.ScoreEntryDate = DateTime.Parse(validateText(worksheet.Cells[row, 5].Text.ToString()));
exelData.UserId = long.Parse(validateNumber(worksheet.Cells[row, 6].Value.ToString()));
exelDataList.Add(exelData);
}
}
return(exelDataList);
}
public List <User> AddUsersFromExcel()
{
List <User> users = new List <User>();
for (int i = 0; i < listData.Count; i++)
{
ExelData exelData = listData.ElementAt(i);
User user = new User()
{
Username = exelData.Name + " " + exelData.Surname,
MemberID = exelData.UserId + ""
};
if (!UserExist(users, user))
{
users.Add(user);
}
}
_context.AddRange(users);
_context.SaveChanges();
return(users);
}
public List <Competition> AddCompetitionsFromExcel()
{
List <Competition> competitions = new List <Competition>();
for (int i = 0; i < listData.Count; i++)
{
ExelData exelData = listData.ElementAt(i);
Competition competition = new Competition()
{
Name = exelData.CompetitionName,
Status = true,
BestScoresNumber = 4
};
if (!CompetitionExist(competitions, competition))
{
competitions.Add(competition);
}
}
_context.Competitions.AddRange(competitions);
_context.SaveChanges();
return(competitions);
}
