public static async Task <DateTime> GetServerTime(bool localTime = true)
{
JSONNode response = await APIRequest("time/", new string[] { });
if (localTime)
{
return(DateTimeOffset.FromUnixTimeSeconds(response["timestamp"].AsLong).ToLocalTime().DateTime);
}
else
{
return(DateTimeOffset.FromUnixTimeSeconds(response["timestamp"].AsLong).DateTime);
}
}
public UserData(JSONNode JSONData)
{
Id = JSONData["id"];
AvatarURL = JSONData["avatar_url"];
UserName = JSONData["username"];
DisplayName = JSONData["developer_name"];
Description = JSONData["developer_description"];
Website = JSONData["developer_website"];
SignedUp = JSONData["signed_up"];
SignedUpTime = DateTimeOffset.FromUnixTimeSeconds(JSONData["signed_up_timestamp"].AsLong).DateTime;
LastLoggedIn = JSONData["last_logged_in"];
LastLoggedInTime = DateTimeOffset.FromUnixTimeSeconds(JSONData["last_logged_in_timestamp"].AsLong).DateTime;
Status = JSONData["status"];
}
public Handled IsAlreadyHandled(int id, DateTimeOffset modifiedDate)
{
var q = @"SELECT * FROM `songs` WHERE `song_id` = @id";
using (var cmd = Connection.CreateCommand())
{
cmd.CommandText = q;
cmd.Parameters.AddWithValue("@id", id);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var entryModifiedDate = DateTimeOffset.FromUnixTimeSeconds(reader.GetInt32(reader.GetOrdinal("modified_date")));
return(modifiedDate > entryModifiedDate ? Handled.OUTDATED : Handled.HANDLED);
}
}
return(Handled.NOT_HANDLED);
}
}
