Method | Description | |
---|---|---|
Authenticate ( |
Attemts to register a new user or authenticate an existing user with the given credentials
|
|
Database ( string connString ) : System |
Loads a database from the given connection string
|
|
Database ( string hostID, int port, string databaseName, string userID, string password ) : System |
Loads a database from the given connection string
|
|
GetID ( |
Searches the database for a song that matches the given song. If there is a match, returns the ID. If not, returns -1
|
|
GetID ( string username ) : int |
Returns id of an item from the users table
|
|
GetNextAvailableID ( string table ) : int |
Gets the next available ID for the server
|
|
GetSong ( int id ) : |
Returns the song with the given ID
|
|
GetSongList ( int numSongs, string genre, string username ) : List |
Gets a list of songs that match the given SongParameters object
|
|
GetUsername ( int id ) : string |
Returns the username of a user with the given ID
|
|
RefreshSong ( |
Returns the given song with updated ID, score and user data. Does not add the song to the database if it isn't already there.
|
|
RefreshToken ( string username ) : bool |
Refreshes the user token of a user, effectively forcing them to login again.
|
|
SQLNonQuery ( |
Performs an SQL NonQuery to the database
|
|
SongExists ( int id ) : bool |
Checks to see if a song with the given ID exists in the database.
|
|
TestConnection ( ) : int |
Tests the connection to the database
|
|
VerifyToken ( |
Verifies a user token
|
|
VoteOnSong ( |
Checks to see if a song is in the database already. If it isn't, the song is added to the database with a single vote. If it is, add the vote to that song.
|
|
addVoteToUserTable ( int userID, int songID, bool vote ) : void | ||
changePassword ( int userID, string hash ) : void | ||
changeVoteScore ( int songID, int newScore ) : void | ||
checkAndChangeVote ( int userID, int songID, bool vote ) : int | ||
createUser ( string username, string hash ) : bool | ||
createUserTable ( int userID ) : void | ||
deleteSong ( int songID ) : void | ||
deleteUser ( int userID ) : void | ||
getUserHash ( int userID ) : string | ||
getUserToken ( int userID ) : |
||
insertData ( |
||
returnItem ( int id, string col, string table ) : object | ||
storeUserToken ( int userID, System.DateTime expires, string token ) : void | ||
updateScore ( int id, int voteAmount ) : void |