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