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(); } }
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 = ""; } }