protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddl = (DropDownList)sender; TextBox tbCity = pnlGlobal_Insert_Properties.FindControl("tbCity") as TextBox; DropDownList ddlCounty = pnlGlobal_Insert_Properties.FindControl("ddlCounty") as DropDownList; DropDownList ddlTownshipNY = pnlGlobal_Insert_Properties.FindControl("ddlTownshipNY") as DropDownList; DropDownList ddlBasin = pnlGlobal_Insert_Properties.FindControl("ddlBasin") as DropDownList; DropDownList ddlSubbasin = pnlGlobal_Insert_Properties.FindControl("ddlSubbasin") as DropDownList; DropDownList ddlZip = (DropDownList)pnlGlobal_Insert_Properties.FindControl("ddlZip"); WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(ddlZip, null, ddl.SelectedValue, true); if (ddl.SelectedValue == "NY") { WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(ddlCounty, false, null); ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); } else { ddlCounty.Items.Clear(); ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); } if (tbCity != null) { tbCity.Text = string.Empty; } }
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddl = (DropDownList)sender; WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", null, ddl.SelectedValue); if (fvProperty.CurrentMode == FormViewMode.Edit) { Label lblCity = fvProperty.FindControl("lblCity") as Label; DropDownList ddlCountyNY = fvProperty.FindControl("ddlCounty") as DropDownList; DropDownList ddlTownshipNY = fvProperty.FindControl("ddlTownshipNY") as DropDownList; DropDownList ddlBasin = fvProperty.FindControl("ddlBasin") as DropDownList; DropDownList ddlSubbasin = fvProperty.FindControl("ddlSubbasin") as DropDownList; if (ddl.SelectedValue == "NY") { WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(ddlCountyNY, false, null); ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); } else { ddlCountyNY.Items.Clear(); ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); } if (lblCity != null) { lblCity.Text = ""; } } }
protected void ddlZip_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddl = (DropDownList)sender; DropDownList ddlState = fvProperty.FindControl("ddlState") as DropDownList; DropDownList ddlCountyNY = fvProperty.FindControl("ddlCounty") as DropDownList; DropDownList ddlTownshipNY = fvProperty.FindControl("ddlTownshipNY") as DropDownList; DropDownList ddlBasin = fvProperty.FindControl("ddlBasin") as DropDownList; DropDownList ddlSubbasin = fvProperty.FindControl("ddlSubbasin") as DropDownList; TextBox tbCity = fvProperty.FindControl("tbCity") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.zipcodes.Where(w => w.pk_zipcode == ddl.SelectedValue) select b).Single(); if (ddlState.SelectedValue.ToUpper() == "NY") { try { var c = wDataContext.list_countyNies.Where(w => w.county == a.county).Select(s => s.pk_list_countyNY); if (c.Count() == 1) { WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(ddlCountyNY, false, c.Single()); WACGlobal_Methods.PopulateControl_DatabaseLists_TownshipNY_DDL(ddlTownshipNY, c.Single(), null); WACGlobal_Methods.PopulateControl_DatabaseLists_Basin_DDL(ddlBasin, null, null, null, c.Single(), null, true); ddlSubbasin.Items.Clear(); } else { WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(ddlCountyNY, false, null); ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); } } catch { ddlCountyNY.SelectedIndex = 0; ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); tbCity.Text = ""; } } else { ddlCountyNY.Items.Clear(); ddlTownshipNY.Items.Clear(); ddlBasin.Items.Clear(); ddlSubbasin.Items.Clear(); } tbCity.Text = a.city; } }
private void BindProperty(int i) { using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = from b in wDataContext.properties.Where(w => w.pk_property == i) select b; fvProperty.DataKeyNames = new string[] { "pk_property" }; fvProperty.DataSource = a; fvProperty.DataBind(); if (fvProperty.CurrentMode == FormViewMode.ReadOnly) { if (i > 0) { WACUT_Associations assoc = fvProperty.FindControl("WACUT_Associations") as WACUT_Associations; List <WACParameter> parms = new List <WACParameter>(); parms.Add(new WACParameter("pk_property", i, WACParameter.ParameterType.SelectedKey)); parms.Add(new WACParameter("pk_property", i, WACParameter.ParameterType.PrimaryKey)); assoc.InitControl(parms); parms = null; } } if (fvProperty.CurrentMode == FormViewMode.Insert) { WACGlobal_Methods.PopulateControl_DatabaseLists_StatesUS_DDL(fvProperty, "ddlState", "NY"); WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", null, "NY"); } if (fvProperty.CurrentMode == FormViewMode.Edit) { WACGlobal_Methods.PopulateControl_DatabaseLists_StatesUS_DDL(fvProperty, "ddlState", a.Single().state); WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", a.Single().fk_zipcode, a.Single().state); WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(fvProperty.FindControl("ddlCounty") as DropDownList, false, a.Single().fk_list_countyNY); if (a.Single().fk_list_countyNY != null) { WACGlobal_Methods.PopulateControl_DatabaseLists_TownshipNY_DDL(fvProperty.FindControl("ddlTownshipNY") as DropDownList, a.Single().fk_list_countyNY, a.Single().fk_list_townshipNY); WACGlobal_Methods.PopulateControl_DatabaseLists_Basin_DDL(fvProperty.FindControl("ddlBasin") as DropDownList, null, null, null, a.Single().fk_list_countyNY, a.Single().fk_basin_code, true); if (!string.IsNullOrEmpty(a.Single().fk_basin_code)) { WACGlobal_Methods.PopulateControl_DatabaseLists_Subbasin_DDL(fvProperty.FindControl("ddlSubbasin") as DropDownList, a.Single().fk_basin_code, a.Single().fk_subbasin_code); } } } } upProperty.Update(); }
public void BindProperty(int i) { using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.properties.Where(w => w.pk_property == i).Select(s => s); fvProperty.DataKeyNames = new string[] { "pk_property" }; fvProperty.DataSource = a; fvProperty.DataBind(); if (fvProperty.CurrentMode != FormViewMode.Insert) { hfPropertyPK.Value = a.Single().pk_property.ToString(); } if (fvProperty.CurrentMode == FormViewMode.Insert) { WACGlobal_Methods.PopulateControl_DatabaseLists_StatesUS_DDL(fvProperty, "ddlState", "NY"); WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", null, "NY"); } if (fvProperty.CurrentMode == FormViewMode.Edit) { WACGlobal_Methods.PopulateControl_DatabaseLists_StatesUS_DDL(fvProperty, "ddlState", a.Single().state); WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", a.Single().fk_zipcode, a.Single().state); WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(fvProperty.FindControl("ddlCounty") as DropDownList, false, a.Single().fk_list_countyNY); if (a.Single().fk_list_countyNY != null) { WACGlobal_Methods.PopulateControl_DatabaseLists_TownshipNY_DDL(fvProperty.FindControl("ddlTownshipNY") as DropDownList, a.Single().fk_list_countyNY, a.Single().fk_list_townshipNY); WACGlobal_Methods.PopulateControl_DatabaseLists_Basin_DDL(fvProperty.FindControl("ddlBasin") as DropDownList, null, null, null, a.Single().fk_list_countyNY, a.Single().fk_basin_code, true); if (!string.IsNullOrEmpty(a.Single().fk_basin_code)) { WACGlobal_Methods.PopulateControl_DatabaseLists_Subbasin_DDL(fvProperty.FindControl("ddlSubbasin") as DropDownList, a.Single().fk_basin_code, a.Single().fk_subbasin_code); } } } } }