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); } }
public void updateRelevantSkills(bool correctAnswer) { int toAdd = 0; if (correctAnswer) { toAdd = 1; } else { toAdd = -1; } bool hasFirstSongsSkill = false, hasSecondSongsSkill = false, hasYearsSkill = false; string first_song_ID = this.Answer1_song_id; string second_song_ID = this.Answer2_song_id; string songYear = this.year; hasFirstSongsSkill = db.CheckSpecificSkill("songs_skills", first_song_ID, this.User_email); hasFirstSongsSkill = db.CheckSpecificSkill("songs_skills", second_song_ID, this.User_email); hasYearsSkill = db.CheckSpecificSkill("years_skills", songYear, this.User_email); if (hasFirstSongsSkill) { db.UpdateRate("user_songs_skills", this.User_email, "song_id", first_song_ID, toAdd); } else { db.InsertNewSkill("user_songs_skills", this.User_email, first_song_ID, toAdd); } if (hasSecondSongsSkill) { db.UpdateRate("user_songs_skills", this.User_email, "song_id", second_song_ID, toAdd); } else { db.InsertNewSkill("user_songs_skills", this.User_email, second_song_ID, toAdd); } if (hasYearsSkill) { db.UpdateRate("user_years_skills", this.User_email, "year", songYear, toAdd); } else { db.InsertNewSkill("user_years_skills", this.User_email, songYear.ToString(), toAdd); } }
/** * updates relevant skills in skills tables according to the answer and if user answered correctly. **/ public void updateRelevantSkills(bool correctAnswer) { int toAdd = 0; if (correctAnswer) { toAdd = 1; } else { toAdd = -1; } bool hasLocationsSkill = false, hasArtistsSkill = false; string artistID = answer_artist_id; string artist_location = FirstArtistLocation; hasArtistsSkill = db.CheckSpecificSkill("artists_skills", artistID, this.User_email); 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 (hasArtistsSkill) { db.UpdateRate("user_artists_skills", this.User_email, "artist_id", artistID, toAdd); } else { db.InsertNewSkill("user_artists_skills", this.User_email, artistID, toAdd); } }