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