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