private void Changed(object sender, RecordChangedEventArgs <Employee> e)
{
if (e.ChangeType != ChangeType.None)
{
// TODO: manage the changed entity
var changedEntity = e.Entity;
//_hubContext.Clients.All.InvokeAsync("UpdateCatalog", _repository.Products);
}
}
protected override async void OnChanged(object sender, RecordChangedEventArgs <UserBalance> e)
{
if (e.ChangeType != ChangeType.None)
{
var balance = e.Entity;
await HubContext.Clients.User(balance.UserId.ToString()).SendAsync("UpdateBalance", balance);
Console.WriteLine($"Updated balance for user with id = {balance.UserId.ToString()} curent balance = {balance.Amount} at {balance.BalanceDate}");
}
}
private void TableDependency_Changed(object sender, RecordChangedEventArgs <Stock> e)
{
Console.WriteLine(Environment.NewLine);
Console.WriteLine($"DML: {e.ChangeType}");
Console.WriteLine($"Code: {e.Entity.Code}");
Console.WriteLine($"Name: {e.Entity.Name}");
Console.WriteLine($"Price: {e.Entity.Price}");
this.PublishPriceChange(e.Entity.Code, e.Entity.Name, e.Entity.Price);
}
public void Changed(object sender, RecordChangedEventArgs <SaleFoodOnline> e)
{
MessageBox.Show("Test");
var changedEntity = e.Entity;
Console.WriteLine("DML operation: " + e.ChangeType);
GetList(changedEntity);
//Console.WriteLine("SaleFoodIDFact: " + changedEntity.SaleFoodIDFact);
//Console.WriteLine("CustomerName: " + changedEntity.CustomerName);
}
private void OnClanGameLogChanged(object sender, RecordChangedEventArgs <ClanGameLog> e)
{
if (e.ChangeType == ChangeType.Insert)
{
_logger.LogInformation("Clan \"{0}\" won to clan \"{1}\"", e.Entity.WinnerClanName, e.Entity.LoserClanName);
ClanWarNotificationEventHandlerAsync handler = OnClanWarNotification;
handler?.Invoke(this, new ClanWarNotificationEventArgs(e.Entity));
}
}
private void TableDependency_OnChanged(object sender, RecordChangedEventArgs <StatisticBasicModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
case ChangeType.Update:
this._clients.All.changeEntity(e.Entity.IdPlayer);
break;
}
}
public void Changed(object sender, RecordChangedEventArgs <Zaposleni> e)
{
var changedEntity = e.Entity;
Invoke((MethodInvoker) delegate
{
var text = changedEntity.Ime.ToString() + " " + changedEntity.Prezime.ToString();
this.ShowNotification(text);
});
}
internal void Changed(object sender, RecordChangedEventArgs <T> e)
{
if (ChangesSupport.Contains(e.ChangeType))
{
Entity = e.Entity;
JsonEntity = JsonConvert.SerializeObject(Entity);
JsonObject = JObject.Parse(JsonEntity);
NotificationTable?.NotificationTable(e.Entity, ConvertType(e.ChangeType));
}
}
private static void TableDependency_Changed(object sender, RecordChangedEventArgs <TestOracleModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
_checkValues[ChangeType.Insert.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Insert.ToString()].Item2.Description = e.Entity.Description;
break;
}
}
public static void Changed(object sender, RecordChangedEventArgs <Customer> e)
{
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("DateTime: " + DateTime.Now);
}
private void GenFueltableDependency(object sender, RecordChangedEventArgs <GenFuelTbl> e)
{
if (e.ChangeType != ChangeType.None)
{
List <fuelTypeData> data = new List <fuelTypeData>();
data = _FuelTypeRepository.GetFuelType(1);
_hubContext.Clients.All.SendAsync("ReceiveGenmix", data[0]);
}
}
/// <summary>
/// The program has detected something inside the table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void _sqlTableDependency_OnChanged(object sender, RecordChangedEventArgs <Cobrancas> e)
{
if (e != null)
{
if (e.ChangeType == ChangeType.Update)
{
new Util().LogMessageToFile(JsonConvert.SerializeObject(e.Entity));
}
}
}
void TableDependency_Changed(object sender, RecordChangedEventArgs <ScrapeRun> e)
{
if (e.ChangeType != ChangeType.None)
{
var changedEntity = e.Entity;
Console.WriteLine("DML operation: " + e.ChangeType);
Console.WriteLine("ID: " + changedEntity.Id);
Console.WriteLine("Description: " + changedEntity.Heading);
}
}
private static void TableDependency_Changed(object sender, RecordChangedEventArgs <DataAnnotationTestSqlServer10Model> e)
{
_counter++;
switch (e.ChangeType)
{
case ChangeType.Insert:
_checkValues[ChangeType.Insert.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Insert.ToString()].Item2.Description = e.Entity.Description;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Insert.ToString()].Item2.Name = e.EntityOldValues.Name;
_checkValuesOld[ChangeType.Insert.ToString()].Item2.Description = e.EntityOldValues.Description;
}
else
{
_checkValuesOld[ChangeType.Insert.ToString()] = null;
}
break;
case ChangeType.Update:
_checkValues[ChangeType.Update.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Update.ToString()].Item2.Description = e.Entity.Description;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Update.ToString()].Item2.Name = e.EntityOldValues.Name;
_checkValuesOld[ChangeType.Update.ToString()].Item2.Description = e.EntityOldValues.Description;
}
else
{
_checkValuesOld[ChangeType.Update.ToString()] = null;
}
break;
case ChangeType.Delete:
_checkValues[ChangeType.Delete.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Delete.ToString()].Item2.Description = e.Entity.Description;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Delete.ToString()].Item2.Name = e.EntityOldValues.Name;
_checkValuesOld[ChangeType.Delete.ToString()].Item2.Description = e.EntityOldValues.Description;
}
else
{
_checkValuesOld[ChangeType.Delete.ToString()] = null;
}
break;
}
}
private static void TableDependency_Changed(object sender, RecordChangedEventArgs <EventForAllColumnsTestSqlServerModel> e)
{
_counter++;
switch (e.ChangeType)
{
case ChangeType.Insert:
_checkValues[ChangeType.Insert.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Insert.ToString()].Item2.Surname = e.Entity.Surname;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Insert.ToString()].Item2.Name = e.EntityOldValues.Name;
_checkValuesOld[ChangeType.Insert.ToString()].Item2.Surname = e.EntityOldValues.Surname;
}
else
{
_checkValuesOld[ChangeType.Insert.ToString()] = null;
}
break;
case ChangeType.Update:
_checkValues[ChangeType.Update.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Update.ToString()].Item2.Surname = e.Entity.Surname;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Update.ToString()].Item2.Name = e.EntityOldValues.Name;
_checkValuesOld[ChangeType.Update.ToString()].Item2.Surname = e.EntityOldValues.Surname;
}
else
{
_checkValuesOld[ChangeType.Update.ToString()] = null;
}
break;
case ChangeType.Delete:
_checkValues[ChangeType.Delete.ToString()].Item2.Name = e.Entity.Name;
_checkValues[ChangeType.Delete.ToString()].Item2.Surname = e.Entity.Surname;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Delete.ToString()].Item2.Name = e.EntityOldValues.Name;
_checkValuesOld[ChangeType.Delete.ToString()].Item2.Surname = e.EntityOldValues.Surname;
}
else
{
_checkValuesOld[ChangeType.Delete.ToString()] = null;
}
break;
}
}
private void Changed(object sender, RecordChangedEventArgs <lmpTbl> e)
{
if (e.ChangeType != ChangeType.None)
{
lmpDataRow lmpData = new lmpDataRow();
lmpData.timestamp = e.Entity.timestamp;
lmpData.Interval5MinLMP = e.Entity._5_Minute_Weighted_Avg__LMP;
_hubContext.Clients.All.SendAsync("ReceiveLMP", lmpData);
}
}
private static void TableDependency_Changed(object sender, RecordChangedEventArgs <NullMessageContentTestOracleModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
_id = e.Entity.Id;
_name = e.Entity.Name;
_description = e.Entity.Description;
break;
}
}
private void LoadChanged(object sender, RecordChangedEventArgs <loadTbl> e)
{
if (e.ChangeType != ChangeType.None)
{
loadTblRow loadData = new loadTblRow();
loadData.timestamp = e.Entity.timestamp;
loadData.Instantaneous_Load = e.Entity.Instantaneous_Load;;
_hubContext.Clients.All.SendAsync("ReceiveLoad", loadData);
}
}
private async void Changed(object sender, RecordChangedEventArgs <CollectionOperation> e)
{
if (e.ChangeType == ChangeType.None)
{
return;
}
var changedEntity = e.Entity;
using (var scope = _scopeFactory.CreateScope())
{
var dbContext = scope.ServiceProvider.GetRequiredService <AppIdentityDbContext>();
var result = (from collector in dbContext.Users
join collection in dbContext.Collections on collector.Id equals collection.CollectorId
join provider in dbContext.Users on collection.ProviderId equals provider.Id
join deskIssued in dbContext.Desks on collection.DeskIssuedId equals deskIssued.DeskId into desks
from desk in desks.DefaultIfEmpty()
where collection.CollectionId == changedEntity.CollectionId
select new
{
CollectorId = collector.Id,
CollectorPushAllId = collector.PushAllUserId,
CollectionAmount = collection.Amount,
CollectionDesk = desk.Description,
ProviderName = provider.Name
}).FirstOrDefault();
if (result == null)
{
return;
}
const string topic = "AMS";
var message = $"Поступила новая инкассация {result.ProviderName} {result.CollectionDesk} {result.CollectionAmount:### ### ##0.00}";
await _hubContext.Clients.User(result.CollectorId).SendAsync("ReceiveMessage", message, topic);
if (result.CollectorPushAllId == null)
{
return;
}
var client = _httpClientFactory.CreateClient();
client.BaseAddress = new Uri("https://pushall.ru/");
var response = await client.PostAsync("api.php", new MultipartFormDataContent
{
{ new StringContent("unicast"), "type" },
{ new StringContent(_configuration["PushAll:ChannelId"]), "id" },
{ new StringContent(_configuration["PushAll:ApiKey"]), "key" },
{ new StringContent(message), "text" },
{ new StringContent("AMS"), "title" },
{ new StringContent("300"), "ttl" },
{ new StringContent(result.CollectorPushAllId.ToString()), "uid" }
});
}
}
private void TableDependency_Changed(object sender, RecordChangedEventArgs <FloatAndIntegerTypesModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
GotModel.FLOATCOLUMN = e.Entity.FLOATCOLUMN;
GotModel.INTEGERCOLUMN = e.Entity.INTEGERCOLUMN;
GotModel.NUMBERCOLUMN = e.Entity.NUMBERCOLUMN;
break;
}
}
public void Dep_PersonFromTeamList_OnChanged(object sender, RecordChangedEventArgs <PersonTeamMetadata> e)
{
if (e.ChangeType == ChangeType.Insert || e.ChangeType == ChangeType.Update)
{
var person = PersonFromTeamList.FirstOrDefault(p => p.PassportSerial == e.Entity.PassportSerial);
if (person != null)
{
person.IsSelected = e.Entity.AccountNumberRegisteredInMilitaryID == 1;
}
}
}
/// <summary>
/// Loads a data object using a primary key
/// </summary>
/// <param name="ID">Primary key value to load.</param>
public void Load(int ID)
{
// Load a dataobject by it's Primary[0] ID
if (PrimaryKeys.Count == 0)
{
DataObjectException ValidationError = new DataObjectException("Only one key was given for a multiple key object.");
throw ValidationError;
}
if (TableName.Trim().Length == 0)
{
DataObjectException ValidationError = new DataObjectException("The object's table has not been set.");
throw ValidationError;
}
try
{
DataCommand.Connection = ConnHandler.RequestConnection(Alias, this);
DataCommand.CommandText = "SELECT * FROM " +
TableName + " WHERE " + PrimaryKeys[0].Name +
" = " + ID.ToString();
DataAdapter.SelectCommand = _dbcmdData;
int x = (int)DataAdapter.Fill(_dataTable);
if (x == 0)
{
// Record doesn't exist
_dataRow = null;
DataObjectException.InvalidRecordException PrimaryKeyError =
new DataObjectException.InvalidRecordException();
throw PrimaryKeyError;
}
else
{
_dataRow = _dataTable.Rows[_dataTable.Rows.Count - 1];
if (RecordChanged != null)
{
RecordChangedEventArgs args = new RecordChangedEventArgs(RowAction.Loaded);
RecordChanged(this, args);
}
}
}
catch (Exception err)
{
throw err;
}
finally
{
ConnHandler.ReleaseConnection(this, DataCommand.Connection);
}
}
private static void TableDependency_Changed(object sender, RecordChangedEventArgs <Issue24Model> e)
{
Console.WriteLine(Environment.NewLine);
if (e.ChangeType != ChangeType.None)
{
var changedEntity = e.Entity;
Console.WriteLine("DML operation: " + e.ChangeType);
Console.WriteLine("ID: " + changedEntity.Id);
Console.WriteLine("Message: " + changedEntity.Message);
}
}
private static void Changed(object sender, RecordChangedEventArgs <Customer> e)
{
Console.WriteLine(Environment.NewLine);
if (e.ChangeType != ChangeType.None)
{
var changedEntity = e.Entity;
Console.WriteLine("DML operation: " + e.ChangeType);
Console.WriteLine("CompanyName: " + changedEntity.CompanyName);
Console.WriteLine("ContactName: " + changedEntity.ContactName);
}
}
private void SqlTableDependency_Changed(
object sender,
RecordChangedEventArgs <DowntimeManualModel> e
)
{
if (e.ChangeType == ChangeType.None)
{
return;
}
Task.Run(() => BroadCastChange(e.Entity));
}
private void TableDependency_Changed(object sender, RecordChangedEventArgs <GetMessageAfterRestartTestOracleModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
_checkValues.Add(e.Entity.Name);
break;
default:
throw new ArgumentOutOfRangeException();
}
}
static void TableDependency_Changed(object sender, RecordChangedEventArgs <SwipeData> e)
{
if (e.ChangeType == ChangeType.Insert)
{
var changedEntity = e.Entity;
if (GlobalVar.StartValue == 0)
{
GlobalVar.StartValue = changedEntity.entry_number;
}
GlobalVar.SwipeNum += 1;
}
}
private void TableDependency_Changed(object sender, RecordChangedEventArgs <XmlAsStringSqlServerTestModel> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
_checkValues[ChangeType.Insert.ToString()].Item2.VarcharMaxColumn = e.Entity.VarcharMaxColumn;
_checkValues[ChangeType.Insert.ToString()].Item2.NvarcharMaxColumn = e.Entity.NvarcharMaxColumn;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Insert.ToString()].Item2.VarcharMaxColumn = e.EntityOldValues.VarcharMaxColumn;
_checkValuesOld[ChangeType.Insert.ToString()].Item2.NvarcharMaxColumn = e.EntityOldValues.NvarcharMaxColumn;
}
else
{
_checkValuesOld[ChangeType.Insert.ToString()] = null;
}
break;
case ChangeType.Update:
_checkValues[ChangeType.Update.ToString()].Item2.VarcharMaxColumn = e.Entity.VarcharMaxColumn;
_checkValues[ChangeType.Update.ToString()].Item2.NvarcharMaxColumn = e.Entity.NvarcharMaxColumn;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Update.ToString()].Item2.VarcharMaxColumn = e.EntityOldValues.VarcharMaxColumn;
_checkValuesOld[ChangeType.Update.ToString()].Item2.NvarcharMaxColumn = e.EntityOldValues.NvarcharMaxColumn;
}
else
{
_checkValuesOld[ChangeType.Update.ToString()] = null;
}
break;
case ChangeType.Delete:
_checkValues[ChangeType.Delete.ToString()].Item2.VarcharMaxColumn = e.Entity.VarcharMaxColumn;
_checkValues[ChangeType.Delete.ToString()].Item2.NvarcharMaxColumn = e.Entity.NvarcharMaxColumn;
if (e.EntityOldValues != null)
{
_checkValuesOld[ChangeType.Delete.ToString()].Item2.VarcharMaxColumn = e.EntityOldValues.VarcharMaxColumn;
_checkValuesOld[ChangeType.Delete.ToString()].Item2.NvarcharMaxColumn = e.EntityOldValues.NvarcharMaxColumn;
}
else
{
_checkValuesOld[ChangeType.Delete.ToString()] = null;
}
break;
}
}
private static void TableDependency_Changed(object sender, RecordChangedEventArgs <TeardownTestSqlserver4Model> e)
{
switch (e.ChangeType)
{
case ChangeType.Insert:
_notifiedValues.Add(new TeardownTestSqlserver4Model()
{
Id = e.Entity.Id, Name = e.Entity.Name, Description = e.Entity.Description
});
break;
}
}
private async void _dependency_OnChanged(object sender, RecordChangedEventArgs <Model.Models.Poruka> e)
{
if (e.ChangeType != ChangeType.None && e.Entity.Posiljaoc != "Uposlenik")
{
//this.grid.Dispatcher.Invoke(DispatcherPriority.Background, new Action(() =>
//{
// this.grid.ItemsSource = ArticleController.GetAll();
//}));
btnPoruke.BackColor = Color.Red;
//NewMethod();
}
}
private void _stockDependency_OnChanged(object sender, RecordChangedEventArgs<Stock> e)
{
if (e.ChangeType != ChangeType.None)
{
BroadcastStockPrice(e.Entity);
}
}
private void TableDependency_Changed(object sender, RecordChangedEventArgs<LineStatus> e)
{
if (e.ChangeType != ChangeType.None)
{
var changedEntity = e.Entity;
if (changedEntity.IdLine == 1)
{
if (changedEntity.ProductionPlan >= 0 && changedEntity.ProductionActual >= 0)
{
var balenced = ((double)changedEntity.ProductionActual / changedEntity.ProductionPlan) * 100;
if (balenced <= 100)
{
SetText(lineUserControl1.lblBalenced, $"{Math.Round(balenced, 2)} %");
}
else
{
SetText(lineUserControl1.lblBalenced, "N/A");
}
}
else
{
SetText(lineUserControl1.lblBalenced, "0 %");
}
SetText(lineUserControl1.lblLineName, $"Tên Line: {changedEntity.NameLine}");
SetText(lineUserControl1.lblPerson, changedEntity.CountPerson.ToString());
SetText(lineUserControl1.lblModel, changedEntity.ModelCurrent);
SetText(lineUserControl1.lblPlan, changedEntity.ProductionPlan.ToString());
SetText(lineUserControl1.lblActual, changedEntity.ProductionActual.ToString());
SetText(lineUserControl1.lblComment, changedEntity.Comment);
SetBackgourdIsRun(lineUserControl1.lblRun, lineUserControl1.lblPause, lineUserControl1.lblStop, changedEntity.StatusLine);
SetBackgourdIsPause(lineUserControl1.lblRun, lineUserControl1.lblPause, lineUserControl1.lblStop, changedEntity.StatusLine);
SetBackgourdIsStop(lineUserControl1.lblRun, lineUserControl1.lblPause, lineUserControl1.lblStop, changedEntity.StatusLine);
//IsRunCallBackColorPause(true);
}
else if(changedEntity.IdLine == 2)
{
if (changedEntity.ProductionPlan >= 0 && changedEntity.ProductionActual >= 0)
{
var balenced = ((double)changedEntity.ProductionActual / changedEntity.ProductionPlan) * 100;
if (balenced <= 100)
{
SetText(lineUserControl2.lblBalenced, $"{Math.Round(balenced, 2)} %");
}
else
{
SetText(lineUserControl2.lblBalenced, "N/A");
}
}
else
{
SetText(lineUserControl2.lblBalenced, "0 %");
}
SetText(lineUserControl2.lblLineName, $"Tên Line: {changedEntity.NameLine}");
SetText(lineUserControl2.lblPerson, changedEntity.CountPerson.ToString());
SetText(lineUserControl2.lblModel, changedEntity.ModelCurrent);
SetText(lineUserControl2.lblPlan, changedEntity.ProductionPlan.ToString());
SetText(lineUserControl2.lblActual, changedEntity.ProductionActual.ToString());
SetText(lineUserControl2.lblComment, changedEntity.Comment);
SetBackgourdIsRun(lineUserControl2.lblRun, lineUserControl2.lblPause, lineUserControl2.lblStop, changedEntity.StatusLine);
SetBackgourdIsPause(lineUserControl2.lblRun, lineUserControl2.lblPause, lineUserControl2.lblStop, changedEntity.StatusLine);
SetBackgourdIsStop(lineUserControl2.lblRun, lineUserControl2.lblPause, lineUserControl2.lblStop, changedEntity.StatusLine);
}
else if(changedEntity.IdLine == 3)
{
if (changedEntity.ProductionPlan >= 0 && changedEntity.ProductionActual >= 0)
{
var balenced = ((double)changedEntity.ProductionActual / changedEntity.ProductionPlan) * 100;
if (balenced <= 100)
{
SetText(lineUserControl3.lblBalenced, $"{Math.Round(balenced, 2)} %");
}
else
{
SetText(lineUserControl3.lblBalenced, "N/A");
}
}
else
{
SetText(lineUserControl3.lblBalenced, "0 %");
}
SetText(lineUserControl3.lblLineName, $"Tên Line: {changedEntity.NameLine}");
SetText(lineUserControl3.lblPerson, changedEntity.CountPerson.ToString());
SetText(lineUserControl3.lblModel, changedEntity.ModelCurrent);
SetText(lineUserControl3.lblPlan, changedEntity.ProductionPlan.ToString());
SetText(lineUserControl3.lblActual, changedEntity.ProductionActual.ToString());
SetText(lineUserControl3.lblComment, changedEntity.Comment);
SetBackgourdIsRun(lineUserControl3.lblRun, lineUserControl3.lblPause, lineUserControl3.lblStop, changedEntity.StatusLine);
SetBackgourdIsPause(lineUserControl3.lblRun, lineUserControl3.lblPause, lineUserControl3.lblStop, changedEntity.StatusLine);
SetBackgourdIsStop(lineUserControl3.lblRun, lineUserControl3.lblPause, lineUserControl3.lblStop, changedEntity.StatusLine);
}
}
}
static void Changed(object sender, RecordChangedEventArgs<Item> e)
{
if (e.ChangeType != ChangeType.None)
{
var changedEntity = e.Entity;
Console.WriteLine("DML operation: " + e.ChangeType);
Console.WriteLine("ID: " + changedEntity.SID);
Console.WriteLine("Name: " + changedEntity.NAME);
}
}
