CheevoService.Database.CheevoAlreadyProposed C# (CSharp) 메소드

CheevoAlreadyProposed() 정적인 개인적인 메소드

static private CheevoAlreadyProposed ( string user, int id ) : bool
user string
id int
리턴 bool
        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;
        }