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