AJH.CMS.Core.Data.UserDataMapper.FillFromReader C# (CSharp) Method

        internal static void FillFromReader(User user, SqlDataReader reader)
        {
            int colIndex = 0;

            int days = 0, seconds = 0;
            colIndex = reader.GetOrdinal(CN_USER_CREATION_DAY);
            if (!reader.IsDBNull(colIndex))
                days = reader.GetInt32(colIndex);

            colIndex = reader.GetOrdinal(CN_USER_CREATION_SEC);
            if (!reader.IsDBNull(colIndex))
                seconds = reader.GetInt32(colIndex);

            user.CreationDate = CMSCoreHelper.GetDateTime(days, seconds);

            colIndex = reader.GetOrdinal(CN_USER_EMAIL);
            if (!reader.IsDBNull(colIndex))
                user.Email = reader.GetString(colIndex);

            colIndex = reader.GetOrdinal(CN_USER_ID);
            if (!reader.IsDBNull(colIndex))
                user.ID = reader.GetInt32(colIndex);

            colIndex = reader.GetOrdinal(CN_USER_IS_ACTIVE);
            if (!reader.IsDBNull(colIndex))
                user.IsActive = reader.GetBoolean(colIndex);

            colIndex = reader.GetOrdinal(CN_USER_IS_DELETED);
            if (!reader.IsDBNull(colIndex))
                user.IsDeleted = reader.GetBoolean(colIndex);

            colIndex = reader.GetOrdinal(CN_USER_NAME);
            if (!reader.IsDBNull(colIndex))
                user.Name = reader.GetString(colIndex);

            colIndex = reader.GetOrdinal(CN_USER_PASSWORD);
            if (!reader.IsDBNull(colIndex))
                user.Password = EncryptAndDecrypt.Decrypt(reader.GetString(colIndex), true);
        }