/// <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
}
