protected void gv_MyTeam_CheckChanged(object sender, EventArgs e) { string danrules = "yes"; int _id = 0; RepeaterItem row = (sender as CheckBox).Parent as RepeaterItem; CheckBox cb = row.FindControl("CheckBox2") as CheckBox; RepeaterItem item = (RepeaterItem)cb.NamingContainer; Label lblid = (Label)item.FindControl("lblID"); _id = int.Parse(lblid.Text); if (cb.Checked) { using (FF2014Entities itx = new FF2014Entities()) { var _i = from i in itx.FF_Player where i.ID == _id select i; foreach (var t in _i) { t.DRAFTED = true; t.MYTEAM = true; } itx.SaveChanges(); updateCount(_id, itx, true); itx.Dispose(); } BuildData(); } else { using (FF2014Entities itx = new FF2014Entities()) { var _i = from i in itx.FF_Player where i.ID == _id select i; foreach (var t in _i) { t.DRAFTED = false; t.MYTEAM = false; } itx.SaveChanges(); updateCount(_id, itx, false); itx.Dispose(); } BuildData(); } }
public static string[] GetPlayerList(string keyword) { List <string> _players = new List <string>(); using (FF2014Entities atx = new FF2014Entities()) { var _a = from d in atx.FF_Player let fullname = d.FIRST + " " + d.LAST where fullname.Contains(keyword) && d.DRAFTED == false select d; foreach (var a in _a) { _players.Add(a.FIRST.Trim() + " " + a.LAST.Trim() + " (" + a.POS.Trim() + ")" + " - " + a.TEAM + " |" + a.ID); } atx.Dispose(); } return(_players.ToArray()); }
private void updateTeam() { List <FFTeam> _teams = new List <FFTeam>(); List <int> teamIDs = new List <int>(); using (FF2014Entities itx = new FF2014Entities()) { var _tids = (from x in itx.FF_Team from d in itx.FF_DRAFT.Where(o => x.ID == o.TEAMID).DefaultIfEmpty() group new { x.ID, d.DRAFT, x.TeamName, x.TeamManager, x.Picture } by new { x.ID, d.DRAFT, x.TeamName, x.TeamManager, x.Picture } into g orderby g.Key.DRAFT select new { ID = g.Key.ID, TeamName = g.Key.TeamName, TeamManager = g.Key.TeamManager, Picture = g.Key.Picture }); foreach (var u in _tids) { _teams.Add(new FFTeam { TeamID = u.ID, TeamName = u.TeamName }); } foreach (FFTeam f in _teams) { var _pids = from l in itx.FF_League where l.TEAMID == f.TeamID select l.PLAYERID; foreach (int l in _pids) { var _player = from p in itx.FF_Player where p.ID == l select p; foreach (var t in _player) { #region switch position switch (t.POS.Trim()) { case "QB": if (string.IsNullOrEmpty(f.QB)) { f.QB = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH1)) { f.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH2)) { f.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH3)) { f.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH4)) { f.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH5)) { f.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH6)) { f.BENCH6 = t.FIRST + " " + t.LAST; } break; case "RB": if (string.IsNullOrEmpty(f.RB1)) { f.RB1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.RB2)) { f.RB2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.FLEX)) { f.FLEX = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH1)) { f.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH2)) { f.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH3)) { f.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH4)) { f.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH5)) { f.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH6)) { f.BENCH6 = t.FIRST + " " + t.LAST; } break; case "WR": if (string.IsNullOrEmpty(f.WR1)) { f.WR1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.WR2)) { f.WR2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.WR3)) { f.WR3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.FLEX)) { f.FLEX = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH1)) { f.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH2)) { f.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH3)) { f.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH4)) { f.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH5)) { f.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH6)) { f.BENCH6 = t.FIRST + " " + t.LAST; } break; case "TE": if (string.IsNullOrEmpty(f.TE)) { f.TE = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.FLEX)) { f.FLEX = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH1)) { f.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH2)) { f.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH3)) { f.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH4)) { f.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH5)) { f.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH6)) { f.BENCH6 = t.FIRST + " " + t.LAST; } break; case "K": if (string.IsNullOrEmpty(f.K)) { f.K = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH1)) { f.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH2)) { f.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH3)) { f.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH4)) { f.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH5)) { f.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH6)) { f.BENCH6 = t.FIRST + " " + t.LAST; } break; case "DEF": if (string.IsNullOrEmpty(f.DEF)) { f.DEF = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH1)) { f.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH2)) { f.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH3)) { f.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH4)) { f.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH5)) { f.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(f.BENCH6)) { f.BENCH6 = t.FIRST + " " + t.LAST; } break; } #endregion } } } itx.Dispose(); } dlTeams.DataSource = _teams; dlTeams.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { drafting = getTurn(); string boxvalue = tags.Text; string[] parts = boxvalue.Split('|'); if (parts.Length > 1) { int pid = int.Parse(parts[1].ToString().Trim()); using (FF2014Entities ptx = new FF2014Entities()) { var tid = (from i in ptx.FF_DRAFT where i.DRAFT == drafting select i.TEAMID).First(); FF_League l = new FF_League { PLAYERID = pid, TEAMID = (int)tid }; ptx.FF_League.Add(l); ptx.SaveChanges(); var p = from layer in ptx.FF_Player where layer.ID == pid select layer; foreach (var y in p) { y.DRAFTED = true; if (tid == 1) { y.MYTEAM = true; } } ptx.SaveChanges(); ptx.Dispose(); } using (FF2014Entities stx = new FF2014Entities()) { var s = from x in stx.FF_Turn where x.ID == 1 select x; foreach (var a in s) { int incr = a.DRAFTSPOT; if (!a.UPDOWN) { if (a.DRAFTSPOT != a.MAXCOUNT) { incr++; } else { a.UPDOWN = true; } } else { if (a.DRAFTSPOT != 1) { incr--; } else { a.UPDOWN = false; } } a.DRAFTSPOT = incr; } stx.SaveChanges(); stx.Dispose(); //Update counters updateCount(pid, true); } tags.Text = ""; drafting = getTurn(); SetupPage(); updateTeam(); tags.Focus(); } else { tags.Text = ""; } }