public static void CreateSubstitutePlayer(SubstitutePlayerDTO substitutePlayerDTO) { // ballpark instance of Player class in Retrosheet_Persist.Retrosheet var substitutePlayer = convertToEntity(substitutePlayerDTO); // entity data model var dbCtx = new retrosheetDB(); dbCtx.Substitute_Player.Add(substitutePlayer); try { dbCtx.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } catch (Exception e) { string text; text = e.Message; } }
private static Substitute_Player convertToEntity(SubstitutePlayerDTO substitutePlayerDTO) { var substitutePlayer = new Substitute_Player(); substitutePlayer.record_id = substitutePlayerDTO.RecordID; substitutePlayer.game_id = substitutePlayerDTO.GameID; substitutePlayer.inning = substitutePlayerDTO.Inning; substitutePlayer.game_team_code = substitutePlayerDTO.GameTeamCode; substitutePlayer.sequence = substitutePlayerDTO.Sequence; substitutePlayer.player_id = substitutePlayerDTO.PlayerID; substitutePlayer.game_team_code = substitutePlayerDTO.GameTeamCode; substitutePlayer.batting_order = substitutePlayerDTO.BattingOrder; substitutePlayer.field_position = substitutePlayerDTO.FieldPosition; substitutePlayer.team_id = substitutePlayerDTO.TeamId; return(substitutePlayer); }
private static void ReadWriteSubstitutePlayerFile() { string[] columnValue; string textLine = null; using (StreamReader reader = new StreamReader(@"C:\users\mmr\documents\retrosheet\2016 Regular Season\Output\2016SLN\2016SLN_sub")) { while (!reader.EndOfStream) { try { textLine = reader.ReadLine(); } catch (Exception e) { // Let the user know what went wrong. Console.WriteLine("The " + @"C:\users\mmr\documents\retrosheet\2016 Regular Season\Output\2016SLN\2016SLN_sub" + " file could not be read:"); Console.WriteLine(e.Message); Console.ReadLine(); } columnValue = textLine.Split('|'); var substitutePlayerDTO = new SubstitutePlayerDTO(); substitutePlayerDTO.RecordID = Guid.NewGuid(); substitutePlayerDTO.GameID = columnValue[0]; substitutePlayerDTO.Inning = Convert.ToInt16(columnValue[1]); substitutePlayerDTO.GameTeamCode = Convert.ToInt16(columnValue[2]); substitutePlayerDTO.Sequence = Convert.ToInt16(columnValue[3]); substitutePlayerDTO.PlayerID = columnValue[5]; substitutePlayerDTO.BattingOrder = Convert.ToInt16(columnValue[8]); substitutePlayerDTO.FieldPosition = Convert.ToInt16(columnValue[9]); SubstitutePlayerPersist.CreateSubstitutePlayer(substitutePlayerDTO); Console.WriteLine(textLine); } } }