public void GetMatchups() { DataTable dt = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["localConnection"].ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("dbo.getMatchups", conn); cmd.Parameters.AddWithValue("@tid", tid); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); } foreach (DataRow dr in dt.Rows) { Matchup temp = new Matchup(dr); ml.Add(temp); if (completed == 1 && temp.mid == 0) { if (temp.winner == 1) { if (!string.IsNullOrEmpty(temp.p1user)) { winnername = temp.p1user; } else { winnername = temp.p1email; } } else { if (!string.IsNullOrEmpty(temp.p2user)) { winnername = temp.p2user; } else { winnername = temp.p2email; } } } } }
public void UpdateMatchup(Matchup m, int tid) { if (m.winner > 0) { SetWinner(tid, m.mid, m.winner); } using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["localConnection"].ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("dbo.modifyMatchup", conn); cmd.Parameters.AddWithValue("@tid", tid); cmd.Parameters.AddWithValue("@mid", m.mid); cmd.Parameters.AddWithValue("@p1score", m.p1score); cmd.Parameters.AddWithValue("@p2score", m.p2score); cmd.Parameters.AddWithValue("@winner", m.winner); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } }