Example #1
0
        public IEventBase Build(IDataRecord record)
        {
            Contract.Requires(null != record, "The record must be valid.");

            String eventId;
            if (_isEventIdAnInt)
            {
                var eventIdInt = record.GetInt32(_eventIdOrdinal);
                if (!IdLookup.TryGetValue(eventIdInt, out eventId))
                    throw new Exception("What id is this?"); // we can't process this event, it's unknown
            }
            else
            {
                eventId = record.GetString(_eventIdOrdinal);
            }

            Tuple<CreateLoader, CreateEvent> tuple;
            if (!Creation.TryGetValue(eventId, out tuple))
            {
                Debug.WriteLine("Unhandled eventId [" + eventId + "]");
                return null; // we don't know how to process this event, return null
            }

            // get the loader
            EventClassLoaderInfoBase loader;
            if (!_metadata.TryGetValue(eventId, out loader))
            {
                // we don't have one already, create it and store in dict
                loader = tuple.Item1(record);
                _metadata[eventId] = loader;
            }

            // create the event
            return tuple.Item2(record, loader);
        }
Example #2
0
 private static Distributor MapRecord(IDataRecord record)
 {
     return new Distributor
     {
         Id = record.Get<long>(SelectParameters.Id),
         Name = record.Get<string>(SelectParameters.Name),
         ShortName = record.Get<string>(SelectParameters.ShortName),
         DistributorType = new DistributorType
         {
             Code = record.Get<string>(SelectParameters.DistributorTypeCode),
             Name = record.Get<string>(SelectParameters.DistributorTypeName),
             DisplaySequence = record.Get<int>(SelectParameters.DistributorTypeDisplaySequence)
         },
         MultiChannelModel = record.GetEnum<MultiChannelModelEnum>(SelectParameters.MultiChannelModelCode),
         DefaultChannelId = record.Get<int?>(SelectParameters.DefaultChannelId),
         MarketingText = record.Get<string>(SelectParameters.MarketingText),
         DisplaySequence = record.Get<int>(SelectParameters.DisplaySequence),
         DistributorImage = new Image
         {
             ImageType = new ImageType
             {
                 Code = record.Get<string>(SelectParameters.ImageTypeCode),
                 Width = record.Get<int?>(SelectParameters.ImageTypeWidth),
                 Height = record.Get<int?>(SelectParameters.ImageTypeHeight)
             },
             Uri = record.Get<string>(SelectParameters.DistributorImageUri)
         },
         UpdatedByUserId = record.Get<Guid>(SelectParameters.UpdatedByUserId),
         UpdatedDateTime = record.Get<DateTime>(SelectParameters.UpdatedDatetime)
     };
 }
        public SchemaObjectManagementEventLoaderInfo(IDataRecord record)
        {
            Contract.Requires(null != record, "The record object can not be null.");

            record.TryGetOrdinal("TextData", out _textDataOrdinal);
            record.TryGetOrdinal("DatabaseID", out _databaseIDOrdinal);
            record.TryGetOrdinal("TransactionID", out _transactionIDOrdinal);
            record.TryGetOrdinal("NTUserName", out _nTUserNameOrdinal);
            record.TryGetOrdinal("NTDomainName", out _nTDomainNameOrdinal);
            record.TryGetOrdinal("HostName", out _hostNameOrdinal);
            record.TryGetOrdinal("ApplicationName", out _applicationNameOrdinal);
            record.TryGetOrdinal("LoginName", out _loginNameOrdinal);
            record.TryGetOrdinal("SPID", out _sPIDOrdinal);
            record.TryGetOrdinal("StartTime", out _startTimeOrdinal);
            record.TryGetOrdinal("EventSubClass", out _eventSubClassOrdinal);
            record.TryGetOrdinal("Success", out _successOrdinal);
            record.TryGetOrdinal("ServerName", out _serverNameOrdinal);
            record.TryGetOrdinal("EventClass", out _eventClassOrdinal);
            record.TryGetOrdinal("ObjectType", out _objectTypeOrdinal);
            record.TryGetOrdinal("NestLevel", out _nestLevelOrdinal);
            record.TryGetOrdinal("ObjectName", out _objectNameOrdinal);
            record.TryGetOrdinal("DatabaseName", out _databaseNameOrdinal);
            record.TryGetOrdinal("OwnerName", out _ownerNameOrdinal);
            record.TryGetOrdinal("DBUserName", out _dBUserNameOrdinal);
            record.TryGetOrdinal("LoginSid", out _loginSidOrdinal);
            record.TryGetOrdinal("RequestID", out _requestIDOrdinal);
            record.TryGetOrdinal("XactSequence", out _xactSequenceOrdinal);
            record.TryGetOrdinal("EventSequence", out _eventSequenceOrdinal);
            record.TryGetOrdinal("ParentName", out _parentNameOrdinal);
            record.TryGetOrdinal("IsSystem", out _isSystemOrdinal);
            record.TryGetOrdinal("SessionLoginName", out _sessionLoginNameOrdinal);
        }
        /// <summary>
        /// Reads the values from an <see cref="IDataRecord"/> and assigns the read values to this
        /// object's properties. The database column's name is used to as the key, so the value
        /// will not be found if any aliases are used or not all columns were selected.
        /// </summary>
        /// <param name="source">The object to add the extension method to.</param>
        /// <param name="dataRecord">The <see cref="IDataRecord"/> to read the values from. Must already be ready to be read from.</param>
        public static void ReadValues(this CharacterTemplateInventoryTable source, IDataRecord dataRecord)
        {
            Int32 i;

            i = dataRecord.GetOrdinal("chance");

            source.Chance = (ItemChance)dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("character_template_id");

            source.CharacterTemplateID = (CharacterTemplateID)dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("id");

            source.ID = dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("item_template_id");

            source.ItemTemplateID = (ItemTemplateID)dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("max");

            source.Max = dataRecord.GetByte(i);

            i = dataRecord.GetOrdinal("min");

            source.Min = dataRecord.GetByte(i);
        }
