// Implementation of IOracleCustomType.ToCustomObject() public virtual void ToCustomObject(OracleConnection con, object pUdt) { // Convert from the Oracle Object to a Custom Type // Get the "NAME" attribute // If the "NAME" attribute is NULL, then null will be returned m_name = (string)OracleUdt.GetValue(con, pUdt, "NAME"); // The "NAME" attribute can also be accessed by specifying index 0 // m_name = (string)OracleUdt.GetValue(con, pUdt, 0); // Get the "ADDRESS" attribute // If the "ADDRESS" attribute is NULL, then OracleString.Null will be returned m_address = (OracleString)OracleUdt.GetValue(con, pUdt, "ADDRESS"); // The "NAME" attribute can also be accessed by specifying index 1 // m_address = (OracleString)OracleUdt.GetValue(con, pUdt, 1); // Get the "AGE" attribute // If the "AGE" attribute is NULL, then null will be returned m_age = (int?)OracleUdt.GetValue(con, pUdt, "AGE"); // The "AGE" attribute can also be accessed by specifying index 2 // m_age = (int?)OracleUdt.GetValue(con, pUdt, 2); }
public void ToCustomObject(OracleConnection con, IntPtr pUdt) { Id = (string)OracleUdt.GetValue(con, pUdt, "ID"); Count = (int)OracleUdt.GetValue(con, pUdt, "COUNT"); Height = (int)OracleUdt.GetValue(con, pUdt, "HEIGHT"); Barcodes = (BarcodeArray)OracleUdt.GetValue(con, pUdt, "BARCODES"); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt) { REFERENCE_NUMBER = (string)OracleUdt.GetValue(con, pUdt, "REFERENCE_NUMBER"); EVIDENCE_TYPE = (int)OracleUdt.GetValue(con, pUdt, "EVIDENCE_TYPE"); MIME_TYPE = (string)OracleUdt.GetValue(con, pUdt, "MIME_TYPE"); DISTRICT_ID = (long)OracleUdt.GetValue(con, pUdt, "DISTRICT_ID"); }
// IOracleCustomType.ToCustomObject() implementation // Writes a JOBS_TYPE Oracle UDT into a JobClass object public virtual void ToCustomObject(OracleConnection con, IntPtr pUdt) { _jobID = (string)OracleUdt.GetValue(con, pUdt, "JOBID"); _jobName = (string)OracleUdt.GetValue(con, pUdt, "JOBNAME"); _jobDescription = (string)OracleUdt.GetValue(con, pUdt, "JOBDESCRIPTION"); _jobPrice = (int)OracleUdt.GetValue(con, pUdt, "JOBPRICE"); }
public void ToCustomObject(OracleConnection con, IntPtr pUdt) { object objectStatusArray = null; Array = (Int32[])OracleUdt.GetValue(con, pUdt, 0, out objectStatusArray); m_statusArray = (OracleUdtStatus[])objectStatusArray; }
public virtual void ToCustomObject(OracleConnection con, System.IntPtr pUdt) { object objectStatusArray = null; this.m_TCODESTRINGFIELD = ((string[])(OracleUdt.GetValue(con, pUdt, 0, out objectStatusArray))); this.m_statusArray = ((OracleUdtStatus[])(objectStatusArray)); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt) { VEHICLE_TEST_BOOKING_ID = (long)OracleUdt.GetValue(con, pUdt, "VEHICLE_TEST_BOOKING_ID"); INSPECTION_EVIDENCE_TYPE_ID = (long)OracleUdt.GetValue(con, pUdt, "INSPECTION_EVIDENCE_TYPE_ID"); MIME_TYPE = (string)OracleUdt.GetValue(con, pUdt, "MIME_TYPE"); SITE_ID = (long)OracleUdt.GetValue(con, pUdt, "SITE_ID"); }
public void ToCustomObject(OracleConnection con, IntPtr pUdt) { if (!OracleUdt.IsDBNull(con, pUdt, 0)) { Value = (int?[])OracleUdt.GetValue(con, pUdt, 0); } }
public virtual void ToCustomObject(OracleConnection con, System.IntPtr pUdt) { IndicatorId = ((decimal?)(OracleUdt.GetValue(con, pUdt, "INDICATOR_ID"))); TitleId = ((decimal?)(OracleUdt.GetValue(con, pUdt, "TITLE_ID"))); BlockTitleId = ((decimal?)(OracleUdt.GetValue(con, pUdt, "BLOCK_TITLE_ID"))); UnitId = ((decimal?)(OracleUdt.GetValue(con, pUdt, "UNIT_ID"))); Value = ((decimal?)(OracleUdt.GetValue(con, pUdt, "VALUE"))); }
// Implementation of IOracleCustomType.ToCustomObject() public override void ToCustomObject(OracleConnection con, object pUdt) { // Convert from the Oracle Object to a Custom Type. // Invoke the base class conversion method. base.ToCustomObject(con, pUdt); // Get the "MAJOR" attribute. // If the "MAJOR" attribute is NULL, then "null" will be returned. // The "MAJOR" attribute can also be accessed by specifying index 5. m_major = (string)OracleUdt.GetValue(con, pUdt, "MAJOR"); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt) { VehicleTestBookingID = (int)OracleUdt.GetValue(con, pUdt, "VEHICLE_TEST_BOOKING_ID"); TestTypeID = (int)OracleUdt.GetValue(con, pUdt, "TEST_TYPE_ID"); TestQuestionsID = (int)OracleUdt.GetValue(con, pUdt, "TEST_QUESTIONS_ID"); TextAnswer = (string)OracleUdt.GetValue(con, pUdt, "TEXT_ANSWER"); TestQuestionsAnswersID = (int)OracleUdt.GetValue(con, pUdt, "TEST_QUESTIONS_ANSWERS_ID"); TestQuestionsAnswersIDRelID = (int)OracleUdt.GetValue(con, pUdt, "TEST_QUESTIONS_ANSWERS_REL_ID"); Comments = (string)OracleUdt.GetValue(con, pUdt, "COMMENTS"); IsPassed = (int)OracleUdt.GetValue(con, pUdt, "IS_PASSED"); }
protected U GetValue <U>(int oracleColumnId) { if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnId)) { if (default(U) is ValueType) { throw new Exception(errorMessageHead + oracleColumnId + " of value type " + typeof(U)); } return(default(U)); } return((U)OracleUdt.GetValue(_connection, _pUdt, oracleColumnId)); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt) { BookingDate = (DateTime)OracleUdt.GetValue(con, pUdt, "BOOKING_DATE"); TestCategoryID = (int)OracleUdt.GetValue(con, pUdt, "TEST_CATEGORY_ID"); IsPassed = (int)OracleUdt.GetValue(con, pUdt, "IS_PASSED"); EngineNumber = (string)OracleUdt.GetValue(con, pUdt, "ENGINE_NUMBER"); VehicleIdentificationNumber = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_IDENTIFICATION_NUMBER"); VLN = (string)OracleUdt.GetValue(con, pUdt, "VLN"); BookingReference = (string)OracleUdt.GetValue(con, pUdt, "BOOKING_REFERENCE"); DateIndicator = (int)OracleUdt.GetValue(con, pUdt, "DATE_INDICATOR"); Quantity = (int)OracleUdt.GetValue(con, pUdt, "QUANTITY"); PageNumber = (int)OracleUdt.GetValue(con, pUdt, "PAGE_NUMBER"); }
protected TUser GetValue <TUser>(int oracleColumnId) { if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnId)) { if (default(TUser) is ValueType) { throw new Exception(ErrorMessageHead + oracleColumnId.ToString() + " of value type " + typeof(TUser)); } return(default(TUser)); } return((TUser)OracleUdt.GetValue(_connection, _pUdt, oracleColumnId)); }
public void ToCustomObject(OracleConnection con, object pUdt) { // If the UDT may contain NULL attribute data, enable the following code //if (!OracleUdt.IsDBNull(con, pUdt, 0)) _gtype = (int)OracleUdt.GetValue(con, pUdt, 0); // If the UDT may contain NULL attribute data, enable the following code //if (!OracleUdt.IsDBNull(con, pUdt, 0)) _srid = (int)OracleUdt.GetValue(con, pUdt, 1); _point = (SdoPoint)OracleUdt.GetValue(con, pUdt, 2); _elementInfo = (int[])OracleUdt.GetValue(con, pUdt, 3); _ordinates = (double[])OracleUdt.GetValue(con, pUdt, 4); }
public virtual void ToCustomObject(OracleConnection con, IntPtr pUdt) { object objectStatusArray; var oraXml = ((OracleXmlType[])(OracleUdt.GetValue(con, pUdt, 0, out objectStatusArray))); // ”бираю PLINQ, т.к. возможно "из-за него" вылезают ошибки Access Violation //this.m_TLISTXML = oraXml.AsParallel().Select(i => i.GetXmlDocument()).ToArray(); this.m_TLISTXML = oraXml.Select(i => i.GetXmlDocument()).ToArray(); this.m_statusArray = ((OracleUdtStatus[])(objectStatusArray)); foreach (var ora in oraXml) { ora.Dispose(); } }
public TU GetValue <TU>(int oracleColumnId) { if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnId)) { if (default(TU) is ValueType) { throw new Exception("Error converting Oracle User Defined Type to .Net Type"); } return(default(TU)); } return((TU)OracleUdt.GetValue(_connection, _pUdt, oracleColumnId)); }
public void ToCustomObject(OracleConnection con, object pUdt) { // If the UDT may contain NULL attribute data, enable the following code //if (!OracleUdt.IsDBNull(con, pUdt, 0)) X = (double)OracleUdt.GetValue(con, pUdt, 0); // If the UDT may contain NULL attribute data, enable the following code //if (!OracleUdt.IsDBNull(con, pUdt, 1)) Y = (double)OracleUdt.GetValue(con, pUdt, 1); // If the UDT may contain NULL attribute data, enable the following code //if (!OracleUdt.IsDBNull(con, pUdt, 2)) Z = (double)OracleUdt.GetValue(con, pUdt, 2); }
public void ToCustomObject(OracleConnection con, IntPtr pUdt) { ProcessProperties((prop, attr) => { if (prop.PropertyType.IsCollection()) { dynamic collection = OracleUdt.GetValue(con, pUdt, attr.AttributeName); prop.SetValue(this, collection.Array); } else { prop.SetValue(this, OracleUdt.GetValue(con, pUdt, attr.AttributeName)); } }); }
protected TUser GetValue <TUser>(string oracleColumnName) { if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnName)) { if (default(TUser) != null) { throw new Exception(ErrorMessageHead + oracleColumnName + " of value type " + typeof(TUser)); } return(default(TUser)); } return((TUser)OracleUdt.GetValue(_connection, _pUdt, oracleColumnName)); }
public void MapTo(T instance, OracleConnection conn, IntPtr pUdt) { if (_attribute != null) { string attributeName = _attribute.AttributeName; if (!OracleUdt.IsDBNull(conn, pUdt, attributeName)) { object value = OracleUdt.GetValue(conn, pUdt, attributeName); if (!(value == null || value is DBNull)) { _property.SetValue(instance, value, null); } } } }
protected U GetValue <U>(string oracleColumnName) { if (OracleUdt.IsDBNull(this.connection, this.udtHandle, oracleColumnName)) { if (default(U) is ValueType) { throw new Exception(errorMessageHead + oracleColumnName.ToString() + " of value type " + typeof(U).ToString()); } else { return(default(U)); } } else { return((U)OracleUdt.GetValue(this.connection, this.udtHandle, oracleColumnName)); } }
protected U GetValue <U>(int oracleColumn_Id) { if (OracleUdt.IsDBNull(connection, pUdt, oracleColumn_Id)) { if (default(U) is ValueType) { throw new Exception(errorMessageHead + oracleColumn_Id.ToString() + " of value type " + typeof(U).ToString()); } else { return(default(U)); } } else { return((U)OracleUdt.GetValue(connection, pUdt, oracleColumn_Id)); } }
public void ToCustomObject(OracleConnection con, IntPtr pUdt) { Name = (string)OracleUdt.GetValue(con, pUdt, "NAME"); ValueTypeNo = (long)OracleUdt.GetValue(con, pUdt, "VALUE_TYPE_NO"); switch ((EValueType)ValueTypeNo) { case EValueType.DATE: if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_DATE")) { ValueDate = (DateTime)OracleUdt.GetValue(con, pUdt, "VALUE_DATE"); } break; case EValueType.NUMBER: if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_NUMBER")) { ValueNumber = (decimal)OracleUdt.GetValue(con, pUdt, "VALUE_NUMBER"); } break; case EValueType.OBJECT: if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_OBJECT_NO")) { ValueObject = (long)OracleUdt.GetValue(con, pUdt, "VALUE_OBJECT_NO"); } break; case EValueType.VARCHAR: if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_VARCHAR2")) { ValueVarchar2 = (string)OracleUdt.GetValue(con, pUdt, "VALUE_VARCHAR2"); } break; } }
public void ToCustomObject(OracleConnection con, IntPtr pUdt) { object sdoGType = OracleUdt.GetValue(con, pUdt, "SDO_GTYPE"); _sdoGTypeIsNull = sdoGType == null || sdoGType is DBNull; if (!_sdoGTypeIsNull) { SdoGType = (int)sdoGType; } SdoOrdinates = (SdoOrdinates)OracleUdt.GetValue(con, pUdt, "SDO_ORDINATES"); SdoElemInfo = (SdoElemInfo)OracleUdt.GetValue(con, pUdt, "SDO_ELEM_INFO"); object sdoSrid = OracleUdt.GetValue(con, pUdt, "SDO_SRID"); if (!(sdoSrid == null || sdoSrid is DBNull)) { SdoSrid = (int)sdoSrid; } SdoPoint = (SdoPoint)OracleUdt.GetValue(con, pUdt, "SDO_POINT"); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt) { STATS_FILE_NAME = (string)OracleUdt.GetValue(con, pUdt, "STATS_FILE_NAME"); MACHINE_ID = (string)OracleUdt.GetValue(con, pUdt, "MACHINE_ID"); LOCATION_CODE = (string)OracleUdt.GetValue(con, pUdt, "LOCATION_CODE"); RUN_DATE = (string)OracleUdt.GetValue(con, pUdt, "RUN_DATE"); TIME = (string)OracleUdt.GetValue(con, pUdt, "TIME"); SPEED = (long?)OracleUdt.GetValue(con, pUdt, "SPEED"); ZONE = (long?)OracleUdt.GetValue(con, pUdt, "ZONE"); LANE = (long?)OracleUdt.GetValue(con, pUdt, "LANE"); TYPE = (string)OracleUdt.GetValue(con, pUdt, "TYPE"); DISTANCE = (long?)OracleUdt.GetValue(con, pUdt, "DISTANCE"); DIRECTION = (string)OracleUdt.GetValue(con, pUdt, "DIRECTION"); CLASSIFICATION = (string)OracleUdt.GetValue(con, pUdt, "CLASSIFICATION"); CAPTURED = (string)OracleUdt.GetValue(con, pUdt, "CAPTURED"); ENC_FILE_NAME = (string)OracleUdt.GetValue(con, pUdt, "ENC_FILE_NAME"); ERROR_MESSAGE = (string)OracleUdt.GetValue(con, pUdt, "ERROR_MESSAGE"); SMD_STRING = (string)OracleUdt.GetValue(con, pUdt, "SMD_STRING"); PLATES = (string)OracleUdt.GetValue(con, pUdt, "PLATES"); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt) { REFERENCE_NUMBER = (string)OracleUdt.GetValue(con, pUdt, "REFERENCE_NUMBER"); VEHICLE_REGISTRATION_NUMBER = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_REGISTRATION_NUMBER"); VEHICLE_MAKE_ID = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_MAKE_ID"); VEHICLE_MAKE = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_MAKE"); VEHICLE_MODEL_ID = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_MODEL_ID"); VEHICLE_MODEL = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_MODEL"); VEHICLE_TYPE_ID = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_TYPE_ID"); VEHICLE_TYPE = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_TYPE"); VEHICLE_USAGE_ID = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_USAGE_ID"); VEHICLE_COLOUR_ID = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_COLOUR_ID"); YEAR_OF_MAKE = (string)OracleUdt.GetValue(con, pUdt, "YEAR_OF_MAKE"); LICENSE_EXPIRE_DATE = (DateTime?)OracleUdt.GetValue(con, pUdt, "LICENSE_EXPIRE_DATE"); CLEARENCE_CERT_NO = (string)OracleUdt.GetValue(con, pUdt, "CLEARENCE_CERT_NO"); OWNER_ID = (string)OracleUdt.GetValue(con, pUdt, "OWNER_ID"); OWNER_ID_TYPE = (string)OracleUdt.GetValue(con, pUdt, "OWNER_ID_TYPE"); OWNER_NAME = (string)OracleUdt.GetValue(con, pUdt, "OWNER_NAME"); OWNER_INIT = (string)OracleUdt.GetValue(con, pUdt, "OWNER_INIT"); OWNER_SURNAME = (string)OracleUdt.GetValue(con, pUdt, "OWNER_SURNAME"); OWNER_GENDER = (string)OracleUdt.GetValue(con, pUdt, "OWNER_GENDER"); OWNER_POSTAL = (string)OracleUdt.GetValue(con, pUdt, "OWNER_POSTAL"); OWNER_POSTAL_STREET = (string)OracleUdt.GetValue(con, pUdt, "OWNER_POSTAL_STREET"); OWNER_POSTAL_SUBURB = (string)OracleUdt.GetValue(con, pUdt, "OWNER_POSTAL_SUBURB"); OWNER_POSTAL_TOWN = (string)OracleUdt.GetValue(con, pUdt, "OWNER_POSTAL_TOWN"); OWNER_POSTAL_CODE = (string)OracleUdt.GetValue(con, pUdt, "OWNER_POSTAL_CODE"); OWNER_PHYS = (string)OracleUdt.GetValue(con, pUdt, "OWNER_PHYS"); OWNER_PHYS_STREET = (string)OracleUdt.GetValue(con, pUdt, "OWNER_PHYS_STREET"); OWNER_PHYS_SUBURB = (string)OracleUdt.GetValue(con, pUdt, "OWNER_PHYS_SUBURB"); OWNER_PHYS_TOWN = (string)OracleUdt.GetValue(con, pUdt, "OWNER_PHYS_TOWN"); OWNER_PHYS_CODE = (string)OracleUdt.GetValue(con, pUdt, "OWNER_PHYS_CODE"); OWNER_TELEPHONE = (string)OracleUdt.GetValue(con, pUdt, "OWNER_TELEPHONE"); OWNER_CELLPHONE = (string)OracleUdt.GetValue(con, pUdt, "OWNER_CELLPHONE"); OWNER_COMPANY = (string)OracleUdt.GetValue(con, pUdt, "OWNER_COMPANY"); DATE_OF_OWNERSHIP = (DateTime?)OracleUdt.GetValue(con, pUdt, "DATE_OF_OWNERSHIP"); IMPORT_FILE_NAME = (string)OracleUdt.GetValue(con, pUdt, "IMPORT_FILE_NAME"); NATURE_OF_OWNERSHIP = (string)OracleUdt.GetValue(con, pUdt, "NATURE_OF_OWNERSHIP"); PROXY_INDICATOR = (string)OracleUdt.GetValue(con, pUdt, "PROXY_INDICATOR"); EMAIL_ADDRESS = (string)OracleUdt.GetValue(con, pUdt, "EMAIL_ADDRESS"); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt) { VIN = (string)OracleUdt.GetValue(con, pUdt, "VEHICLE_IDENTIFICATION_NUMBER"); EngineNumber = (string)OracleUdt.GetValue(con, pUdt, "ENGINE_NUMBER"); VehicleCategoryID = (int)OracleUdt.GetValue(con, pUdt, "VEHICLE_CATEGORY_ID"); VehicleTypeID = (int)OracleUdt.GetValue(con, pUdt, "VEHICLE_TYPE_ID"); VehicleMakeID = (int)OracleUdt.GetValue(con, pUdt, "VEHICLE_MAKE_ID"); VehicleModelID = (int)OracleUdt.GetValue(con, pUdt, "VEHICLE_MODEL_ID"); VehicleModelNumberID = (int)OracleUdt.GetValue(con, pUdt, "VEHICLE_MODEL_NUMBER_ID"); YearOfMake = (int)OracleUdt.GetValue(con, pUdt, "YEAR_OF_MAKE"); ColourID = (int)OracleUdt.GetValue(con, pUdt, "COLOUR_ID"); VLN = (string)OracleUdt.GetValue(con, pUdt, "VLN"); NetWeight = (int)OracleUdt.GetValue(con, pUdt, "NET_WEIGHT"); GVM = (int)OracleUdt.GetValue(con, pUdt, "GVM"); PropelledByID = (int)OracleUdt.GetValue(con, pUdt, "PROPELLED_BY_ID"); FuelTypeID = (int)OracleUdt.GetValue(con, pUdt, "FUEL_TYPE_ID"); RegistrationStatusID = (int)OracleUdt.GetValue(con, pUdt, "REGISTRATION_STATUS_ID"); LicenceExpiryDate = (DateTime)OracleUdt.GetValue(con, pUdt, "LICENCE_EXPIRY_DATE"); RoadworthyExpiryDate = (DateTime)OracleUdt.GetValue(con, pUdt, "ROADWORTHINESS_EXPIRY_DATE"); InsuranceExpiryDate = (DateTime)OracleUdt.GetValue(con, pUdt, "INSURANCE_EXPIRY_DATE"); SeatingCapacity = (long)OracleUdt.GetValue(con, pUdt, "SEATING_CAPACITY"); }
public void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt) { ParameterName = (string)OracleUdt.GetValue(con, pUdt, "PARAMETERNAME"); ParameterValue = (string)OracleUdt.GetValue(con, pUdt, "PARAMETERVALUE"); }
public virtual void ToCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt) { this.m_TBSM_PURCHASE_DTL = ((TBSM_PURCHASE_DTL[])(OracleUdt.GetValue(con, pUdt, 0))); }