public static void CreateSubstituteUmpire(SubstituteUmpireDTO substituteUmpireDTO)
{
// ballpark instance of Umpire class in Retrosheet_Persist.Retrosheet
var substituteUmpire = convertToEntity(substituteUmpireDTO);
// entity data model
var dbCtx = new retrosheetDB();
dbCtx.Substitute_Umpire.Add(substituteUmpire);
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_Umpire convertToEntity(SubstituteUmpireDTO substituteUmpireDTO)
{
var substituteUmpire = new Substitute_Umpire();
substituteUmpire.record_id = substituteUmpireDTO.RecordID;
substituteUmpire.game_id = substituteUmpireDTO.GameID;
substituteUmpire.inning = substituteUmpireDTO.Inning;
substituteUmpire.sequence = substituteUmpireDTO.Sequence;
substituteUmpire.comment_sequence = substituteUmpireDTO.ComSequence;
substituteUmpire.umpire_id = substituteUmpireDTO.UmpireID;
substituteUmpire.field_position = substituteUmpireDTO.FieldPosition;
return(substituteUmpire);
}
private static void ReadWriteSubstituteUmpireFile()
{
string[] columnValue;
string textLine = null;
using (StreamReader reader = new StreamReader(@"C:\users\mmr\documents\retrosheet\2016 Regular Season\Output\2016TOR\2016TOR_com_umpchange"))
{
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\2016TOR\2016TOR_com_umpchange" + " file could not be read:");
Console.WriteLine(e.Message);
Console.ReadLine();
}
columnValue = textLine.Split('|');
var substituteUmpireDTO = new SubstituteUmpireDTO();
substituteUmpireDTO.RecordID = Guid.NewGuid();
substituteUmpireDTO.GameID = columnValue[0];
substituteUmpireDTO.Inning = Convert.ToInt16(columnValue[1]);
substituteUmpireDTO.Sequence = Convert.ToInt16(columnValue[3]);
substituteUmpireDTO.FieldPosition = columnValue[7];
substituteUmpireDTO.UmpireID = columnValue[8];
SubstituteUmpirePersist.CreateSubstituteUmpire(substituteUmpireDTO);
Console.WriteLine(textLine);
}
}
}
