/// <summary> /// Returns a list of lookup values for any given <lookupName></lookupName> /// </summary> /// <param name="search">The name of the lookup that must be searched for</param> /// <returns>List of lookup values</returns> public static IEnumerable <Lookup> ReturnLookup(LookupSearch search) { var paramList = new List <ParameterValue> { new ParameterValue("Lookup", search.Lookup), new ParameterValue("ShowInactive", search.ShowInactive ? 1 : 0) }; if (search.IDParent != null) { paramList.Add(new ParameterValue("idParent", search.IDParent)); } var dataSet = DataFacade.GetDataSet("LookupLoad", paramList.ToArray()); var returnList = new List <Lookup>(); if (dataSet.Tables.Count > 0) { returnList.AddRange(from DataTable t in dataSet.Tables from DataRow r in t.Rows select new Lookup { Id = r["idLookup"].ToString(), IDParent = r["idParent"].ToString(), LookupName = r["Lookup"].ToString(), Value = r["Value"].ToString(), SortOrder = r["SortOrder"].ToString(), IsActive = Convert.ToBoolean(r["Active"].ToString()) }); } return(returnList); }
public DropDownList Populate(ref DropDownList dropDownList, LookupSearch lookup, bool insertEmptyRow) { //Clearing the dropdownList dropDownList.Items.Clear(); //Finding the dropdown items IEnumerable <Lookup> list = GetLookup(lookup); if (insertEmptyRow) { dropDownList.Items.Add(new ListItem(string.Empty, string.Empty)); } //Populating the dropdown items foreach (Lookup item in list) { dropDownList.Items.Add(new ListItem(item.Value, item.Id)); } return(dropDownList); }
public IEnumerable <Lookup> GetLookup(LookupSearch lookup) { return(LookupDao.ReturnLookup(lookup)); }