//protected void uoDropDownListRegion_SelectedIndexChanged(object sender, EventArgs e) //{ // BindCountry(); // UpdatePanel2.Update(); //} #endregion #region METHODS ///// <summary> ///// Date Created: 03/10/2011 ///// Created By: Charlene Remotigue ///// Description: binds all regions to dropdownlist ///// </summary> //private void BindRegion() //{ // DataTable RegionDataTable = null; // try // { // RegionDataTable = CountryBLL.MapListByUser(GlobalCode.Field2String(Session["UserName"])); // uoDropDownListRegion.Items.Clear(); // ListItem item = new ListItem("--Select Region--", "0"); // uoDropDownListRegion.Items.Add(item); // uoDropDownListRegion.DataSource = RegionDataTable; // uoDropDownListRegion.DataTextField = "colMapNameVarchar"; // uoDropDownListRegion.DataValueField = "colMapIDInt"; // uoDropDownListRegion.DataBind(); // item = new ListItem("--Select Country--", "0"); // uoDropDownListCountry.Items.Add(item); // } // catch (Exception ex) // { // throw ex; // } // finally // { // if (RegionDataTable != null) // { // RegionDataTable.Dispose(); // } // } //} /// <summary> /// Date Created: 03/10/2011 /// Created By: Charlene Remotigue /// Descrition: binds country to dropdownlist /// </summary> private void BindCountry() { DataTable CountryDataTable = null; try { //CountryDataTable = CountryBLL.CountryListByRegion(uoDropDownListRegion.SelectedValue, ""); CountryDataTable = CountryBLL.CountryList(); uoDropDownListCountry.Items.Clear(); ListItem item = new ListItem("--Select Country--", "0"); uoDropDownListCountry.Items.Add(item); uoDropDownListCountry.DataSource = CountryDataTable; uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; uoDropDownListCountry.DataValueField = "colCountryIDInt"; uoDropDownListCountry.DataBind(); } catch (Exception ex) { throw ex; } finally { if (CountryDataTable != null) { CountryDataTable.Dispose(); } } }
/// <summary> /// Date Created: 01/08/2011 /// Created By: Marco Abejar /// (description) Loads port city to dropdownlist /// ----------------------------------------------- /// Date Edited: 18/07/2012 /// Created By: Jefferson Bermundo /// (description) Remove-- Port city not being used /// </summary> //private void PortCityLoad(int CountryID) //{ // DataTable dt = new DataTable(); // dt = CityBLL.CityListbyCountry(CountryID); // if (dt.Rows.Count > 0) // { // uoDropDownListCity.DataSource = dt; // uoDropDownListCity.DataTextField = "colCityNameVarchar"; // uoDropDownListCity.DataValueField = "colCityIDInt"; // uoDropDownListCity.DataBind(); // uoDropDownListCity.Items.Insert(0, new ListItem("- Select a City -", "")); // } // else // { // uoDropDownListCity.DataBind(); // } //} private void PortCountryLoad() { /// <summary> /// Date Created: 01/08/2011 /// Created By: Marco Abejar /// (description) Loads port country to dropdownlist /// </summary> DataTable dt = new DataTable(); dt = CountryBLL.CountryList(); if (dt.Rows.Count > 0) { uoDropDownListCountry.DataSource = dt; uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; uoDropDownListCountry.DataValueField = "colCountryIDInt"; uoDropDownListCountry.DataBind(); uoDropDownListCountry.Items.Insert(0, new ListItem("- Select a Country -", "")); uoDropDownListCountry.SelectedValue = dt.Rows[0]["colCountryIDInt"].ToString(); } else { uoDropDownListCountry.DataBind(); } }
/// <summary> /// Date Created: 29/07/2011 /// Created By: Gabriel Oquialda /// (description) Loads vendor city to dropdownlist /// ----------------------------------------------------- /// Date Modified: 05/Aug/2013 /// Created By: Josephine Gad /// (description) Change Datatable to Session /// ----------------------------------------------------- /// </summary> private void vendorCountryLoad() { List <CountryList> listCountry = new List <CountryList>(); uoDropDownListCountry.Items.Clear(); if (Session["CountryList"] != null) { listCountry = ((List <CountryList>)Session["CountryList"]); uoDropDownListCountry.DataSource = listCountry; uoDropDownListCountry.DataTextField = "CountryName"; uoDropDownListCountry.DataValueField = "CountryId"; } else { DataTable dtCountry = CountryBLL.CountryList(); if (dtCountry.Rows.Count > 0) { listCountry = (from a in dtCountry.AsEnumerable() select new CountryList { CountryId = GlobalCode.Field2Int(a["colCountryIDInt"]), CountryName = GlobalCode.Field2String(a["colCountryNameVarchar"]), }).ToList(); uoDropDownListCountry.DataSource = listCountry; uoDropDownListCountry.DataTextField = "CountryName"; uoDropDownListCountry.DataValueField = "CountryId"; HttpContext.Current.Session["CountryList"] = listCountry; } } uoDropDownListCountry.Items.Insert(0, (new ListItem("--Select Country--", "0"))); uoDropDownListCountry.DataBind(); }
/// <summary> /// Date Created: 07/09/2011 /// Created By: Gabriel Oquialda /// (description) Select country list by vendor id /// </summary> private void countryList() { DataTable dt = new DataTable(); dt = CountryBLL.CountryList(); if (dt.Rows.Count > 0) { uoDropDownListCountry.DataSource = dt; uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; uoDropDownListCountry.DataValueField = "colCountryIDInt"; uoDropDownListCountry.DataBind(); uoDropDownListCountry.Items.Insert(0, new ListItem("--Select a Country--", "0")); } else { uoDropDownListCountry.DataBind(); } //DataTable dt = null; //try //{ // uoDropDownListCountry.Items.Clear(); // dt = VendorMaintenanceBLL.countryList(); // if (dt.Rows.Count > 0) // { // uoDropDownListCountry.DataSource = dt; // uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; // uoDropDownListCountry.DataValueField = "colCountryIDInt"; // uoDropDownListCountry.DataBind(); // } // else // { // uoDropDownListCountry.DataBind(); // } // uoDropDownListCountry.Items.Insert(0, (new ListItem("--Select Country--", "0"))); // if (dt.Rows.Count == 1) // { // uoDropDownListCountry.SelectedIndex = 1; // } //} //catch (Exception ex) //{ // throw ex; //} //finally //{ // if (dt != null) // { // dt.Dispose(); // } //} }
/// <summary> /// Date Created: 29/07/2011 /// Created By: Gabriel Oquialda /// (description) Loads vendor city to dropdownlist /// </summary> private void vendorCountryLoad() { DataTable dt = new DataTable(); dt = CountryBLL.CountryList(); if (dt.Rows.Count > 0) { uoDropDownListCountry.DataSource = dt; uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; uoDropDownListCountry.DataValueField = "colCountryIDInt"; uoDropDownListCountry.DataBind(); uoDropDownListCountry.Items.Insert(0, new ListItem("- Select a Country -", "")); uoDropDownListCountry.SelectedValue = dt.Rows[0]["colCountryIDInt"].ToString(); } else { uoDropDownListCountry.DataBind(); } }
/// <summary> /// Date Created: 05/Nov/2013 /// Created By: Josephine Gad /// (description) Change Datatable to Session /// ----------------------------------------------------- /// </summary> private void vendorCountryLoad() { DataTable dt = null; try { List <CountryList> listCountry = new List <CountryList>(); uoDropDownListCountry.Items.Clear(); if (Session["CountryList"] != null) { listCountry = ((List <CountryList>)Session["CountryList"]); uoDropDownListCountry.DataSource = listCountry; uoDropDownListCountry.DataTextField = "CountryName"; uoDropDownListCountry.DataValueField = "CountryId"; } else { dt = CountryBLL.CountryList(); if (dt.Rows.Count > 0) { uoDropDownListCountry.DataSource = dt; uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; uoDropDownListCountry.DataValueField = "colCountryIDInt"; } } uoDropDownListCountry.Items.Insert(0, (new ListItem("--Select Country--", "0"))); uoDropDownListCountry.DataBind(); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
private void CompanyCountryLoad() { /// <summary> /// Date Created: 29/07/2011 /// Created By: Gabriel Oquialda /// (description) Loads vendor city to dropdownlist /// </summary> DataTable dt = new DataTable(); dt = CountryBLL.CountryList(); if (dt.Rows.Count > 0) { uoDropDownListCountry.DataSource = dt; uoDropDownListCountry.DataTextField = "colCountryNameVarchar"; uoDropDownListCountry.DataValueField = "colCountryIDInt"; uoDropDownListCountry.DataBind(); uoDropDownListCountry.Items.Insert(0, new ListItem("- Select Country -", "")); } else { uoDropDownListCountry.DataBind(); } }