private void playersTeamComboBox_SelectedValueChanged(object sender, EventArgs e) { dtm = (DivisionTeamsModel)playersTeamComboBox.SelectedItem; if (dtm != null) { teamMembers.Clear(); teamMembers = GlobalConfig.Connection.GetTeamMembers(dtm); wireUpPlayersListBox(); wireUpPlayersComboBox(); } }
// <summary> /// Gets a List of The TeamMembers in selected Team /// </summary> /// <returns>A List of The PersonModels in selected Team </returns> public List <PersonModel> GetTeamMembers(DivisionTeamsModel model) { List <PersonModel> output; using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@DivisionTeamsID", model.DivisionTeamsID); output = connection.Query <PersonModel>("spGetTeamMembers", p, commandType: CommandType.StoredProcedure).ToList(); } return(output); }
public void PersonComplete(PersonModel model) { DivisionTeamsModel dtm = (DivisionTeamsModel)playersTeamComboBox.SelectedItem; RosterModel rm = new RosterModel(); rm.DivisionTeamsID = dtm.DivisionTeamsID; sdtp.PersonID = model.PersonID; teamMembers.Add(model); rm.players = teamMembers; GlobalConfig.Connection.CreateRoster(rm); sdtp.RosterID = rm.RosterID; wireUpPlayersListBox(); }
/// <summary> /// add selected teams to db et.al /// </summary> /// <param name="model"></param> private void addTeams(DivisionModel model) { DivisionTeamsModel dtm = new DivisionTeamsModel(); dtm.SeasonDivisionsID = sdm.SeasonDivisionsID; foreach (TeamModel team in teamsToAdd) { dtm.TeamID = team.TeamID; model.DivisionTeams.Add(team); GlobalConfig.Connection.CreateDivisionTeams(dtm); } teamsToAdd = new List <TeamModel>(); }
/// <summary> /// When team is complete update display and DB /// </summary> /// <param name="model"></param> public void TeamComplete(TeamModel model) { dtm = new DivisionTeamsModel(); dtm.SeasonDivisionsID = sdtp.SeasonDivisionsID; dtm.DivisionID = ((DivisionModel)teamsDivisionComboBox.SelectedItem).DivisionID; dtm.TeamID = model.TeamID; sdtp.TeamID = model.TeamID; //selectedTeams.Add(model); GlobalConfig.Connection.CreateDivisionTeams(dtm); sdtp.DivisionTeamsID = dtm.DivisionTeamsID; wireupTeamsListBox(); wireUpPlayersTeamComboBox(); //teamsListBox.Items.Add(model.TeamName); }
public DivisionTeamsModel GetDivisionTeamModel(int seasonDivisionsID, int teamID) { List <DivisionTeamsModel> output; DivisionTeamsModel dtm = new DivisionTeamsModel(); using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@InSeasonDivisionsID", seasonDivisionsID); p.Add("@InTeamID", teamID); output = connection.Query <DivisionTeamsModel>("spGetDivisionTeamModel", p, commandType: CommandType.StoredProcedure).ToList(); } foreach (DivisionTeamsModel model in output) { dtm = model; } return(dtm); }
/// <summary> /// Adds selected team to selected Division in current season /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void addTeamButton_Click(object sender, EventArgs e) { dm = (DivisionModel)(teamsDivisionComboBox.SelectedItem); if (dm != null) { TeamModel tm = (TeamModel)teamsComboBox.SelectedItem; if (tm != null) { selectedTeams.Add(tm); dtm = new DivisionTeamsModel(); dtm.SeasonDivisionsID = sdm.SeasonDivisionsID; dtm.DivisionID = dm.DivisionID; dtm.TeamID = tm.TeamID; GlobalConfig.Connection.CreateDivisionTeams(dtm); sdtp.DivisionTeamsID = dtm.DivisionTeamsID; wireupTeamsListBox(); wireUpTeamsComboBox(); wireUpPlayersTeamComboBox(); } } }
private void dateComboBox_SelectedValueChanged(object sender, EventArgs e) { thisGame = (GameModel)dateComboBox.SelectedValue; thisGame.HomeTeamModel = (TeamModel)allTeams.FirstOrDefault(x => x.TeamID == thisGame.HomeTeam); thisGame.AwayTeamModel = (TeamModel)allTeams.FirstOrDefault(x => x.TeamID == thisGame.AwayTeam); if (thisGame.HomeTeamModel.TeamID != 0) { //TODO work out whats missing here if anything } //DateTime date = thisGame.GameDate; sdtp = GlobalConfig.Connection.GetSdtpModel(sdtpID); DivisionTeamsModel dtmAway = GlobalConfig.Connection.GetDivisionTeamModel(sdtp.SeasonDivisionsID, thisGame.AwayTeamModel.TeamID); DivisionTeamsModel dtmHome = GlobalConfig.Connection.GetDivisionTeamModel(sdtp.SeasonDivisionsID, thisGame.HomeTeamModel.TeamID); thisGame.HomeTeamPlayers = GlobalConfig.Connection.GetTeamMembers(dtmHome); thisGame.AwayTeamPlayers = GlobalConfig.Connection.GetTeamMembers(dtmAway); t1Available = thisGame.HomeTeamPlayers; t2Available = thisGame.AwayTeamPlayers; WireupTeamComboBoxes(thisGame); }
private void addPlayerButton_Click(object sender, EventArgs e) { dtm = (DivisionTeamsModel)(playersTeamComboBox.SelectedItem); if (dtm != null) { PersonModel pm = (PersonModel)playersComboBox.SelectedItem; if (pm != null) { teamMembers.Clear(); teamMembers.Add(pm); seasonPlayers.Add(pm); RosterModel rm = new RosterModel(); rm.DivisionTeamsID = dtm.DivisionTeamsID; rm.players = teamMembers; GlobalConfig.Connection.CreateRoster(rm); sdtp.SeasonID = season.SeasonID; sdtp.PersonID = pm.PersonID; sdtp.DivisionTeamsID = dtm.DivisionTeamsID; sdtp.RosterID = rm.RosterID; sdtp.SeasonDivisionsID = dtm.SeasonDivisionsID; sdtp.TeamID = dtm.TeamID; sdtp.DivisionID = dtm.DivisionID; //dtm = (DivisionTeamsModel)playersTeamComboBox.SelectedItem; teamMembers.Clear(); teamMembers = GlobalConfig.Connection.GetTeamMembers(dtm); // creat ean entry in DB with SeasonID, DivisionteamsID and PlayerID GlobalConfig.Connection.CreateSDTP(sdtp); wireUpPlayersListBox(); wireUpPlayersComboBox(); } } }
/// <summary> /// Saves a new Collection of Teams in Selected Dvision to the MySQL DB /// </summary> /// <param name="model"></param> /// <returns>Nothing atm</returns> public DivisionTeamsModel CreateDivisionTeams(DivisionTeamsModel model) { using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@DivisionTeamsID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@InSeasonDivisionsID", model.SeasonDivisionsID); p.Add("@InDivisionID", model.DivisionID); p.Add("@InTeamID", model.TeamID); connection.Execute("spDivisionTeams", p, commandType: CommandType.StoredProcedure); // grabs newly created ID from database and returns it as part of the current Person Model // https://stackoverflow.com/questions/13151861/fetch-last-inserted-id-form-stored-procedure-in-mysql var id = p.Get <int?>("DivisionTeamsID"); model.DivisionTeamsID = Convert.ToInt32(id); return(model); } }
public List <PersonModel> GetTeamMembers(DivisionTeamsModel model) { throw new NotImplementedException(); }
public DivisionTeamsModel CreateDivisionTeams(DivisionTeamsModel model) { throw new NotImplementedException(); }