public OracleTimestampWithLocalTimeZone(OracleTimeStampLTZ timeStamp)
{
_value = timeStamp;
if (!timeStamp.IsNull)
{
_dateTime = new OracleDateTime(timeStamp.Year, timeStamp.Month, timeStamp.Day, timeStamp.Hour, timeStamp.Minute, timeStamp.Second);
}
}
/// <summary>
///
/// </summary>
/// <param name="format"></param>
/// <param name="date"></param>
/// <param name="dateTime"></param>
/// <returns></returns>
protected internal bool ConvertToDateTimeFromOracleInternal(OracleDateTimeFormat format, object date, out DateTime dateTime)
{
dateTime = DateTime.MinValue;
if (date == null)
{
return(false);
}
try
{
switch (format)
{
case OracleDateTimeFormat.ORACLE_DATE:
var oracleDate = new OracleDate((string)date);
if (oracleDate != OracleDate.Null)
{
dateTime = oracleDate.Value;
}
break;
case OracleDateTimeFormat.ORACLE_TIMESTAMP:
var oracleTSDate = new OracleTimeStamp((string)date);
if (oracleTSDate != OracleTimeStamp.Null)
{
dateTime = oracleTSDate.Value;
}
break;
case OracleDateTimeFormat.ORACLE_TIMESTAMP_TZ:
var oracleTSZDate = new OracleTimeStampTZ((string)date);
if (oracleTSZDate != OracleTimeStampTZ.Null)
{
dateTime = oracleTSZDate.Value;
}
break;
case OracleDateTimeFormat.ORACLE_TIMESTAMP_LTZ:
var oracleLTSZDate = new OracleTimeStampLTZ((string)date);
if (oracleLTSZDate != OracleTimeStampLTZ.Null)
{
dateTime = oracleLTSZDate.Value;
}
break;
default:
throw new ApplicationException("Invalid format specified");
}
}
catch (Exception)
{
return(false);
}
return(true);
}
private void TableDependency_Changed(object sender, RecordChangedEventArgs <DataTimeModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
dateColumReturned = e.Entity.DateColum;
timeStampColumnReturned = new OracleTimeStamp(e.Entity.TimeStampColumn);
timeStampWithTimeZoneReturned = e.Entity.TimeStampWithTimeZone;
timeStampWithLocalTimeZoneReturned = new OracleTimeStampLTZ(e.Entity.TimeStampWithLocalTimeZone);
intervalDayToSecondColumnReturned = new OracleIntervalDS(e.Entity.IntervalDayToSecondColumn);
intervalYearToMonthColumnReturned = new OracleIntervalYM(e.Entity.IntervalYearToMonthColumn);
break;
}
}
public static void ClassInitialize(TestContext testContext)
{
OracleHelper.DropTable(ConnectionString, TableName);
using (var connection = new OracleConnection(ConnectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = $"CREATE TABLE {TableName}(DATECOLUM DATE,TIMESTAMPCOLUMN TIMESTAMP(6),TIMESTAMPWITHTIMEZONE TIMESTAMP WITH TIME ZONE,TIMESTAMPWITHLOCALTIMEZONE TIMESTAMP WITH LOCAL TIME ZONE, INTERVALDAYTOSECONDCOLUMN INTERVAL DAY(2) TO SECOND(6),INTERVALYEARTOMONTHCOLUMN INTERVAL YEAR(2) TO MONTH)";
command.ExecuteNonQuery();
}
}
dateColum = DateTime.Now;
timeStampColumn = new OracleTimeStamp(DateTime.Now);
timeStampWithLocalTimeZone = OracleTimeStampLTZ.GetSysDate();
timeStampWithTimeZone = DateTimeOffset.Now;
intervalDayToSecondColumn = new OracleIntervalDS(1);
intervalYearToMonthColumn = new OracleIntervalYM(2);
}
private object GetValue(OracleDecimal number, OracleDate date, OracleTimeStamp timestamp, OracleTimeStampTZ timestampWithTimezone, OracleTimeStampLTZ timestampWithLocalTimeZone, OracleIntervalYM yearToMonth, OracleIntervalDS dayToSecond)
{
if (!LimitValuesAvailable)
{
return(null);
}
if (_valueType == typeof(OracleDecimal))
{
return(number.IsNull ? null : new OracleNumber(number));
}
if (_valueType == typeof(OracleDate))
{
return(date.IsNull ? null : new OracleDateTime(date));
}
if (_valueType == typeof(OracleTimeStamp))
{
return(timestamp.IsNull ? null : new OracleTimestamp(timestamp));
}
if (_valueType == typeof(OracleTimeStampTZ))
{
return(timestampWithTimezone.IsNull ? null : new OracleTimestampWithTimeZone(timestampWithTimezone));
}
if (_valueType == typeof(OracleTimeStampLTZ))
{
return(timestampWithLocalTimeZone.IsNull ? null : new OracleTimestampWithLocalTimeZone(timestampWithLocalTimeZone));
}
if (_valueType == typeof(OracleIntervalYM))
{
return(yearToMonth.IsNull ? null : new OracleIntervalYearToMonth(yearToMonth));
}
if (_valueType == typeof(OracleIntervalDS))
{
return(dayToSecond.IsNull ? null : new OracleIntervalDayToSecond(dayToSecond));
}
return(null);
}
public OracleTimeStampLtzField(OracleTimeStampLTZ value)
{
_value = value;
}
internal static bool IsEqual(OracleTimeStampLTZ?val1, OracleTimeStampLTZ?val2) =>
val1.Value.IsNull != val2.Value.IsNull
? false
: (val1.Value.IsNull && val2.Value.IsNull) ||
OracleTimeStampLTZ.SetPrecision(val1.Value, OracleTimeStampPrecisionCompare).Equals(OracleTimeStampLTZ.SetPrecision(val2.Value, OracleTimeStampPrecisionCompare));
private object GetValue(OracleDecimal number, OracleDate date, OracleTimeStamp timestamp, OracleTimeStampTZ timestampWithTimezone, OracleTimeStampLTZ timestampWithLocalTimeZone, OracleIntervalYM yearToMonth, OracleIntervalDS dayToSecond)
{
if (!LimitValuesAvailable)
{
return null;
}
if (_valueType == typeof(OracleDecimal))
{
return number.IsNull ? null : new OracleNumber(number);
}
if (_valueType == typeof(OracleDate))
{
return date.IsNull ? null : new OracleDateTime(date);
}
if (_valueType == typeof(OracleTimeStamp))
{
return timestamp.IsNull ? null : new OracleTimestamp(timestamp);
}
if (_valueType == typeof(OracleTimeStampTZ))
{
return timestampWithTimezone.IsNull ? null : new OracleTimestampWithTimeZone(timestampWithTimezone);
}
if (_valueType == typeof(OracleTimeStampLTZ))
{
return timestampWithLocalTimeZone.IsNull ? null : new OracleTimestampWithLocalTimeZone(timestampWithLocalTimeZone);
}
if (_valueType == typeof(OracleIntervalYM))
{
return yearToMonth.IsNull ? null : new OracleIntervalYearToMonth(yearToMonth);
}
if (_valueType == typeof(OracleIntervalDS))
{
return dayToSecond.IsNull ? null : new OracleIntervalDayToSecond(dayToSecond);
}
return null;
}
