protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { int selectedCountryKey = Int32.Parse(ddlCountry.SelectedValue); ddlPool.Items.Clear(); ddlLocationGroup.Items.Clear(); ddlLocation.Items.Clear(); ddlCarClass.Items.Clear(); using (var dc = new Mars.App.Classes.DAL.FleetDemand.DataAccess()) { var pools = dc.GetPoolsForCountry(selectedCountryKey); if (pools.Count > 0) { ddlPool.Items.Add(new ListItem("Select", "0")); foreach (var pool in pools) { ddlPool.Items.Add(new ListItem(pool.CmsPool, pool.CmsPoolKey.ToString())); } } var cars = dc.GetCarClassForCountry(selectedCountryKey); if (cars.Count > 0) { ddlCarClass.Items.Add(new ListItem("Select", "0")); foreach (var car in cars) { ddlCarClass.Items.Add(new ListItem(car.CarClass, car.CarClassKey.ToString())); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlCountry.Items.Add(new ListItem("Select", "0")); using (var dc = new Mars.App.Classes.DAL.FleetDemand.DataAccess()) { foreach (var country in dc.GetCountries()) { ddlCountry.Items.Add(new ListItem(country.Country, country.CountryKey.ToString())); } } ddlPool.Items.Clear(); ddlLocationGroup.Items.Clear(); ddlLocation.Items.Clear(); } }
protected void ddlLocationGroup_SelectedIndexChanged(object sender, EventArgs e) { int selectedLocationGroupKey = Int32.Parse(ddlLocationGroup.SelectedValue); ddlLocation.Items.Clear(); using (var dc = new Mars.App.Classes.DAL.FleetDemand.DataAccess()) { var locations = dc.GetLocationsForLocationGroup(selectedLocationGroupKey); if (locations.Count > 0) { ddlLocation.Items.Add(new ListItem("Select", "0")); foreach (var location in locations) { ddlLocation.Items.Add(new ListItem(location.LocationCode + " - " + location.LocationName, location.LocationKey.ToString())); } } } }