private void AddPointClick(object sender, RoutedEventArgs e)
{
string message;
string caption;
number = (int)RouteNumber.Value;
if (String.IsNullOrEmpty(hex))
{
message = "Выберите цвет!";
caption = "Ошибка при заполнении";
MessageBox.Show(message, caption, MessageBoxButton.OK);
}
else
{
if (RouteNumbers.Contains(number))
{
MessageBox.Show("Маршрут с таким номером уже существует");
}
else
{
db.InsertRoute(number, hex, sessionId);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
}
}
private void Create_click(object sender, RoutedEventArgs e)
{
dayNumber = (int)DayNumber.Value;
if (Name_text.Text != null)
{
session = Name_text.Text;
if (manager != null)
{
if (doArchive)
{
db.InsertSession(session, manager, dayNumber);
}
else
{
db.InsertSession(session, manager);
}
}
}
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void Create_click(object sender, RoutedEventArgs e)
{
//Строка не меньше 3 знаков
var pass = Pass.Password;
var userName = Name_text.Text;
if (userName.Length < 5)
{
MessageBox.Show("Имя пользователя должно быть не меньше 5 знаков");
}
else
{
var salt = userName.Substring(3);
Security secur = new Security();
string hash = secur.HashPassword(pass, salt);
System.Console.Write(hash);
db.InsertUser(userName, hash);
//БД вызов на добавление
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
}
private void SaveChangesPAPersonnel()
{
foreach (var person in PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Local.ToList())
{
if (person.EMPID == null)
{
PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Remove(person);
}
}
PA_PERSONNEL_CONTEXT.SaveChanges();
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
PA_PERSONNEL_CONTEXT.Dispose();
PA_PERSONNEL_CONTEXT = new Data_Model.Portable_Traps_Entities();
System.Windows.Data.CollectionViewSource pA_PERSONNELViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pA_PERSONNELViewSource")));
PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Local.Add(new Data_Model.PA_PERSONNEL()
{
ID = ROWID
});
pA_PERSONNELViewSource.Source = PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Local;
}
private void EnableDataChangedCallback(Subscription group)
{
DataChangedEventHandler handler = new DataChangedEventHandler(DataChangedCallback);
group.DataChanged += new DataChangedEventHandler(DataChangedCallback);
group.State.Active = true;
}
private void SaveChangesPASpecies()
{
foreach (var species in SPECIES_CONTEXT.PA_SPECIES.Local.ToList())
{
if (species.ID == 0)
{
SPECIES_CONTEXT.PA_SPECIES.Remove(species);
}
}
try
{
SPECIES_CONTEXT.SaveChanges();
}
catch (DbUpdateException ex)
{
var sb = new StringBuilder();
sb.AppendLine("DbUpdateException error details - {ex?.InnerException?.InnerException?.Message}");
foreach (var eve in ex.Entries)
{
sb.AppendLine("Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated");
}
var error = sb.ToString();
MessageBox.Show(error);
//throw;
}
catch (Exception ex1)
{
var error1 = ex1.ToString();
MessageBox.Show(error1);
}
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
if (OfficeUseID == 0)
{
SPECIES_CONTEXT.Dispose();
SPECIES_CONTEXT = new Data_Model.Portable_Traps_Entities();
System.Windows.Data.CollectionViewSource pA_SPECIESViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pA_SPECIESViewSource")));
SPECIES_CONTEXT.PA_SPECIES.Local.Add(new Data_Model.PA_SPECIES()
{
ID = ROWID
});
pA_SPECIESViewSource.Source = SPECIES_CONTEXT.PA_SPECIES.Local;
textBoxspecies.Text = "";
textBoxAlive.Text = "";
textBoxDead.Text = "";
}
}
//-----------------
public MyDaSubscription(uint updateRate, MyDaSession parentSession) : base(updateRate, parentSession)
{
DataChanged += new DataChangedEventHandler(HandleDataChanged);
StateChangeCompleted += new StateChangeEventHandler(HandleStateChanged);
ReadCompleted += new SubscriptionReadEventHandler(HandleSubscriptionReadCompleted);
WriteCompleted += new SubscriptionWriteEventHandler(HandleSubscriptionWriteCompleted);
PerformStateTransitionCompleted += new PerformStateTransitionEventHandler(HandlePerformStateTransition);
}
public void SetDataChangeHandler(DataChangedEventHandler eventHandler)
{
if (DataChangeHandlerAvailable)
{
return;
}
ClientSubscription().DataChanged += eventHandler;
DataChangeHandlerAvailable = true;
}
private void BtnUpdateProduct_Click(object sender, RoutedEventArgs e)
{
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
AddUpdateProductHandler(handler);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void bAddOption_Click(object sender, RoutedEventArgs e)
{
TextBox tbOptionalArgument = ((sender as Button).Tag as TextBox);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
// Send the data to the parent window using an event
handler(this, new OptionalArgumentEventArgs(tbOptionalArgument.Text));
}
}
private void OkClick(object sender, RoutedEventArgs e)
{
Name = DBName.Text;
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DataChangedEventHandler handler = DataChanged;
//db.DeleteTable();
//db.BulkInsertLoans(DT);
if (handler != null)
{
handler(this, new EventArgs());
}
}
/// <summary>
/// Sends a data update callback.
/// </summary>
private void OnUpdate(object stateInfo)
{
//TODO zmylka dla wizkona ustalic czy faktycznie potrzebna
lock (m_firstUpdateDelayLock)
{
if (m_firstUpdateDelay)
{
// DEBUG_INFO_MESSAGE
//Opc.EventLogMonitor.WriteToEventLogInfo("sleep:"+BaseStation.Management.AppConfigManagement.WaitForFirstGroupUpdateSendInMiliSec.ToString());
System.Threading.Thread.Sleep(CAS.Lib.RTLib.Management.AppConfigManagement.WaitForFirstGroupUpdateSendInMiliSec);
m_firstUpdateDelay = false;
}
}
try
{
do
{
object clientHandle = null;
ItemValueResult[] values = null;
DataChangedEventHandler callback = null;
lock (this)
{
// check if subscription object has been disposed.
if (m_disposed)
{
return;
}
if (m_updateQueue.Count == 0)
{
break;
}
callback = m_dataChanged;
clientHandle = m_state.ClientHandle;
values = (ItemValueResult[])m_updateQueue.Dequeue();
}
if (callback != null)
{
callback(clientHandle, null, values);
}
}while (true);
}
catch (Exception e)
{
string message = e.Message;
}
}
private void btnMarkCompleted_Click(object sender, RoutedEventArgs e)
{
agendaItem.IsCompleted = true;
agendaManager.ModifyAgendaItem(agendaItem);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void SaveClick(object sender, RoutedEventArgs e)
{
number = (int)RouteNumber.Value;
db.ChangeRoute(route.ID_Route, number, hex);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void AddPointClick(object sender, RoutedEventArgs e)
{
string korp = "0";
if (City.Text == null || Street.Text == "" || House.Text == "")
{
System.Windows.MessageBox.Show("Не все обязательные значения введены");
}
else
{
//pointRN = (int)wayNumber.Value; // получаем введенное значение
//if (pointNumber < db.FindLastPoint(wayVal + 1, interVal) + 1)
// db.Shift(wayVal + 1, interVal, pointNumber);
if (Corpes.Text != "")
{
korp = Corpes.Text;
}
var orderNumber = Order.Text;
var house = House.Text;
var city = City.Text;
var street = Street.Text;
var interval = interVal;
var number = 0; //заглушка?
//Если номер больше 0, то вызываем метод сдвига
if (wayNumber.Value > 0)
{
//Метод возвращает (утверждает) номер точки, осуществляя по необходимости сдвиг
pointRN = GUI.PointRN.NumberInsert((int)wayNumber.Value, db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
}
//если равен или меньше то ставим в конец
else
{
DBWork db = new DBWork();
pointRN = GUI.PointRN.FirstNumber(db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
}
db.InsertPoint(orderNumber, city, street, house, korp, interval, number, pointRN, sessionID, wayVal);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
GUI.PointRN.DeleteNumber(point.PointType, db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
db.deletePoint(point.ID_Point);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
viewModel.AddCustomer();
// C//ustomersViewModel cus = new CustomersViewModel();
// cus.LoadCustomers();
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void Delete_click(object sender, RoutedEventArgs e)
{
System.Console.Write(user);
db.DeleteUser(user);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void Save_Click(object sender, RoutedEventArgs e)
{
var route = wayVal;
var interval = interVal;
var number = 0; //заглушка?
string comment = Comment.Text;
addr_street = tB_Addr_street.Text;
addr_house = tB_Addr_house.Text;
addr_korp = tB_Addr_korp.Text;
order = tB_order.Text;
if ((addr_street == "") || (addr_house == "") || (order == ""))
{
MessageBox.Show("Введите улицу/дом/номер заказа");
}
//Если номер точки изменился используем метод перестроения ряда
if (wayNumber.Value != pointRN & wayNumber.Value > 0)
{
try
{
//Вызов метода сдвига точек при изменении номера
pointRN = GUI.PointRN.NumberMove((int)wayNumber.Value, pointRN, db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
}
catch (Exception)
{
MessageBox.Show("Неверный ввод номера точки в маршруте");
return;
}
}
db.ChangePoint(point.ID_Point, route, interval, number, pointRN, sessionID, comment, addr_street, addr_house, addr_korp, order);
GUI.PointRN.SpaceChecking(db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
var Data = db.getPointBySession(sessionID);
db.ChangePoint(point.ID_Point, route, interval, number, pointRN, sessionID, comment, addr_street, addr_house, addr_korp, order);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void BtnAddProduct_Click(object sender, RoutedEventArgs e)
{
DataChangedEventHandler handler = DataAdded;
if (DataValidation.IsValidProductCode(txtProductCode.Text))
{
if (handler != null)
{
AddUpdateProductHandler(handler);
}
}
else
{
MessageBox.Show("Invalid Product code, it should be 5 digits number only, please check and try again");
}
}
public void AddSubscription(string groupName, List <string> tagList, DataChangedEventHandler onDataChange)
{
if (!_server.IsConnected)
{
Console.WriteLine("Connection to OPC server is not established");
return;
}
// Create group
Opc.Da.Subscription group;
Opc.Da.SubscriptionState groupState = new Opc.Da.SubscriptionState();
groupState.Name = groupName;
groupState.Active = true;
groupState.UpdateRate = 200;
// Short circuit if group already exists
SubscriptionCollection existingCollection = _server.Subscriptions;
if (existingCollection.Count > 0)
{
for (int i = 0; i < existingCollection.Count; i++)
{
if (existingCollection[i].Name == groupName)
{
Console.WriteLine(String.Format("Subscription group {0} already exists", groupName));
return;
}
}
}
group = (Opc.Da.Subscription)_server.CreateSubscription(groupState);
// Create list of items to monitor
Item[] opcItems = new Item[1];
int j = 0;
foreach (string tag in tagList)
{
opcItems[j] = new Item();
opcItems[j].ItemName = tag;
j++;
}
// Attach items and event to group
group.AddItems(opcItems);
//group.DataChanged += new Opc.Da.DataChangedEventHandler(OPCSubscription_DataChanged);
group.DataChanged += new Opc.Da.DataChangedEventHandler(onDataChange);
}
private void AddUpdateProductHandler(DataChangedEventHandler handler)
{
try
{
Product product = new Product();
product.ProductCode = Convert.ToInt32(txtProductCode.Text);
product.ProductDescription = txtProductDescription.Text != null ? txtProductDescription.Text : "";
product.RetailPriceIncVAT = Convert.ToDecimal(RetailPriceIncVAT.Text);
product.VATRate = Convert.ToDecimal(txtVATRate.Text);
product.Barcodes = txtBarcode.Text != null ? txtBarcode.Text : "";
handler(product, new EventArgs());
}
catch (Exception)
{
// ToDo
// Add validation in decimal fields to take numbers input only
MessageBox.Show("ToDo: Add validation in decimal fields to take numbers input only.");
}
}
private void SaveChangesPA_PAT_Assessments()
{
foreach (var assessment in PA_PAT_ASSESSMENTS_CONTEXT.PA_PAT_ASSESSMENTS.Local.ToList())
{
if (assessment.ID == 0)
{
PA_PAT_ASSESSMENTS_CONTEXT.PA_PAT_ASSESSMENTS.Remove(assessment);
}
}
try
{
PA_PAT_ASSESSMENTS_CONTEXT.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
var sb = new StringBuilder();
sb.AppendLine("DbUpdateException error details - {ex?.InnerException?.InnerException?.Message}");
foreach (var eve in ex.Entries)
{
sb.AppendLine("Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated");
}
var error = sb.ToString();
MessageBox.Show(error);
//throw;
}
catch (Exception ex1)
{
var error1 = ex1.ToString();
MessageBox.Show(error1);
}
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
}
private void Save_click(object sender, RoutedEventArgs e)
{
if (user != Name_text.Text)
{
db.saveUserNameChanges(user, Name_text.Text);
}
if (Pass.Password != String.Empty && Name_text.Text.Length >= 5)
{
db.saveUserPassChanges(user, Pass.Password);
}
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void btn_saveAndExit(object sender, RoutedEventArgs e)
{
if (selectedDates.Count == 0)
{
CreateAgendaObject();
}
else
{
CreateRepeatableAgendaObjects();
}
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(createdAgendas, new EventArgs());
}
this.Close();
}
private void AddCustomer_Executed(object sender, ExecutedRoutedEventArgs e)
{
foreach (var features in Geo_Features_Context.GEOGRAPHIC_FEATURES.Local.ToList())
{
if (features.WAYPOINT_ID == 0)
{
Geo_Features_Context.GEOGRAPHIC_FEATURES.Remove(features);
}
}
try
{
Geo_Features_Context.SaveChanges();
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
WaypointIDTextBox.IsEnabled = false;
}
catch (DbUpdateException ex)
{
var sb = new StringBuilder();
sb.AppendLine("DbUpdateException error details - {ex?.InnerException?.InnerException?.Message}");
foreach (var eve in ex.Entries)
{
sb.AppendLine("Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated");
}
var error = sb.ToString();
MessageBox.Show(error);
//throw;
}
catch (Exception ex1)
{
var error1 = ex1.ToString();
MessageBox.Show(error1);
}
}
/// <summary>
/// Called when a data changed event is received.
/// </summary>
public void OnEvent(
int hClientSubscription,
int bRefresh,
int bLastRefresh,
int dwCount,
ONEVENTSTRUCT[] pEvents)
{
LicenseHandler.ValidateFeatures(LicenseHandler.ProductFeature.AlarmsConditions, true);
try
{
lock (this)
{
// do nothing if no connections.
if (DataChangedEventHandler == null)
{
return;
}
// un marshal item values.
TsCAeEventNotification[] notifications = Interop.GetEventNotifications(pEvents);
foreach (var notification in notifications)
{
notification.ClientHandle = clientHandle_;
}
if (!LicenseHandler.IsExpired)
{
// invoke the callback.
DataChangedEventHandler?.Invoke(notifications, bRefresh != 0, bLastRefresh != 0);
}
}
}
catch (Exception e)
{
Utils.Trace(e, "Exception '{0}' in event handler.", e.Message);
string stack = e.StackTrace;
}
}
/// <summary>
/// Sends a data update callback.
/// </summary>
private void OnUpdate(object stateInfo)
{
try
{
do
{
object clientHandle = null;
ItemValueResult[] values = null;
DataChangedEventHandler callback = null;
lock (this)
{
// check if subscription object has been disposed.
if (m_disposed)
{
return;
}
if (m_updateQueue.Count == 0)
{
break;
}
callback = m_dataChanged;
clientHandle = m_state.ClientHandle;
values = (ItemValueResult[])m_updateQueue.Dequeue();
}
if (callback != null)
{
callback(clientHandle, null, values);
}
}while (true);
}
catch (Exception e)
{
string message = e.Message;
}
}
public void AddSubscription(string groupName, List<string> tagList, DataChangedEventHandler onDataChange)
{
if (!_server.IsConnected) {
Console.WriteLine("Connection to OPC server is not established");
return;
}
// Create group
Opc.Da.Subscription group;
Opc.Da.SubscriptionState groupState = new Opc.Da.SubscriptionState();
groupState.Name = groupName;
groupState.Active = true;
groupState.UpdateRate = 200;
// Short circuit if group already exists
SubscriptionCollection existingCollection = _server.Subscriptions;
if (existingCollection.Count > 0) {
for(int i = 0; i < existingCollection.Count; i++){
if (existingCollection[i].Name == groupName) {
Console.WriteLine(String.Format("Subscription group {0} already exists", groupName));
return;
}
}
}
group = (Opc.Da.Subscription)_server.CreateSubscription(groupState);
// Create list of items to monitor
Item[] opcItems = new Item[1];
int j = 0;
foreach (string tag in tagList) {
opcItems[j] = new Item();
opcItems[j].ItemName = tag;
j++;
}
// Attach items and event to group
group.AddItems(opcItems);
//group.DataChanged += new Opc.Da.DataChangedEventHandler(OPCSubscription_DataChanged);
group.DataChanged += new Opc.Da.DataChangedEventHandler(onDataChange);
}
