public List <SelectListItem> GetPartsMasterItems()
{
DBPOProfile poProfile = new DBPOProfile();
var PartsItems = poProfile.GetPartsMaster();
List <SelectListItem> item = (from a in PartsItems
orderby a.PartsName
select new SelectListItem()
{
Text = a.PartsName,
Value = a.PartsID.ToString()
}).Distinct().ToList();
item.Insert(0, new SelectListItem()
{
Text = "Select An Item", Value = "0"
});
return(item);
}
public List <SelectListItem> GetProjectItems()
{
DBPOProfile poProfile = new DBPOProfile();
var ProjectName = poProfile.GetProjectNames();
List <SelectListItem> item = (from a in ProjectName
orderby a.ProjectID
select new SelectListItem()
{
Text = a.ProjectName,
Value = a.ProjectID.ToString()
}).Distinct().ToList();
item.Insert(0, new SelectListItem()
{
Text = "Select All", Value = "0"
});
return(item);
}
public List <SelectListItem> GetPONoItems()
{
DBPOProfile poProfile = new DBPOProfile();
var PONoItems = poProfile.GetPONo();
List <SelectListItem> item = (from a in PONoItems
orderby a.POID
select new SelectListItem()
{
Text = a.PONo,
Value = a.PONo
}).Distinct().ToList();
item.Insert(0, new SelectListItem()
{
Text = "Select All", Value = "0"
});
return(item);
}
