public void updateRelevantSkills(bool correctAnswer)
{
int toAdd = 0;
if (correctAnswer)
{
toAdd = 1;
}
else
{
toAdd = -1;
}
bool hasLocationsSkill = false, hasSongsSkill = false, hasArtistsSkill = false, hasYearsSkill = false;
string songID = songForQuiestion.Song_id;
string artistID = songForQuiestion.Artist_id;
int songYear = songForQuiestion.Year;
string artist_location = db.GetArtistLocation(artistID);
hasSongsSkill = db.CheckSpecificSkill("songs_skills", songID, this.User_email);
hasArtistsSkill = db.CheckSpecificSkill("artists_skills", artistID, this.User_email);
hasYearsSkill = db.CheckSpecificSkill("years_skills", songYear.ToString(), this.User_email);
if (artist_location != null)
{
hasLocationsSkill = db.CheckSpecificSkill("locations_skills", artist_location, this.User_email);
if (hasLocationsSkill)
{
db.UpdateRate("user_locations_skills", this.User_email, "artist_location", artist_location, toAdd);
}
else
{
db.InsertNewSkill("user_locations_skills", this.User_email, artist_location, toAdd);
}
}
if (hasSongsSkill)
{
db.UpdateRate("user_songs_skills", this.User_email, "song_id", songID, toAdd);
}
else
{
db.InsertNewSkill("user_songs_skills", this.User_email, songID, toAdd);
}
if (hasArtistsSkill)
{
db.UpdateRate("user_artists_skills", this.User_email, "artist_id", artistID, toAdd);
}
else
{
db.InsertNewSkill("user_artists_skills", this.User_email, artistID, toAdd);
}
if (hasYearsSkill)
{
db.UpdateRate("user_years_skills", this.User_email, "year", songYear.ToString(), toAdd);
}
else
{
db.InsertNewSkill("user_years_skills", this.User_email, songYear.ToString(), toAdd);
}
}
