/// <summary>
        /// Gets the warehouse.
        /// </summary>
        /// <returns></returns>
        public String GetWarehouse()
        {
            Receipt receipt = new Receipt();
            var     query   = HCMIS.Repository.Queries.Receipt.SelectGetWarehouse(ID);

            receipt.LoadFromRawSql(query);
            try
            {
                return(receipt.GetColumn("WarehouseName").ToString());
            }
            catch
            {
                return("");
            }
        }
 /// <summary>
 /// Gets the warehouse.
 /// </summary>
 /// <returns></returns>
 public String GetWarehouse()
 {
     Receipt receipt = new Receipt();
     var query = HCMIS.Repository.Queries.Receipt.SelectGetWarehouse(ID);
     receipt.LoadFromRawSql(query);
     try
     {
         return receipt.GetColumn("WarehouseName").ToString();
     }
     catch
     {
         return "";
     }
 }