protected void CountryDropDownList_SelectedIndexChanged(object sender, EventArgs e) { try { HRSCustomersBLL customerBLLObject = new HRSCustomersBLL(); var states = customerBLLObject.GetState(Convert.ToInt32(CountryDropDownList.SelectedItem.Value)); StateDropDownList.DataSource = states; StateDropDownList.DataTextField = "Value"; StateDropDownList.DataValueField = "Key"; StateDropDownList.DataBind(); StateDropDownList.Focus(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("$(function () {"); sb.Append(" $('#Register').modal('show');});"); sb.Append("</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModelScript", sb.ToString(), false); StateDropDownList.Focus(); } catch (Exception ex) { Utility.ExceptionUtility.ExceptionLog(ex); throw; } }
protected void CountryDropDownList_SelectedIndexChanged(object sender, EventArgs e) { DropDownList countryDropDownList = (DropDownList)sender; try { ServiceAccess serviceLoader = ServiceAccess.GetInstance(); StateDropDownList.Items.Clear(); int countryId = Convert.ToInt32(countryDropDownList.SelectedValue); if (countryId == 0) { StateDropDownList.Items.Add(new ListItem("<Select a State>", "0")); } else { CommonService.CommonService commonService = serviceLoader.GetCommon(); IList <CommonService.StateInfo> states = commonService.GetStates(countryId); StateDropDownList.DataSource = states; StateDropDownList.DataValueField = "StateId"; StateDropDownList.DataTextField = "Name"; StateDropDownList.DataBind(); } } catch (Exception ex) { log.Error("UNKNOWN ERROR:", ex); } }
private void InitializeForCountyAdmin() { DialogCredentialMessage.InnerHtml = "Your sign-in credentials allow only " + Counties.GetFullName(_SecureAdminPage.StateCode, _SecureAdminPage.CountyCode) + " local districts to be selected."; StateName.InnerHtml = States.GetName(_SecureAdminPage.StateCode); StateDropDownList.AddCssClasses("hidden"); StateRadioButton.AddCssClasses("invisible"); CountyName.InnerHtml = Counties.GetName(_SecureAdminPage.StateCode, _SecureAdminPage.CountyCode); CountyDropDownList.AddCssClasses("hidden"); LocalName.AddCssClasses("hidden"); switch (_SecureAdminPage.AdminPageLevel) { case AdminPageLevel.County: CountyRadioButton.Checked = true; PopulateLocalDropDown(true); break; case AdminPageLevel.Local: LocalRadioButton.Checked = true; PopulateLocalDropDown(); break; } }
private void PopulateStateDropDown(bool includeSelectMessage = false) { if (includeSelectMessage) { StateCache.Populate(StateDropDownList, "<select a state>", Empty); } else { StateCache.Populate(StateDropDownList, _SecureAdminPage.StateCode); } var nonStateCodesAllowed = _SecureAdminPage.NonStateCodesAllowed; if (nonStateCodesAllowed == null) { return; } if (!SecurePage.IsSuperUser) { var nonStateCodesRequireSuperUser = _SecureAdminPage.NonStateCodesRequireSuperUser; if (nonStateCodesRequireSuperUser != null) { nonStateCodesAllowed = nonStateCodesAllowed.Where( s => !nonStateCodesRequireSuperUser.Contains(s)); } } foreach (var nonState in nonStateCodesAllowed) { StateDropDownList.AddItem(GetNonStateCodeName(nonState), nonState, nonState == _SecureAdminPage.StateCode); } }
protected void Page_Load(object sender, EventArgs e) { int.TryParse(Request.QueryString["id"], out CarrierID); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("spGetCarrierAddress", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", CarrierID); SqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); rdr.Close(); conn.Close(); } string getstates = "SELECT * from State"; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand(getstates, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); StateDropDownList.DataSource = rdr; StateDropDownList.DataTextField = "Name"; StateDropDownList.DataValueField = "Id"; StateDropDownList.DataBind(); rdr.Close(); conn.Close(); } }
private void InitializeForStateAdmin() { DialogCredentialMessage.InnerHtml = "Your sign-in credentials allow any " + States.GetName(_SecureAdminPage.StateCode) + " jurisdiction to be selected."; StateName.InnerHtml = States.GetName(_SecureAdminPage.StateCode); StateDropDownList.AddCssClasses("hidden"); CountyName.AddCssClasses("hidden"); switch (_SecureAdminPage.AdminPageLevel) { case AdminPageLevel.State: StateRadioButton.Checked = true; LocalRadioButton.Disabled = true; PopulateCountyDropDown(true); LocalDropDownList.AddCssClasses("hidden"); break; case AdminPageLevel.County: CountyRadioButton.Checked = true; PopulateCountyDropDown(); PopulateLocalDropDown(true); LocalName.AddCssClasses("hidden"); break; case AdminPageLevel.Local: LocalRadioButton.Checked = true; PopulateCountyDropDown(); PopulateLocalDropDown(); LocalName.AddCssClasses("hidden"); break; } }
protected void AddressDropDownList_SelectedIndexChanged(object sender, EventArgs e) { int i = Int32.Parse(AddressDropDownList.SelectedValue.ToString()); if (i == 0) { DescriptionTextBox.Text = ""; Address1TextBox.Text = ""; Address2TextBox.Text = ""; Address3TextBox.Text = ""; CityTextBox.Text = ""; ZipTextBox.Text = ""; CountryDropDownList.SelectedValue = "1"; StateDropDownList.SelectedValue = "1"; } else { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand("spGetAddressDetails", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", i); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); DescriptionTextBox.Text = rdr["AddressDescription"].ToString(); Address1TextBox.Text = rdr["AddressLine1"].ToString(); Address2TextBox.Text = rdr["AddressLine2"].ToString(); Address3TextBox.Text = rdr["AddressLine3"].ToString(); CityTextBox.Text = rdr["City"].ToString(); ZipTextBox.Text = rdr["Zip"].ToString(); CountryDropDownList.SelectedValue = rdr["CountryID"].ToString(); if (CountryDropDownList.SelectedValue == "2") { StateLabel.Text = "Province:"; string getprovinces = "SELECT * from Province"; using (SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd2 = new SqlCommand(getprovinces, conn2); conn2.Open(); SqlDataReader rdr2 = cmd2.ExecuteReader(); StateDropDownList.DataSource = rdr2; StateDropDownList.DataTextField = "Name"; StateDropDownList.DataValueField = "Id"; StateDropDownList.DataBind(); rdr2.Close(); conn2.Close(); } } StateDropDownList.SelectedValue = rdr["StateID"].ToString(); rdr.Close(); conn.Close(); } } }
protected void CancelButton_Click(object sender, EventArgs e) { /*BranchNameDropDownList.SelectedValue = ""; * BranchHeadDropDownList.SelectedValue = ""; * MaleRadioButton.Checked = false; * FemaleRadioButton.Checked = false; * OtherRadioButton.Checked = false; * StateDropDownList.SelectedValue = ""; * CityDropDownList.SelectedValue = ""; * BranchAddressTextBox.Text = ""; * DateofBranchRegistrationTextBox.Text = ""; * BranchCodeDropDownList.SelectedValue = "";*/ BranchNameDropDownList.ClearSelection(); BranchHeadDropDownList.ClearSelection(); MaleRadioButton.Checked = false; FemaleRadioButton.Checked = false; OtherRadioButton.Checked = false; StateDropDownList.ClearSelection(); CityDropDownList.ClearSelection(); BranchAddressTextBox.Text = " "; DateofBranchRegistrationTextBox.Text = ""; BranchCodeDropDownList.ClearSelection(); }
protected void Page_Load(object sender, EventArgs e) { StateDropDownList.ListDataSource = () => { DataTable statesTable = DatabaseHelper.Retrieve(GetStatesQuery); StateDropDownList.SetTextAndValueFields("Abbreviation", "Id"); return(statesTable); }; }
protected void ResetButton_Click(object sender, EventArgs e) { NameTextBox.Text = " "; CellTextBox.Text = " "; StateDropDownList.ClearSelection(); AgeUpdown.Text = " "; MaleButton.Checked = false; FemaleButton.Checked = false; MailTextBox.Text = " "; }
protected void CountryDropDownList_SelectedIndexChanged(object sender, EventArgs e) { try { HRSCustomersBLL customerBLLObject = new HRSCustomersBLL(); var states = customerBLLObject.GetState(Convert.ToInt32(CountryDropDownList.SelectedItem.Value)); StateDropDownList.DataSource = states; StateDropDownList.DataTextField = "Value"; StateDropDownList.DataValueField = "Key"; StateDropDownList.DataBind(); StateDropDownList.Focus(); } catch (Exception ex) { Utility.ExceptionUtility.ExceptionLog(ex); throw; } }
protected void CountryDropDownList_SelectedIndexChanged(object sender, EventArgs e) { if (CountryDropDownList.SelectedValue == "1") { StateLabel.Text = "State:"; string getstates = "SELECT * from State"; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand(getstates, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); StateDropDownList.DataSource = rdr; StateDropDownList.DataTextField = "Name"; StateDropDownList.DataValueField = "Id"; StateDropDownList.DataBind(); rdr.Close(); conn.Close(); } return; } if (CountryDropDownList.SelectedValue == "2") { StateLabel.Text = "Province:"; string getprovinces = "SELECT * from Province"; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand(getprovinces, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); StateDropDownList.DataSource = rdr; StateDropDownList.DataTextField = "Name"; StateDropDownList.DataValueField = "Id"; StateDropDownList.DataBind(); rdr.Close(); conn.Close(); } return; } }
protected void Page_Load(object sender, EventArgs e) { string constring = ConfigurationManager.ConnectionStrings["RKCS"].ConnectionString; using (SqlConnection con = new SqlConnection(constring)) { con.Open(); SqlCommand cmd = new SqlCommand("Select count(*) from Volunteers", con); count = Convert.ToInt32(cmd.ExecuteScalar()); CountLabel.Text = count.ToString(); if (!IsPostBack) { SqlDataAdapter da = new SqlDataAdapter("Select * from State", con); SqlCommandBuilder build = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "State"); StateDropDownList.DataSource = ds; StateDropDownList.DataTextField = "StateName"; StateDropDownList.DataValueField = "StateId"; StateDropDownList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!User.IsInRole("Librarian")) { Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized)); } if (!IsPostBack) { // Bind libraries list LibraryDropDownList.ListDataSource = () => { DataTable librariesTable = DatabaseHelper.Retrieve(GetLibrariesQuery); LibraryDropDownList.SetTextAndValueFields("Name", "Id"); return(librariesTable); }; // Bind states list StateDropDownList.ListDataSource = () => { DataTable statesTable = DatabaseHelper.Retrieve(GetStatesQuery); StateDropDownList.SetTextAndValueFields("Abbreviation", "Id"); return(statesTable); }; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //load option for Gender try { using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("Select * from options where qid = 1", connection); SqlDataReader reader = command.ExecuteReader(); GenderDropdownList.DataSource = reader; GenderDropdownList.DataTextField = "description"; GenderDropdownList.DataValueField = "oid"; GenderDropdownList.DataBind(); GenderDropdownList.Items.Insert(0, new ListItem("Please select", "Default value")); } } catch (SqlException ex) { Console.WriteLine("Error: " + ex); } //load option for State try { using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("Select * from options where qid = 3", connection); SqlDataReader reader = command.ExecuteReader(); StateDropDownList.DataSource = reader; StateDropDownList.DataTextField = "description"; StateDropDownList.DataValueField = "oid"; StateDropDownList.DataBind(); StateDropDownList.Items.Insert(0, new ListItem("Please select", "Default value")); } } catch (SqlException ex) { Console.WriteLine("Error: " + ex); } //load option for Bank try { using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("Select * from options where qid = 7", connection); SqlDataReader reader = command.ExecuteReader(); BankDropdownList.DataSource = reader; BankDropdownList.DataTextField = "description"; BankDropdownList.DataValueField = "oid"; BankDropdownList.DataBind(); BankDropdownList.Items.Insert(0, new ListItem("Please select", "Default value")); } } catch (SqlException ex) { Console.WriteLine("Error: " + ex); } //load option for Service try { using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("Select * from options where qid = 13", connection); SqlDataReader reader = command.ExecuteReader(); ServiceDropdownList.DataSource = reader; ServiceDropdownList.DataTextField = "description"; ServiceDropdownList.DataValueField = "oid"; ServiceDropdownList.DataBind(); ServiceDropdownList.Items.Insert(0, new ListItem("Please select", "Default value")); } } catch (SqlException ex) { Console.WriteLine("Error: " + ex); } } }