protected void CompanySignUpButton_Click(object sender, EventArgs e)
{
if (MultiView2.GetActiveView() == CompanySignUp)
{
MultiView2.SetActiveView(emptyView);
}
else
{
MultiView2.SetActiveView(CompanySignUp);
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("EXEC ListAllCities", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
companyCityList.DataSource = reader;
companyCityList.DataTextField = "Name";
companyCityList.DataValueField = "ID";
companyCityList.DataBind();
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
CompanyDistrictList.Items.Clear();
SqlCommand command = new SqlCommand("EXEC ListAllDistrictsWithCity " + companyCityList.SelectedItem.Value, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
CompanyDistrictList.DataSource = reader;
CompanyDistrictList.DataTextField = "Name";
CompanyDistrictList.DataValueField = "ID";
CompanyDistrictList.DataBind();
}
}
protected void companyCityList_SelectedIndexChanged(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
CompanyDistrictList.Items.Clear();
SqlCommand command = new SqlCommand("EXEC ListAllDistrictsWithCity " + companyCityList.SelectedItem.Value, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
CompanyDistrictList.DataSource = reader;
CompanyDistrictList.DataTextField = "Name";
CompanyDistrictList.DataValueField = "ID";
CompanyDistrictList.DataBind();
}
companysignuppassword1.Attributes.Add("value", password);
companysignuppassword2.Attributes.Add("value", password);
}
