/// <summary>
 /// Gets the zone by region and number Receiving Units.
 /// </summary>
 /// <param name="regionId">The region id.</param>
 /// <param name="storeID">The store ID.</param>
 /// <param name="issuedTo">if set to <c>true</c> [issued to].</param>
 /// <returns></returns>
 public static DataTable GetZoneByRegionAndNumberRU(int regionId,int storeID, bool issuedTo)
 {
     Zone zones = new Zone();
     var query = HCMIS.Repository.Queries.Zone.SelectGetZoneByRegionAndNumberRU(regionId, storeID);
     Institution institution = new Institution();
     zones.LoadFromRawSql(query);
     return zones.DataTable;
 }
        /// <summary>
        /// Gets the zone by region and number Receiving Units.
        /// </summary>
        /// <param name="regionId">The region id.</param>
        /// <param name="storeID">The store ID.</param>
        /// <param name="issuedTo">if set to <c>true</c> [issued to].</param>
        /// <returns></returns>
        public static DataTable GetZoneByRegionAndNumberRU(int regionId, int storeID, bool issuedTo)
        {
            Zone        zones       = new Zone();
            var         query       = HCMIS.Repository.Queries.Zone.SelectGetZoneByRegionAndNumberRU(regionId, storeID);
            Institution institution = new Institution();

            zones.LoadFromRawSql(query);
            return(zones.DataTable);
        }