예제 #1
0
        /// <summary>
        /// Populate business objects from the data reader
        /// </summary>
        /// <param name="dataReader">data reader</param>
        /// <returns>list of clsContacts</returns>
        internal List <clsBirthday> PopulateObjectsFromReader(IDataReader dataReader)
        {
            List <clsBirthday> list = new List <clsBirthday>();

            while (dataReader.Read())
            {
                clsBirthday businessObject = new clsBirthday();
                PopulateBusinessObjectFromReader(businessObject, dataReader);
                list.Add(businessObject);
            }
            return(list);
        }
예제 #2
0
        /// <summary>
        /// Populate business object from data reader
        /// </summary>
        /// <param name="businessObject">business object</param>
        /// <param name="dataReader">data reader</param>
        internal void PopulateBusinessObjectFromReader(clsBirthday businessObject, IDataReader dataReader)
        {
            businessObject.EMP_ID = dataReader.GetInt32(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.EMP_ID.ToString()));

            businessObject.FIRST_NAME = dataReader.GetString(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.FIRST_NAME.ToString()));
            businessObject.LAST_NAME  = dataReader.GetString(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.LAST_NAME.ToString()));

            if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.IMAGE_PATH.ToString())))
            {
                businessObject.IMAGE_PATH = dataReader.GetString(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.IMAGE_PATH.ToString()));
            }
            else
            {
                businessObject.IMAGE_PATH = String.Empty;
            }

            if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.BIRTHDATE.ToString())))
            {
                businessObject.BIRTHDAY = dataReader.GetDateTime(dataReader.GetOrdinal(clsBirthday.clsBirthdayFields.BIRTHDATE.ToString()));
            }
        }