/// <summary>
/// Method to view the sql generated for an achievement. Unlikely to be used other than for debugign.
/// </summary>
/// <param name="DJKey">The DJKey for the venue.</param>
/// <param name="achievementID">The ID of the achievement.</param>
/// <returns>The outcome of the operation.</returns>
public Response ViewAchievementSql(long DJKey, int achievementID)
{
int DJID = -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;
List<Achievement> achievements;
r = db.DJViewAchievements(DJID, out achievements);
if (r.error)
return r;
foreach (Achievement a in achievements)
{
if (a.ID == achievementID)
{
string sql;
List<SqlCommand> sqlCommands;
r = AchievementParser.CreateAchievementSQL(a, DJID, out sql, out sqlCommands);
if (r.error)
return r;
r.message = sql;
r.error = false;
return r;
}
}
r.error = true;
r.message = "Achievement not found";
return r;
}
}
/// <summary>
/// View all the achievements belonging to the DJ.
/// </summary>
/// <param name="DJKey">The DJKey for the venue.</param>
/// <param name="achievements">Out list of achievements.</param>
/// <returns>The outcome of the operation.</returns>
public Response DJViewAchievements(long DJKey, out List<Achievement> achievements)
{
int DJID = -1;
achievements = new List<Achievement>();
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;
r = db.DJViewAchievements(DJID, out achievements);
if (r.error)
return r;
return r;
}
}