/// <summary>
        /// Get the price of a product in function of its size.
        /// <param name="productID" , size="UnitSize"></param>
        /// <returns>Price</returns>
        public decimal GetPriceBySize(int id, int size)
        {
            SizeDTO product = new SizeDTO();

            try
            {
                product = DB.FindPriceBySize(id, size);
            }
            catch (Exception e)
            {
                e.GetBaseException();
            }
            return(product.GetPrice());
        }
        /// <summary>
        /// Update only certain information
        /// the return value should be > 0 if
        /// the changes were successfull.
        /// </summary>
        /// <param name="productID"></param>
        /// <param name="size"></param>
        /// <param name="price"></param>
        /// <param name="name"></param>
        /// <param name="type"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public int Update2(int productID, int sizeID, int size, decimal price, string name, string type, int stock, int status)
        {
            ProductDTO product = new ProductDTO();
            SizeDTO    dtoSize = new SizeDTO();
            int        result  = 0;

            try
            {
                result = DB.Update(productID, name, type, stock, status);
                SB.UpdateSize2(sizeID, size, price);
            }
            catch (Exception e)
            {
                e.GetBaseException();
                Debug.Write(e.ToString());
            }
            return(result);
        }