/// <summary>
/// Add a song request to the queue. Automatically figures out of the user is already in the queue or not.
/// If the song request userID is > 0, matches based on registered user id.
/// If the song request userID is 0, matches based in registered user name.
/// If the song request uesrID is less than 0, matches based on temporary user name.
/// Automaticlaly creates the temporary user if needed.
/// </summary>
/// <param name="sr">The song request to add.</param>
/// <param name="queueIndex">The position to add the user in, if they don't already have song requests in the queue.</param>
/// <param name="DJKey">The DJ's assigned key.</param>
/// <returns>The outcome of the operation. If the operation is sucessful, the client ID number is returned in result and message.</returns>
public Response DJAddQueue(SongRequest sr, int queueIndex, long DJKey)
{
int DJID = -1;
int songID = -1;
int clientID = -1;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return r;
// Convert the DJKey to a DJID
r = DJKeyToID(DJKey, out DJID, db);
if (r.error)
return r;
// Make sure the DJ isn't logged out.
r = DJValidateStatus(DJID, "2", db);
if (r.error)
return r;
// Check to see if song exists.
r = db.SongExists(DJID, sr.songID);
if (r.error)
return r;
// Make sure the songExists method returned a song.
if (!int.TryParse(r.message.Trim(), out songID))
{
r.error = true;
r.message = "Could not find song";
return r;
}
if (sr.user.userID < -1)
sr.user.userID = -1;
// when userID == -1, we are dealing with creating an anonmymous user.
if (sr.user.userID == -1)
{
// See if this username exists.
r = db.DJValidateTempUserName(sr.user.userName, DJID);
if (r.error)
return r;
// In this case, the username does not exist.
if (r.message.Trim().Length == 0)
{
// Add the tempUser.
r = db.DJAddTempUser(sr.user.userName, DJID);
if (r.error)
return r;
// Get the tempUser's ID from the DB.
r = db.DJValidateTempUserName(sr.user.userName, DJID);
if (r.error)
return r;
// Parse the ID.
if (!int.TryParse(r.message.Trim(), out clientID))
{
r.error = true;
r.message = "Unable to get the clientID of the new user.";
return r;
}
}
// In this case, the username already exists.
else
{
// Get the tempUser's ID from the DB.
r = db.DJValidateTempUserName(sr.user.userName, DJID);
if (r.error)
return r;
// Parse the ID.
if (!int.TryParse(r.message.Trim(), out clientID))
{
r.error = true;
r.message = "Unable to get the clientID of the temp user.";
return r;
}
}
}
// When userID == 0, we look the user up by username instead of userID.
else if (sr.user.userID == 0)
{
r = db.MobileValidateUsername(sr.user.userName);
if (r.error)
return r;
if (!int.TryParse(r.message.Trim(), out clientID))
{
r.error = true;
r.message = "Client name could not be validated.";
return r;
}
}
// If a userID is passed in.
else
{
r = db.MobileValidateID(sr.user.userID);
if (r.error)
return r;
// See if an ID was returned.
if (r.message.Trim() == String.Empty)
{
string s = r.message.Trim();
r.error = true;
r.message = "Client ID could not be validated.";
return r;
}
clientID = sr.user.userID;
}
// Get the current song Requests
r = db.GetSongRequests(DJID);
if (r.error)
return r;
string requests = r.message;
string newRequests = string.Empty;
// If there were no requests, simply add the single request.
if (requests.Trim().Length == 0)
{
newRequests = clientID.ToString() + "~" + sr.songID.ToString();
//r = Common.PushMessageToMobile(sr.user.userID, "queue", db);
Common.PushMessageToUsersOfDJ(DJID, "queue", db);
r = db.SetSongRequests(DJID, newRequests);
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return r;
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == clientID)
{
// Loop through the songs to see if the user is already singing this song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
if (queue[i].songs[j].ID == sr.songID)
{
r.error = true;
r.message = "User is already singing that song";
return r;
}
}
// They dont' already have the song in the list, add them to the list
Song s = new Song();
s.ID = sr.songID;
queue[i].songs.Add(s);
Common.MinimalListToDB(queue, out newRequests);
r = db.SetSongRequests(DJID, newRequests);
if (r.error)
return r;
Common.PushMessageToMobile(clientID, "queue", db);
//Common.PushMessageToUsersOfDJ(DJID, "queue", db);
r.message = clientID.ToString();
r.result = clientID;
return r;
}
}
// Now they are not in the queue, add them at queueIndex.
queueSinger qs = new queueSinger();
qs.songs = new List<Song>();
qs.user = sr.user;
qs.user.userID = clientID;
Song song = new Song();
song.ID = sr.songID;
qs.songs.Add(song);
if (queueIndex < 0)
queueIndex = 0;
if (queueIndex > queue.Count)
queueIndex = queue.Count;
queue.Insert(queueIndex, qs);
Common.MinimalListToDB(queue, out newRequests);
r = db.SetSongRequests(DJID, newRequests);
if (r.error)
return r;
Common.PushMessageToUsersOfDJ(DJID, "queue", db);
r.message = clientID.ToString();
r.result = clientID;
return r;
}
}
/// <summary>
/// Rate a song.
/// </summary>
/// <param name="songID">The songID.</param>
/// <param name="rating">The rating -1 to 5.</param>
/// <param name="venueID">The venueID of the song.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileRateSong(int songID, int rating, int venueID, long userKey)
{
int mobileID = -1;
int venueStatus;
int songExists;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
Response r = new Response();
if (rating < -1 || rating > 5)
{
r.error = true;
r.message = "Rating must be between -1 and 5 (inclusive).";
return r;
}
// Try to establish a database connection
r = db.OpenConnection();
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the client isn't already logged out.
r = MobileCheckStatus(mobileID, "!0", db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the venueID exists.
r = db.DJGetStatus(venueID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out venueStatus))
{
r.error = true;
r.message= "MobileGetPlayLists venueID parse fail (Bad venueID given?)";
return r;
}
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.error = true;
r.message = "Could not find song";
return r;
}
// Set the song rating.
r = db.MobileSetSongRating(mobileID, songID, rating);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
return r;
}
}
/// <summary>
/// Changes a user's song request.
/// </summary>
/// <param name="newSR">The new song request to user.</param>
/// <param name="oldSR">The old song request to replace.</param>
/// <param name="DJKey">The DJ's assigned key.</param>
/// <returns>The outcome of the operation.</returns>
public Response DJChangeSongRequest(SongRequest newSR, SongRequest oldSR, long DJKey)
{
int DJID = -1;
int songID = -1;
bool songChangeMade = false;
bool requireSendToAll = false;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return r;
if (newSR.user.userID != oldSR.user.userID)
{
r.error = true;
r.message = "User must be the same between song requets";
return r;
}
// Convert the DJKey to a DJID
r = DJKeyToID(DJKey, out DJID, db);
if (r.error)
return r;
// Make sure the DJ isn't logged out.
r = DJValidateStatus(DJID, "2", db);
if (r.error)
return r;
// Check to see if song exists.
r = db.SongExists(DJID, newSR.songID);
if (r.error)
return r;
// Make sure a songID was sent back.
if (!int.TryParse(r.message.Trim(), out songID))
{
r.error = true;
r.message = "Could not find new song.";
return r;
}
// Make sure the mobile user is valid.
r = db.MobileValidateID(oldSR.user.userID);
if (r.error)
return r;
// See if an ID was returned.
if (r.message.Trim() == String.Empty)
{
string s = r.message.Trim();
r.error = true;
r.message = "Client ID could not be validated.";
return r;
}
// Get the current song Requests
r = db.GetSongRequests(DJID);
if (r.error)
return r;
string requests = r.message;
string newRequests = string.Empty;
// If there were no requests, simply add the single request.
if (requests.Trim().Length == 0)
{
r.error = true;
r.message = "There are no song requests";
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return r;
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == oldSR.user.userID)
{
// Loop through the songs to see if the user is already singing this song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
if (queue[i].songs[j].ID == newSR.songID)
{
r.error = true;
r.message = "User is already singing that song";
return r;
}
if (queue[i].songs[j].ID == oldSR.songID)
{
queue[i].songs[j].ID = newSR.songID;
songChangeMade = true;
if (j == 0)
requireSendToAll = true;
}
}
if (songChangeMade)
{
Common.MinimalListToDB(queue, out newRequests);
r = db.SetSongRequests(DJID, newRequests);
if (r.error)
return r;
if (requireSendToAll)
Common.PushMessageToUsersOfDJ(DJID, "queue", db);
else
Common.PushMessageToMobile(oldSR.user.userID, "queue", db);
return r;
}
// We didn't find the old song.
r.error = true;
r.message = "Could not find the old song.";
return r;
}
}
// We didn't find the user.
r.error = true;
r.message = "Could not find the user.";
return r;
}
}
/// <summary>
/// Add a song to a playlist.
/// </summary>
/// <param name="songID">The songID</param>
/// <param name="playListID">The PlaylistID</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileAddSongToPlaylist(int songID, int playListID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the client isn't already logged out.
r = MobileCheckStatus(mobileID, "!0", db);
if (r.error)
return r;
// Get the venue information from the playlist in DB.
r = db.MobileGetVenueFromPlaylist(playListID, mobileID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out venueID))
{
r.error = true;
r.message = "Could not figure out Venue from DB";
return r;
}
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.error = true;
r.message = "Could not find song in venue's library.";
return r;
}
// Object to represent the song to add.
Song song = new Song();
song.ID = songID;
// Get the current songs in the playlist.
List<Song> songs;
r = db.MobileGetSongsFromPlaylist(playListID, mobileID, out songs);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Check to see if the song already exists.
foreach (Song s in songs)
{
if (s.ID == song.ID)
{
r.error = true;
r.message = "You already have that song in this playlist";
return r;
}
}
// Otherwise, add this to the playlist.
songs.Add(song);
r = db.MobileSetPlaylistSongs(playListID, mobileID, songs);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
return r;
}
}
/// <summary>
/// Move a user's song to the front of his/her songs.
/// </summary>
/// <param name="songID">The ID of the song.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileMoveSongRequestToTop(int songID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the client isn't already logged out.
r = MobileCheckStatus(mobileID, "!0", db);
if (r.error)
return r;
// Get the venueID
r = MobileGetVenue(mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
venueID = r.result;
// Make sure the venue is accepting songs.
r = VenueCheckStatus(venueID, "2", db);
if (r.error)
return r;
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.error = true;
r.message = "Could not find song in venue library.";
return r;
}
// Get the current song Requests
r = db.GetSongRequests(venueID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
string requests = r.message;
string newRequests = string.Empty;
// If there are no song requests.
if (requests.Trim().Length == 0)
{
r.error = true;
r.message = "There are no song requests.";
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == mobileID)
{
// Loop through the songs to find the song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
// Remove this song, and add them to the front of the queue.
if (queue[i].songs[j].ID == songID)
{
Song s = queue[i].songs[j];
queue[i].songs.RemoveAt(j);
queue[i].songs.Insert(0, s);
r = Common.MinimalListToDB(queue, out newRequests);
if(r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
r = db.SetSongRequests(venueID, newRequests);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
Common.PushMessageToUsersOfDJ(venueID, "queue", db);
return r;
}
}
}
}
// If we couldn't find the user.
r.error = true;
r.message = "Could not find that song in your queue.";
return r;
}
}
/// <summary>
/// Changes a user's song request to a new song.
/// </summary>
/// <param name="oldSongID">The old request.</param>
/// <param name="newSongID">The new request.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileChangeSongRequest(int oldSongID, int newSongID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
bool songChangeMade = false;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the client isn't already logged out.
r = MobileCheckStatus(mobileID, "!0", db);
if (r.error)
return r;
// Get the venueID
r = MobileGetVenue(mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
venueID = r.result;
// Make sure the venue is accepting songs.
r = VenueCheckStatus(venueID, "2", db);
if (r.error)
return r;
// Check to see if song exists.
r = db.SongExists(venueID, newSongID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.error = true;
r.message = "Could not find new song";
return r;
}
// Get the current song Requests
r = db.GetSongRequests(venueID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
string requests = r.message;
string newRequests = string.Empty;
// If there are no song requests.
if (requests.Trim().Length == 0)
{
r.error = true;
r.message = "There are no song requests.";
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == mobileID)
{
// Loop through the songs to find the old song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
// If we find the new song, we don't want to allow duplicates
if (queue[i].songs[j].ID == newSongID)
{
r.error = true;
r.message = "You are already singing the new song";
return r;
}
// If we found the old song.
if (queue[i].songs[j].ID == oldSongID)
{
queue[i].songs[j].ID = newSongID;
songChangeMade = true;
}
}
if (songChangeMade)
{
Common.MinimalListToDB(queue, out newRequests);
r = db.SetSongRequests(venueID, newRequests);
if(r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
Common.PushMessageToUsersOfDJ(venueID, "queue", db);
return r;
}
// If we couldn't find the old song, inform user.
r.error = true;
r.message = "Could not find the old song";
return r;
}
}
// If we couldn't find the user.
r.error = true;
r.message = "You have no song reqeusts.";
return r;
}
}
/// <summary>
/// View a song rating.
/// </summary>
/// <param name="songID">The songID.</param>
/// <param name="venueID">The venueID.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileViewSongRating(int songID, int venueID, long userKey)
{
int mobileID = -1;
int venueStatus;
int songExists;
int rating;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the client isn't already logged out.
r = MobileCheckStatus(mobileID, "!0", db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the venueID exists.
r = db.DJGetStatus(venueID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out venueStatus))
{
r.error = true;
r.message = "MobileGetPlayLists venueID parse fail (Bad venueID given?)";
return r;
}
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.error = true;
r.message = "Could not find song";
return r;
}
// Set the song rating.
r = db.MobileGetSongRating(mobileID, songID);
if(r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (r.message.Trim().Length == 0)
{
r.message = "-1";
r.result = -1;
return r;
}
if (!int.TryParse(r.message.Trim(), out rating))
{
r.error = true;
r.message = "Could not parse rating";
return r;
}
r.message = rating.ToString();
r.result = rating;
return r;
}
}
/// <summary>
/// Create a song request.
/// </summary>
/// <param name="songID">The songID</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileSongRequest(int songID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
Response r = db.OpenConnection();
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Make sure the client isn't already logged out.
r = MobileCheckStatus(mobileID, "!0", db);
if (r.error)
return r;
// Get the venueID
r = MobileGetVenue(mobileID, db);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
venueID = r.result;
// Make sure the venue is accepting songs.
r = VenueCheckStatus(venueID, "2", db);
if (r.error)
return r;
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.error = true;
r.message = "Could not find song";
return r;
}
// Get the current song Requests
r = db.GetSongRequests(venueID);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
string requests = r.message;
string newRequests = string.Empty;
if (requests.Trim().Length == 0)
{
requests = mobileID.ToString() + "~" + songID.ToString();
r = db.SetSongRequests(venueID, requests);
if (r.error)
return r;
r = Common.PushMessageToMobile(mobileID, "queue", db);
if (r.error)
Common.LogError(r.message, Environment.StackTrace, null, 0);
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == mobileID)
{
// Loop through the songs to see if the user is already singing this song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
if (queue[i].songs[j].ID == songID)
{
r.error = true;
r.message = "You are already in queue to sing that song";
return r;
}
}
// They dont' already have the song in the list, add them to the list
Song s = new Song();
s.ID = songID;
queue[i].songs.Add(s);
Common.MinimalListToDB(queue, out newRequests);
r = db.SetSongRequests(venueID, newRequests);
if(r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
Common.PushMessageToUsersOfDJ(venueID, "queue", db);
return r;
}
}
queueSinger qs = new queueSinger();
qs.songs = new List<Song>();
User u = new User();
u.userID = mobileID;
qs.user = u;
Song song = new Song();
song.ID = songID;
qs.songs.Add(song);
queue.Add(qs);
Common.MinimalListToDB(queue, out newRequests);
r = db.SetSongRequests(venueID, newRequests);
if(r.error)
return (Response)Common.LogError(r.message, Environment.StackTrace, r, 0);
Common.PushMessageToUsersOfDJ(venueID, "queue", db);
return r;
}
}
/// <summary>
/// Move a user's song to the front of his/her songs.
/// </summary>
/// <param name="songID">The ID of the song.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileMoveSongRequestToTop(int songID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
ExpResponse r = db.OpenConnection();
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Make sure the client isn't already logged out.
bool validStatus;
r = MobileCheckStatus(mobileID, "!0", db, out validStatus);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!validStatus)
{
r.setErMsg(true, Messages.ERR_STATUS_IS_NOT_IN);
return r;
}
// Get the venueID
r = MobileGetVenue(mobileID, db);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
venueID = r.result;
if (venueID == -1)
{
r.setErMsg(true, Messages.MSG_NO_VENUE_ASSOCIATED);
return r;
}
// Make sure the venue is accepting songs.
r = VenueCheckStatus(venueID, "2", db, out validStatus);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!validStatus)
{
r.setErMsg(true, Messages.ERR_VENUE_NO_SESSION);
return r;
}
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.setErMsg(true, Messages.MSG_SONG_NOT_FOUND);
return r;
}
// Get the current song Requests
r = db.GetSongRequests(venueID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
string requests = r.message;
string newRequests = string.Empty;
// If there are no song requests.
if (requests.Trim().Length == 0)
{
r.setErMsg(true, Messages.MSG_NO_SONG_REQUESTS);
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == mobileID)
{
// Loop through the songs to find the song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
// Remove this song, and add them to the front of the queue.
if (queue[i].songs[j].ID == songID)
{
Song s = queue[i].songs[j];
queue[i].songs.RemoveAt(j);
queue[i].songs.Insert(0, s);
r = Common.MinimalListToDB(queue, out newRequests);
if(r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
r = db.SetSongRequests(venueID, newRequests);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
Common.PushMessageToUsersOfDJ(venueID, "queue", db);
return r;
}
}
}
}
// If we couldn't find the user.
r.setErMsg(true, Messages.MSG_SONG_NOT_FOUND);
return r;
}
}
/// <summary>
/// Add a song to a playlist.
/// </summary>
/// <param name="songID">The songID</param>
/// <param name="playListID">The PlaylistID</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileAddSongToPlaylist(int songID, int playListID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
ExpResponse r = db.OpenConnection();
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Make sure the client isn't already logged out.
bool validStatus;
r = MobileCheckStatus(mobileID, "!0", db, out validStatus);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!validStatus)
{
r.setErMsg(true, Messages.ERR_STATUS_IS_NOT_IN);
return r;
}
// Get the venue information from the playlist in DB.
r = db.MobileGetVenueFromPlaylist(playListID, mobileID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!int.TryParse(r.message.Trim(), out venueID))
{
r.setErMsgStk(true, "Could not figure out Venue from DB", Environment.StackTrace);
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
}
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.setErMsg(true, Messages.MSG_SONG_NOT_FOUND);
return r;
}
// Object to represent the song to add.
Song song = new Song();
song.ID = songID;
// Get the current songs in the playlist.
List<Song> songs;
r = db.MobileGetSongsFromPlaylist(playListID, mobileID, out songs);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Check to see if the song already exists.
foreach (Song s in songs)
{
if (s.ID == song.ID)
{
r.setErMsg(true, Messages.ERR_PLYLST_DUP_SONG);
return r;
}
}
// Otherwise, add this to the playlist.
songs.Add(song);
r = db.MobileSetPlaylistSongs(playListID, mobileID, songs);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
return r;
}
}
/// <summary>
/// View a song rating.
/// </summary>
/// <param name="songID">The songID.</param>
/// <param name="venueID">The venueID.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileViewSongRating(int songID, int venueID, long userKey)
{
int mobileID = -1;
int venueStatus;
int songExists;
int rating;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
ExpResponse r = db.OpenConnection();
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Make sure the client isn't already logged out.
bool validStatus;
r = MobileCheckStatus(mobileID, "!0", db, out validStatus);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!validStatus)
{
r.setErMsg(true, Messages.ERR_STATUS_IS_NOT_IN);
return r;
}
// Make sure the venueID exists.
r = db.DJGetStatus(venueID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!int.TryParse(r.message.Trim(), out venueStatus))
{
r.setErMsgStk(true, "MobileGetPlayLists venueID parse fail (Bad venueID given?)", Environment.StackTrace);
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
}
// Check to see if song exists.
r = db.SongExists(venueID, songID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.setErMsgStk(true, "Could not find song", Environment.StackTrace);
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
}
// Set the song rating.
r = db.MobileGetSongRating(mobileID, songID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (r.message.Trim().Length == 0)
{
r.setErMsgRes(false, "-1", -1);
return r;
}
if (!int.TryParse(r.message.Trim(), out rating))
{
r.setErMsgStk(true, "Could not parse song rating song", Environment.StackTrace);
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
}
r.setErMsgRes(false, rating.ToString(), rating);
return r;
}
}
/// <summary>
/// Changes a user's song request to a new song.
/// </summary>
/// <param name="oldSongID">The old request.</param>
/// <param name="newSongID">The new request.</param>
/// <param name="userKey">client mobile key.</param>
/// <returns>The outcome of the opearation.</returns>
public Response MobileChangeSongRequest(int oldSongID, int newSongID, long userKey)
{
int venueID = -1;
int songExists;
int mobileID;
bool songChangeMade = false;
bool requireSendToAll = false;
using (DatabaseConnectivity db = new DatabaseConnectivity())
{
// Try to establish a database connection
ExpResponse r = db.OpenConnection();
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Convert the userKey to MobileID
r = MobileKeyToID(userKey, out mobileID, db);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Make sure the client isn't already logged out.
bool validStatus;
r = MobileCheckStatus(mobileID, "!0", db, out validStatus);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!validStatus)
{
r.setErMsg(true, Messages.ERR_STATUS_IS_NOT_IN);
return r;
}
// Get the venueID
r = MobileGetVenue(mobileID, db);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
venueID = r.result;
if (venueID == -1)
{
r.setErMsg(true, Messages.MSG_NO_VENUE_ASSOCIATED);
return r;
}
// Make sure the venue is accepting songs.
r = VenueCheckStatus(venueID, "2", db, out validStatus);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!validStatus)
{
r.setErMsg(true, Messages.ERR_VENUE_NO_SESSION);
return r;
}
// Check to see if song exists.
r = db.SongExists(venueID, newSongID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (!int.TryParse(r.message.Trim(), out songExists))
{
r.setErMsg(true, "Could not find new song");
return r;
}
// Get the current song Requests
r = db.GetSongRequests(venueID);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
string requests = r.message;
string newRequests = string.Empty;
// If there are no song requests.
if (requests.Trim().Length == 0)
{
r.setErMsg(true, "There are no song requests.");
return r;
}
// Since there is a list of requests, call to parse the raw string data into an list of queuesingers.
List<queueSinger> queue;
r = Common.DBToMinimalList(requests, out queue);
if (r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
// Search to see if the user is already in this list of singers.
for (int i = 0; i < queue.Count; i++)
{
// We found the userID already in here.
if (queue[i].user.userID == mobileID)
{
// Loop through the songs to find the old song.
for (int j = 0; j < queue[i].songs.Count; j++)
{
// If we find the new song, we don't want to allow duplicates
if (queue[i].songs[j].ID == newSongID)
{
r.setErMsg(true, "You are already singing the new song");
return r;
}
// If we found the old song.
if (queue[i].songs[j].ID == oldSongID)
{
queue[i].songs[j].ID = newSongID;
songChangeMade = true;
if (j == 0)
requireSendToAll = true;
}
}
if (songChangeMade)
{
r = Common.MinimalListToDB(queue, out newRequests);
if(r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
r = db.SetSongRequests(venueID, newRequests);
if(r.error)
return Common.LogErrorRetNewMsg(r, Messages.ERR_SERVER, Common.LogFile.Mobile);
if (requireSendToAll)
Common.PushMessageToUsersOfDJ(venueID, "queue", db);
else
Common.PushMessageToMobile(mobileID, "queue", db);
return r;
}
// If we couldn't find the old song, inform user.
r.setErMsg(true, Messages.MSG_SONG_NOT_FOUND);
return r;
}
}
// If we couldn't find the user.
r.setErMsg(true, Messages.MSG_USER_NO_SONG_REQUESTS);
return r;
}
}