public static List <ProductCustodian> GetAllProductCustodians() { using (FreeMarketEntities db = new FreeMarketEntities()) { List <ProductCustodian> custodians = new List <ProductCustodian>(); List <GetAllProductCustodians_Result> result = db.GetAllProductCustodians().ToList(); foreach (GetAllProductCustodians_Result item in result) { ProductCustodian productCustodianDB = db.ProductCustodians .FirstOrDefault(c => c.ProductNumber == item.ProductNumber && c.SupplierNumber == item.SupplierNumber); if (productCustodianDB == null) { return(new List <ProductCustodian>()); } bool inStock = productCustodianDB.QuantityOnHand > 0 ? true : false; Product product = db.Products.Find(item.ProductNumber); product.GetProductImages(product); Supplier supplier = db.Suppliers.Find(item.SupplierNumber); custodians.Add(new ProductCustodian { ProductName = product.Description, ProductNumber = item.ProductNumber, SupplierNumber = item.SupplierNumber, MainImageNumber = product.MainImageNumber, SupplierName = product.SupplierName, InStock = inStock }); } return(custodians); } }