// Add new team to database. Team object receieves a TeamID public void AddTeam(Team team) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); try { p.Add("TeamName", team.TeamName); p.Add("ManagerName", team.ManagerName); p.Add("LeagueID", team.LeagueID); p.Add("TeamID", DbType.Int32, direction: ParameterDirection.Output); cn.Execute("CreateTeam", p, commandType: CommandType.StoredProcedure); team.TeamID = p.Get<int>("TeamID"); } //catch (Exception e) //{ // var ep = new DynamicParameters(); // ep.Add("ExceptionType", e.GetType()); // ep.Add("ExceptionMessage", e.Message); // ep.Add("Input", String.Format("TeamName = {0}, ManagerName = {1}, LeagueID = {2}", // team.TeamName, team.ManagerName, team.LeagueID)); // cn.Execute("AddError", ep, commandType: CommandType.StoredProcedure); //} finally { cn.Close(); } } }
public int AddTeam(Team team) { int teamId; using (var connection = new SqlConnection(Settings.ConnectionString)) { var command = new SqlCommand(); command.CommandText = "SP_AddTeam"; command.CommandType = CommandType.StoredProcedure; var outputParam = new SqlParameter("@TeamID", SqlDbType.Int) { Direction = ParameterDirection.Output }; command.Connection = connection; command.Parameters.AddWithValue("@TeamName", team.TeamName); command.Parameters.AddWithValue("@ManagerName", team.ManagerName); command.Parameters.Add(outputParam); connection.Open(); command.ExecuteNonQuery(); teamId = (int)outputParam.Value; } return teamId; }
public void AddTeamTest() { var team = new Team(); team.TeamName = "CloudRiders"; team.Manager = "Genos"; team.League.LeagueID = 2; var response = _ops.AddTeam(team); Assert.AreEqual(true, response.Success); }
public Response() { League = new League(); Leagues = new List<League>(); Team = new Team(); Teams = new List<Team>(); Position = new Position(); Positions = new List<Position>(); Player = new Player(); Players = new List<Player>(); }
public Team AddTeam(Team team) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var pnsm = new DynamicParameters(); pnsm.Add("@TeamName", team.TeamName); pnsm.Add("@Manager", team.Manager); pnsm.Add("@LeagueID", team.League.LeagueID); pnsm.Add("@TeamID", DbType.Int32, direction: ParameterDirection.Output); cn.Execute("InsertTeams", pnsm, commandType: CommandType.StoredProcedure); var teamID = pnsm.Get<int>("TeamID"); return GetTeamByID(teamID); } }
public int AddTeam(Team t) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var sqlQuery = "INSERT INTO Team (TeamName,Manager,LeagueID) " + "VALUES (@TeamName,@Manager,@LeagueID) "+ "SELECT SCOPE_IDENTITY() AS id"; int teamId = cn.Query<int>(sqlQuery, new { t.TeamName, t.Manager, t.LeagueId }).FirstOrDefault(); return teamId; } }
public void AddTeam() { var team = new Team(); team.TeamName = "Cloud Riders"; team.Manager = "Genos"; team.League.LeagueID = 2; var result = _repo.AddTeam(team); var expectedTeam = _repo.GetTeamByID( result.TeamID); var actual = _jss.Serialize(result); var expected = _jss.Serialize(expectedTeam); Assert.AreEqual(expected, actual); }
public Response AddTeam(Team teamToAdd) { _response = new Response(); var team = _repo.AddTeam(teamToAdd); if (team != null) { _response.Success = true; _response.Team = team; } else { _response.Success = false; } return _response; }
private Team PopulateTeamInfoFromDataReader(SqlDataReader dr) { var team = new Team(); team.TeamID = (int)dr["TeamID"]; team.TeamName = dr["TeamName"].ToString(); team.Manager = dr["Manager"].ToString(); team.League.LeagueID = (int)dr["LeagueID"]; return team; }
public League GetTeamsByLeagueID(int leagueID) { League league = new League(); Teams = new List<Team>(); using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand(); cmd.CommandText = "GetTeamsByLeagueID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = cn; cmd.Parameters.AddWithValue("@LeagueID", leagueID); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { league = PopulateLeagueInfoFromReader(dr); Team team = new Team(); team.TeamID = (int)dr["TeamID"]; team.League.LeagueID = (int)dr["leagueID"]; team.League.LeagueName = dr["leagueName"].ToString(); team.Manager = dr["Manager"].ToString(); team.TeamName = dr["TeamName"].ToString(); Teams.Add(team); league.Teams = Teams; } } } return league; }
//public League GetTeamsByLeagueID(int leagueID) //{ // League league = new League(); // using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) // { // var p = new DynamicParameters(); // p.Add("@LeagueID", leagueID); // league = cn.Query<League>("GetTeamsByLeagueID", p, commandType: CommandType.StoredProcedure).FirstOrDefault(); // } // return league; //} public Team GetTeamByID(int teamID) { Team team = new Team(); using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TeamID", teamID); team = cn.Query<Team>("GetTeamByID", p, commandType: CommandType.StoredProcedure).FirstOrDefault(); } return team; }
public Player() { Position = new Position(); Team = new Team(); }
public TeamAndPlayersViewModel(Team t, List<Player> plist) { Team = t; Players = plist; }
public TeamAndPlayersViewModel() { Team = new Team(); Players = new List<Player>(); }
// Add new team to database. Team object receieves a TeamID public void AddTeam(Team team) { var create = new Create(); create.AddTeam(team); }
public void PostNewTeam(Team NewTeam) { var ops = new BaseballBLL(); ops.AddTeam(NewTeam); }