public static void CreatePitcherAdjustment(PitcherAdjustmentDTO pitcherAdjustmentDTO)
{
// ballpark instance of Player class in Retrosheet_Persist.Retrosheet
var pitcherAdjustment = convertToEntity(pitcherAdjustmentDTO);
// entity data model
//var dbCtx = new retrosheetDB();
var dbCtx = new retrosheetEntities();
dbCtx.Pitcher_Adjustment.Add(pitcherAdjustment);
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 Pitcher_Adjustment convertToEntity(PitcherAdjustmentDTO pitcherAdjustmentDTO)
{
var pitcherAdjustment = new Pitcher_Adjustment();
pitcherAdjustment.record_id = pitcherAdjustmentDTO.RecordID;
pitcherAdjustment.game_id = pitcherAdjustmentDTO.GameID;
pitcherAdjustment.inning = pitcherAdjustmentDTO.Inning;
pitcherAdjustment.game_team_code = pitcherAdjustmentDTO.GameTeamCode;
pitcherAdjustment.sequence = pitcherAdjustmentDTO.Sequence;
pitcherAdjustment.player_id = pitcherAdjustmentDTO.PlayerID;
pitcherAdjustment.pitcher_hand = pitcherAdjustmentDTO.PitcherHand;
pitcherAdjustment.team_id = pitcherAdjustmentDTO.TeamID;
return(pitcherAdjustment);
}
private static void ReadWritePitcherAdjustmentFile()
{
string[] columnValue;
string textLine = null;
using (StreamReader reader = new StreamReader(@"C:\users\mmr\documents\retrosheet\2016 Regular Season\Output\2016SEA\2016SEA_padj"))
{
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\2016SEA\2016SEA_padj" + " file could not be read:");
Console.WriteLine(e.Message);
Console.ReadLine();
}
columnValue = textLine.Split('|');
PitcherAdjustmentDTO pitcherAdjustmentDTO = new PitcherAdjustmentDTO();
pitcherAdjustmentDTO.RecordID = Guid.NewGuid();
pitcherAdjustmentDTO.GameID = columnValue[0];
pitcherAdjustmentDTO.Inning = Convert.ToInt16(columnValue[1]);
pitcherAdjustmentDTO.GameTeamCode = Convert.ToInt16(columnValue[2]);
pitcherAdjustmentDTO.Sequence = Convert.ToInt16(columnValue[3]);
pitcherAdjustmentDTO.PlayerID = columnValue[5];
pitcherAdjustmentDTO.PitcherHand = columnValue[6];
PitcherAdjustmentPersist.CreatePitcherAdjustment(pitcherAdjustmentDTO);
Console.WriteLine(textLine);
}
}
}
