public List <ListItem> GetListItems(string category, string title)
{
try
{
var list = new List <ListItem>();
if (!string.IsNullOrEmpty(title))
{
var items = SAP_Vendor_Items.Where(d => d.Category == category && d.Enable == "1" && d.Value.ToLower().Trim().Contains(title.ToLower().Trim())).Take(500).Select(d => new { d.Value, d.Description }).OrderBy(d => d).ToList();
foreach (var item in items)
{
list.Add(new ListItem(item.Description, item.Value));
}
}
else
{
var items = SAP_Vendor_Items.Where(d => d.Category == category && d.Enable == "1").Take(500).Select(d => new { d.Value, d.Description }).OrderBy(d => d).ToList();
foreach (var item in items)
{
list.Add(new ListItem(item.Description, item.Value));
}
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
public void BindListItems(ListControl list, string category)
{
try
{
list.Items.Clear();
list.Items.Insert(0, new ListItem("", ""));
var items = SAP_Vendor_Items.Where(d => d.Category == category && d.Enable == "1").Select(d => new { d.Value, d.Description }).OrderBy(d => d).ToList();
foreach (var item in items)
{
list.Items.Add(new ListItem(item.Description, item.Value));
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <string> GetListItemTitles(string category)
{
return(SAP_Vendor_Items.Where(d => d.Category == category && d.Enable == "1").Select(d => d.Value).OrderBy(d => d).ToList());
}
public List <SAP_Vendor_Items> GetTQListItems(string category)
{
return(SAP_Vendor_Items.Where(d => d.Category == category).OrderBy(d => d.Value).ToList());
}