public void UpdateDate(int id, DateTimeOffset modifiedDate)
{
var q = "UPDATE `songs` SET `modified_date` = @date WHERE `song_id` = @id";
using (var cmd = Connection.CreateCommand())
{
cmd.CommandText = q;
cmd.Parameters.AddWithValue("@date", modifiedDate.ToUnixTimeSeconds());
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
}
}
public static void InitializeRandom(System.DateTimeOffset seedTime)
{
random = new System.Random((int)seedTime.ToUnixTimeSeconds());
}
private long EpochSeconds()
{
var _epoch = new System.DateTimeOffset(System.DateTime.UtcNow);
return(_epoch.ToUnixTimeSeconds());
}
private double ConvertGregorianToJulian(System.DateTimeOffset gregorianDate)
{
return(gregorianDate.ToUnixTimeSeconds() / secondsInDay - 0.5 + J1970);
}
