/// <summary>
/// Sets the date time offset.
/// </summary>
/// <param name="record">The record.</param>
/// <param name="fieldName">Name of the field.</param>
/// <param name="value">The value.</param>
public static void SetDateTimeOffset(this SqlDataRecord record, string fieldName, DateTimeOffset?value)
{
int ordinal = GetOrdinal(record, fieldName);
if (value.HasValue)
{
record.SetDateTimeOffset(ordinal, value.Value);
}
}
public override void Set(SqlDataRecord record, int ordinal, DateTimeOffset?value)
{
if (value.HasValue)
{
record.SetDateTimeOffset(ordinal, value.Value);
}
else
{
record.SetDBNull(ordinal);
}
}
internal override void SetDataRecordValue(SqlDataRecord record, int ordinal)
{
if (InputValue == null)
{
record.SetDBNull(ordinal);
}
else
{
record.SetDateTimeOffset(ordinal, InputValue.Value);
}
}
private static SqlDataRecord CreateVideoDataRecord(YoutubeVideo video)
{
int index = 0;
var dataRecord = new SqlDataRecord(VideoMetaData);
dataRecord.SetString(index++, video.ChannelId);
dataRecord.SetString(index++, video.Id);
dataRecord.SetString(index++, video.Title);
dataRecord.SetInt64(index++, video.Duration.Ticks);
dataRecord.SetDateTimeOffset(index++, video.PublishedAt);
dataRecord.SetString(index++, video.Thumbnail);
return(dataRecord);
}
public override void Set(SqlDataRecord record, int ordinal, DateTimeOffset?value)
{
EnsureArg.IsNotNull(record, nameof(record));
if (value.HasValue)
{
record.SetDateTimeOffset(ordinal, value.Value);
}
else
{
record.SetDBNull(ordinal);
}
}
public override void Set(SqlDataRecord record, int ordinal, DateTimeOffset value)
{
record.SetDateTimeOffset(ordinal, value);
}
public override void Set(SqlDataRecord record, int ordinal, DateTimeOffset value)
{
EnsureArg.IsNotNull(record, nameof(record));
record.SetDateTimeOffset(ordinal, value);
}
