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