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