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;
}
