private static void OnConfigChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency depend = (SqlDependency)sender;
depend.OnChange -= OnConfigChange;
if (e.Type == SqlNotificationType.Change)
{
LoadConfig();
}
}
private void OnDependencyChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency dependency = sender as SqlDependency;
// Notices are only a one shot deal
// so remove the existing one so a new
// one can be added
dependency.OnChange -= OnDependencyChange;
OnScheduleChanged();
}
private void OnIncidentListChange(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
SqlDependency dependency = sender as SqlDependency;
dependency.OnChange -= OnIncidentListChange;
UpdateGridViewIncidentList();
}
}
public void Personas_Cambio(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
string mensaje = ObtenerMensajeAMostrar(e);
chatHub.Clients.All.SendAsync("ReceiveMessage", "Admin", mensaje);
}
SuscribirseALosCambiosDeLaTablaPersonas();
}
private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
// SqlDependency dependency = sender as SqlDependency;
// if (dependency != null) dependency.OnChange -= dependency_OnChange;
if (e.Type == SqlNotificationType.Change)
{
BroadcastVotes(GetResultsFromDB());
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency dependency = sender as SqlDependency;
dependency.OnChange -= Dependency_OnChange;
if (e.Info != SqlNotificationInfo.Invalid)
{
InitSqlDependency();
}
}
private void Dp_OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency dp = sender as SqlDependency;
dp.OnChange -= Dp_OnChange;
if (OnNewForm != null)
{
OnNewForm();
}
}
private void OnPersonEvent(object sender, SqlNotificationEventArgs e)
{
if (dependency.HasChanges && e.Info != SqlNotificationInfo.AlreadyChanged)
{
var dep = sender as SqlDependency;
dep.OnChange -= OnPersonEvent;
Console.WriteLine("Data Changed : {0}", e.Info.ToString());
}
StartNotification();
}
public void chartdetail_OnChange(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
status3 = true;
MessagesHub.SendMessages();
notifchartdetail();
}
}
private void de_OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency de = sender as SqlDependency;
de.OnChange -= de_OnChange;
if (_Change != null)
{
_Change(this, new EventArgs());
}
}
private void OnChage(object sender, SqlNotificationEventArgs e)
{
SqlDependency de = sender as SqlDependency;
de.OnChange -= OnChage;
if (OnGetNotify != null)
{
OnGetNotify();
}
}
void sqlDep_onChange(object sender, SqlNotificationEventArgs e)
{
if (e.Info == SqlNotificationInfo.Insert)
{
SqlDependency sqldep = sender as SqlDependency;
sqldep.OnChange += sqlDep_onChange;
var notificationHub = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>();
notificationHub.Clients.All.notify("added");
}
}
void dependency_messages_OnChange(object sender, SqlNotificationEventArgs e)
{
if (this.MessageDataChanged != null)
{
this.MessageDataChanged(this, null);
}
// reinitialize the dependency
InitializeMessagesSqlDependency();
}
void dependency_user_OnChange(object sender, SqlNotificationEventArgs e)
{
if (this.UserDataChanged != null)
{
this.UserDataChanged(this, null);
}
// reinitialize the dependency
InitializeUsersSqlDependency();
}
private void OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency dependency = sender as SqlDependency;
dependency.OnChange -= OnChange;
if (OnNewMessage != null)
{
OnNewMessage();
}
}
private static void dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
SqlNotificationInfo s = e.Info;
List <Scope> listScopes = ScopeRepository.GetAllCompletedScopes();
foreach (Scope obj in listScopes)
{
ScopeHub.Show(obj);
}
}
private void CaptureLowres_OnChange(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
CapLowresHub nHub = new CapLowresHub();
nHub.SendCaptureLowresItems();
}
}
private void OnDependencyChange(object sender, SqlNotificationEventArgs e)
{
var sonuc = e.Source.ToString() + " " + e.Info.ToString() + " ";
DispatcherOperation op = Dispatcher.BeginInvoke((Action)(() => {
l1.Content = "çalıştı " + sonuc + DateTime.Now;
verileriYukle();
}));
}
private void OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency oldDependency = (SqlDependency)sender;
oldDependency.OnChange -= OnChange;
Setup();
_categories = GetData();
}
public void de_OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency de = sender as SqlDependency;
de.OnChange -= de_OnChange;
if (bangGiaDelegate != null)
{
bangGiaDelegate();
}
}
public void de_OnChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency de = sender as SqlDependency;
de.OnChange -= de_OnChange;
if (OnNewHome != null)
{
OnNewHome();
}
}
public void OnDependencyChange(object sender, SqlNotificationEventArgs e)
{
//remember alter database enable broker service
SqlDependency sqlDependency = sender as SqlDependency;
sqlDependency.OnChange -= OnDependencyChange;
UpdateData updateData = new UpdateData(LoadData);
this.Invoke(updateData, null);
}
private void Dependency_OnChangeEmploye(object sender, SqlNotificationEventArgs e)
{
if (e.Info != SqlNotificationInfo.Invalid)
{
dgEmployes(QRE);
}
dgGroup(QRG);
dgCabinetes(QRC);
dgTerritory(QRT);
}
private void Personas_Cambio(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
string mesanje = ObtenerMensajeAMostar(e);
chatHub.Clients.All.SendAsync("ReceiveMessage", "Admin", mesanje);
}
SuscribirseAlosCambiosDeLaTablaPersonas();//hay que volver a suscribirse para cualquier cambio de nuevo en la tabla.
}
public void dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
status3 = true;
MessagesHub.SendMessages();
notifdep();
}
}
void sd_OnChange(object sender, SqlNotificationEventArgs e)
{
if (e.Type == SqlNotificationType.Change)
{
SqlDependency sd = sender as SqlDependency;
sd.OnChange -= sd_OnChange;
var myHub = GlobalHost.ConnectionManager.GetHubContext <MyHub>();
myHub.Clients.All.message("newrecord");
}
}
private void OnDatabaseChange(object sender, SqlNotificationEventArgs args)
{
SqlNotificationInfo info = args.Info;
if (SqlNotificationInfo.Insert.Equals(info) || SqlNotificationInfo.Update.Equals(info))
{
dataGridView1.Rows.Clear();
LoadData();
}
WatchingQuery();
}
private void sqlDependency_OnChange(object sender, SqlNotificationEventArgs e)
{
if (e.Info == SqlNotificationInfo.Invalid)
{
throw new HelperClasses.LibraryException("A statement was provided that cannot be notified.");
}
BindSqlDependency();
this.OnCollectionChanged(e);
}
// Handler method
void OnDependencyChange(object sender,
SqlNotificationEventArgs e)
{
// Handle the event (for example, invalidate this cache entry).
string trigger = "a change occured now!";
//execute another query:
//where
//subscribeBroker();
}
private void sqlDependency_OnChange(object sender, SqlNotificationEventArgs e)
{
MessageBox.Show($"OnChange Event fired. SqlNotificationEventArgs: Info={e.Info}, Source={e.Source}, Type={e.Type}\r\n");
//resubscribe only if valid
if ((e.Info != SqlNotificationInfo.Invalid) &&
(e.Type != SqlNotificationType.Subscribe))
{
SearchUserLog();
}
}
