public static void GetDevisPrestataire(Devis d) { String sql = "SELECT devisid, prestataireid, dp.prix, nom FROM DevisPrestataire dp inner join Prestataire p on dp.prestataireid = p.id WHERE devisId=@devisId "; using (MySqlCommand command = new MySqlCommand(sql, connection)) { command.Connection.Open(); command.Parameters.AddWithValue("@devisid", d.Id); using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { int devisid = dbReader.GetInt32(0); int prestataireid = dbReader.GetInt32(1); int prix = dbReader.GetInt32(2); string nom = dbReader.GetString(3); DevisPrestataire dp = new DevisPrestataire(devisid, prestataireid, prix) { Nom = nom }; d.DevisPrestataires.Add(dp); } } command.Connection.Close(); } }
private static BasicPerson ReadPersonFromDataReader (DbDataReader reader) { int personId = reader.GetInt32(0); string passwordHash = reader.GetString(1); string name = reader.GetString(2); string email = reader.GetString(3); string street = reader.GetString(4); string postalCode = reader.GetString(5); string cityName = reader.GetString(6); int countryId = reader.GetInt32(7); string phone = reader.GetString(8); int geographyId = reader.GetInt32(9); DateTime birthdate = reader.GetDateTime(10); int genderId = reader.GetInt32(11); // Fix broken names, emails email = email.ToLower().Trim(); name = name.Trim(); while (name.Contains(" ")) { name = name.Replace(" ", " "); } return new BasicPerson(personId, passwordHash, name, email, street, postalCode, cityName, countryId, phone, geographyId, birthdate, (PersonGender)genderId); }
private static BasicGeography ReadGeographyFromDataReader (DbDataReader reader) { int geographyId = reader.GetInt32(0); int parentGeographyId = reader.GetInt32(1); string name = reader.GetString(2); return new BasicGeography(geographyId, parentGeographyId, name); }
private static BasicCity ReadCityFromDataReader (DbDataReader reader) { int cityId = reader.GetInt32(0); int countryId = reader.GetInt32(1); string cityName = reader.GetString(2); int geographyId = reader.GetInt32(3); return new BasicCity(cityId, cityName, countryId, geographyId); }
private BasicOutboundInvoiceItem ReadOutboundInvoiceItemFromDataReader (DbDataReader reader) { int outboundInvoiceItemId = reader.GetInt32(0); int outboundInvoiceId = reader.GetInt32(1); string description = reader.GetString(2); Int64 amountCents = reader.GetInt64(3); return new BasicOutboundInvoiceItem(outboundInvoiceItemId, outboundInvoiceId, description, amountCents); }
private static BasicGeographyDesignation ReadGeographyDesignationFromDataReader (DbDataReader reader) { int geographyId = reader.GetInt32(0); int countryId = reader.GetInt32(1); string designation = reader.GetString(2); GeographyLevel level = (GeographyLevel) reader.GetInt32(3); return new BasicGeographyDesignation(geographyId, countryId, designation, level); }
private BasicPostalCode ReadPostalCodeFromDataReader(DbDataReader reader) { int postalCodeId = reader.GetInt32(0); string postalCode = reader.GetString(1); int cityId = reader.GetInt32(2); int countryId = reader.GetInt32(3); return new BasicPostalCode(postalCodeId, postalCode, cityId, countryId); }
private static BasicCountry ReadCountryFromDataReader(DbDataReader reader) { int countryId = reader.GetInt32(0); string name = reader.GetString(1); string code = reader.GetString(2).ToUpperInvariant(); string culture = reader.GetString(3); int geographyId = reader.GetInt32(4); return new BasicCountry(countryId, name, code, culture, geographyId); }
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); }
static private BasicPersonRole ReadPersonRoleFromDataReader (DbDataReader reader) { int personRoleId = reader.GetInt32(0); string personRoleTypeName = reader.GetString(1); int personId = reader.GetInt32(2); int organizationId = reader.GetInt32(3); int geographyId = reader.GetInt32(4); RoleType roleType = (RoleType) Enum.Parse(typeof (RoleType), personRoleTypeName); return new BasicPersonRole(personRoleId, personId, roleType, organizationId, geographyId); }
private static BasicAutoMail ReadAutoMailFromDataReader (DbDataReader reader) { int autoMailId = reader.GetInt32(0); AutoMailType type = (AutoMailType) Enum.Parse(typeof (AutoMailType), reader.GetString(1)); int geographyId = reader.GetInt32(3); int organizationId = reader.GetInt32(2); int authorPersonId = reader.GetInt32(4); // appear to be unused? string title = reader.GetString(5); string body = reader.GetString(6); return new BasicAutoMail(autoMailId, type, organizationId, geographyId, authorPersonId, title, body); }
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); }
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(); } }
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); }
private BasicExternalCredential ReadExternalCredentialFromDataReader (DbDataReader reader) { int externalCredentialId = reader.GetInt32(0); string serviceName = reader.GetString(1); string login = reader.GetString(2); string password = reader.GetString(3); return new BasicExternalCredential(externalCredentialId, serviceName, login, password); }
private static BasicExceptionLog ExceptionLogFromDataReader (DbDataReader reader) { int ExceptionId = reader.GetInt32(0); DateTime ExceptionDateTime = reader.GetDateTime(1); string Source = reader.GetString(2); string ExceptionText = reader.GetString(3); return new BasicExceptionLog(ExceptionId, ExceptionDateTime, Source, ExceptionText); }
private Dictionary<int, Medicine> Read(DbDataReader reader, IDatabase db) { Dictionary<int, Medicine> medicines = new Dictionary<int, Medicine>(); while (reader.Read()) { Medicine m = new Medicine(); m.Id = reader.GetInt32(0); m.Name = reader.GetString(1); m.Description = reader.GetString(2); m.PackageSize = reader.GetInt32(3); m.Price = Decimal.ToSingle(reader.GetDecimal(4)); m.Allergens = this.ReadAllergens(m, db); medicines.Add(m.Id, m); } return medicines; }
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); }
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); }
static int GetInt32(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); int o = obj.GetInt32(arg0); LuaDLL.lua_pushinteger(L, o); return(1); } catch (Exception e) { return(LuaDLL.toluaL_exception(L, e)); } }
protected Conversation GetCurrentConversation(DbDataReader reader) { int colID = reader.GetOrdinal("grupoid_grupo"); int colName = reader.GetOrdinal("nombre"); Conversation conversation = new Conversation(); if (!reader.IsDBNull(colID)) { conversation.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colName)) { conversation.Name = reader.GetString(colName); } return conversation; }
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); }
private void mapValues(DbDataReader reader, object record) { foreach (var accessor in this.accessors) { var index = reader.GetOrdinal(accessor.Name); if (reader.IsDBNull(index)) { continue; } if (accessor.PropertyType == typeof(string)) { accessor.Set(record, reader.GetString(index)); } else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) { accessor.Set(record, reader.GetInt32(index)); } else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) { accessor.Set(record, reader.GetInt64(index)); } else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) { accessor.Set(record, reader.GetDateTime(index)); } else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) { accessor.Set(record, reader.GetChar(index)); } } }
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 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); }
ProfileInfoCollection BuildProfileInfoCollection (DbDataReader reader, out int totalRecords) { ProfileInfoCollection pic = new ProfileInfoCollection (); while (reader.Read ()) { ProfileInfo pi = ReadProfileInfo (reader); if (pi != null) pic.Add (pi); } totalRecords = 0; if (reader.NextResult ()) { if (reader.Read ()) totalRecords = reader.GetInt32 (0); } return pic; }
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; }
// 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(); } } } }
public IEnumerable <Bunk> QueryBunkListView(DataTransferObject.Foundation.BunkQueryCondition condition, Core.Pagination pagination) { var result = new List <Bunk>(); using (var dbOperator = new DbOperator(Provider, ConnectionString)) { if (!string.IsNullOrWhiteSpace(condition.Airline)) { dbOperator.AddParameter("@iAirline", condition.Airline.Trim()); } if (!string.IsNullOrWhiteSpace(condition.Departure)) { dbOperator.AddParameter("@iDeparture", condition.Departure.Trim()); } if (!string.IsNullOrWhiteSpace(condition.Arrival)) { dbOperator.AddParameter("@iArrival", condition.Arrival.Trim()); } if (!string.IsNullOrWhiteSpace(condition.BunkCode)) { dbOperator.AddParameter("@iBunkCode", condition.BunkCode.Trim()); } if (condition.BunkType.HasValue) { dbOperator.AddParameter("@iBunkType", (int)condition.BunkType); } if (condition.VoyageType.HasValue) { dbOperator.AddParameter("@iVoyageType", (byte)condition.VoyageType); } if (condition.FlightBeginDate.HasValue) { dbOperator.AddParameter("@iFlightBeginDate", condition.FlightBeginDate.Value.Date); } if (condition.FlightEndDate.HasValue) { dbOperator.AddParameter("@iFlightEndDate", condition.FlightEndDate.Value.Date); } if (condition.Status.HasValue) { dbOperator.AddParameter("@iStatus", condition.Status); } if (pagination != null) { dbOperator.AddParameter("@iPageSize", pagination.PageSize); dbOperator.AddParameter("@iPageIndex", pagination.PageIndex); } System.Data.Common.DbParameter totalCount = dbOperator.AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (System.Data.Common.DbDataReader reader = dbOperator.ExecuteReader("dbo.P_QueryBunks", System.Data.CommandType.StoredProcedure)) { Guid?previousId = null; Bunk bunk = null; while (reader.Read()) { var currentId = reader.GetGuid(1); if (bunk == null || previousId.Value != currentId) { bunk = null; } var bunkType = (BunkType)reader.GetInt32(0); switch (bunkType) { case BunkType.Economic: bunk = loadEconomicBunk(bunk, reader); break; case BunkType.FirstOrBusiness: bunk = loadFirstBusinessBunk(bunk, reader); break; case BunkType.Promotion: bunk = loadPromotionBunk(bunk, reader); break; case BunkType.Production: bunk = loadProductionBunk(bunk, reader); break; case BunkType.Transfer: bunk = loadTransferBunk(bunk, reader); break; case BunkType.Free: bunk = loadFreeBunk(bunk, reader); break; case BunkType.Team: bunk = loadTeamBunk(bunk, reader); break; } bunk.VoyageType = (VoyageTypeValue)reader.GetByte(19); bunk.TravelType = (TravelTypeValue)reader.GetByte(20); bunk.PassengerType = (PassengerTypeValue)reader.GetByte(21); bunk.RefundRegulation = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); bunk.ChangeRegulation = reader.IsDBNull(16) ? string.Empty : reader.GetString(16); bunk.EndorseRegulation = reader.IsDBNull(17) ? string.Empty : reader.GetString(17); bunk.Remarks = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); if (!previousId.HasValue || previousId.Value != currentId) { result.Add(bunk); previousId = currentId; } } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } } return(result); }
private List<Request> Read(DbDataReader reader) { List<Request> requests = new List<Request>(); while (reader.Read()) { SampleRequest er = new SampleRequest(); er.Id = reader.GetInt32(0); er.Type = reader.GetString(1); er.Description = reader.GetString(2); er.Created = reader.GetDateTime(3); requests.Add(er); } return requests; }
protected Authority readAuthority(DbDataReader dataReader) { Authority auth = null; while (dataReader.Read()) { auth = new Authority(); //Authority_ID,Auth_Type_ID,Default_Group_ID,Authority_Guid,Authority_Name, //Authority_URL,Pass_Phrase, Email_Proxy,Description,Contact_Email,Bug_Email,Location if (!dataReader.IsDBNull(0)) auth.authorityID = dataReader.GetInt32(0); if (!dataReader.IsDBNull(1)) auth.authTypeID = dataReader.GetInt32(1); if (!dataReader.IsDBNull(2)) auth.defaultGroupID = dataReader.GetInt32(2); if (!dataReader.IsDBNull(3)) auth.authGuid = dataReader.GetString(3); if (!dataReader.IsDBNull(4)) auth.authName = dataReader.GetString(4); if (!dataReader.IsDBNull(5)) auth.authURL = dataReader.GetString(5); if (!dataReader.IsDBNull(6)) auth.passphrase = dataReader.GetString(6); if (!dataReader.IsDBNull(7)) auth.emailProxy = dataReader.GetString(7); if (!dataReader.IsDBNull(8)) auth.description = dataReader.GetString(8); if (!dataReader.IsDBNull(9)) auth.contactEmail = dataReader.GetString(9); if (!dataReader.IsDBNull(10)) auth.bugEmail = dataReader.GetString(10); if (!dataReader.IsDBNull(11)) auth.location = dataReader.GetString(11); } return auth; }
private int CheckDbAndIndex(DbDataReader dbreader, IndexReader ixreader, List<Difference> result) { var versionId = dbreader.GetInt32(0); var dbNodeTimestamp = dbreader.GetInt64(1); var dbVersionTimestamp = dbreader.GetInt64(2); var termDocs = ixreader.TermDocs(new Lucene.Net.Index.Term(LucObject.FieldName.VersionId, Lucene.Net.Util.NumericUtils.IntToPrefixCoded(versionId))); Lucene.Net.Documents.Document doc = null; int docid = -1; if (termDocs.Next()) { docid = termDocs.Doc(); doc = ixreader.Document(docid); var indexNodeTimestamp = ParseLong(doc.Get(LucObject.FieldName.NodeTimestamp)); var indexVersionTimestamp = ParseLong(doc.Get(LucObject.FieldName.VersionTimestamp)); var nodeId = ParseInt(doc.Get(LucObject.FieldName.NodeId)); var version = doc.Get(LucObject.FieldName.Version); var p = doc.Get(LucObject.FieldName.Path); if (termDocs.Next()) { result.Add(new Difference(IndexDifferenceKind.MoreDocument) { DocId = docid, NodeId = nodeId, VersionId = versionId, Version = version, Path = p, DbNodeTimestamp = dbNodeTimestamp, DbVersionTimestamp = dbVersionTimestamp, IxNodeTimestamp = indexNodeTimestamp, IxVersionTimestamp = indexVersionTimestamp, }); } if (dbVersionTimestamp != indexVersionTimestamp) { result.Add(new Difference(IndexDifferenceKind.DifferentVersionTimestamp) { DocId = docid, VersionId = versionId, DbNodeTimestamp = dbNodeTimestamp, DbVersionTimestamp = dbVersionTimestamp, IxNodeTimestamp = indexNodeTimestamp, IxVersionTimestamp = indexVersionTimestamp, NodeId = nodeId, Version = version, Path = p }); } if (dbNodeTimestamp != indexNodeTimestamp) { var ok = false; var isLastDraft = doc.Get(LucObject.FieldName.IsLastDraft); if (isLastDraft != BooleanIndexHandler.YES) { var latestDocs = ixreader.TermDocs(new Lucene.Net.Index.Term(LucObject.FieldName.NodeId, Lucene.Net.Util.NumericUtils.IntToPrefixCoded(nodeId))); Lucene.Net.Documents.Document latestDoc = null; while (latestDocs.Next()) { var latestdocid = latestDocs.Doc(); var d = ixreader.Document(latestdocid); if (d.Get(LucObject.FieldName.IsLastDraft) != BooleanIndexHandler.YES) continue; latestDoc = d; break; } var latestPath = latestDoc.Get(LucObject.FieldName.Path); if (latestPath == p) ok = true; } if (!ok) { result.Add(new Difference(IndexDifferenceKind.DifferentNodeTimestamp) { DocId = docid, VersionId = versionId, DbNodeTimestamp = dbNodeTimestamp, DbVersionTimestamp = dbVersionTimestamp, IxNodeTimestamp = indexNodeTimestamp, IxVersionTimestamp = indexVersionTimestamp, NodeId = nodeId, Version = version, Path = p }); } } } else { result.Add(new Difference(IndexDifferenceKind.NotInIndex) { DocId = docid, VersionId = versionId, DbNodeTimestamp = dbNodeTimestamp, DbVersionTimestamp = dbVersionTimestamp, }); } return docid; }
protected void FillTreeNavigation(int major, TreeNode tNode, ContextMenuStrip nodeContextMenuStrip) { //change the type of data base if (tNode != null) { TreeNodeData dataNode = (TreeNodeData)tNode.Tag; currentConnectionStringName = dataNode.ConnectionStringName; } if (!string.IsNullOrEmpty(currentConnectionStringName)) { currentProviderName = ConfigurationManager.ConnectionStrings[currentConnectionStringName].ProviderName; currentConnectionString = ConfigurationManager.ConnectionStrings[currentConnectionStringName].ConnectionString; switch (currentProviderName) { case "System.Data.SqlClient": { dbConnection = sqlConnection; dbCommand = sqlCommand; dbConnectionDaughter = sqlConnectionDaughter; dbCommandDaughter = sqlCommandDaughter; break; } case "FirebirdSql.Data.FirebirdClient": { dbConnection = fbConnection; dbCommand = fbCommand; dbConnectionDaughter = fbConnectionDaughter; dbCommandDaughter = fbCommandDaughter; break; } default: { throw new Exception("Bad name of current connection string"); } } } else { throw new Exception("Bad name of current connection string"); } //logic dbConnection.Open(); dbConnectionDaughter.Open(); TreeNodeData treeNodeData; TreeNode currentNode; int i = 0, n = 0; dbCommand.CommandText = "Select Id, Name From TUObjects Where Major = " + major + " Order by ClassId, Name"; dbDataReader = dbCommand.ExecuteReader(); while (dbDataReader.Read()) { treeNodeData = new TreeNodeData(dbDataReader.GetInt32(0), false, currentConnectionStringName); currentNode = new TreeNode(dbDataReader.GetString(1)); currentNode.Tag = treeNodeData; if(nodeContextMenuStrip != null) currentNode.ContextMenuStrip = nodeContextMenuStrip; if (tNode != null) tNode.Nodes.Add(currentNode); else treeNavigation.Nodes.Add(currentNode); dbCommandDaughter.CommandText = "Select Count(Id) From TUObjects Where Major = " + dbDataReader.GetInt32(0); n = (int)dbCommandDaughter.ExecuteScalar(); if (n > 0) { if (tNode != null) tNode.Nodes[i].Nodes.Add("Virtual Node"); else treeNavigation.Nodes[i].Nodes.Add("Virtual Node"); } i++; } dbDataReader.Close(); dbConnection.Close(); dbConnectionDaughter.Close(); }