public List <BusinessLogicLayer> GetProductsBySupplier(int id)
 {
     tblProducts = adpProducts.GetProductsBySupplierID(id);
     if (tblProducts.Count > 0)
     {
         listProductsBySupplier = new List <BusinessLogicLayer>();
         foreach (var row in tblProducts)
         {
             BusinessLogicLayer supplierProduct = new BusinessLogicLayer();
             supplierProduct.Id    = row.ProductID;
             supplierProduct.Name  = row.ProductName;
             supplierProduct.Price = row.UnitPrice;
             supplierProduct.Stock = row.UnitsInStock;
             listProductsBySupplier.Add(supplierProduct);
         }
     }
     return(listProductsBySupplier);
 }