Example #5
0
 /// <summary>
 /// Map the basic fields for the BusinessContact table to the Channel model object
 /// </summary>
 /// <param name="record">The SqlDataReader with the executed query result</param>
 /// <param name="prefix">a prefix used to identify fields for the BusinessContact model  in the resultset if required</param>        
 /// <returns>An instance of BusinessContactl</returns>
 internal static BusinessContactPerson MapRecord(IDataRecord record, string prefix = "")
 {
     return new BusinessContactPerson
     {
         BusinessId = DbHelper.ConvertValue<long>(record[prefix + Parameters.BusinessId]),
         ContactTypeCode = DbHelper.ConvertValue<string>(record[prefix + Parameters.ContactTypeCode]),
         TitleId = DbHelper.ConvertValue<byte?>(record[prefix + Parameters.TitleId]),
         Forename = DbHelper.ConvertValue<string>(record[prefix + Parameters.Forename]),
         Surname = DbHelper.ConvertValue<string>(record[prefix + Parameters.Surname]),
         Email = DbHelper.ConvertValue<string>(record[prefix + Parameters.Email]),
         UseBusinessAddress = DbHelper.ConvertValue<bool>(record[prefix + Parameters.UseBusinessAddress]),
         AddressLine1 = DbHelper.ConvertValue<string>(record[prefix + Parameters.AddressLine1]),
         AddressLine2 = DbHelper.ConvertValue<string>(record[prefix + Parameters.AddressLine2]),
         AddressLine3 = DbHelper.ConvertValue<string>(record[prefix + Parameters.AddressLine3]),
         City = DbHelper.ConvertValue<string>(record[prefix + Parameters.City]),
         StateProvinceId = DbHelper.ConvertValue<int?>(record[prefix + Parameters.StateProvinceId]),
         PostCode = DbHelper.ConvertValue<string>(record[prefix + Parameters.PostCode]),
         CountryId = DbHelper.ConvertValue<int?>(record[prefix + Parameters.CountryId]),
         Notes = DbHelper.ConvertValue<string>(record[prefix + Parameters.Notes]),
         IsPrimary = DbHelper.ConvertValue<bool>(record[prefix + Parameters.IsPrimary]),
         CreatedDatetime = DbHelper.ConvertValue<DateTime>(record[prefix + Parameters.CreatedDateTime]),
         UpdatedByUserId = DbHelper.ConvertValue<Guid>(record[prefix + Parameters.UpdatedByUserId]),
         UpdatedDateTime = DbHelper.ConvertValue<DateTime>(record[prefix + Parameters.UpdatedDatetime]),
     };
 }
