FreakOut.classes.DatabaseConnector.SetTGDBID C# (CSharp) Method

        public bool SetTGDBID(Game GameToUpdate)
        {
            if (GameToUpdate.scraper_gdb_id == 0 || GameToUpdate.ID == 0)
                return false;
            else
            {
                if (!connectionopen)
                {
                    DBConnector.Open();
                    connectionopen = true;
                }
                FbTransaction DBTransaction = DBConnector.BeginTransaction();
                FbCommand DBCommand = new FbCommand("UPDATE games SET TGDB_ID = '" + GameToUpdate.scraper_gdb_id + "' WHERE ID = " + GameToUpdate.ID, DBConnector, DBTransaction);
                DBCommand.ExecuteNonQuery();
                DBTransaction.Commit();
                DBConnector.Close();
                connectionopen = false;
                return true;
            }
        }