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