static bool CheevoAlreadyProposed(string user, int id)
{
bool ret = false;
string loadCheevos = "select ID from popped_cheevos where CheevoID = @id and User = @user and SecondMod is null";
bool dbOpened = false;
lock (Database.sqliteCon)
{
try
{
Database.sqliteCon.Open();
dbOpened = true;
using (SQLiteCommand selectCommand = new SQLiteCommand(loadCheevos, Database.sqliteCon))
{
selectCommand.Parameters.AddWithValue("@id", id);
selectCommand.Parameters.AddWithValue("@user", user);
using (SQLiteDataReader dataReader = selectCommand.ExecuteReader())
{
ret = dataReader.HasRows;
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message + " " + ex.StackTrace);
}
finally
{
if (dbOpened)
{
Database.sqliteCon.Close();
}
}
}
return ret;
}