protected void Page_Load(object sender, EventArgs e)
{
int playerId = int.Parse(Request.QueryString["player"]);
MlbDataContext mlbData = new MlbDataContext();
var player = (from p in mlbData.PLAYERs
where p.PLAYER_ID == playerId
select p).SingleOrDefault();
var contract = (from c in mlbData.CONTRACTs
where c.Player == playerId
select c).SingleOrDefault();
lblPlayer.Text = player.Name;
if (contract != null)
{
}
else
{
}
}
protected void butSearch_Click(object sender, EventArgs e)
{
MlbDataContext mlbData = new MlbDataContext();
if (txtSearch.Text.Length > 0)
{
var players = from p in mlbData.PLAYERs
where p.Name.IndexOf(txtSearch.Text) >= 0
select p;
grdPlayerContracts.DataSource = players;
grdPlayerContracts.DataBind();
}
}
protected void butSubmit_Click(object sender, EventArgs e)
{
int playerId = int.Parse(Request.QueryString["player"]);
MlbDataContext mlbData = new MlbDataContext();
CONTRACT con = (from c in mlbData.CONTRACTs
where c.Player == playerId
select c).SingleOrDefault();
if (con == null)
{
con = new CONTRACT();
con.Player = playerId;
mlbData.CONTRACTs.InsertOnSubmit(con);
}
con.YearSigned = int.Parse(drpYearSigned.Text);
mlbData.SubmitChanges();
foreach (string key in Request.Form.Keys)
{
int index = key.IndexOf("Salary");
if (index >= 0)
{
int year = int.Parse(key.Substring(index + 6));
var conYear = (from cy in mlbData.CONTRACT_YEARs
where cy.Contract == con.CONTRACT_ID && cy.Year == year
select cy).SingleOrDefault();
if (conYear == null)
{
conYear = new CONTRACT_YEAR();
conYear.Contract = con.CONTRACT_ID;
conYear.Year = year;
mlbData.CONTRACT_YEARs.InsertOnSubmit(conYear);
}
conYear.Salary = decimal.Parse(Request.Form[key]);
}
}
mlbData.SubmitChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int teamId = int.Parse(Request.QueryString["team"]);
var team = (from t in fantasyData.TEAMs
where t.TEAM_ID == teamId
select t).SingleOrDefault();
lblTeamName.Text = team.Name;
imgTeam.ImageUrl = Request.ApplicationPath + "images/mlb/" + team.Logo;
var batters = from b in fantasyData.GetFantasyTeamBattersYearly(4, teamId, 2007)
orderby b.Ordinal
select new
{
b.Player,
b.Position,
b.Name,
HAB = (b.H.HasValue && b.AB.HasValue) ? b.H.ToString() + "/" + b.AB.ToString() : null,
b.R,
b.HR,
b.RBI,
b.SB,
AVG = FantasyBaseball.AVG(b.Player, b.AB, b.H),
OBP = FantasyBaseball.OBP(b.Player, b.AB, b.BB, b.HBP, b.SF, b.H),
SLG = FantasyBaseball.SLG(b.Player, b.AB, b.H, b._2B, b._3B, b.HR),
OPS = FantasyBaseball.OBP(b.Player, b.AB, b.BB, b.HBP, b.SF, b.H) + FantasyBaseball.SLG(b.Player, b.AB, b.H, b._2B, b._3B, b.HR)
};
var pitchers = from p in fantasyData.GetFantasyTeamPitchersYearly(4, teamId, 2007)
orderby p.Ordinal
select new
{
p.Player,
p.Position,
p.Name,
IP = FantasyBaseball.IP(p.Player, p.OUTS),
p.W,
p.SV,
p.SO,
K9 = FantasyBaseball.K9(p.Player, p.OUTS, p.SO),
p.HLD,
ERA = FantasyBaseball.ERA(p.Player, p.OUTS, p.ER),
WHIP = FantasyBaseball.WHIP(p.Player, p.OUTS, p.H, p.BB)
};
grdHitters.DataSource = batters;
grdHitters.DataKeyNames = new string[] { "Player" };
grdHitters.DataBind();
grdPitchers.DataSource = pitchers;
grdPitchers.DataKeyNames = new string[] { "Player" };
grdPitchers.DataBind();
}
if (Request.QueryString["addplayer"] != null)
{
MlbDataContext mlbData = new MlbDataContext();
int playerId = int.Parse(Request.QueryString["addplayer"]);
PLAYER player = (from p in mlbData.PLAYERs
where p.PLAYER_ID == playerId
select p).SingleOrDefault();
lblAddPlayer.Text = player.Name;
hidAddPlayer.Value = playerId.ToString();
hidPlayerPos.Value = player.Position;
pnlAddPlayer.Visible = true;
}
}
