public void FromCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt)
{
OracleUdt.SetValue(con, pUdt, "REFERENCE_NUMBER", REFERENCE_NUMBER);
OracleUdt.SetValue(con, pUdt, "EVIDENCE_TYPE", EVIDENCE_TYPE);
OracleUdt.SetValue(con, pUdt, "MIME_TYPE", MIME_TYPE);
OracleUdt.SetValue(con, pUdt, "DISTRICT_ID", DISTRICT_ID);
}
public void ToCustomObject(OracleConnection con, IntPtr pUdt)
{
if (!OracleUdt.IsDBNull(con, pUdt, 0))
{
Value = (int?[])OracleUdt.GetValue(con, pUdt, 0);
}
}
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");
}
public void FromCustomObject(OracleConnection con, IntPtr pUdt)
{
OracleUdt.SetValue(con, pUdt, "ID", Id);
OracleUdt.SetValue(con, pUdt, "COUNT", Count);
OracleUdt.SetValue(con, pUdt, "HEIGHT", Height);
OracleUdt.SetValue(con, pUdt, "BARCODES", Barcodes);
}
protected void SetValue(string oracleColumnName, object value)
{
if (value != null)
{
OracleUdt.SetValue(this.connection, this.udtHandle, oracleColumnName, value);
}
}
protected void SetValue(int oracleColumnId, object value)
{
if (value != null)
{
OracleUdt.SetValue(this.connection, this.udtHandle, oracleColumnId, value);
}
}
public void FromCustomObject(OracleConnection con, IntPtr pUdt)
{
if (Value != null)
{
OracleUdt.SetValue(con, pUdt, 0, Value);
}
}
// 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);
}
protected void SetValue(int oracleColumn_Id, object value)
{
if (value != null)
{
OracleUdt.SetValue(connection, pUdt, oracleColumn_Id, value);
}
}
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 virtual void FromCustomObject(OracleConnection con, System.IntPtr pUdt)
{
if (this.Value != null)
{
OracleUdt.SetValue(con, pUdt, 0, this.Value);
}
}
protected void SetValue(string oracleColumnName, object value)
{
if (value != null)
{
OracleUdt.SetValue(connection, pUdt, oracleColumnName, value);
}
}
// 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");
}
// Implementation of IOracleCustomType.FromCustomObject()
public virtual void FromCustomObject(OracleConnection con, object pUdt)
{
// Convert from the Custom Type to Oracle Object
// Set the "NAME" attribute.
// By default the "NAME" attribute will be set to NULL.
if (m_name != null)
{
OracleUdt.SetValue(con, pUdt, "NAME", m_name);
// The "NAME" attribute can also be accessed by specifying index 0.
// OracleUdt.SetValue(con, pUdt, 0, m_name);
}
// Set the "ADDRESS" attribute.
// By default the "ADDRESS" attribute will be set to NULL.
if (!m_address.IsNull)
{
OracleUdt.SetValue(con, pUdt, "ADDRESS", m_address);
// The "ADDRESS" attribute can also be accessed by specifying index 1.
// OracleUdt.SetValue(con, pUdt, 1, m_address);
}
// Set the "AGE" attribute.
// By default the "AGE" attribute will be set to NULL.
if (m_age != null)
{
OracleUdt.SetValue(con, pUdt, "AGE", m_age);
// The "AGE attribute can also be accessed by specifying index 2.
// OracleUdt.SetValue(con, pUdt, 2, m_age);
}
}
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 FromCustomObject(OracleConnection con, IntPtr pUdt)
{
if (!_sdoGTypeIsNull)
{
OracleUdt.SetValue(con, pUdt, "SDO_GTYPE", SdoGType);
}
if (!SdoOrdinates.IsNull)
{
OracleUdt.SetValue(con, pUdt, "SDO_ORDINATES", SdoOrdinates);
}
if (!SdoElemInfo.IsNull)
{
OracleUdt.SetValue(con, pUdt, "SDO_ELEM_INFO", SdoElemInfo);
}
if (!_sdoSridIsNull)
{
OracleUdt.SetValue(con, pUdt, "SDO_SRID", SdoSrid);
}
else
{
OracleUdt.SetValue(con, pUdt, "SDO_SRID", DBNull.Value);
}
if (!SdoPoint.IsNull)
{
OracleUdt.SetValue(con, pUdt, "SDO_POINT", SdoPoint);
}
}
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 FromCustomObject(Oracle.DataAccess.Client.OracleConnection con, System.IntPtr pUdt)
{
OracleUdt.SetValue(con, pUdt, "VEHICLE_TEST_BOOKING_ID", VEHICLE_TEST_BOOKING_ID);
OracleUdt.SetValue(con, pUdt, "INSPECTION_EVIDENCE_TYPE_ID", INSPECTION_EVIDENCE_TYPE_ID);
OracleUdt.SetValue(con, pUdt, "MIME_TYPE", MIME_TYPE);
OracleUdt.SetValue(con, pUdt, "SITE_ID", SITE_ID);
}
public void SetValue(int oracleColumnId, object value)
{
if (value != null)
{
OracleUdt.SetValue(_connection, _pUdt, oracleColumnId, value);
}
}
public void SetValue(string oracleColumnName, object value)
{
if (value != null)
{
OracleUdt.SetValue(_connection, _pUdt, oracleColumnName, value);
}
}
public void ToCustomObject(OracleConnection con, IntPtr pUdt)
{
object objectStatusArray = null;
Array = (Int32[])OracleUdt.GetValue(con, pUdt, 0, out objectStatusArray);
m_statusArray = (OracleUdtStatus[])objectStatusArray;
}
public void FromCustomObject(OracleConnection con, object pUdt)
{
OracleUdt.SetValue(con, pUdt, 0, _gtype);
OracleUdt.SetValue(con, pUdt, 1, _srid);
OracleUdt.SetValue(con, pUdt, 2, _point);
OracleUdt.SetValue(con, pUdt, 3, _elementInfo);
OracleUdt.SetValue(con, pUdt, 4, _ordinates);
}
public void FromCustomObject(OracleConnection con, IntPtr pUdt)
{
OracleUdt.SetValue(con, pUdt, "ID", Id);
if (!string.IsNullOrEmpty(FullName))
{
OracleUdt.SetValue(con, pUdt, "FULL_NAME", FullName);
}
}
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")));
}
public override void FromCustomObject(OracleConnection con, IntPtr pUdt)
{
if (X.HasValue)
{
OracleUdt.SetValue(con, pUdt, 0, X);
}
OracleUdt.SetValue(con, pUdt, 1, Z);
}
public void ToCustomObject(global::Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt)
{
this.SdoGType = OracleUdt.IsDBNull(con, pUdt, "SDO_GTYPE") ? null : (int?)OracleUdt.GetValue(con, pUdt, "SDO_GTYPE");
this.SdoSRID = OracleUdt.IsDBNull(con, pUdt, "SDO_SRID") ? null : (int?)OracleUdt.GetValue(con, pUdt, "SDO_SRID");
this.SdoPoint = OracleUdt.IsDBNull(con, pUdt, "SDO_POINT") ? null : (SdoPointType)OracleUdt.GetValue(con, pUdt, "SDO_POINT");
this.SdoElemInfoArray = OracleUdt.IsDBNull(con, pUdt, "SDO_POINT") ? null : (int[])(OracleUdt.GetValue(con, pUdt, "SDO_ELEM_INFO"));
this.SdoOrdinateArray = OracleUdt.IsDBNull(con, pUdt, "SDO_ORDINATES") ? null : (double[])(OracleUdt.GetValue(con, pUdt, "SDO_ORDINATES"));
}
public void FromCustomObject(global::Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt)
{
if (!this.IsNull)
{
OracleUdt.SetValue(con, pUdt, "X", this.X);
OracleUdt.SetValue(con, pUdt, "Y", this.Y);
OracleUdt.SetValue(con, pUdt, "Z", this.Z);
}
}
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");
}
// 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 FromCustomObject(Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt)
{
OracleUdt.SetValue(con, pUdt, "VEHICLE_TEST_BOOKING_ID", VehicleTestBookingID);
OracleUdt.SetValue(con, pUdt, "TEST_TYPE_ID", TestTypeID);
OracleUdt.SetValue(con, pUdt, "TEST_QUESTIONS_ID", TestQuestionsID);
OracleUdt.SetValue(con, pUdt, "TEXT_ANSWER", TextAnswer);
OracleUdt.SetValue(con, pUdt, "TEST_QUESTIONS_ANSWERS_ID", TestQuestionsAnswersID);
OracleUdt.SetValue(con, pUdt, "TEST_QUESTIONS_ANSWERS_REL_ID", TestQuestionsAnswersIDRelID);
OracleUdt.SetValue(con, pUdt, "COMMENTS", Comments);
OracleUdt.SetValue(con, pUdt, "IS_PASSED", IsPassed);
}
