예제 #1
0
        /// <summary>
        /// Gets the ownership type by region and number RU.
        /// </summary>
        /// <param name="WoredaID">The woreda ID.</param>
        /// <returns></returns>
        public static DataTable GetOwnershipTypeByRegionAndNumberRU(int WoredaID)
        {
            OwnershipType ownershipType = new OwnershipType();
            string        query         =
                HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(WoredaID);

            ownershipType.LoadFromRawSql(query);
            return(ownershipType.DataTable);
        }
        /// <summary>
        /// Gets the ownership type by region and number RU.
        /// </summary>
        /// <param name="WoredaID">The woreda ID.</param>
        /// <returns></returns>
        public static DataTable GetOwnershipTypeByRegionAndNumberRU(int WoredaID)
        {
            OwnershipType ownershipType = new OwnershipType();
            string query =
                HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(WoredaID);

            ownershipType.LoadFromRawSql(query);
            return ownershipType.DataTable;
        }
        /// <summary>
        /// Gets the ownership type by region and number RU.
        /// </summary>
        /// <param name="receivingUnitTypeID">The receiving unit type ID.</param>
        /// <param name="storeID">The store ID.</param>
        /// <param name="hasBeenIssuedTo">if set to <c>true</c> [has been issued to].</param>
        /// <returns></returns>
        public static DataTable GetOwnershipTypeByRegionAndNumberRU(int receivingUnitTypeID, int storeID, bool hasBeenIssuedTo)
        {
            OwnershipType ownershipType = new OwnershipType();
            string query = "";

            query = HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(receivingUnitTypeID, storeID);

            ownershipType.LoadFromRawSql(query);
            return ownershipType.DataTable;
        }
예제 #4
0
        /// <summary>
        /// Gets the ownership type by region and number RU.
        /// </summary>
        /// <param name="receivingUnitTypeID">The receiving unit type ID.</param>
        /// <param name="storeID">The store ID.</param>
        /// <param name="hasBeenIssuedTo">if set to <c>true</c> [has been issued to].</param>
        /// <returns></returns>
        public static DataTable GetOwnershipTypeByRegionAndNumberRU(int receivingUnitTypeID, int storeID, bool hasBeenIssuedTo)
        {
            OwnershipType ownershipType = new OwnershipType();
            string        query         = "";


            query = HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(receivingUnitTypeID, storeID);

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