public void AddPlayerYear(AddPlayerYear cmd) { var repo = PopulateMyself(cmd.LahmanId); var existingYear = this.Years.FirstOrDefault(p => p.Year == cmd.Year); if (existingYear == null) { this.Years.Add(new PlayerYear() { Average = cmd.Average, Doubles = cmd.Doubles, Hits = cmd.Hits, HomeRuns = cmd.HomeRuns, LahmanId = cmd.LahmanId, RunsBattedIn = cmd.RunsBattedIn, Salary = cmd.Salary, StrikeOuts = cmd.StrikeOuts, Triples = cmd.Triples, Year = cmd.Year, TeamName = cmd.TeamName }); } else { existingYear = new PlayerYear() { Average = cmd.Average, Doubles = cmd.Doubles, Hits = cmd.Hits, HomeRuns = cmd.HomeRuns, LahmanId = cmd.LahmanId, RunsBattedIn = cmd.RunsBattedIn, Salary = cmd.Salary, StrikeOuts = cmd.StrikeOuts, Triples = cmd.Triples, Year = cmd.Year, TeamName = cmd.TeamName }; } repo.Save(this); ApplyEvent(new PlayerYearAdded() { Average = cmd.Average, Doubles = cmd.Doubles, FirstName = FirstName, Hits = cmd.Hits, HomeRuns = cmd.HomeRuns, Id = Id, LastName = LastName, PlayerId = PlayerId, RunsBattedIn = cmd.RunsBattedIn, Salary = cmd.Salary, StrikeOuts = cmd.StrikeOuts, Team = cmd.TeamName, Triples = cmd.Triples, Year = cmd.Year }); }
public CardModule(ICardRepository repo) { _repo = repo; Get["/card/search"] = args => { return(View["search.cshtml"]); }; Post["/card/search"] = criteria => { var req = this.Bind <HitterSearch>(); var searchModel = _repo.GetHitterSearch(req); return(View["results.cshtml", searchModel]); }; Post["/card/facetsearch"] = criteria => { var req = this.Bind <HitterFacetSearch>(); var searchModel = _repo.GetFacetedHitterSearch(req.YearStart, req.YearEnd, req.MaxSalary, req.MinHomeRuns, req.field, req.criteria); return(View["results.cshtml", searchModel]); }; Get["/newcard"] = _ => { Agile.Minimalist.Commands.Writer.ICommandWriter writer = new Agile.Minimalist.Commands.Writer.CommandWriter(); using (var conn = new SqlConnection("server=AGILE-L03\\DSHSQL08_1;initial catalog=Lahman2012;integrated security=true;")) { using (var cmd = new SqlCommand("SELECT * FROM dbo.Master", conn)) { cmd.Connection.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var player = new CreatePlayer() { Bats = reader["Bats"].ToString(), College = reader["College"].ToString(), Debut = reader["debut"] == DBNull.Value ? default(DateTime?) : Convert.ToDateTime(reader["debut"]), FinalGame = reader["finalGame"] == DBNull.Value ? default(DateTime?) : Convert.ToDateTime(reader["finalGame"]), FirstName = reader["nameFirst"].ToString(), Height = 75, LahmanId = reader.GetInt32(reader.GetOrdinal("lahmanID")), LastName = reader["nameLast"].ToString(), NickName = reader["nameNick"].ToString(), PlayerId = reader["playerID"].ToString(), Throws = reader["Throws"].ToString(), Weight = 150 }; writer.SendCommand(player); } } } } return("new player submitted"); }; Get["/newcardstats"] = args => { Agile.Minimalist.Commands.Writer.ICommandWriter writer = new Agile.Minimalist.Commands.Writer.CommandWriter(); using (var conn = new SqlConnection("server=AGILE-L03\\DSHSQL08_1;initial catalog=Lahman2012;integrated security=true;")) { using (var cmd = new SqlCommand("SELECT * FROM dbo.BaseballHitters", conn)) { cmd.Connection.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var playerYear = new AddPlayerYear() { Year = Convert.ToInt32(reader["yearID"]), Average = Convert.ToDouble(reader["average"] == DBNull.Value ? 0 : reader["average"]), Doubles = Convert.ToInt32(reader["doubles"]), Hits = Convert.ToInt32(reader["H"] == DBNull.Value ? 0 : reader["H"]), HomeRuns = Convert.ToInt32(reader["HR"] == DBNull.Value ? 0 : reader["HR"]), LahmanId = Convert.ToInt32(reader["lahmanID"]), RunsBattedIn = Convert.ToInt32(reader["rbi"]), Salary = Convert.ToInt32(reader["salary"]), StrikeOuts = Convert.ToInt32(reader["so"]), TeamName = reader["teamName"].ToString(), Triples = Convert.ToInt32(reader["triples"]) }; writer.SendCommand(playerYear); } } } } return("player year submitted"); }; Get["/testcard"] = _ => { var player = new CreatePlayer() { Bats = "R", College = "University of Notre Dame", Debut = DateTime.Now.AddYears(-10), FinalGame = DateTime.Now.AddYears(-2), FirstName = "David", Height = 74, LahmanId = 100000, LastName = "Hoerster", NickName = "Dave", PlayerId = "davehoerster", Throws = "R", Weight = 180 }; Agile.Minimalist.Commands.Writer.ICommandWriter writer = new Agile.Minimalist.Commands.Writer.CommandWriter(); writer.SendCommand(player); return("test player created!"); }; Get["/testcard/{year}"] = args => { var playerYear = new AddPlayerYear() { Average = 0.275, Doubles = 25, Hits = 100, HomeRuns = 50, LahmanId = 100000, RunsBattedIn = 75, Salary = 10000000, StrikeOuts = 3, TeamName = "Pittsburgh Pirates", Triples = 15, Year = args.year }; Agile.Minimalist.Commands.Writer.ICommandWriter writer = new Agile.Minimalist.Commands.Writer.CommandWriter(); writer.SendCommand(playerYear); return("player year for year " + args.year + " created!"); }; }