public void CompareToNullableDateTimeOffsetToOffsetTest()
{
DateTimeOffset?nullableDateTimeOffset = NullableDateTimeOffset;
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset != NullableDateTimeOffset.ToOffset(FirstOffset)); // works fine
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset != nullableDateTimeOffset.Value.ToOffset(FirstOffset)); // failed
});
}
public void CompareToDateTimeTest()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset > FirstDateTimeOffset.ToLocalTime().AddHours(-1));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset > FirstMillisecondDateTimeOffset.ToUniversalTime().AddMilliseconds(-1));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset > NullableDateTimeOffset.ToLocalTime().Date);
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset < FirstDateTimeOffset.ToLocalTime().AddHours(1));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset < FirstMillisecondDateTimeOffset.ToUniversalTime().AddMilliseconds(1));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset < NullableDateTimeOffset.ToUniversalTime().AddYears(1));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset > FirstDateTimeOffset.ToLocalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset < FirstMillisecondDateTimeOffset.ToLocalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset > NullableDateTimeOffset.AddDays(1).ToUniversalTime());
});
}
public void CompareTest()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset > FirstDateTimeOffset.AddHours(-1));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset > FirstMillisecondDateTimeOffset.AddMilliseconds(-1));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset > NullableDateTimeOffset.AddYears(-1));
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset < FirstDateTimeOffset.AddHours(1));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset < FirstMillisecondDateTimeOffset.AddMilliseconds(1));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset < NullableDateTimeOffset.AddYears(1));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset > FirstDateTimeOffset);
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset < FirstMillisecondDateTimeOffset);
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset > NullableDateTimeOffset.AddSeconds(11));
});
}
public void EqualsToDateTimeOffsetWithAnotherOffset()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == FirstDateTimeOffset.ToOffset(FirstOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == FirstDateTimeOffset.ToOffset(SecondOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == FirstDateTimeOffset.ToOffset(TimeSpan.Zero));
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == FirstDateTimeOffset.ToLocalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == FirstDateTimeOffset.ToUniversalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == FirstMillisecondDateTimeOffset.ToOffset(FirstOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == FirstMillisecondDateTimeOffset.ToOffset(SecondOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == FirstMillisecondDateTimeOffset.ToOffset(TimeSpan.Zero));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == FirstMillisecondDateTimeOffset.ToLocalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == FirstMillisecondDateTimeOffset.ToUniversalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == NullableDateTimeOffset.ToOffset(FirstOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == NullableDateTimeOffset.ToOffset(SecondOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == NullableDateTimeOffset.ToOffset(TimeSpan.Zero));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == NullableDateTimeOffset.ToLocalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == NullableDateTimeOffset.ToUniversalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == WrongDateTimeOffset.ToOffset(FirstOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == WrongDateTimeOffset.ToOffset(SecondOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == WrongDateTimeOffset.ToOffset(TimeSpan.Zero));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == WrongDateTimeOffset.ToLocalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset == WrongDateTimeOffset.ToUniversalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == WrongMillisecondDateTimeOffset.ToOffset(FirstOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == WrongMillisecondDateTimeOffset.ToOffset(SecondOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == WrongMillisecondDateTimeOffset.ToOffset(TimeSpan.Zero));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == WrongMillisecondDateTimeOffset.ToLocalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset == WrongMillisecondDateTimeOffset.ToUniversalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == WrongDateTimeOffset.ToOffset(FirstOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == WrongDateTimeOffset.ToOffset(SecondOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == WrongDateTimeOffset.ToOffset(TimeSpan.Zero));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == WrongDateTimeOffset.ToLocalTime());
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset == WrongDateTimeOffset.ToUniversalTime());
});
}
public void AddSecondsTest()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.AddSeconds(1) == FirstDateTimeOffset.AddSeconds(1));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.AddSeconds(-2) == FirstMillisecondDateTimeOffset.AddSeconds(-2));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.AddSeconds(33) == NullableDateTimeOffset.AddSeconds(33));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.AddSeconds(1) == FirstDateTimeOffset.AddSeconds(2));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.AddSeconds(-1) == FirstMillisecondDateTimeOffset.AddSeconds(-2));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.AddSeconds(33) == NullableDateTimeOffset.AddSeconds(44));
});
}
public void ToUniversalTime()
{
Require.ProviderIsNot(StorageProvider.PostgreSql, "ToUniversalTime is not supported");
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.ToUniversalTime() == FirstDateTimeOffset.ToUniversalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.ToUniversalTime() == FirstMillisecondDateTimeOffset.ToUniversalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.ToUniversalTime() == NullableDateTimeOffset.ToUniversalTime());
});
}
public void SubstractDateTimeOffsetAndIntervalUsageTest()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.Subtract(SecondDateTimeOffset).TotalMilliseconds == FirstDateTimeOffset.Subtract(SecondDateTimeOffset).TotalMilliseconds);
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.Subtract(FirstDateTimeOffset).TotalMilliseconds == FirstMillisecondDateTimeOffset.Subtract(FirstDateTimeOffset).TotalMilliseconds);
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.Subtract(SecondDateTimeOffset).TotalMilliseconds == NullableDateTimeOffset.Subtract(SecondDateTimeOffset).TotalMilliseconds);
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.Subtract(SecondDateTimeOffset).TotalMilliseconds == FirstDateTimeOffset.Subtract(WrongDateTimeOffset).TotalMilliseconds);
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.Subtract(SecondDateTimeOffset).TotalMilliseconds == FirstMillisecondDateTimeOffset.Subtract(WrongDateTimeOffset).TotalMilliseconds);
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.Subtract(SecondDateTimeOffset).TotalMilliseconds == NullableDateTimeOffset.Subtract(WrongDateTimeOffset).TotalMilliseconds);
});
}
public void SubtractDateTimeTest()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.Subtract(SecondDateTime) == FirstDateTimeOffset.Subtract(SecondDateTime));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.Subtract(SecondDateTime) == FirstMillisecondDateTimeOffset.Subtract(SecondDateTime));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.Subtract(SecondDateTime) == NullableDateTimeOffset.Subtract(SecondDateTime));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.Subtract(SecondDateTime) == FirstDateTimeOffset.Subtract(WrongDateTime));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.Subtract(SecondDateTime) == FirstMillisecondDateTimeOffset.Subtract(WrongDateTime));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.Subtract(SecondDateTime) == NullableDateTimeOffset.Subtract(WrongDateTime));
});
}
public void AddTimeSpanTest()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.Add(FirstOffset) == FirstDateTimeOffset.Add(FirstOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.Add(SecondOffset) == FirstMillisecondDateTimeOffset.Add(SecondOffset));
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.Add(FirstOffset) == NullableDateTimeOffset.Add(FirstOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.Add(FirstOffset) == FirstDateTimeOffset.Add(WrongOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.Add(SecondOffset) == FirstMillisecondDateTimeOffset.Add(WrongOffset));
RunWrongTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.Add(FirstOffset) == NullableDateTimeOffset.Add(WrongOffset));
});
}
public void ToUniversalTime()
{
ExecuteInsideSession(() => {
RunTest <SingleDateTimeOffsetEntity>(c => c.DateTimeOffset.ToUniversalTime() == FirstDateTimeOffset.ToUniversalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.MillisecondDateTimeOffset.ToUniversalTime() == FirstMillisecondDateTimeOffset.ToUniversalTime());
RunTest <SingleDateTimeOffsetEntity>(c => c.NullableDateTimeOffset.Value.ToUniversalTime() == NullableDateTimeOffset.ToUniversalTime());
});
}
