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