protected void CreateTournament_Click(object sender, EventArgs e)
{
string savePath;
string selectStatement = $"select TournamentName from tbl_Tournaments where TournamentName='{TournamentName.Text}'";
bool tournamentExists = true;
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(selectStatement, con);
con.Open();
try
{
var tournament = cmd.ExecuteScalar().ToString();
}
catch (System.NullReferenceException)
{
tournamentExists = false;
}
con.Close();
if (!tournamentExists)
{
string insertStatement = $"insert into tbl_Tournaments(TournamentName, StartDate, TeamlistLink) \n values(@TournamentName, @StartDate, @savePath)";
SqlCommand cmd2 = new SqlCommand(insertStatement, con);
cmd.Parameters.AddWithValue("@TournamentName", TournamentName.Text);
cmd.Parameters.AddWithValue("@StartDate", StartDate.SelectedDate);
if (FileUploadTeamlist.HasFile)
{
savePath = Server.MapPath("~/Tournament Teamlists/" + TournamentName.Text + " Team List.json");
cmd.Parameters.AddWithValue("@savePath", savePath);
FileUploadTeamlist.SaveAs(savePath);
}
else
{
cmd.Parameters.AddWithValue("@savePath", "NULL");
}
//if (FileUploadMappool.HasFile)
//{
// savePath = Server.MapPath("~/Tournament Mappools/" + TournamentName.Text + " Mappool.json");
// cmd.Parameters.AddWithValue("@Mappool", savePath);
// FileUploadMappool.SaveAs(savePath);
//}
//else
//{
// cmd.Parameters.AddWithValue("@Mappool", "NULL");
//}
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (ArgumentNullException)
{
}
}
}
protected void EditTournament_Click(object sender, EventArgs e)
{
string savePath;
string updateStatement = $"UPDATE tbl_Tournaments SET TournamentName =@tournamentname WHERE TournamentName = '{Tournament.SelectedValue}'";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(updateStatement, con);
cmd.Parameters.AddWithValue("@tournamentname", TournamentName.Text);
if (FileUploadTeamlist.HasFile)
{
savePath = Server.MapPath("~/Tournament Teamlists/" + TournamentName.Text + " Team List.json");
FileUploadTeamlist.SaveAs(savePath);
}
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
//while (reader.Read())
//{
// tournamentList.Add(reader["TournamentName"].ToString());
//}
con.Close();
}
