public void Changed(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <SaleFoodOnline> e) { var changedEntity = e.Entity; MessageBox.Show("DML operation: " + e.ChangeType); MessageBox.Show("ID: " + changedEntity.SaleFoodIDFact); }
private void _tableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <HmiMgmtExchange> e) // Er is een wijziging in de tabel { string groepNaam = e.Entity.Machine; // Groep identifer van Clients. ==> Enkel clients met dia aangesloten zijn aan een grope met dezelfde naam ontvangen een melding. switch (e.ChangeType) { case ChangeType.None: // Doe niets break; case ChangeType.Delete: // Aangepast Object versturen naar alle clients in groep met naam: "groepNaam" _hubContext.Clients.Group(groepNaam).SendAsync("DeletedItem", e.Entity); break; case ChangeType.Insert: // Aangepast Object versturen naar alle clients in groep met naam: "groepNaam" _hubContext.Clients.Group(groepNaam).SendAsync("InsertedItem", e.Entity); break; case ChangeType.Update: // Aangepast Object versturen naar alle clients in groep met naam: "groepNaam" _hubContext.Clients.Group(groepNaam).SendAsync("UpdatedItem", e.Entity); break; default: break; } }
private static void Dep_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <UserModel> e) { var changedEntity = e.Entity; Console.WriteLine("DML operation: " + e.ChangeType); Console.WriteLine("ID: " + changedEntity.UserId); Console.WriteLine("Name: " + changedEntity.FirstName); Console.WriteLine("Surname: " + changedEntity.LastName); }
private static void TableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <Customer> e) { Console.WriteLine(Environment.NewLine); if (e.ChangeType != TableDependency.SqlClient.Base.Enums.ChangeType.None) { var changedEntity = e.Entity; Console.WriteLine("DML operation: " + e.ChangeType); Console.WriteLine("ID: " + changedEntity.Id); Console.WriteLine("Name: " + changedEntity.Name); Console.WriteLine("Surname: " + changedEntity.Surname); Console.WriteLine(Environment.NewLine); } }
private void SqlTableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <tblProduct> e) { switch (e.ChangeType) { case ChangeType.Delete: this.Clients.All.removetblProduct(e.Entity); break; case ChangeType.Insert: this.Clients.All.addtblProduct(e.Entity); break; case ChangeType.Update: this.Clients.All.updatetblProduct(e.Entity); break; } }
private void _serviceDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <ServiceReport> e) { var changedEntity = e.Entity; string type = e.ChangeType.ToString(); if (type == "Insert") { //string fileName = ""; //string filepath = @"\\spm-adfs\Shares\Shail\vs\"; //System.IO.Directory.CreateDirectory(filepath); //fileName = filepath + changedEntity.Title + ".pdf"; //SaveReport(changedEntity.Title, fileName); makereportAsync(changedEntity.Title); //Console.WriteLine("New Report got added"); //string fileName = ""; //string filepath = @"\\spm-adfs\Shares\Shail\vs\"; //fileName = filepath + changedEntity.Title + ".pdf"; //SendEmail("*****@*****.**", "SPM CONNECT - PROBLEM CASE ID: " + Path.GetRandomFileName(), changedEntity.Title, ""); } }
private void Dep_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <Modelos.Categoria> e) { MessageBox.Show(e.Entity.Descripcion.Trim() + " Ha cambiado"); }
private void _subscriptionMonitor_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <DataSubscription> e) { string changeType = e.ChangeType.ToString().ToUpper(); base.SubscriptionChangeNotification(changeType, e.Entity); }
private void _connectionDefMonitor_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <FDASourceConnection> e) { string changeType = e.ChangeType.ToString().ToUpper(); base.SourceConnectionMonitorNotification(changeType, e.Entity); }
private void _DemandMonitor_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <FDARequestGroupDemand> e) { string changeType = e.ChangeType.ToString().ToUpper(); base.DemandMonitorNotification(changeType, e.Entity); }
private void _dataPointDefMonitor_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs <FDADataPointDefinitionStructure> e) { string changeType = e.ChangeType.ToString().ToUpper(); base.DataPointMonitorNotification(changeType, e.Entity); }