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);
}
