public bool GenerateNextRoundMatchups(Round round)
{
double tempSeeds;
int numOfSeeds;
tempSeeds = 16 / (Math.Pow(2, round.Name - 1));
if (!int.TryParse(tempSeeds.ToString(), out numOfSeeds))
return false;
List<int> regionIds = new List<int>();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["IYFD"].ToString()))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("dbo.GetAllRegions", connection))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
regionIds.Add(Convert.ToInt32(reader["id"]));
}
}
}
foreach (int j in regionIds)
{
for (int i = 1; i <= numOfSeeds / 2; i++)
{
using (SqlCommand cmd = new SqlCommand("dbo.GenerateMatchup", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@regionID", j);
cmd.Parameters.AddWithValue("@seed", i);
cmd.Parameters.AddWithValue("@numOfSeed", numOfSeeds);
cmd.Parameters.AddWithValue("@roundId", round.ID);
cmd.ExecuteNonQuery();
}
}
}
}
return true;
}
public bool UpsertRound(Round round)
{
int rows = 0;
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["IYFD"].ToString()))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("dbo.UpsertRound", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
//if(team.ID != null)
//cmd.Parameters.AddWithValue("@ID", team.ID);
cmd.Parameters.AddWithValue("@round", round.Name);
rows = cmd.ExecuteNonQuery();
}
}
return rows > 0;
}