private void updateCount(int pid, bool updown) { using (FF2014Entities ttt = new FF2014Entities()) { var p = (from y in ttt.FF_Player where y.ID == pid select y).First(); string _pos = p.POS.Trim(); var c = (from x in ttt.FF_TAKEN where x.POS == _pos select x).First(); if (updown) { c.COUNT++; } else { c.COUNT--; } ttt.SaveChanges(); } }
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(); } }
private void cleanSpace() { using (FF2014Entities stx = new FF2014Entities()) { var _players = from p in stx.FF_Player where p.DRAFTED == false select p; foreach (var p in _players) { p.FIRST = p.FIRST.Trim(); } stx.SaveChanges(); } }
private int getTurn() { int t = 0; using (FF2014Entities gtx = new FF2014Entities()) { var _t = from x in gtx.FF_Turn where x.ID == 1 select x.DRAFTSPOT; foreach (var u in _t) { t = u; } } return(t); }
private void SetupPage() { string curname = string.Empty; using (FF2014Entities itx = new FF2014Entities()) { var im = (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 a in im) { int?draftnum; var did = (from i in itx.FF_DRAFT where i.TEAMID == a.ID select i.DRAFT).FirstOrDefault(); draftnum = int.Parse(did.ToString()); _teams.Add(new localTeam { TeamName = a.TeamName, TeamManager = a.TeamManager, Picture = "IMG/" + a.Picture, DraftOrder = draftnum, ID = a.ID }); } var curdraft = (from f in itx.FF_DRAFT where f.DRAFT == drafting select f).FirstOrDefault(); var cur = (from i in itx.FF_Team where i.ID == curdraft.TEAMID select i).First(); curname = cur.TeamName; } rptDrafters.DataSource = _teams; rptDrafters.DataBind(); lblNowDrafting.Text = curname.Trim(); }
private void BuildData() { List <MyTeam> teamList = new List <MyTeam>(); List <localPlayer> playerList = new List <localPlayer>(); using (FF2014Entities ptx = new FF2014Entities()) { var _players = from p in ptx.FF_Player where p.DRAFTED == false select p; foreach (var p in _players) { localPlayer l = new localPlayer(); l.ID = p.ID; l.FIRST = p.FIRST; l.LAST = p.LAST; l.FullName = p.FIRST.Trim() + " " + p.LAST.Trim(); l.OVERALL = p.OVERALL; l.ADP = p.ADP; l.Team = p.TEAM; l.Bye = p.BYE; l.Pos = p.POS; l.VDB = p.VBD; l.Pts = p.PTS; l.Drafted = p.DRAFTED; l.MyTeam = p.MYTEAM; l.SID = p.SID; playerList.Add(l); } getCounters(ptx); } rptPlayers.DataSource = playerList.OrderBy(x => x.OVERALL); rptPlayers.DataBind(); updateTeam(); teamList.Add(team); rptMyTeam.DataSource = teamList; rptMyTeam.DataBind(); }
private void getCounters(FF2014Entities ptx) { var counters = from x in ptx.FF_TAKEN select x; int totalcount = 0; foreach (var a in counters) { if (a.POS.Trim().ToUpper() == "QB") { lblQBCount.Text = a.COUNT.ToString(); totalcount += int.Parse(a.COUNT.ToString()); } if (a.POS.Trim().ToUpper() == "RB") { lblRBCount.Text = a.COUNT.ToString(); totalcount += int.Parse(a.COUNT.ToString()); } if (a.POS.Trim().ToUpper() == "WR") { lblWRCount.Text = a.COUNT.ToString(); totalcount += int.Parse(a.COUNT.ToString()); } if (a.POS.Trim().ToUpper() == "TE") { lblTECount.Text = a.COUNT.ToString(); totalcount += int.Parse(a.COUNT.ToString()); } if (a.POS.Trim().ToUpper() == "K") { lblKCount.Text = a.COUNT.ToString(); totalcount += int.Parse(a.COUNT.ToString()); } if (a.POS.Trim().ToUpper() == "DEF") { lblDEFCount.Text = a.COUNT.ToString(); totalcount += int.Parse(a.COUNT.ToString()); } } lblTotalCount.Text = totalcount.ToString(); }
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()); }
protected void lbEmail_Click(object sender, EventArgs e) { string messagebody = string.Empty; messagebody += "<table>"; using (FF2014Entities ltx = new FF2014Entities()) { var row = from l in ltx.FF_League from t in ltx.FF_Team.Where(o => l.TEAMID == o.ID).DefaultIfEmpty() from p in ltx.FF_Player.Where(z => l.PLAYERID == z.ID).DefaultIfEmpty() select new { Teamname = t.TeamName, PlayerName = p.FIRST + " " + p.LAST }; foreach (var r in row) { messagebody += "<tr><td>" + r.Teamname + "</td><td>" + r.PlayerName + "</td></tr>"; } } System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage(); message.To.Add("*****@*****.**"); message.Subject = "North Shore Booze Bags 10 Draft Results"; message.From = new System.Net.Mail.MailAddress("*****@*****.**"); message.Body = messagebody; message.IsBodyHtml = true; System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient(); smtp.Host = "smtp.hitchiner.com"; //smtp.Port = 587; //smtp.EnableSsl = true; smtp.Send(message); }
private void updateTeam() { // if(Session["_team"] != null) {team = (MyTeam)Session["_team"];} using (FF2014Entities itx = new FF2014Entities()) { var _player = from p in itx.FF_Player where p.MYTEAM == true select p; foreach (var t in _player) { switch (t.POS.Trim()) { case "QB": if (string.IsNullOrEmpty(team.QB)) { team.QB = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH1)) { team.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH2)) { team.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH3)) { team.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH4)) { team.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH5)) { team.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH6)) { team.BENCH6 = t.FIRST + " " + t.LAST; } break; case "RB": if (string.IsNullOrEmpty(team.RB1)) { team.RB1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.RB2)) { team.RB2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.FLEX)) { team.FLEX = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH1)) { team.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH2)) { team.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH3)) { team.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH4)) { team.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH5)) { team.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH6)) { team.BENCH6 = t.FIRST + " " + t.LAST; } break; case "WR": if (string.IsNullOrEmpty(team.WR1)) { team.WR1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.WR2)) { team.WR2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.WR3)) { team.WR3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.FLEX)) { team.FLEX = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH1)) { team.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH2)) { team.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH3)) { team.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH4)) { team.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH5)) { team.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH6)) { team.BENCH6 = t.FIRST + " " + t.LAST; } break; case "TE": if (string.IsNullOrEmpty(team.TE)) { team.TE = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.FLEX)) { team.FLEX = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH1)) { team.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH2)) { team.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH3)) { team.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH4)) { team.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH5)) { team.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH6)) { team.BENCH6 = t.FIRST + " " + t.LAST; } break; case "K": if (string.IsNullOrEmpty(team.K)) { team.K = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH1)) { team.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH2)) { team.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH3)) { team.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH4)) { team.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH5)) { team.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH6)) { team.BENCH6 = t.FIRST + " " + t.LAST; } break; case "DEF": if (string.IsNullOrEmpty(team.DEF)) { team.DEF = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH1)) { team.BENCH1 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH2)) { team.BENCH2 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH3)) { team.BENCH3 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH4)) { team.BENCH4 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH5)) { team.BENCH5 = t.FIRST + " " + t.LAST; } else if (string.IsNullOrEmpty(team.BENCH6)) { team.BENCH6 = t.FIRST + " " + t.LAST; } break; } } } }
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 = ""; } }