/// <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); }
/// <summary> /// Setup listener for the chat table /// </summary> /// <param name="chatMethode"></param> public static void MonitorChat(OnChange_Chat chatMethode) { try { string query = "SELECT Id FROM dbo.Chat"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(query, connection)) { SqlDependency dependency = new SqlDependency(command); dependency.OnChange += new OnChangeEventHandler(chatMethode); 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 }