private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (NewMessage != null) NewMessage(sender, e); //subscribe again to notifier RegisterForNotifications(); }
// NOTE: If you recieve Subscribe notification immediatly after execution, it's possibly because of "The statement is not valid for notificationThe statement is not valid for notification" // For more information read http://www.codeproject.com/Articles/12335/Using-SqlDependency-for-data-change-events private static void SqlDependencyOnChange(object sender, SqlNotificationEventArgs eventArgs) { Console.WriteLine($"Notification recieved. Source = {eventArgs.Source}, Type = {eventArgs.Type}, Info = {eventArgs.Info}"); if (eventArgs.Type != SqlNotificationType.Change) return; _RegisterDependency(); }
private void Dependency_OnChange(object sender, System.Data.SqlClient.SqlNotificationEventArgs e) { if (e.Info != SqlNotificationInfo.Invalid) { dgFill(QR); } }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change) { MessagesHub.SendMessages(); } }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Insert) { MessagesChat[] messages = GetMessagesChat().ToArray(); List<string> users = null; foreach (MessagesChat mess in messages) { MessagesChat arr = GetMessagesChatFull(mess.Id); if (mess.Type.Equals("G", StringComparison.OrdinalIgnoreCase)) { users = GetListUserOfGroup(arr.GroupId); } else { users = GetListUser(arr.Id); } MobiChatHub.lsUsers = users; MobiChatHub.SendMessages(new MessagesChat { Id = arr.Id, Content = arr.Content, SenderId = arr.SenderId, UserName = arr.UserName, SendDate = arr.SendDate, Type = arr.Type, GroupId = arr.GroupId }); WebChatHub.lsUsers = users; WebChatHub.SendMessages(new MessagesChat { Id = arr.Id, Content = arr.Content, SenderId = arr.SenderId, UserName = arr.UserName, SendDate = arr.SendDate, Type = arr.Type, GroupId = arr.GroupId }); UpdateStatusMessage(mess.Id, DateTime.Now); } } RegisterMessages(); }
static void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Info == SqlNotificationInfo.Invalid) { Debug.Print("SqlNotification: A statement was provided that cannot be notified."); return; } try{ var id =((SqlDependency)sender).Id; IEnumerable collection; if (collections.TryGetValue(id, out collection)) { collections.Remove(id); AutoRefresh(collection); var notifyRefresh = collection as INotifyRefresh; if (notifyRefresh != null) System.Windows.Application.Current.Dispatcher.BeginInvoke( (Action)(notifyRefresh.OnRefresh)); } } catch (Exception ex) { System.Diagnostics.Debug.Print("Error in OnChange: {0}", ex.Message); } }
private void OnDependencyChanged(object sender, SqlNotificationEventArgs e) { if (_eventHandler != null) _eventHandler.Invoke(this, e); _dependency = null; Start(); }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change) { //MessagesHub test = new MessagesHub(services); //test.SendMessages(); MessagesHub.SendMessages(); } }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change) { SendNotifications(); } }
//event fired whenever db entites in the select list change private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change) { //calls to hub message to broadvast changes MessagesHub.SendMessages(); } }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Insert) { } RegisterDiscussMessages(); }
static void kmoDependency_OnChange(object sender, SqlNotificationEventArgs e) { Console.WriteLine("change happened"); Console.WriteLine(e.Info.ToString()); Console.WriteLine(e.Source.ToString()); Console.WriteLine(e.Type.ToString()); Console.WriteLine("restarting dependency watch..."); m_restartWatch = true; }
private void Dependency_OnChange(object sender, System.Data.SqlClient.SqlNotificationEventArgs e) { //Если отклик не равен бездействию, то перевыполняем метод //Заполения данных о клиенте if (e.Info != System.Data.SqlClient.SqlNotificationInfo.Invalid) { Klient_Data_Fill(); } }
internal void NewMessageRecieved(object sender, SqlNotificationEventArgs e) { IEnumerable<Message> newMessages = FetchMessagesFromDb(); _dispatcher(newMessages.Select(lm => lm.MessageTest)); using (ApplicationDbContext db = new ApplicationDbContext()) { //Mark all dispatched messages as sent newMessages.ToList().ForEach(lm => { db.Messages.Attach(lm); lm.IsSend = true; }); db.SaveChanges(); } }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change) { var context = GlobalHost.ConnectionManager.GetHubContext<PingResultHub>(); PingResultRepository repo = new PingResultRepository(); var res = repo.GetAllPingResults(); context.Clients.All.addPingResultToPage(res); } RegisterNotification(); }
public void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change) { // We reach this point if a change is observed SendNotifications(); } if (e.Type == SqlNotificationType.Subscribe) { // We reach this point if a change is observed SendNotifications(); } }
private void _dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Info == SqlNotificationInfo.Invalid) { System.Diagnostics.Debug.WriteLine("SqlNotification: A statement was provided that cannot be notified."); return; } SqlDependency dependency = (SqlDependency)sender; dependency.OnChange -= _dependency_OnChange; OnRefreshEntityEvent(); RegisterDependency(); }
void NotificationHandler(object sender, SqlNotificationEventArgs e) { if (this.InvokeRequired) { this.BeginInvoke(new OnChangeEventHandler(NotificationHandler), new object[]{sender, e}); return; } var sqlDep = sender as SqlDependency; sqlDep.OnChange -= new OnChangeEventHandler(NotificationHandler); dataGridView.DataSource = notification.SomeMethod(NotificationHandler); }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Insert) { List<DiscussMessageModel> lsDiscussMessage = GetDiscussMessages(); foreach (DiscussMessageModel model in lsDiscussMessage) { } } RegisterDiscussMessages(); }
private void OnDependencyChange(Object o, SqlNotificationEventArgs args) { if ((args.Source.ToString() == "Data") || (args.Source.ToString() == "Timeout")) { Console.WriteLine(Environment.NewLine + "Refreshing data due to {0}", args.Source); Notify(CacheDependencyChangeTypes.Changed); ListenForChanges(); } else { Console.WriteLine(Environment.NewLine + "Data not refreshed due to unexpected SqlNotificationEventArgs: Source={0}, Info={1}, Type={2}", args.Source, args.Info, args.Type.ToString()); } }
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) { hub.SendDiscussMessage(model.Username, model.FilePath, model.Message); } } RegisterDiscussMessages(); }
private void dependency_OnChange( object sender, SqlNotificationEventArgs e) { // This event will occur on a thread pool thread. // Updating the UI from a worker thread is not permitted. // The following code checks to see if it is safe to // update the UI. ISynchronizeInvoke i = (ISynchronizeInvoke)this; // If InvokeRequired returns True, the code // is executing on a worker thread. if (i.InvokeRequired) { // Create a delegate to perform the thread switch. OnChangeEventHandler tempDelegate = new OnChangeEventHandler(dependency_OnChange); object[] args = { sender, e }; // Marshal the data from the worker thread // to the UI thread. i.BeginInvoke(tempDelegate, args); return; } // Remove the handler, since it is only good // for a single notification. SqlDependency dependency = (SqlDependency)sender; dependency.OnChange -= dependency_OnChange; // At this point, the code is executing on the // UI thread, so it is safe to update the UI. ++changeCount; label1.Text = String.Format(statusMessage, changeCount); // Add information from the event arguments to the list box // for debugging purposes only. listBox1.Items.Clear(); listBox1.Items.Add("Info: " + e.Info.ToString()); listBox1.Items.Add("Source: " + e.Source.ToString()); listBox1.Items.Add("Type: " + e.Type.ToString()); // Reload the dataset that is bound to the grid. GetData(); }
private static void Dep_OnChange(object sender, SqlNotificationEventArgs e) { //清除相關快取 List<string> keys = new List<string>(); var cache = MemoryCache.Default; foreach (var item in cache) { if (item.Key.StartsWith("MaintenanceMode_")) keys.Add(item.Key); } foreach (var key in keys) { cache.Remove(key); } SetMonitor(); }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { ISynchronizeInvoke i = this; if (i.InvokeRequired) { OnChangeEventHandler tempDelegate = dependency_OnChange; object[] args = { sender, e }; i.BeginInvoke(tempDelegate, args); return; } SqlDependency dependency = (SqlDependency)sender; dependency.OnChange -= dependency_OnChange; GetData(); }
private static void sqlDependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Info == SqlNotificationInfo.Insert) { var cntrl = new DotNetNuke.Services.Log.EventLog.EventLogController(); int records = 0; int pageSize = 10; int pageIndex = 0; // Get DNN Logs //var dnnLogs = cntrl.GetLogs(PortalId, DotNetNuke.Services.Log.EventLog.EventLogController.EventLogType.HOST_ALERT.ToString(), pageSize, pageIndex, ref records); // else try manually var props = new DotNetNuke.Services.Log.EventLog.LogProperties(); props.Deserialize("<LogProperties><LogProperty><PropertyName>Install Package:</PropertyName><PropertyValue>CCFileExplorer</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Starting Installation</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Starting Installation - CCFileExplorer</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Starting Installation - Script</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Begin Sql execution</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - Providers\\DataProviders\\SqlDataProvider\\00.00.01.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - Providers\\\\DataProviders\\SqlDataProvider\\00.00.01.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Executing 00.00.01.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Start Sql execution: 00.00.01.SqlDataProvider file</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>End Sql execution: 00.00.01.SqlDataProvider file</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - Providers\\DataProviders\\SqlDataProvider\\Uninstall.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - Providers\\DataProviders\\SqlDataProvider\\Uninstall.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Finished Sql execution</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Component installed successfully - Script</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Starting Installation - ResourceFile</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Expanding Resource file</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - Edit.ascx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - Edit.ascx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - License.txt</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - License.txt</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - module.css</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - module.css</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - ReleaseNotes.txt</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - ReleaseNotes.txt</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - Settings.ascx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - Settings.ascx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - View.ascx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - View.ascx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - App_LocalResources\\Edit.ascx.resx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - App_LocalResources/Edit.ascx.resx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - App_LocalResources\\Settings.ascx.resx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - App_LocalResources/Settings.ascx.resx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - App_LocalResources\\View.ascx.resx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - App_LocalResources/View.ascx.resx</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - Documentation\\Documentation.css</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - Documentation/Documentation.css</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - Documentation\\Documentation.html</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - Documentation/Documentation.html</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Resource Files created</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Component installed successfully - ResourceFile</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Starting Installation - Module</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Module registered successfully - CCFileExplorer</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Component installed successfully - Module</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Starting Installation - Assembly</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Assembly registered - bin\\CCFileExplorer.dll</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Creating backup of previous version - bin\\CCFileExplorer.dll</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Created - bin\\CCFileExplorer.dll</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Component installed successfully - Assembly</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Installation committed</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Installation successful. - CCFileExplorer</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Deleted temporary install folder</PropertyValue></LogProperty><LogProperty><PropertyName>Info:</PropertyName><PropertyValue>Installation successful.</PropertyValue></LogProperty></LogProperties>"); var dnnLog = new DotNetNuke.Services.Log.EventLog.LogInfo() { LogGUID = Guid.NewGuid().ToString() ,LogTypeKey = "HOST_ALERT" ,LogConfigID = "95" ,LogUserID = 0 ,LogUserName ="******" ,LogPortalID = 0 ,LogPortalName = null ,LogCreateDate = DateTime.UtcNow ,LogServerName = "Cass" ,LogProperties = props }; var dnnLogs = new List<DotNetNuke.Services.Log.EventLog.LogInfo>(){dnnLog}; // Convert to EventLogs var logs = dnnLogs.Where(log => log.LogCreateDate >= SinceDate).Select(x => new EventLog(x)).ToList(); // Broadcast LogHubController.Instance.BroadcastLogs(logs); SinceDate = DateTime.UtcNow; } //Call the RegisterNotification method again RegisterDependency(); }
public static void LogSqlNotificationData(SqlNotificationEventArgs p_args, Type p_type) { if (p_args != null) { string sMessage = string.Format( "SqlNotification received.\n\tNotification Info: {0}\n\tNotification Source: {1}\n\tNotification Type: {2}\nEntity:{3}\n", p_args.Info, p_args.Source, p_args.Type, p_type.FullName); if (p_args.Info == SqlNotificationInfo.Invalid || p_args.Info == SqlNotificationInfo.Error || p_args.Info == SqlNotificationInfo.Options || p_args.Info == SqlNotificationInfo.Resource || p_args.Info == SqlNotificationInfo.TemplateLimit || p_args.Info == SqlNotificationInfo.Unknown) AssistLogger.WriteInformation( sMessage, AssistLogger.Category.Database); AssistLogger.WriteDebugInformation(sMessage, "Sql Notification"); } }
private static void Dep_OnChange(object sender, SqlNotificationEventArgs e) { Console.WriteLine("UpdateCallback-Info:" + e.Info); Console.WriteLine("UpdateCallback-Source:" + e.Source); //TODO:Clear all of the relative caches List<string> keys = new List<string>(); var cache = MemoryCache.Default; Console.WriteLine("cacheClear-before:" + cache.Count()); foreach (var item in cache) { keys.Add(item.Key); } foreach (var key in keys) { cache.Remove(key); } Console.WriteLine("cacheClear-after:" + cache.Count()); }
void dep_OnChange(object sender, SqlNotificationEventArgs e) { using (var conn = GetConnection()) { var sql = @" SELECT [Id] ,[Url] ,[AppName] ,[UserName] ,[Running] ,[LastModified] ,[Version] FROM [prototypes].[dbo].[Applications]"; var r = conn.Query<Application>(sql).ToList(); hub.Clients.All.updateApplicationList(r); //resubscribe this.Start(); } }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Type == SqlNotificationType.Subscribe || e.Info == SqlNotificationInfo.Error) return; string jsonCajero; if (e.Info == SqlNotificationInfo.Delete) { var dbnn = _listInstances.Find(dbn => dbn.IdCondicional == IdCondicional); _listInstances.Remove(dbnn); return; } using (var db = new ApplicationDbContext()) { var cajero = db.Cajeros.Find(IdCondicional).ToSimpleCajero(); jsonCajero = JsonConvert.SerializeObject(cajero); } if (OnNewChange != null) OnNewChange(jsonCajero, e); ResgisterNotification(); }
public void SendCashLevels(object sender, SqlNotificationEventArgs e) { var cajero = JsonConvert.DeserializeObject<Cajero>((string)sender); var userList = new List<string>(); using (var db = new ApplicationDbContext()) { userList = db.Cajeros.Find(cajero.IdCajero).Users.Select(u => u.UserName).ToList(); var AdminList = db.Users.Where(u => u.Roles.Select(r => r.RoleId).Contains("A")) .ToList() .Select(uu => uu.UserName); userList.AddRange(AdminList); } var cashLevels = JsonConvert.SerializeObject(new { cajero.IdCajero, cajero.EfectivoActual, cajero.NivelBajoEfectivo }); Clients.Users(userList).CashLevels(cashLevels); }
private void OnChange(object sender, SqlNotificationEventArgs e) { SqlDependency dependency = (SqlDependency)sender; // Notices are only a one shot deal // so remove the existing one so a new // one can be added if (dependency != null) dependency.OnChange -= OnChange; IConnectionManager connectionManager = AspNetHost.DependencyResolver.Resolve<IConnectionManager>(); IConnection connection = connectionManager.GetConnection<MyConnection>(); connection.Broadcast("Update!"); try { StartNotifying(); } catch (Exception ex) { broadCastException(ex); throw; } }
private void DependencyObj_OnChange(object sender, SqlNotificationEventArgs e) { if (e.Info == SqlNotificationInfo.Invalid || e.Info == SqlNotificationInfo.Error || e.Type == SqlNotificationType.Subscribe) { Print.Error(e.Info.ToString(), e.Source.ToString(), e.Type.ToString()); Scan.ContinueExit("Press enter to Exit to the Application"); } using (var db = new AtmTestDbContext()) { var id = _query.Substring(_query.LastIndexOf('=') + 1).Trim(); if (_query.Contains("Dispensadores")) { var com = db.Dispensadores.Find(id); ClientHub.HubProxy.Invoke("DispensadorData", com.EfectivoActual, com.EfectivoDispensado, com.EfectivoInicial, com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: Dispensador-> {com.EfectivoActual},{com.EfectivoDispensado},{com.EfectivoInicial},{com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("TonelerosA")) { var com = db.TonelerosA.Find(id); ClientHub.HubProxy.Invoke("ToneleroAData", com.EfectivoActual, com.EfectivoDispensado, com.EfectivoInicial, com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: ToneleroA-> {com.EfectivoActual},{com.EfectivoDispensado},{com.EfectivoInicial},{com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("TonelerosB")) { var com = db.TonelerosB.Find(id); ClientHub.HubProxy.Invoke("ToneleroBData", com.EfectivoActual, com.EfectivoDispensado, com.EfectivoInicial, com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: ToneleroB-> {com.EfectivoActual},{com.EfectivoDispensado},{com.EfectivoInicial},{com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("Impresoras")) { var com = db.Impresoras.Find(id); ClientHub.HubProxy.Invoke("ImpresoraData", com.Papel, com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: Impresora-> {com.Papel},{com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("Scanners")) { var com = db.Scanners.Find(id); ClientHub.HubProxy.Invoke("ScannerData", com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: Scanner-> {com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("Tarjetas")) { var com = db.Tarjetas.Find(id); ClientHub.HubProxy.Invoke("TarjetaData", com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: Tarjeta-> {com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("AceptadoresBilletes")) { var com = db.AceptadoresBilletes.Find(id); ClientHub.HubProxy.Invoke("AceptadorBilletesData", com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: Billetero-> {com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } else if (_query.Contains("AceptadoresMonedas")) { var com = db.AceptadoresMonedas.Find(id); ClientHub.HubProxy.Invoke("AceptadorMonedasData", com.Status, com.Error, com.Cajero.First().NsCajero); Print.NewLine($"DataSent: Moneder-> {com.Status},{com.Error},{com.Cajero.First().NsCajero}"); } } RegisterQuery(); }
internal static Exception SqlNotificationException(SqlNotificationEventArgs notify) { return(ADP.InvalidOperation(Res.GetString("SQLNotify_ErrorFormat", new object[] { notify.Type, notify.Info, notify.Source }))); }
internal void Invoke(SqlNotificationEventArgs args) { _args = args; ExecutionContext.Run(_context, s_contextCallback, this); }