Example #6
0
        public static Recommend RecommendFromReader(IDataRecord reader)
        {
            Recommend rec = new Recommend();
            // 处理string类型
            var ps = typeof(Recommend).Properties<string>();
            try
            {
                foreach (var p in ps)
                {
                    if (p.StartsWith("Time"))
                    {
                        continue;
                    }
                    rec.SetProperty(p, reader[p] as string);
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("ex:" + ex.StackTrace);
            }

            // 处理时间类型
            DateTime t1 = (DateTime)reader["Time1"];
            DateTime t2 = (DateTime)reader["Time2"];

            rec.Time1 = t1.ToString("yy-MM-dd HH:mm");
            rec.Time2 = t2.ToString("yy-MM-dd HH:mm");

            rec.PreferResult = (PreferResult)reader["PreferResult"];

            rec.Odds = (float)((double)reader["Odds"]);

            return rec;
        }
        public ChangeAuditEventLoaderInfo(IDataRecord record)
        {
            Contract.Requires(null != record, "The record object can not be null.");

            record.TryGetOrdinal("TextData", out _textDataOrdinal);
            record.TryGetOrdinal("DatabaseID", out _databaseIDOrdinal);
            record.TryGetOrdinal("LineNumber", out _lineNumberOrdinal);
            record.TryGetOrdinal("NTUserName", out _nTUserNameOrdinal);
            record.TryGetOrdinal("NTDomainName", out _nTDomainNameOrdinal);
            record.TryGetOrdinal("HostName", out _hostNameOrdinal);
            record.TryGetOrdinal("ClientProcessID", out _clientProcessIDOrdinal);
            record.TryGetOrdinal("ApplicationName", out _applicationNameOrdinal);
            record.TryGetOrdinal("LoginName", out _loginNameOrdinal);
            record.TryGetOrdinal("SPID", out _sPIDOrdinal);
            record.TryGetOrdinal("StartTime", out _startTimeOrdinal);
            record.TryGetOrdinal("EventSubClass", out _eventSubClassOrdinal);
            record.TryGetOrdinal("Success", out _successOrdinal);
            record.TryGetOrdinal("ServerName", out _serverNameOrdinal);
            record.TryGetOrdinal("EventClass", out _eventClassOrdinal);
            record.TryGetOrdinal("NestLevel", out _nestLevelOrdinal);
            record.TryGetOrdinal("DatabaseName", out _databaseNameOrdinal);
            record.TryGetOrdinal("OwnerName", out _ownerNameOrdinal);
            record.TryGetOrdinal("DBUserName", out _dBUserNameOrdinal);
            record.TryGetOrdinal("LoginSid", out _loginSidOrdinal);
            record.TryGetOrdinal("ColumnPermissions", out _columnPermissionsOrdinal);
            record.TryGetOrdinal("RequestID", out _requestIDOrdinal);
            record.TryGetOrdinal("XactSequence", out _xactSequenceOrdinal);
            record.TryGetOrdinal("EventSequence", out _eventSequenceOrdinal);
            record.TryGetOrdinal("IsSystem", out _isSystemOrdinal);
            record.TryGetOrdinal("SessionLoginName", out _sessionLoginNameOrdinal);
        }
Example #8
0
 public void RecordRemoved(IDataRecord record)
 {
     if (record.Identifier == ParentIdentifier)
     {
         Repository.Remove(this);
     }
 }
Example #9
0
 /// <summary>
 /// constructor
 /// </summary>
 /// <param name="dataRecord"></param>
 public C2C(IDataRecord dataRecord)
 {
     this.Id = int.Parse(dataRecord["Id"].ToString());
     this.Campus = dataRecord["CAMPUS"].ToString().Replace("'", string.Empty);
     this.CadGap = dataRecord["CAD_GAP"].ToString();
     this.CadMath = dataRecord["CAD_MATH"].ToString();
     this.CadPost = dataRecord["CAD_POST"].ToString();
     this.CadProgress = dataRecord["CAD_PROGRESS"].ToString();
     this.CadRead = dataRecord["CAD_READ"].ToString();
     this.CadScie = dataRecord["CAD_SCIE"].ToString();
     this.CadSoci = dataRecord["CAD_SOCI"].ToString();
     this.CampusName = dataRecord["CAMPNAME"].ToString();
     this.Cflalted = dataRecord["CFLALTED"].ToString();
     this.Cflchart = dataRecord["CFLCHART"].ToString();
     this.CountyName = dataRecord["CNTYNAME"].ToString();
     this.County = dataRecord["COUNTY"].ToString();
     this.CRating = dataRecord["C_RATING"].ToString();
     this.DistrictName = dataRecord["DISTNAME"].ToString();
     this.District = dataRecord["DISTRICT"].ToString();
     this.Grdspan = dataRecord["GRDSPAN"].ToString();
     this.Grdtype = dataRecord["GRDTYPE"].ToString();
     this.Paircamp = dataRecord["PAIRCAMP"].ToString();
     this.Pairname = dataRecord["PAIRNAME"].ToString();
     this.Region = dataRecord["REGION"].ToString();
 }
Example #10
0
        /// <summary>
        /// Map the basic fields for the RoomType table to the RoomType model object
        /// </summary>
        /// <param name="record">The SqlDataReader with the executed query result</param>
        /// <param name="prefix">a prefix used to identify fields for the RoomType model  in the resultset if required</param>        
        /// <returns>An instance of Model.Room.RoomType</returns>
        internal static RoomType MapRecordWithCode(IDataRecord record, string prefix = "")
        {
            var roomType = MapRecord(record, prefix);
            roomType.Code = DbHelper.ConvertValue<string>(record[prefix + Parameters.Code]);

            return roomType;
        }
Example #11
0
        public static void Fill_EntityProperty_Ids( IDataRecord record, IList _includeEntityPropertyList, ref Hashtable _entityProperty_ids ) {

            if (_includeEntityPropertyList == null) return;

            foreach (EntityPropertyInfo info in _includeEntityPropertyList) {

                String columnName = info.ColumnName;
                try
                {
                    if (record[columnName] == DBNull.Value) continue;

                    if (_entityProperty_ids[columnName] == null)
                    {
                        _entityProperty_ids[columnName] = record[columnName] + ",";
                    }
                    else
                    {
                        String ids = _entityProperty_ids[columnName].ToString();
                        String tempId = "," + record[columnName] + ",";
                        if (("," + ids).IndexOf(tempId) < 0)
                        {
                            _entityProperty_ids[columnName] = ids + record[columnName] + ",";
                        }
                    }
                }
                catch (Exception ex)
                {
                    LogManager.GetLogger("Class:System.ORM.Operation.EntityPropertyUtil Method:Fill_EntityProperty_Ids").Info("异常:" + ex.Message + "\n堆栈:" + ex.StackTrace);
                }
            }
        }
Example #12
0
        public static Object Populate( IDataRecord rd, ObjectInfo state )
        {
            IEntity obj = Entity.New( state.EntityInfo.Type.FullName );
            // state
            //obj.state.Order = state.Order;

            for (int i = 0; i < rd.FieldCount; i++) {

                Object fdvalue = rd[i];

                if (fdvalue == null || fdvalue == DBNull.Value) continue;

                EntityPropertyInfo ep = state.EntityInfo.GetPropertyByColumn( rd.GetName( i ) );
                if (ep == null) continue;

                try {
                    if (ep.IsEntity || ep.IsAbstractEntity) {
                        setEntityPropertyValueById( obj, state, ep, rd.GetInt32( i ) );
                    }
                    else {
                        ep.SetValue( obj, getReaderValue( fdvalue, ep.Type ) );
                    }

                }
                catch (Exception ex) {
                    logger.Error( ex.Message + "=" + ep.Name + "_" + ep.Type );
                    logger.Error( ex.StackTrace );
                    throw ex;
                }

            }

            return obj;
        }
        /// <summary>
        /// Reads the values from an <see cref="IDataRecord"/> and assigns the read values to this
        /// object's properties. The database column's name is used to as the key, so the value
        /// will not be found if any aliases are used or not all columns were selected.
        /// </summary>
        /// <param name="source">The object to add the extension method to.</param>
        /// <param name="dataRecord">The <see cref="IDataRecord"/> to read the values from. Must already be ready to be read from.</param>
        public static void ReadValues(this WorldStatsUserLevelTable source, IDataRecord dataRecord)
        {
            Int32 i;

            i = dataRecord.GetOrdinal("character_id");

            source.CharacterID = (CharacterID)dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("id");

            source.ID = dataRecord.GetUInt32(i);

            i = dataRecord.GetOrdinal("level");

            source.Level = dataRecord.GetByte(i);

            i = dataRecord.GetOrdinal("map_id");

            source.MapID = (Nullable<MapID>)(dataRecord.IsDBNull(i) ? (ushort?)null : dataRecord.GetUInt16(i));

            i = dataRecord.GetOrdinal("when");

            source.When = dataRecord.GetDateTime(i);

            i = dataRecord.GetOrdinal("x");

            source.X = dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("y");

            source.Y = dataRecord.GetUInt16(i);
        }
Example #14
0
 public void LoadElement(IDataRecord record)
 {
     DescriptorUid = (Guid)record["DescriptorUid"];
     DescriptorTypeUid = (Guid)record["DescriptorTypeUid"];
     NodeUid = (Guid)record["NodeUid"];
     RelationshipUid = (Guid)record["RelationshipUid"];
 }
Example #15
0
 public object Map(IDataRecord record, Type type)
 {
     var instance = _instanceFactory.CreateInstance(type);
     foreach (var propertySetter in _recordToPropertyMappers)
         propertySetter.Execute(record, instance);
     return instance;
 }
 private static MessageEnvelope Fill(IDataRecord reader)
 {
     var conversationId = reader.GetGuid(0);
 	var messageEnvelope = ((byte[]) reader.GetValue(1)).ToMessageEnvelope();
 	messageEnvelope.ConversationId = conversationId;
 	return messageEnvelope;
 }
        private static BasicFinancialTransactionTagSetType ReadFinancialTransactionTagSetTypeFromDataReader(IDataRecord reader)
        {
            int financialTransactionTagSetTypeId = reader.GetInt32(0);
            string resourceName = reader.GetString(1);

            return new BasicFinancialTransactionTagSetType(financialTransactionTagSetTypeId, resourceName);
        }
        internal BrokerConversationEvent(IDataRecord record, BrokerConversationEventLoaderInfo loaderInfo)
        {
            Contract.Requires(null != record, "The record must be valid.");
            Contract.Requires(null != loaderInfo, "The loaderInfo must be valid.");

            if (null != loaderInfo.TextDataOrdinal)
                _textData = record.GetNullableString(loaderInfo.TextDataOrdinal.Value);
            if (null != loaderInfo.DatabaseIDOrdinal)
                _databaseID = record.GetNullableInt32(loaderInfo.DatabaseIDOrdinal.Value);
            if (null != loaderInfo.TransactionIDOrdinal)
                _transactionID = record.GetNullableInt64(loaderInfo.TransactionIDOrdinal.Value);
            if (null != loaderInfo.NTUserNameOrdinal)
                _nTUserName = record.GetNullableString(loaderInfo.NTUserNameOrdinal.Value);
            if (null != loaderInfo.NTDomainNameOrdinal)
                _nTDomainName = record.GetNullableString(loaderInfo.NTDomainNameOrdinal.Value);
            if (null != loaderInfo.HostNameOrdinal)
                _hostName = record.GetNullableString(loaderInfo.HostNameOrdinal.Value);
            if (null != loaderInfo.ClientProcessIDOrdinal)
                _clientProcessID = record.GetNullableInt32(loaderInfo.ClientProcessIDOrdinal.Value);
            if (null != loaderInfo.ApplicationNameOrdinal)
                _applicationName = record.GetNullableString(loaderInfo.ApplicationNameOrdinal.Value);
            if (null != loaderInfo.LoginNameOrdinal)
                _loginName = record.GetNullableString(loaderInfo.LoginNameOrdinal.Value);
            if (null != loaderInfo.SPIDOrdinal)
                _sPID = record.GetNullableInt32(loaderInfo.SPIDOrdinal.Value);
            if (null != loaderInfo.StartTimeOrdinal)
                _startTime = record.GetNullableDateTime(loaderInfo.StartTimeOrdinal.Value);
            if (null != loaderInfo.SeverityOrdinal)
                _severity = record.GetNullableInt32(loaderInfo.SeverityOrdinal.Value);
            if (null != loaderInfo.EventSubClassOrdinal)
                _eventSubClass = record.GetNullableInt32(loaderInfo.EventSubClassOrdinal.Value);
            if (null != loaderInfo.ObjectIDOrdinal)
                _objectID = record.GetNullableInt32(loaderInfo.ObjectIDOrdinal.Value);
            if (null != loaderInfo.IntegerDataOrdinal)
                _integerData = record.GetNullableInt32(loaderInfo.IntegerDataOrdinal.Value);
            if (null != loaderInfo.ServerNameOrdinal)
                _serverName = record.GetNullableString(loaderInfo.ServerNameOrdinal.Value);
            if (null != loaderInfo.StateOrdinal)
                _state = record.GetNullableInt32(loaderInfo.StateOrdinal.Value);
            if (null != loaderInfo.ErrorOrdinal)
                _error = record.GetNullableInt32(loaderInfo.ErrorOrdinal.Value);
            if (null != loaderInfo.RoleNameOrdinal)
                _roleName = record.GetNullableString(loaderInfo.RoleNameOrdinal.Value);
            if (null != loaderInfo.DBUserNameOrdinal)
                _dBUserName = record.GetNullableString(loaderInfo.DBUserNameOrdinal.Value);
            if (null != loaderInfo.LoginSidOrdinal)
                _loginSid = (Byte[])record.GetValue(loaderInfo.LoginSidOrdinal.Value);
            if (null != loaderInfo.TargetLoginNameOrdinal)
                _targetLoginName = record.GetNullableString(loaderInfo.TargetLoginNameOrdinal.Value);
            if (null != loaderInfo.EventSequenceOrdinal)
                _eventSequence = record.GetNullableInt64(loaderInfo.EventSequenceOrdinal.Value);
            if (null != loaderInfo.BigintData1Ordinal)
                _bigintData1 = record.GetNullableInt64(loaderInfo.BigintData1Ordinal.Value);
            if (null != loaderInfo.GUIDOrdinal)
                _gUID = record.GetNullableGuid(loaderInfo.GUIDOrdinal.Value);
            if (null != loaderInfo.IsSystemOrdinal)
                _isSystem = record.GetNullableInt32(loaderInfo.IsSystemOrdinal.Value);
            if (null != loaderInfo.SessionLoginNameOrdinal)
                _sessionLoginName = record.GetNullableString(loaderInfo.SessionLoginNameOrdinal.Value);
        }
Example #19
0
        /// <summary>
        /// Retrieves bytes from a datarecord, or null if null.
        /// </summary>
        /// <param name="reader"></param>
        /// <param name="ordinal"></param>
        /// <returns></returns>
        protected static byte[] GetBytes(IDataRecord reader, int ordinal)
        {
            if (reader.IsDBNull(ordinal))
            {
                return null;
            }

            List<byte> bytes = new List<byte>();

            byte[] buffer = new byte[256];
            long readCount = 0;
            long readTotal = 0;

            do
            {
                readCount = reader.GetBytes(ordinal, readTotal, buffer, 0, buffer.Length);
                readTotal += readCount;

                if (readCount == 0)
                    break;

                bytes.AddRange(buffer);
            } while (readCount > 0);

            bytes = bytes.GetRange(0, (int) readTotal);  // in case the message byte array is not factorable by buffer.Length

            return bytes.ToArray();
        }
        private static BasicOutboundMail ReadOutboundMailFromDataReader (IDataRecord reader)
        {
            int outboundMailId = reader.GetInt32(0);
            int authorType = reader.GetInt32(1);
            int authorPersonId = reader.GetInt32(2);
            string title = reader.GetString(3);
            string body = reader.GetString(4);

            int mailPriority = reader.GetInt32(5);
            int mailTypeId = reader.GetInt32(6);
            int organizationId = reader.GetInt32(7);
            int geographyId = reader.GetInt32(8);
            DateTime createdDateTime = reader.GetDateTime(9);

            DateTime releaseDateTime = reader.GetDateTime(10);
            bool readyForPickup = reader.GetBoolean(11);
            bool resolved = reader.GetBoolean(12);
            bool processed = reader.GetBoolean(13);
            DateTime resolvedDateTime = reader.GetDateTime(14);

            DateTime startProcessDateTime = reader.GetDateTime(15);
            DateTime endProcessDateTime = reader.GetDateTime(16);
            int recipientCount = reader.GetInt32(17);
            int recipientsSuccess = reader.GetInt32(18);
            int recipientsFail = reader.GetInt32(19);

            return new BasicOutboundMail(outboundMailId, (MailAuthorType)authorType, authorPersonId, title, body,
                mailPriority, mailTypeId, organizationId, geographyId, createdDateTime,
                releaseDateTime, readyForPickup, resolved, processed, resolvedDateTime, startProcessDateTime, endProcessDateTime,
                recipientCount, recipientsSuccess, recipientsFail);
        }
        public override object Evaluate(object value, IDataRecord sourceRecord)
        {
            if (sourceRecord == null)
            {
                throw new ArgumentNullException("sourceRecord");
            }

            var str0 = EtlValueConverter.ToString(value);
            var str1 = EtlValueTranslation.Evaluate(this.SourceFieldName, this.SourceFieldTranslation, sourceRecord, this.DefaultValue);

            if (str0 == null || str1 == null)
            {
                if (this.IgnoreNulls)
                {
                    if (str0 == null)
                    {
                        return str1;
                    }
                    else
                    {
                        return str0;
                    }
                }
                else
                {
                    return null;
                }
            }
            else
            {
                return string.Concat(str0, str1);
            }
        }
 public DataRecordMemberNode(ObjectNode parent, Type[] types, IDataRecord r, int maxDepth, DataContextDriver dcDriver) : base(parent, r, maxDepth, dcDriver)
 {
     if (base.IsAtNestingLimit())
     {
         base.GraphTruncated = true;
     }
     else
     {
         for (int i = 0; i < r.FieldCount; i++)
         {
             object item = r.GetValue(i);
             Type type = null;
             if (types != null)
             {
                 type = types[i];
             }
             else if (item != null)
             {
                 type = item.GetType();
             }
             if (!(item is IDataRecord))
             {
             }
             base.Members.Add(new MemberData(r.GetName(i), type, ObjectNode.Create(this, item, maxDepth, base.DCDriver)));
         }
         if ((base.Members.Count > 50) && (base.NestingDepth > 1))
         {
             base.InitiallyHidden = true;
         }
     }
 }
        /// <summary>
        /// Reads the values from an <see cref="IDataRecord"/> and assigns the read values to this
        /// object's properties. The database column's name is used to as the key, so the value
        /// will not be found if any aliases are used or not all columns were selected.
        /// </summary>
        /// <param name="source">The object to add the extension method to.</param>
        /// <param name="dataRecord">The <see cref="IDataRecord"/> to read the values from. Must already be ready to be read from.</param>
        public static void ReadValues(this AccountBanTable source, IDataRecord dataRecord)
        {
            Int32 i;

            i = dataRecord.GetOrdinal("account_id");

            source.AccountID = (AccountID)dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("end_time");

            source.EndTime = dataRecord.GetDateTime(i);

            i = dataRecord.GetOrdinal("expired");

            source.Expired = dataRecord.GetBoolean(i);

            i = dataRecord.GetOrdinal("id");

            source.ID = dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("issued_by");

            source.IssuedBy = (dataRecord.IsDBNull(i) ? null : dataRecord.GetString(i));

            i = dataRecord.GetOrdinal("reason");

            source.Reason = dataRecord.GetString(i);

            i = dataRecord.GetOrdinal("start_time");

            source.StartTime = dataRecord.GetDateTime(i);
        }
Example #24
0
 /// <summary>
 /// Reads a char array from the current <see cref="IDataRecord"/>.
 /// </summary>
 /// <param name="dataRecord">The target <see cref="IDataRecord"/>.</param>
 /// <param name="ordinal">The ordinal for the field that contains the stream data.</param>
 /// <returns>A new char array.</returns>
 public static char[] ReadCharArray(IDataRecord dataRecord, int ordinal)
 {
     long length = dataRecord.GetChars(ordinal, 0, null, 0, int.MaxValue);
     var buffer = new char[length];
     dataRecord.GetChars(ordinal, 0, buffer, 0, (int)length);
     return buffer;
 }
Example #25
0
        /// <summary>
        /// Retrieve a Guid value from a data record with a default value.
        /// </summary>
        public override Guid GetGuid(IDataRecord dataRecord, int ordinal, Guid defaultValue)
        {
            if (dataRecord == null)
                throw new ArgumentNullException("dataRecord");

            if (dataRecord.IsDBNull(ordinal))
                return defaultValue;

            try
            {
                return new Guid(base.GetString(dataRecord, ordinal));
            }
            catch (ArgumentNullException)
            {
                return defaultValue;
            }
            catch (FormatException)
            {
                return defaultValue;
            }
            catch (OverflowException)
            {
                return defaultValue;
            }
        }
        public LogoutEventLoaderInfo(IDataRecord record)
        {
            Contract.Requires(null != record, "The record object can not be null.");

            record.TryGetOrdinal("TextData", out _textDataOrdinal);
            record.TryGetOrdinal("DatabaseID", out _databaseIDOrdinal);
            record.TryGetOrdinal("NTUserName", out _nTUserNameOrdinal);
            record.TryGetOrdinal("NTDomainName", out _nTDomainNameOrdinal);
            record.TryGetOrdinal("HostName", out _hostNameOrdinal);
            record.TryGetOrdinal("ClientProcessID", out _clientProcessIDOrdinal);
            record.TryGetOrdinal("ApplicationName", out _applicationNameOrdinal);
            record.TryGetOrdinal("LoginName", out _loginNameOrdinal);
            record.TryGetOrdinal("SPID", out _sPIDOrdinal);
            record.TryGetOrdinal("Duration", out _durationOrdinal);
            record.TryGetOrdinal("StartTime", out _startTimeOrdinal);
            record.TryGetOrdinal("EndTime", out _endTimeOrdinal);
            record.TryGetOrdinal("Reads", out _readsOrdinal);
            record.TryGetOrdinal("Writes", out _writesOrdinal);
            record.TryGetOrdinal("CPU", out _cPUOrdinal);
            record.TryGetOrdinal("EventSubClass", out _eventSubClassOrdinal);
            record.TryGetOrdinal("Success", out _successOrdinal);
            record.TryGetOrdinal("ServerName", out _serverNameOrdinal);
            record.TryGetOrdinal("EventClass", out _eventClassOrdinal);
            record.TryGetOrdinal("DatabaseName", out _databaseNameOrdinal);
            record.TryGetOrdinal("LoginSid", out _loginSidOrdinal);
            record.TryGetOrdinal("RequestID", out _requestIDOrdinal);
            record.TryGetOrdinal("EventSequence", out _eventSequenceOrdinal);
            record.TryGetOrdinal("Type", out _typeOrdinal);
            record.TryGetOrdinal("IsSystem", out _isSystemOrdinal);
            record.TryGetOrdinal("SessionLoginName", out _sessionLoginNameOrdinal);
            record.TryGetOrdinal("GroupID", out _groupIDOrdinal);
        }
Example #27
0
 /// <summary>
 /// Reads a byte array from the current <see cref="IDataRecord"/>.
 /// </summary>
 /// <param name="dataRecord">The target <see cref="IDataRecord"/>.</param>
 /// <param name="ordinal">The ordinal for the field that contains the stream data.</param>
 /// <returns>A new byte array.</returns>
 public static byte[] ReadByteArray(IDataRecord dataRecord, int ordinal)
 {
     long length = dataRecord.GetBytes(ordinal, 0, null, 0, int.MaxValue);
     var buffer = new byte[length];
     dataRecord.GetBytes(ordinal, 0, buffer, 0, (int)length);
     return buffer;
 }
Example #28
0
        internal Card(IDataRecord reader)
        {
            Id = reader.GetInt32(0);
            Ot = reader.GetInt32(1);
            Alias = reader.GetInt32(2);
            Setcode = reader.GetInt64(3);
            Type = reader.GetInt32(4);

            int levelInfo = reader.GetInt32(5);
            Level = levelInfo & 0xff;
            LScale = (levelInfo >> 24) & 0xff;
            RScale = (levelInfo >> 16) & 0xff;

            Race = reader.GetInt32(6);
            Attribute = reader.GetInt32(7);
            Attack = reader.GetInt32(8);
            Defense = reader.GetInt32(9);

            Data = new CardData()
            {
                Code = Id,
                Alias = Alias,
                Setcode = Setcode,
                Type = Type,
                Level = Level,
                Attribute = Attribute,
                Race = Race,
                Attack = Attack,
                Defense = Defense,
                LScale = LScale,
                RScale = RScale
            };
        }
        internal DatabasePrincipalImpersonationEvent(IDataRecord record, DatabasePrincipalImpersonationEventLoaderInfo loaderInfo)
        {
            Contract.Requires(null != record, "The record must be valid.");
            Contract.Requires(null != loaderInfo, "The loaderInfo must be valid.");

            if (null != loaderInfo.TextDataOrdinal)
                _textData = record.GetNullableString(loaderInfo.TextDataOrdinal.Value);
            if (null != loaderInfo.DatabaseIDOrdinal)
                _databaseID = record.GetNullableInt32(loaderInfo.DatabaseIDOrdinal.Value);
            if (null != loaderInfo.TransactionIDOrdinal)
                _transactionID = record.GetNullableInt64(loaderInfo.TransactionIDOrdinal.Value);
            if (null != loaderInfo.NTUserNameOrdinal)
                _nTUserName = record.GetNullableString(loaderInfo.NTUserNameOrdinal.Value);
            if (null != loaderInfo.NTDomainNameOrdinal)
                _nTDomainName = record.GetNullableString(loaderInfo.NTDomainNameOrdinal.Value);
            if (null != loaderInfo.HostNameOrdinal)
                _hostName = record.GetNullableString(loaderInfo.HostNameOrdinal.Value);
            if (null != loaderInfo.ApplicationNameOrdinal)
                _applicationName = record.GetNullableString(loaderInfo.ApplicationNameOrdinal.Value);
            if (null != loaderInfo.LoginNameOrdinal)
                _loginName = record.GetNullableString(loaderInfo.LoginNameOrdinal.Value);
            if (null != loaderInfo.SPIDOrdinal)
                _sPID = record.GetNullableInt32(loaderInfo.SPIDOrdinal.Value);
            if (null != loaderInfo.StartTimeOrdinal)
                _startTime = record.GetNullableDateTime(loaderInfo.StartTimeOrdinal.Value);
            if (null != loaderInfo.PermissionsOrdinal)
                _permissions = record.GetNullableInt64(loaderInfo.PermissionsOrdinal.Value);
            if (null != loaderInfo.EventSubClassOrdinal)
                _eventSubClass = record.GetNullableInt32(loaderInfo.EventSubClassOrdinal.Value);
            if (null != loaderInfo.SuccessOrdinal)
                _success = record.GetNullableInt32(loaderInfo.SuccessOrdinal.Value);
            if (null != loaderInfo.ServerNameOrdinal)
                _serverName = record.GetNullableString(loaderInfo.ServerNameOrdinal.Value);
            if (null != loaderInfo.ObjectTypeOrdinal)
                _objectType = record.GetNullableInt32(loaderInfo.ObjectTypeOrdinal.Value);
            if (null != loaderInfo.NestLevelOrdinal)
                _nestLevel = record.GetNullableInt32(loaderInfo.NestLevelOrdinal.Value);
            if (null != loaderInfo.ObjectNameOrdinal)
                _objectName = record.GetNullableString(loaderInfo.ObjectNameOrdinal.Value);
            if (null != loaderInfo.DatabaseNameOrdinal)
                _databaseName = record.GetNullableString(loaderInfo.DatabaseNameOrdinal.Value);
            if (null != loaderInfo.OwnerNameOrdinal)
                _ownerName = record.GetNullableString(loaderInfo.OwnerNameOrdinal.Value);
            if (null != loaderInfo.RoleNameOrdinal)
                _roleName = record.GetNullableString(loaderInfo.RoleNameOrdinal.Value);
            if (null != loaderInfo.DBUserNameOrdinal)
                _dBUserName = record.GetNullableString(loaderInfo.DBUserNameOrdinal.Value);
            if (null != loaderInfo.LoginSidOrdinal)
                _loginSid = (Byte[])record.GetValue(loaderInfo.LoginSidOrdinal.Value);
            if (null != loaderInfo.RequestIDOrdinal)
                _requestID = record.GetNullableInt32(loaderInfo.RequestIDOrdinal.Value);
            if (null != loaderInfo.XactSequenceOrdinal)
                _xactSequence = record.GetNullableInt64(loaderInfo.XactSequenceOrdinal.Value);
            if (null != loaderInfo.EventSequenceOrdinal)
                _eventSequence = record.GetNullableInt64(loaderInfo.EventSequenceOrdinal.Value);
            if (null != loaderInfo.IsSystemOrdinal)
                _isSystem = record.GetNullableInt32(loaderInfo.IsSystemOrdinal.Value);
            if (null != loaderInfo.SessionLoginNameOrdinal)
                _sessionLoginName = record.GetNullableString(loaderInfo.SessionLoginNameOrdinal.Value);
        }
        public DatabaseMirroringLoginEventLoaderInfo(IDataRecord record)
        {
            Contract.Requires(null != record, "The record object can not be null.");

            record.TryGetOrdinal("TextData", out _textDataOrdinal);
            record.TryGetOrdinal("DatabaseID", out _databaseIDOrdinal);
            record.TryGetOrdinal("TransactionID", out _transactionIDOrdinal);
            record.TryGetOrdinal("NTUserName", out _nTUserNameOrdinal);
            record.TryGetOrdinal("NTDomainName", out _nTDomainNameOrdinal);
            record.TryGetOrdinal("HostName", out _hostNameOrdinal);
            record.TryGetOrdinal("ClientProcessID", out _clientProcessIDOrdinal);
            record.TryGetOrdinal("ApplicationName", out _applicationNameOrdinal);
            record.TryGetOrdinal("LoginName", out _loginNameOrdinal);
            record.TryGetOrdinal("SPID", out _sPIDOrdinal);
            record.TryGetOrdinal("StartTime", out _startTimeOrdinal);
            record.TryGetOrdinal("EventSubClass", out _eventSubClassOrdinal);
            record.TryGetOrdinal("ServerName", out _serverNameOrdinal);
            record.TryGetOrdinal("EventClass", out _eventClassOrdinal);
            record.TryGetOrdinal("State", out _stateOrdinal);
            record.TryGetOrdinal("ObjectName", out _objectNameOrdinal);
            record.TryGetOrdinal("FileName", out _fileNameOrdinal);
            record.TryGetOrdinal("OwnerName", out _ownerNameOrdinal);
            record.TryGetOrdinal("RoleName", out _roleNameOrdinal);
            record.TryGetOrdinal("TargetUserName", out _targetUserNameOrdinal);
            record.TryGetOrdinal("LoginSid", out _loginSidOrdinal);
            record.TryGetOrdinal("ProviderName", out _providerNameOrdinal);
            record.TryGetOrdinal("EventSequence", out _eventSequenceOrdinal);
            record.TryGetOrdinal("IsSystem", out _isSystemOrdinal);
            record.TryGetOrdinal("SessionLoginName", out _sessionLoginNameOrdinal);
        }
 public static decimal?GetDecimalWithNull(this IDataRecord record, string name)
 {
     return(record.GetDecimalWithNull(record.GetOrdinal(name)));
 }
        public static GetValueDelegate GetValueFn <T>(IDataRecord reader)
        {
            var nullableType = Nullable.GetUnderlyingType(typeof(T));

            if (nullableType == null)
            {
                var typeCode = Type.GetTypeCode(typeof(T));
                switch (typeCode)
                {
                case TypeCode.String:
                    return(reader.GetString);

                case TypeCode.Boolean:
                    return(i => reader.GetBoolean(i));

                case TypeCode.Int16:
                    return(i => reader.GetInt16(i));

                case TypeCode.Int32:
                    return(i => reader.GetInt32(i));

                case TypeCode.Int64:
                    return(i => reader.GetInt64(i));

                case TypeCode.Single:
                    return(i => reader.GetFloat(i));

                case TypeCode.Double:
                    return(i => reader.GetDouble(i));

                case TypeCode.Decimal:
                    return(i => reader.GetDecimal(i));

                case TypeCode.DateTime:
                    return(i => reader.GetDateTime(i));
                }

                if (typeof(T) == typeof(Guid))
                {
                    return(i => reader.GetGuid(i));
                }
            }
            else
            {
                var typeCode = Type.GetTypeCode(nullableType);
                switch (typeCode)
                {
                case TypeCode.String:
                    return(reader.GetString);

                case TypeCode.Boolean:
                    return(i => reader.IsDBNull(i) ? null : (bool?)reader.GetBoolean(i));

                case TypeCode.Int16:
                    return(i => reader.IsDBNull(i) ? null : (short?)reader.GetInt16(i));

                case TypeCode.Int32:
                    return(i => reader.IsDBNull(i) ? null : (int?)reader.GetInt32(i));

                case TypeCode.Int64:
                    return(i => reader.IsDBNull(i) ? null : (long?)reader.GetInt64(i));

                case TypeCode.Single:
                    return(i => reader.IsDBNull(i) ? null : (float?)reader.GetFloat(i));

                case TypeCode.Double:
                    return(i => reader.IsDBNull(i) ? null : (double?)reader.GetDouble(i));

                case TypeCode.Decimal:
                    return(i => reader.IsDBNull(i) ? null : (decimal?)reader.GetDecimal(i));

                case TypeCode.DateTime:
                    return(i => reader.IsDBNull(i) ? null : (DateTime?)reader.GetDateTime(i));
                }

                if (typeof(T) == typeof(Guid))
                {
                    return(i => reader.IsDBNull(i) ? null : (Guid?)reader.GetGuid(i));
                }
            }

            return(reader.GetValue);
        }
Example #33
0
 protected abstract TEntity Convert(IDataRecord reader);
Example #34
0
 /// <summary>
 /// Map a record to a new entity
 /// </summary>
 /// <param name="record">Row from the query result</param>
 /// <returns>Created and populated entity.</returns>
 public override MapperProviderTests Map(IDataRecord record)
 {
     throw new NotImplementedException();
 }
 public static double?GetDoubleWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (double?)null : record.GetDouble(index));
 }
 public static double GetDouble(this IDataRecord record, string name)
 {
     return(record.GetDouble(record.GetOrdinal(name)));
 }
 public static string GetStringWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? null : record.GetString(index));
 }
 public static DateTime?GetDateTimeWithNull(this IDataRecord record, string name)
 {
     return(record.GetDateTimeWithNull(record.GetOrdinal(name)));
 }
 public static char?GetCharWithNull(this IDataRecord record, string name)
 {
     return(record.GetCharWithNull(record.GetOrdinal(name)));
 }
 public static decimal?GetDecimalWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (decimal?)null : record.GetDecimal(index));
 }
 public static char GetChar(this IDataRecord record, string name)
 {
     return(record.GetChar(record.GetOrdinal(name)));
 }
 public static DateTime?GetDateTimeWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (DateTime?)null : record.GetDateTime(index));
 }
 public static byte?GetByteWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (byte?)null : record.GetByte(index));
 }
 public static char?GetCharWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (char?)null : record.GetChar(index));
 }
 public static bool?GetBooleanWithNull(this IDataRecord record, string name)
 {
     return(record.GetBooleanWithNull(record.GetOrdinal(name)));
 }
 public static byte?GetByteWithNull(this IDataRecord record, string name)
 {
     return(record.GetByteWithNull(record.GetOrdinal(name)));
 }
 public static long?GetInt64WithNull(this IDataRecord record, string name)
 {
     return(record.GetInt64WithNull(record.GetOrdinal(name)));
 }
 public static byte GetByte(this IDataRecord record, string name)
 {
     return(record.GetByte(record.GetOrdinal(name)));
 }
 public static int?GetInt32WithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (int?)null : record.GetInt32(index));
 }
 public static bool?GetBooleanWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (bool?)null : record.GetBoolean(index));
 }
 public static short?GetInt16WithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (short?)null : record.GetInt16(index));
 }
 public static long?GetInt64WithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (long?)null : record.GetInt64(index));
 }
 public static Guid?GetGuidWithNull(this IDataRecord record, string name)
 {
     return(record.GetGuidWithNull(record.GetOrdinal(name)));
 }
 public static int GetInt32(this IDataRecord record, string name)
 {
     return(record.GetInt32(record.GetOrdinal(name)));
 }
 public static Guid GetGuid(this IDataRecord record, string name)
 {
     return(record.GetGuid(record.GetOrdinal(name)));
 }
 public static short GetInt16(this IDataRecord record, string name)
 {
     return(record.GetInt16(record.GetOrdinal(name)));
 }
 public static float?GetFloatWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (float?)null : record.GetFloat(index));
 }
 public static Guid?GetGuidWithNull(this IDataRecord record, int index)
 {
     return(record.IsDBNull(index) ? (Guid?)null : record.GetGuid(index));
 }
 public static float GetFloat(this IDataRecord record, string name)
 {
     return(record.GetFloat(record.GetOrdinal(name)));
 }
 public static float?GetFloatWithNull(this IDataRecord record, string name)
 {
     return(record.GetFloatWithNull(record.GetOrdinal(name)));
 }