public ProductInventoryCollection GetProductInventoryCollection(string whereExpression, string orderByExpression)
        {
            ProductInventoryData       data = new ProductInventoryData();
            ProductInventoryCollection col  = new ProductInventoryCollection();

            try
            {
                col = data.GetAllProductInventorysDynamicCollection(whereExpression, orderByExpression);
            }
            catch (Exception ex)
            {
                log.Write(ex.Message, "GetProductInventoryCollection");
                throw (ex);
            }
            finally
            {
                data = null;
            }
            return(col);
        }
        public ProductInventoryCollection GetAllProductInventoryCollection()
        {
            ProductInventoryData       data = new ProductInventoryData();
            ProductInventoryCollection col  = new ProductInventoryCollection();

            try
            {
                col = data.GetAllProductInventorysCollection();
            }
            catch (Exception ex)
            {
                log.Write(ex.Message, "GetAllProductInventoryCollection");
                throw (ex);
            }
            finally
            {
                data = null;
            }
            return(col);
        }