protected void ajaxManager_AjaxRequest(object sender, AjaxRequestEventArgs e)
{
if (e.Argument == "mobile")
{
RadMenu menu = (RadMenu)WebUserControl1.FindControl("menu");
menu.RenderMode = RenderMode.Mobile;
}
}
protected void CancelButton_Click(object sender, EventArgs e)
{
TextBox NameTextBox = WebUserControl1.FindControl("NameTextBox") as TextBox;
TextBox CityTextBox = WebUserControl1.FindControl("CityTextBox") as TextBox;
NameTextBox.Text = null;
CityTextBox.Text = null;
AddressTextBox.Text = null;
RegistrationTextBox.Text = null;
}
protected void SaveClubButton_Click(object sender, EventArgs e)
{
Response.Write("<script>alert('CLUB SAVED SUCCESSFULLY') </script>");
AddPlayerButton.Visible = true;
TextBox NameTextBox = WebUserControl1.FindControl("NameTextBox") as TextBox;
TextBox CityTextBox = WebUserControl1.FindControl("CityTextBox") as TextBox;
string ClubName = NameTextBox.Text;
string ClubCity = CityTextBox.Text;
SqlConnection conn;
SqlCommand comm;
// Read the connection string from Web.config
string connectionString = ConfigurationManager.ConnectionStrings["SoccerLeague"].ConnectionString;
// Initialize connection
conn = new SqlConnection(connectionString);
// Create command
comm = new SqlCommand("insert into ClubTable(ClubName, ClubCity, ClubRegistrationNo , ClubAddress) values( @ClubName, @ClubCity, @RegistrationNumber, @Address)", conn);
comm.Parameters.AddWithValue("@ClubName", ClubName);
comm.Parameters.AddWithValue("@ClubCity", ClubCity);
comm.Parameters.AddWithValue("@RegistrationNumber", RegistrationTextBox.Text);
comm.Parameters.AddWithValue("@Address", AddressTextBox.Text);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (SqlException ex)
{
Label6.Visible = true;
Label6.Text = ex.Message;
}
finally
{
conn.Close();
}
}
