/// <summary>
        /// Gets the un priced quantity.
        /// </summary>
        /// <param name="itemID">The item ID.</param>
        /// <param name="storeID">The store ID.</param>
        /// <param name="unitID">The unit ID.</param>
        /// <param name="manufacturerID">The manufacturer ID.</param>
        /// <param name="physicalStoreID">The physical store ID.</param>
        /// <param name="preferredExpiryDate">The preferred expiry date.</param>
        /// <returns></returns>
        public Int64 GetUnPricedQuantity(int itemID, int storeID, int? unitID, int? manufacturerID,int? physicalStoreID, DateTime? preferredExpiryDate)
        {
            string query;

            if (BLL.Settings.IsCenter) //If it is center, we don't require it to have been received by delivery notes.
            {
                query =
                    HCMIS.Repository.Queries.Balance.SelectGetUnPricedQuantityForCenter(itemID, storeID, unitID, manufacturerID,
                                                                                        physicalStoreID, preferredExpiryDate);
            }
            else
            {
                query =
                    HCMIS.Repository.Queries.Balance.SelectGetUnPricedQuantityForHub(itemID, storeID, unitID, manufacturerID,
                                                                                     physicalStoreID, preferredExpiryDate);
            }
            BLL.Balance bal = new Balance();
            bal.LoadFromRawSql(query);

            try
            {
                if (bal.IsColumnNull("UQ"))
                    return 0;
                return Convert.ToInt64(bal.GetColumn("UQ"));
            }
            catch
            {
                return 0;
            }
        }