public PlayerViewModelBase(Player player) { //_player = player; if (player != null) { _playerId = player.PlayerId; _firstName = player.FirstName; _lastName = player.LastName; _tvName = player.TvName; _hometown = player.Hometown; _state = player.State; _position = player.Position; _positionFull = player.PositionFull; _height = player.Height; _weight = player.Weight; _class = player.Class; _headshot = player.Headshot; _kiperRank = player.KiperRank; _mcShayRank = player.McShayRank; _school = player.School; _pick = player.Pick; _tradeTidbit = player.TradeTidbit; _tidbits = player.Tidbits; loadTidbits(); } }
public static ObservableCollection<Pick> GetDraftOrder(ObservableCollection<Team> teams) { OracleConnection cn = null; OracleCommand cmd = null; OracleDataReader rdr = null; DataTable tbl = null; ObservableCollection<Pick> picks = new ObservableCollection<Pick>(); try { cn = createConnectionSDR(); if (cn != null) { string sql = "select * from espnews.draftorder"; cmd = new OracleCommand(sql, cn); rdr = cmd.ExecuteReader(); tbl = new DataTable(); tbl.Load(rdr); rdr.Close(); Pick pick; foreach (DataRow row in tbl.Rows) { pick = new Pick(); pick.OverallPick = Convert.ToInt16(row["pick"].ToString()); pick.Round = Convert.ToInt16(row["round"].ToString()); pick.RoundPick = Convert.ToInt16(row["roundpick"].ToString()); //pick.Team = GetTeam(Convert.ToInt32(row["teamid"].ToString())); pick.Team = (Team)teams.SingleOrDefault(s => s.ID == Convert.ToInt32(row["teamid"])); picks.Add(pick); } } } finally { if (cmd != null) cmd.Dispose(); if (tbl != null) tbl.Dispose(); if (cn != null) cn.Close(); cn.Dispose(); } return picks; }
public static bool TradePick(Pick pick, Team newTeam) { OracleConnection cn = null; OracleCommand cmd = null; OracleDataAdapter adp = null; MySqlConnection cnMySql = null; MySqlCommand cmdMySql = null; DataTable tbl = null; string sql = ""; bool saved = false; int fromTeam = 0; try { cn = createConnectionSDR(); sql = "select teamid from draftorder where pick = " + pick.OverallPick; cmd = new OracleCommand(sql, cn); adp = new OracleDataAdapter(cmd); tbl = new DataTable(); adp.Fill(tbl); if (tbl.Rows.Count > 0) { fromTeam = int.Parse(tbl.Rows[0][0].ToString()); } sql = "update draftorder set teamid = " + newTeam.ID + " where pick = " + pick.OverallPick; cmd = new OracleCommand(sql, cn); cmd.ExecuteNonQuery(); //update the MySql database's teams table with the new total pick counts try { cnMySql = createConnectionMySql(); sql = "select count(*) from draftorder where teamid = " + fromTeam; cmd = new OracleCommand(sql, cn); adp = new OracleDataAdapter(cmd); tbl = new DataTable(); adp.Fill(tbl); if (tbl.Rows.Count > 0) { sql = "update teams set totalpicks = '" + tbl.Rows[0][0].ToString() + "' where id = " + fromTeam; cmdMySql = new MySqlCommand(sql, cnMySql); cmdMySql.ExecuteNonQuery(); } sql = "select count(*) from draftorder where teamid = " + newTeam.ID; cmd = new OracleCommand(sql, cn); adp = new OracleDataAdapter(cmd); tbl = new DataTable(); adp.Fill(tbl); if (tbl.Rows.Count > 0) { sql = "update teams set totalpicks = '" + tbl.Rows[0][0].ToString() + "' where id = " + newTeam.ID; cmdMySql = new MySqlCommand(sql, cnMySql); cmdMySql.ExecuteNonQuery(); } } finally { cmd.Dispose(); adp.Dispose(); tbl.Dispose(); } saved = true; } finally { if (cmd != null) cmd.Dispose(); if (cn != null) cn.Close(); cn.Dispose(); } return saved; }