private BasicOutboundInvoice ReadOutboundInvoiceFromDataReader(DbDataReader reader) { int outboundInvoiceId = reader.GetInt32(0); string customerName = reader.GetString(1); string invoiceAddressPaper = reader.GetString(2); string invoiceAddressMail = reader.GetString(3); int currencyId = reader.GetInt32(4); // double amount = reader.GetDouble(5); int organizationId = reader.GetInt32(6); int budgetId = reader.GetInt32(7); DateTime createdDateTime = reader.GetDateTime(8); int createdByPersonId = reader.GetInt32(9); DateTime dueDate = reader.GetDateTime(10); int reminderCount = reader.GetInt32(11); string reference = reader.GetString(12); bool domestic = reader.GetBoolean(13); bool open = reader.GetBoolean(14); bool sent = reader.GetBoolean(15); string securityCode = reader.GetString(16); string theirReference = reader.GetString(17); return new BasicOutboundInvoice(outboundInvoiceId, customerName, invoiceAddressPaper, invoiceAddressMail, currencyId, organizationId, budgetId, createdDateTime, createdByPersonId, dueDate, reminderCount, reference, domestic, open, sent, securityCode, theirReference); }
public static void GetPrestataire() { String sql = "SELECT * FROM Prestataire"; using (MySqlCommand command = new MySqlCommand(sql, connection)) { try { command.Connection.Open(); } catch (MySqlException) { } using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { int Id = dbReader.GetInt32(0); String Nom = dbReader.GetString(1); String Url = dbReader.GetString(2); String Categorie = dbReader.GetString(3); String Contact = dbReader.GetString(4); String Adresse = dbReader.GetString(5); String Description = dbReader.GetString(6); Boolean Activation = dbReader.GetBoolean(7); String Prix = dbReader.GetString(8); // attente de la création de la class business Business.Prestataires.Add(new Prestataire(Id, Nom, Url, Categorie, Contact, Adresse, Description, Activation, Prix)); } } command.Connection.Close(); } }
public static bool? GetBoolean(DbDataReader reader, int index) { if (reader.IsDBNull(index)) return null; else return reader.GetBoolean(index); }
private static BasicOrganization ReadOrganizationFromDataReader (DbDataReader reader) { int organizationId = reader.GetInt32(0); int parentOrganizationId = reader.GetInt32(1); string name = reader.GetString(2); string nameInternational = reader.GetString(3); string nameShort = reader.GetString(4); string domain = reader.GetString(5); string mailPrefix = reader.GetString(6); int anchorGeographyId = reader.GetInt32(7); bool acceptsMembers = reader.GetBoolean(8); bool autoAssignNewMembers = reader.GetBoolean(9); int defaultCountryId = reader.GetInt32(10); return new BasicOrganization(organizationId, parentOrganizationId, name, nameInternational, nameShort, domain, mailPrefix, anchorGeographyId, acceptsMembers, autoAssignNewMembers, defaultCountryId); }
public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null) { var persistenceId = reader.GetString(0); var sequenceNr = reader.GetInt64(1); var isDeleted = reader.GetBoolean(2); var payload = GetPayload(reader); return new Persistent(payload, sequenceNr, persistenceId, isDeleted, sender); }
private BasicOutboundMailRecipient ReadOutboundMailRecipientFromDataReader(DbDataReader reader) { int outboundMailRecipientId = reader.GetInt32(0); int outboundMailId = reader.GetInt32(1); int personId = reader.GetInt32(2); bool asOfficer = reader.GetBoolean(3); int personType = reader.GetInt32(4); return new BasicOutboundMailRecipient(outboundMailRecipientId, outboundMailId, personId, asOfficer, personType); }
static private BasicChurnDataPoint ReadChurnDataPointFromDataReader (DbDataReader reader) { int personId = reader.GetInt32(0); int organizationId = reader.GetInt32(1); bool churn = reader.GetBoolean(2); DateTime decisionDateTime = reader.GetDateTime(3); DateTime expiryDateTime = reader.GetDateTime(4); return new BasicChurnDataPoint(churn ? ChurnDataType.Churn : ChurnDataType.Retention, decisionDateTime, expiryDateTime, personId, organizationId); }
private BasicInternalPoll ReadInternalPollFromDataReader(DbDataReader reader) { int internalPollId = reader.GetInt32(0); int organizationId = reader.GetInt32(1); int geographyId = reader.GetInt32(2); string name = reader.GetString(3); bool runningOpen = reader.GetBoolean(4); bool votingOpen = reader.GetBoolean(5); int maxVoteLength = reader.GetInt32(6); int createdByPersonId = reader.GetInt32(7); DateTime runningOpens = reader.GetDateTime(8); DateTime runningCloses = reader.GetDateTime(9); DateTime votingOpens = reader.GetDateTime(10); DateTime votingCloses = reader.GetDateTime(11); int resultsTypeId = reader.GetInt32(12); InternalPollResultsType resultsType = (InternalPollResultsType) resultsTypeId; return new BasicInternalPoll(internalPollId, createdByPersonId, organizationId, geographyId, name, runningOpen, votingOpen, maxVoteLength, runningOpens, runningCloses, votingOpens, votingCloses, resultsType); }
public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null) { var persistenceId = reader.GetString(PersistenceIdIndex); var sequenceNr = reader.GetInt64(SequenceNrIndex); var isDeleted = reader.GetBoolean(IsDeletedIndex); var manifest = reader.GetString(ManifestIndex); // timestamp is SQL-journal specific field, it's not a part of casual Persistent instance var payload = GetPayload(reader, manifest); return new Persistent(payload, sequenceNr, persistenceId, manifest, isDeleted, sender); }
private BasicInboundInvoice ReadInboundInvoiceFromDataReader(DbDataReader reader) { int inboundInvoiceId = reader.GetInt32(0); int organizationId = reader.GetInt32(1); DateTime createdDateTime = reader.GetDateTime(2); int createdByPersonId = reader.GetInt32(3); DateTime dueDate = reader.GetDateTime(4); Int64 amountCents = reader.GetInt64(5); int budgetId = reader.GetInt32(6); bool attested = reader.GetBoolean(7); bool open = reader.GetBoolean(8); string supplier = reader.GetString(9); string payToAccount = reader.GetString(10); string ocr = reader.GetString(11); string invoiceReference = reader.GetString(12); DateTime closedDateTime = reader.GetDateTime(13); int closedByPersonId = reader.GetInt32(14); return new BasicInboundInvoice(inboundInvoiceId, organizationId, createdDateTime, dueDate, amountCents, budgetId, supplier, payToAccount, ocr, invoiceReference, attested, open, closedDateTime, closedByPersonId); }
private BasicPayrollAdjustment ReadPayrollAdjustmentFromDataReader(DbDataReader reader) { int payrollAdjustmentId = reader.GetInt32(0); int payrollAdjustmentTypeId = reader.GetInt32(1); int payrollItemId = reader.GetInt32(2); Int64 amountCents = reader.GetInt64(3); string description = reader.GetString(4); bool open = reader.GetBoolean(5); int salaryId = reader.GetInt32(6); return new BasicPayrollAdjustment(payrollAdjustmentId, payrollItemId, (PayrollAdjustmentType) payrollAdjustmentTypeId, amountCents, description, open, salaryId); }
static int GetBoolean(IntPtr L) { try { ToLua.CheckArgsCount(L, 2); System.Data.Common.DbDataReader obj = (System.Data.Common.DbDataReader)ToLua.CheckObject(L, 1, typeof(System.Data.Common.DbDataReader)); int arg0 = (int)LuaDLL.luaL_checknumber(L, 2); bool o = obj.GetBoolean(arg0); LuaDLL.lua_pushboolean(L, o); return(1); } catch (Exception e) { return(LuaDLL.toluaL_exception(L, e)); } }
private BasicPWEvent ReadPWEventFromDataReader (DbDataReader reader) { int eventId = reader.GetInt32(0); EventType eventType = (EventType)Enum.Parse(typeof(EventType), reader.GetString(1)); EventSource eventSource = (EventSource)Enum.Parse(typeof(EventSource), reader.GetString(2)); int actingPersonId = reader.GetInt32(3); int affectedPersonId = reader.GetInt32(4); DateTime eventDateTime = reader.GetDateTime(5); DateTime processedDateTime = reader.GetDateTime(6); bool open = reader.GetBoolean(7); int organizationId = reader.GetInt32(8); int geographyId = reader.GetInt32(9); int parameterInt = reader.GetInt32(10); string parameterText = reader.GetString(11); return new BasicPWEvent(eventId, eventDateTime, open, processedDateTime, eventType, eventSource, actingPersonId, affectedPersonId, organizationId, geographyId, parameterInt, parameterText); }
private BasicPayrollItem ReadPayrollItemFromDataReader(DbDataReader reader) { int payrollItemId = reader.GetInt32(0); int personId = reader.GetInt32(1); int organizationId = reader.GetInt32(2); int countryId = reader.GetInt32(3); DateTime employedDate = reader.GetDateTime(4); int reportsToPersonId = reader.GetInt32(5); Int64 baseSalaryCents = reader.GetInt64(6); int budgetId = reader.GetInt32(7); bool open = reader.GetBoolean(8); DateTime terminatedDate = reader.GetDateTime(9); int subtractiveTaxLevelId = reader.GetInt32(10); double additiveTaxLevel = reader.GetDouble(11); return new BasicPayrollItem(payrollItemId, personId, organizationId, countryId, employedDate, reportsToPersonId, baseSalaryCents, budgetId, open, terminatedDate, subtractiveTaxLevelId, additiveTaxLevel); }
MembershipUser GetUserFromReader (DbDataReader reader) { return new MembershipUser (this.Name, /* XXX is this right? */ reader.GetString (0), /* name */ reader.GetGuid (1), /* providerUserKey */ reader.IsDBNull (2) ? null : reader.GetString (2), /* email */ reader.IsDBNull (3) ? null : reader.GetString (3), /* passwordQuestion */ reader.IsDBNull (4) ? null : reader.GetString (4), /* comment */ reader.GetBoolean (5), /* isApproved */ reader.GetBoolean (6), /* isLockedOut */ reader.GetDateTime (7).ToLocalTime (), /* creationDate */ reader.GetDateTime (8).ToLocalTime (), /* lastLoginDate */ reader.GetDateTime (9).ToLocalTime (), /* lastActivityDate */ reader.GetDateTime (10).ToLocalTime (), /* lastPasswordChangedDate */ reader.GetDateTime (11).ToLocalTime () /* lastLockoutDate */); }
protected override object ReadInternal(DbDataReader reader, int ordinal, SqlRandomTableColumn columnInfo, Type asType) { ValidateReadType(typeof(Boolean), asType); if (reader.IsDBNull(ordinal)) return DBNull.Value; return reader.GetBoolean(ordinal); }
private BasicFinancialAccount ReadFinancialAccountFromDataReader (DbDataReader reader) { int accountId = reader.GetInt32(0); string name = reader.GetString(1); int organizationId = reader.GetInt32(2); var accountType = (FinancialAccountType) reader.GetInt32(3); int parentFinancialAccountId = reader.GetInt32(4); int ownerPersonId = reader.GetInt32(5); bool open = reader.GetBoolean(6); int openedYear = reader.GetInt32(7); int closedYear = reader.GetInt32(8); bool expensable = reader.GetBoolean(9); bool administrative = reader.GetBoolean(10); return new BasicFinancialAccount(accountId, name, accountType, organizationId, parentFinancialAccountId, ownerPersonId, open, openedYear, closedYear, expensable, administrative); }
private BasicVolunteer ReadVolunteerFromDataReader (DbDataReader reader) { int volunteerId = reader.GetInt32(0); int personId = reader.GetInt32(1); int ownerPersonId = reader.GetInt32(2); DateTime openedDateTime = reader.GetDateTime(3); bool open = reader.GetBoolean(4); DateTime closedDateTime = reader.GetDateTime(5); string closingComments = reader.GetString(6); return new BasicVolunteer(volunteerId, personId, ownerPersonId, openedDateTime, open, closedDateTime, closingComments); }
MembershipUser GetUserFromReader (DbDataReader reader, string username, object userId) { int i = 0; if (username == null) i = 1; if (userId != null) username = reader.GetString (8); return new MembershipUser (this.Name, /* XXX is this right? */ (username == null ? reader.GetString (0) : username), /* name */ (userId == null ? reader.GetGuid (8 + i) : userId), /* providerUserKey */ reader.IsDBNull (0 + i) ? null : reader.GetString (0 + i), /* email */ reader.IsDBNull (1 + i) ? null : reader.GetString (1 + i), /* passwordQuestion */ reader.IsDBNull (2 + i) ? null : reader.GetString (2 + i), /* comment */ reader.GetBoolean (3 + i), /* isApproved */ reader.GetBoolean (9 + i), /* isLockedOut */ reader.GetDateTime (4 + i).ToLocalTime (), /* creationDate */ reader.GetDateTime (5 + i).ToLocalTime (), /* lastLoginDate */ reader.GetDateTime (6 + i).ToLocalTime (), /* lastActivityDate */ reader.GetDateTime (7 + i).ToLocalTime (), /* lastPasswordChangedDate */ reader.GetDateTime (10 + i).ToLocalTime () /* lastLockoutDate */); }
private BasicVolunteerRole ReadVolunteerRoleFromDataReader (DbDataReader reader) { int volunteerRoleId = reader.GetInt32(0); int volunteerId = reader.GetInt32(1); int organizationId = reader.GetInt32(2); int geographyId = reader.GetInt32(3); int roleTypeId = reader.GetInt32(4); bool open = reader.GetBoolean(5); bool assigned = reader.GetBoolean(6); return new BasicVolunteerRole(volunteerRoleId, volunteerId, organizationId, geographyId, (RoleType) roleTypeId, open, assigned); }
private static List<Private_Items_List_Title> DataReader_To_Private_Items_List(DbDataReader Reader) { // Create return list List<Private_Items_List_Title> returnValue = new List<Private_Items_List_Title>(); Dictionary<int, int> lookup = new Dictionary<int, int>(); // Get all the main title values first while (Reader.Read()) { // Create new database title object for this Private_Items_List_Title result = new Private_Items_List_Title { RowNumber = Reader.GetInt32(0), BibID = Reader.GetString(1), Group_Title = Reader.GetString(2), Type = Reader.GetString(3), LastActivityDate = Reader.GetDateTime(6), LastMilestoneDate = Reader.GetDateTime(7), CompleteItemCount = Reader.GetInt32(8), PrimaryIdentifierType = Reader.GetString(9), PrimaryIdentifier = Reader.GetString(10) }; returnValue.Add(result); lookup.Add(result.RowNumber, returnValue.Count - 1); } // Move to the item table Reader.NextResult(); // If there were no titles, then there are no results if (returnValue.Count == 0) return returnValue; // Step through all the item rows, build the item, and add to the title Private_Items_List_Title titleResult = returnValue[0]; int lastRownumber = titleResult.RowNumber; while (Reader.Read()) { // Ensure this is the right title for this item int thisRownumber = Reader.GetInt32(0); if (thisRownumber != lastRownumber) { titleResult = returnValue[lookup[thisRownumber]]; lastRownumber = thisRownumber; } // Create new database item object for this Private_Items_List_Item result = new Private_Items_List_Item { VID = Reader.GetString(1), Title = Reader.GetString(2), LocallyArchived = Reader.GetBoolean(5), RemotelyArchived = Reader.GetBoolean(6), AggregationCodes = Reader.GetString(7), LastActivityDate = Reader.GetDateTime(8), LastActivityType = Reader.GetString(9), LastMilestone = Reader.GetInt32(10), LastMilestoneDate = Reader.GetDateTime(11) }; // Pull the values that are nullable string comments = Reader.GetString(3); string pubdate = Reader.GetString(4); string creator = Reader.GetString(19); // Assign the values if there are values if (comments.Length > 0) result.Internal_Comments = comments; if (pubdate.Length > 0) result.PubDate = pubdate; if (creator.Length > 0) result.Creator = creator; // Assign the embargo end if (!Reader.IsDBNull(18)) { DateTime embargoEnd = Reader.GetDateTime(18); if (embargoEnd.Year < 9999) result.EmbargoDate = embargoEnd; } // Add this to the title object titleResult.Add_Item_Result(result); } return returnValue; }
X509CertificateRecord LoadCertificateRecord (DbDataReader reader, X509CertificateParser parser, ref byte[] buffer) { var record = new X509CertificateRecord (); for (int i = 0; i < reader.FieldCount; i++) { switch (reader.GetName (i).ToUpperInvariant ()) { case "CERTIFICATE": record.Certificate = DecodeCertificate (reader, parser, i, ref buffer); break; case "PRIVATEKEY": record.PrivateKey = DecodePrivateKey (reader, i, ref buffer); break; case "ALGORITHMS": record.Algorithms = DecodeEncryptionAlgorithms (reader, i); break; case "ALGORITHMSUPDATED": record.AlgorithmsUpdated = reader.GetDateTime (i); break; case "TRUSTED": record.IsTrusted = reader.GetBoolean (i); break; case "ID": record.Id = reader.GetInt32 (i); break; } } return record; }
X509CrlRecord LoadCrlRecord (DbDataReader reader, X509CrlParser parser, ref byte[] buffer) { var record = new X509CrlRecord (); for (int i = 0; i < reader.FieldCount; i++) { switch (reader.GetName (i).ToUpperInvariant ()) { case "CRL": record.Crl = DecodeX509Crl (reader, parser, i, ref buffer); break; case "THISUPDATE": record.ThisUpdate = reader.GetDateTime (i); break; case "NEXTUPDATE": record.NextUpdate = reader.GetDateTime (i); break; case "DELTA": record.IsDelta = reader.GetBoolean (i); break; case "ID": record.Id = reader.GetInt32 (i); break; } } return record; }
// // GetUserFromReader // A helper function that takes the current row from the DbDataReader // and hydrates a MembershiUser from the values. Called by the // MembershipUser.GetUser implementation. // private MembershipUser GetUserFromReader(DbDataReader reader) { object providerUserKey = reader.GetValue(0); string username = reader.GetString(1); string email = reader.GetString(2); string passwordQuestion = ""; if (reader.GetValue(3) != DBNull.Value) passwordQuestion = reader.GetString(3); string comment = ""; if (reader.GetValue(4) != DBNull.Value) comment = reader.GetString(4); bool isApproved = reader.GetBoolean(5); bool isLockedOut = reader.GetBoolean(6); DateTime creationDate = reader.GetDateTime(7); DateTime lastLoginDate = new DateTime(); if (reader.GetValue(8) != DBNull.Value) lastLoginDate = reader.GetDateTime(8); DateTime lastActivityDate = reader.GetDateTime(9); DateTime lastPasswordChangedDate = reader.GetDateTime(10); DateTime lastLockedOutDate = new DateTime(); if (reader.GetValue(11) != DBNull.Value) lastLockedOutDate = reader.GetDateTime(11); MembershipUser u = new MembershipUser(this.Name, username, providerUserKey, email, passwordQuestion, comment, isApproved, isLockedOut, creationDate, lastLoginDate, lastActivityDate, lastPasswordChangedDate, lastLockedOutDate); return u; }
public static void SetProperties(Object obj, DbDataReader reader, Dictionary<string, DbType> lookup, Dictionary<string, string> property_map) { Type type = obj.GetType (); for (int columnNumber = 0; columnNumber < reader.VisibleFieldCount; columnNumber++) { string column = reader.GetName (columnNumber); PropertyInfo prop; try { prop = type.GetProperty (property_map [column]); } catch (KeyNotFoundException) { Log.WarningFormat ("No mapping to property from column {0}", column); continue; } if (prop == null) { Log.WarningFormat ("Unable to find property with name {0}", column); continue; } if (reader.IsDBNull (columnNumber)) { prop.SetValue (obj, null, null); continue; } try { switch (lookup [column]) { case DbType.String: prop.SetValue (obj, reader.GetString (columnNumber), null); break; case DbType.Int32: prop.SetValue (obj, reader.GetInt32 (columnNumber), null); break; case DbType.DateTime: prop.SetValue (obj, reader.GetDateTime (columnNumber), null); break; case DbType.Boolean: prop.SetValue (obj, reader.GetBoolean (columnNumber), null); break; default: break; } } catch (KeyNotFoundException) { Log.WarningFormat ("Attempted to look up invalid column '{0}'", column); } } }
// Copy multiple fields from reader to SmiTypedGetterSetter // Supports V200 code path, without damaging backward compat for V100 code. // Main differences are supporting DbDataReader, and for binary, character, decimal and Udt types. // Assumes caller enforces that reader and setter metadata are compatible internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) { for (int i = 0; i < metaData.Count; i++) { if (reader.IsDBNull(i)) { ValueUtilsSmi.SetDBNull_Unchecked(sink, setters, i); } else { switch (metaData[i].SqlDbType) { case SqlDbType.BigInt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int64)); SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i)); break; case SqlDbType.Binary: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Bit: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Boolean)); SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i)); break; case SqlDbType.Char: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.DateTime: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime)); SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); break; case SqlDbType.Decimal: { // block to scope sqlReader local to avoid conflicts Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlDecimal)); // Support full fidelity for SqlDataReader SqlDataReader sqlReader = reader as SqlDataReader; if (null != sqlReader) { SetSqlDecimal_Unchecked(sink, setters, i, sqlReader.GetSqlDecimal(i)); } else { SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i))); } } break; case SqlDbType.Float: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Double)); SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i)); break; case SqlDbType.Image: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Int: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int32)); SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i)); break; case SqlDbType.Money: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney)); SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); break; case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Real: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Single)); SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i)); break; case SqlDbType.UniqueIdentifier: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Guid)); SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i)); break; case SqlDbType.SmallDateTime: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime)); SetDateTime_Checked(sink, setters, i,metaData[i], reader.GetDateTime(i)); break; case SqlDbType.SmallInt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int16)); SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i)); break; case SqlDbType.SmallMoney: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney)); SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); break; case SqlDbType.Text: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Timestamp: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.TinyInt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Byte)); SetByte_Unchecked(sink, setters, i, reader.GetByte(i)); break; case SqlDbType.VarBinary: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.VarChar: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.String)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Xml: { Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlXml)); SqlDataReader sqlReader = reader as SqlDataReader; if (null != sqlReader) { SetSqlXml_Unchecked(sink, setters, i, sqlReader.GetSqlXml(i)); } else { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); } } break; case SqlDbType.Variant: { // block to scope sqlReader local and avoid conflicts // Support better options for SqlDataReader SqlDataReader sqlReader = reader as SqlDataReader; SqlBuffer.StorageType storageType = SqlBuffer.StorageType.Empty; object o; if (null != sqlReader) { o = sqlReader.GetSqlValue(i); storageType = sqlReader.GetVariantInternalStorageType(i); } else { o = reader.GetValue(i); } ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, o, null, // SmiContextFactory.KatmaiVersion ); if ((storageType == SqlBuffer.StorageType.DateTime2) || (storageType == SqlBuffer.StorageType.Date)) SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null, storageType); else SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null); } break; case SqlDbType.Udt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); // Skip serialization for Udt types. SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; // SqlDbType.Structured should have been caught before this point for TVPs. SUDTs will still need to implement. case SqlDbType.Date: case SqlDbType.DateTime2: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime)); SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); break; case SqlDbType.Time: { // block to scope sqlReader local and avoid conflicts Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.TimeSpan)); SqlDataReader sqlReader = reader as SqlDataReader; TimeSpan ts; if (null != sqlReader) { ts = sqlReader.GetTimeSpan(i); } else { ts = (TimeSpan)reader.GetValue(i); } SetTimeSpan_Checked(sink, setters, i, metaData[i], ts); } break; case SqlDbType.DateTimeOffset: { // block to scope sqlReader local and avoid conflicts Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTimeOffset)); SqlDataReader sqlReader = reader as SqlDataReader; DateTimeOffset dto; if (null != sqlReader) { dto = sqlReader.GetDateTimeOffset(i); } else { dto = (DateTimeOffset)reader.GetValue(i); } SetDateTimeOffset_Unchecked(sink, setters, i, dto); } break; default: // In order for us to get here we would have to have an // invalid instance of SqlDbType, or one would have to add // new member to SqlDbType without adding a case in this // switch, hence the assert - it must be Debug.Assert(false, "unsupported DbType:" + metaData[i].SqlDbType.ToString()); throw ADP.NotSupported(); } } } }
protected ProcessAgentInfo readAgentInfo(DbDataReader dataReader) { long idIn = -1; long idOut = -1; string passIn = null; string passOut = null; ProcessAgentInfo info = new ProcessAgentInfo(); info.agentId = dataReader.GetInt32(0); info.agentGuid = dataReader.GetString(1); if (!DBNull.Value.Equals(dataReader.GetValue(2))) info.agentName = dataReader.GetString(2); info.agentType = (ProcessAgentType.AgentType) dataReader.GetInt32(3); if (!DBNull.Value.Equals(dataReader.GetValue(4))) info.codeBaseUrl = dataReader.GetString(4); info.webServiceUrl = dataReader.GetString(5); if (!DBNull.Value.Equals(dataReader.GetValue(6))) info.domainGuid = dataReader.GetString(6); if (!DBNull.Value.Equals(dataReader.GetValue(7))) info.issuerGuid = dataReader.GetString(7); if (!DBNull.Value.Equals(dataReader.GetValue(8))) idIn = dataReader.GetInt64(8); if (!DBNull.Value.Equals(dataReader.GetValue(9))) passIn = dataReader.GetString(9); if (!DBNull.Value.Equals(dataReader.GetValue(10))) idOut =dataReader.GetInt64(10); if (!DBNull.Value.Equals(dataReader.GetValue(11))) passOut = dataReader.GetString(11); if (!DBNull.Value.Equals(dataReader.GetValue(12))) info.retired = dataReader.GetBoolean(12); if (info.issuerGuid != null) { if (idIn > 0) { Coupon couponIn = new Coupon(); couponIn.couponId = idIn; couponIn.issuerGuid = info.issuerGuid; couponIn.passkey = passIn; info.identIn = couponIn; } else { info.identIn = null; } if (idOut > 0) { Coupon couponOut = new Coupon(); couponOut.couponId = idOut; couponOut.issuerGuid = info.issuerGuid; couponOut.passkey = passOut; info.identOut = couponOut; } else { info.identOut = null; } } return info; }
internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) { for (int i = 0; i < metaData.Count; i++) { object sqlValue; DateTimeOffset dateTimeOffset; TimeSpan timeSpan; ExtendedClrTypeCode code; if (reader.IsDBNull(i)) { SetDBNull_Unchecked(sink, setters, i); continue; } switch (metaData[i].SqlDbType) { case SqlDbType.BigInt: { SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i)); continue; } case SqlDbType.Binary: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Bit: { SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i)); continue; } case SqlDbType.Char: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.DateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.Decimal: { SqlDataReader reader6 = reader as SqlDataReader; if (reader6 == null) { break; } SetSqlDecimal_Unchecked(sink, setters, i, reader6.GetSqlDecimal(i)); continue; } case SqlDbType.Float: { SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i)); continue; } case SqlDbType.Image: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Int: { SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i)); continue; } case SqlDbType.Money: { SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); continue; } case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Real: { SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i)); continue; } case SqlDbType.UniqueIdentifier: { SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i)); continue; } case SqlDbType.SmallDateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.SmallInt: { SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i)); continue; } case SqlDbType.SmallMoney: { SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); continue; } case SqlDbType.Text: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Timestamp: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.TinyInt: { SetByte_Unchecked(sink, setters, i, reader.GetByte(i)); continue; } case SqlDbType.VarBinary: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.VarChar: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Variant: { SqlDataReader reader4 = reader as SqlDataReader; if (reader4 == null) { goto Label_0311; } sqlValue = reader4.GetSqlValue(i); goto Label_0319; } case SqlDbType.Xml: { SqlDataReader reader5 = reader as SqlDataReader; if (reader5 == null) { goto Label_02E4; } SetSqlXml_Unchecked(sink, setters, i, reader5.GetSqlXml(i)); continue; } case SqlDbType.Udt: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Date: case SqlDbType.DateTime2: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.Time: { SqlDataReader reader3 = reader as SqlDataReader; if (reader3 == null) { goto Label_03A0; } timeSpan = reader3.GetTimeSpan(i); goto Label_03AE; } case SqlDbType.DateTimeOffset: { SqlDataReader reader2 = reader as SqlDataReader; if (reader2 == null) { goto Label_03D5; } dateTimeOffset = reader2.GetDateTimeOffset(i); goto Label_03E2; } default: throw ADP.NotSupported(); } SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i))); continue; Label_02E4: SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; Label_0311: sqlValue = reader.GetValue(i); Label_0319: code = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, sqlValue, null, 210L); SetCompatibleValueV200(sink, setters, i, metaData[i], sqlValue, code, 0, 0, null); continue; Label_03A0: timeSpan = (TimeSpan) reader.GetValue(i); Label_03AE: SetTimeSpan_Checked(sink, setters, i, metaData[i], timeSpan); continue; Label_03D5: dateTimeOffset = (DateTimeOffset) reader.GetValue(i); Label_03E2: SetDateTimeOffset_Unchecked(sink, setters, i, dateTimeOffset); } }
public override bool GetBoolean(DbDataReader rd, int i) { return rd.GetBoolean(i); }
private static Boolean? GetBoolean(DbDataReader reader, int index) { if (reader.IsDBNull(index)) return null; else return reader.GetBoolean(index); }
ProfileInfo ReadProfileInfo (DbDataReader reader) { ProfileInfo pi = null; try { string username = reader.GetString (0); bool anonymous = reader.GetBoolean (1); DateTime lastUpdate = reader.GetDateTime (2); DateTime lastActivity = reader.GetDateTime (3); int size = reader.GetInt32 (4); pi = new ProfileInfo (username, anonymous, lastActivity, lastUpdate, size); } catch { } return pi; }
private static BasicMembership ReadMembershipFromDataReader (DbDataReader reader) { int membershipId = reader.GetInt32(0); int personId = reader.GetInt32(1); int organizationId = reader.GetInt32(2); bool active = reader.GetBoolean(3); DateTime expires = reader.GetDateTime(4); DateTime memberSince = reader.GetDateTime(5); DateTime dateTerminated = reader.GetDateTime(6); // bool terminatedAsInvalid = reader.GetBoolean(7); Ignore this field for now return new BasicMembership(membershipId, personId, organizationId, memberSince, expires, active, dateTerminated); }