public Beatmap GetBeatmap(int mapId) { //mapId should be >0 string sql = "SELECT * FROM `withID` WHERE MapId = " + mapId; var reader = Query(sql); var beatmap = new Beatmap(); if (reader.Read()) { beatmap.Read(reader); } else { reader.Dispose(); sql = "SELECT * FROM `Temp` WHERE MapId = " + mapId; reader = Query(sql); beatmap = new Beatmap(); if (reader.Read()) { beatmap.Read(reader); } reader.Dispose(); } return beatmap; }
private Beatmap GetBeatmapUsingReplacements(string table, bool useRaw, Dictionary<string, string> replacements) { var retBeatmap = new Beatmap(); bool foundData = false; if (useRaw) { string sql = string.Format("SELECT * FROM `{0}` WHERE (Raw LIKE @Raw)", table); if (replacements["@diff"] != string.Empty) { sql += " AND DiffName LIKE @diff"; } var reader = Query(sql, replacements); if (reader.Read()) { retBeatmap.Read(reader); foundData = true; } } else { var sql = string.Format("SELECT * FROM `{0}` WHERE (TitleRoman LIKE @title OR TitleUnicode LIKE @title) AND (ArtistRoman LIKE @artist OR ArtistUnicode LIKE @artist)", table); if (replacements["@diff"] != string.Empty) { sql += " AND DiffName LIKE @diff"; } var reader = Query(sql, replacements); if (reader.Read()) { retBeatmap.Read(reader); foundData = true; } } return foundData ? retBeatmap : null; }