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