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); } }