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