/// <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 trade offer
/// </summary>
/// <param name="tradeOfferMethode">Event methode to be run when event fires</param>
public static void MonitorTradeOffer(OnChange_TradeOffers tradeOfferMethode)
{
try
{
string query = "SELECT Id FROM dbo.TradeOffers;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(tradeOfferMethode);
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
{ }
}
