/// <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));
}
