コード例 #1
0
 /// <summary>
 /// Setup all the listeners for the database tables
 /// </summary>
 public static void SetupDatabaseListeners(OnChange_Player player, OnChange_ResourceOffers resourceOffer,
                                           OnChange_TradeOffers tradeOffer, OnChange_Chat chat)
 {
     DependencyInitialization();
     MonitorPlayers(player);
     MonitorResourceOffers(resourceOffer);
     MonitorTradeOffer(tradeOffer);
     MonitorChat(chat);
 }
コード例 #2
0
        /// <summary>
        /// Setup listener for the resource offer table
        /// </summary>
        /// <param name="resourceOfferMethode"></param>
        public static void MonitorResourceOffers(OnChange_ResourceOffers resourceOfferMethode)
        {
            try
            {
                string query = "SELECT Id, HighestBidder, Bid FROM dbo.Market";
                monitorConnection = new SqlConnection(connectionString);
                monitorConnection.Open();
                SqlCommand command = new SqlCommand(query, monitorConnection);
                command.Notification = null;

                SqlDependency dependency = new SqlDependency(command);
                dependency.OnChange += new OnChangeEventHandler(resourceOfferMethode);
                command.ExecuteNonQuery();
            }
#pragma warning disable CS0168 // Variable is declared but never used
            catch (SqlException ex)
#pragma warning restore CS0168 // Variable is declared but never used
            { }
        }