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