public ActionResult HistoricalUpload() { var seasons = _context.Seasons.ToList(); var viewModel = new UploadViewModels.HistoricalUploadViewModel { SeasonsList = seasons }; return(View(viewModel)); }
public ActionResult HistoricalUpload(HttpPostedFileBase uploadfile, UploadViewModels.HistoricalUploadViewModel model) { if (ModelState.IsValid) { if (uploadfile != null && uploadfile.ContentLength > 0) { Stream stream = uploadfile.InputStream; List <HistoricalPerGameStatLine> temp = new List <HistoricalPerGameStatLine>(); using (StreamReader readFile = new StreamReader(stream, Encoding.UTF8)) { string line; string[] row; readFile.ReadLine(); while ((line = readFile.ReadLine()) != null) { row = line.Split(','); HistoricalPerGameStatLine s = new HistoricalPerGameStatLine(); s.Player = row[0]; s.GamesPlayed = row[1]; s.GamesStarted = row[2]; s.MinutesPlayed = row[3]; s.FieldGoalsMade = row[4]; s.FieldGoalsAttemped = row[5]; s.FieldGoalPercentage = row[6]; s.ThreePointersMade = row[7]; s.ThreePointersAttempted = row[8]; s.ThreePointPercentage = row[9]; s.TwoPointersMade = row[10]; s.TwoPointersAttempted = row[11]; s.TwoPointPercentage = row[12]; s.EffectiveFieldGoalPercentage = row[13]; s.FreeThrowsMade = row[14]; s.FreeThrowsAttempted = row[15]; s.FreeThrowPercentage = row[16]; s.OffensiveRebounds = row[17]; s.DefensiveRebounds = row[18]; s.TotalRebounds = row[19]; s.Assists = row[20]; s.Steals = row[21]; s.Blocks = row[22]; s.Turnovers = row[23]; s.PersonalFouls = row[24]; s.Points = row[25]; s.SeasonId = model.SeasonId; temp.Add(s); } readFile.Close(); } foreach (var statLine in temp) { _context.HistoricalPerGameStatLines.Add(statLine); _context.SaveChanges(); } return(View("Success")); } } return(View("Index")); }