private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
        {
            if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Insert)
            {
                List<DiscussMessageModel> lsDiscussMessage = GetDiscussMessages();
                LotteryResultHub hub = new LotteryResultHub();
                foreach (DiscussMessageModel model in lsDiscussMessage)
                {
                    if (model.Status.Equals("A")){
                        hub.SendDiscussMessage(model.Username, model.FilePath, model.Message);
                    }
                }
            }

            RegisterDiscussMessages();
        }
예제 #2
0
        private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
        {
            SqlDependency dependency = sender as SqlDependency;

            dependency.OnChange -= new OnChangeEventHandler(dependency_OnChange);

            if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Insert)
            {
                List<DiscussMessageModel> lsDiscussMessage = GetDiscussMessages();
                LotteryResultHub hub = new LotteryResultHub();
                foreach (DiscussMessageModel model in lsDiscussMessage)
                {
                    if (model.Status.Equals("A")){
                        hub.SendDiscussMessage(model.Username, model.FilePath, model.Message, model.CreatedDate);
                        UpdateDiscussMessagesSent(model.Id);
                    }
                }
               
            }
            RegisterDiscussMessages();
        }