aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.DataCapture/app.config
blob: ff251eb7dac65586065248dfd8d287b9e8ef30e7 (plain) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --></configSections>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Reactive.Core" publicKeyToken="94bc3704cddfc263" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.0.3000.0" newVersion="3.0.3000.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Collections.Immutable" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.2.2.0" newVersion="1.2.2.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Reflection.Metadata" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.4.2.0" newVersion="1.4.2.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.IO.FileSystem" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.ValueTuple" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.2.0" newVersion="4.0.2.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.IO.Compression" publicKeyToken="b77a5c561934e089" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.2.0.0" newVersion="4.2.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.IO.FileSystem.Primitives" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Security.Cryptography.Primitives" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.2.0" newVersion="4.0.2.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Xml.XPath.XDocument" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.1.0.0" newVersion="4.1.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Console" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.2.0" newVersion="4.0.2.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Diagnostics.StackTrace" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.1.0.0" newVersion="4.1.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Xml.ReaderWriter" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.1.1.0" newVersion="4.1.1.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Data.Edm" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-5.6.4.0" newVersion="5.6.4.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Data.Services.Client" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-5.6.4.0" newVersion="5.6.4.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Data.OData" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-5.6.4.0" newVersion="5.6.4.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.IdentityModel.Clients.ActiveDirectory" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.19.8.16603" newVersion="3.19.8.16603" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Security.Cryptography.Algorithms" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.3.0.0" newVersion="4.3.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Text.Encoding.CodePages" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.1.0.0" newVersion="4.1.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>
generated by cgit v1.3.1 (git 2.54.0) at 2026-07-10 10:05:01 +0000
066; font-weight: bold } /* Name.Tag */ .highlight .nv { color: #336699 } /* Name.Variable */ .highlight .ow { color: #008800 } /* Operator.Word */ .highlight .w { color: #bbbbbb } /* Text.Whitespace */ .highlight .mb { color: #0000DD; font-weight: bold } /* Literal.Number.Bin */ .highlight .mf { color: #0000DD; font-weight: bold } /* Literal.Number.Float */ .highlight .mh { color: #0000DD; font-weight: bold } /* Literal.Number.Hex */ .highlight .mi { color: #0000DD; font-weight: bold } /* Literal.Number.Integer */ .highlight .mo { color: #0000DD; font-weight: bold } /* Literal.Number.Oct */ .highlight .sa { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Affix */ .highlight .sb { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Backtick */ .highlight .sc { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Char */ .highlight .dl { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Delimiter */ .highlight .sd { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Doc */ .highlight .s2 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Double */ .highlight .se { color: #0044dd; background-color: #fff0f0 } /* Literal.String.Escape */ .highlight .sh { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Heredoc */ .highlight .si { color: #3333bb; background-color: #fff0f0 } /* Literal.String.Interpol */ .highlight .sx { color: #22bb22; background-color: #f0fff0 } /* Literal.String.Other */ .highlight .sr { color: #008800; background-color: #fff0ff } /* Literal.String.Regex */ .highlight .s1 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Single */ .highlight .ss { color: #aa6600; background-color: #fff0f0 } /* Literal.String.Symbol */ .highlight .bp { color: #003388 } /* Name.Builtin.Pseudo */ .highlight .fm { color: #0066bb; font-weight: bold } /* Name.Function.Magic */ .highlight .vc { color: #336699 } /* Name.Variable.Class */ .highlight .vg { color: #dd7700 } /* Name.Variable.Global */ .highlight .vi { color: #3333bb } /* Name.Variable.Instance */ .highlight .vm { color: #336699 } /* Name.Variable.Magic */ .highlight .il { color: #0000DD; font-weight: bold } /* Literal.Number.Integer.Long */
using Google.Protobuf;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data.Entity.Validation;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Tango.Core.Commands;
using Tango.Core.Helpers;
using Tango.BL.Entities;
using Tango.Integration.ExternalBridge;
using Tango.MachineStudio.Common.Notifications;
using Tango.MachineStudio.Common.StudioApplication;
using Tango.MachineStudio.Synchronization.Navigation;
using Tango.PMR.Integration;
using Tango.SharedUI;
using Tango.Synchronization;
using Tango.Synchronization.Local;
using Tango.Synchronization.Remote;
using Tango.Core.DI;

namespace Tango.MachineStudio.Synchronization.ViewModels
{
    /// <summary>
    /// Represents the 'Direct Synchronization' view model.
    /// </summary>
    /// <seealso cref="Tango.SharedUI.ViewModel" />
    public class DirectSynchronizationViewVM : ViewModel
    {
        private SyncNavigationManager _navigation;
        private String _slaveDBFile;
        private String _masterDBFile;
        private LocalDBComparer _comparer;
        private INotificationProvider _notification;
        private String _comparedSerialNumber;
        private MainViewVM _mainView;

        #region Constructors

        /// <summary>
        /// Initializes a new instance of the <see cref="DirectSynchronizationViewVM"/> class.
        /// </summary>
        /// <param name="applicationManager">The application manager.</param>
        /// <param name="navigation">The navigation.</param>
        /// <param name="notification">The notification.</param>
        public DirectSynchronizationViewVM(IStudioApplicationManager applicationManager, SyncNavigationManager navigation, INotificationProvider notification)
        {
            ApplicationManager = applicationManager;

            _navigation = navigation;
            _notification = notification;

            BackCommand = new RelayCommand(() => _navigation.NavigateTo(NavigationView.MenuView));

            Differences = new ObservableCollection<Diff>();

            CompareCommand = new RelayCommand(Compare, (x) => !IsWorking && SelectedMachine != null);
            CommitAllCommand = new RelayCommand(Synchronize, (x) => Differences.Count > 0 && !IsWorking && SelectedMachine != null);
        }

        #endregion

        #region Commands

        /// <summary>
        /// Gets or sets the back command.
        /// </summary>
        public RelayCommand BackCommand { get; set; }

        /// <summary>
        /// Gets or sets the browse master database command.
        /// </summary>
        public RelayCommand BrowseMasterDBCommand { get; set; }

        /// <summary>
        /// Gets or sets the browse slave database command.
        /// </summary>
        public RelayCommand BrowseSlaveDBCommand { get; set; }

        /// <summary>
        /// Gets or sets the compare command.
        /// </summary>
        public RelayCommand CompareCommand { get; set; }

        /// <summary>
        /// Gets or sets the commit command.
        /// </summary>
        public RelayCommand CommitCommand { get; set; }

        /// <summary>
        /// Gets or sets the commit all command.
        /// </summary>
        public RelayCommand CommitAllCommand { get; set; }

        /// <summary>
        /// Gets or sets the clean command.
        /// </summary>
        public RelayCommand CleanCommand { get; set; }

        #endregion

        #region Properties

        public IStudioApplicationManager ApplicationManager { get; set; }

        private bool _isWorking;
        /// <summary>
        /// Gets or sets a value indicating whether this instance is working.
        /// </summary>
        public bool IsWorking
        {
            get { return _isWorking; }
            set { _isWorking = value; RaisePropertyChangedAuto(); }
        }

        private bool _isClearMachine;
        /// <summary>
        /// Gets or sets a value indicating whether this instance is clear machine.
        /// </summary>
        public bool IsClearMachine
        {
            get { return _isClearMachine; }
            set
            {
                _isClearMachine = value;
                RaisePropertyChangedAuto();
            }
        }

        private ObservableCollection<Diff> _differences;
        /// <summary>
        /// Gets or sets the differences.
        /// </summary>
        public ObservableCollection<Diff> Differences
        {
            get { return _differences; }
            set { _differences = value; RaisePropertyChanged(nameof(Differences)); }
        }

        private Diff _selectedDifference;
        /// <summary>
        /// Gets or sets the selected difference.
        /// </summary>
        public Diff SelectedDifference
        {
            get { return _selectedDifference; }
            set { _selectedDifference = value; RaisePropertyChanged(nameof(SelectedDifference)); InvalidateRelayCommands(); }
        }

        private Machine _selectedMachine;
        /// <summary>
        /// Gets or sets the selected machine.
        /// </summary>
        public Machine SelectedMachine
        {
            get { return _selectedMachine; }
            set { _selectedMachine = value; RaisePropertyChangedAuto(); InvalidateRelayCommands(); }
        }

        #endregion

        #region Event Handlers

        private void Comparer_Progress(object sender, string e)
        {
            if (_mainView == null)
            {
                _mainView = TangoIOC.Default.GetInstance<MainViewVM>();
                _mainView.Log = String.Empty;
            }

            _mainView.Log += ("[" + DateTime.Now.ToTimeString() + "]  " + e + Environment.NewLine);
        }

        #endregion

        #region Private Methods

        /// <summary>
        /// Compares the selected machine against the remote database.
        /// </summary>
        private void Compare()
        {
            if (SelectedMachine.SerialNumber != ApplicationManager.ConnectedMachine.As<ExternalBridgeTcpClient>().SerialNumber)
            {
                if (!_notification.ShowQuestion("The selected machine serial number does not match the connected machine. Are you sure you want to continue?"))
                {
                    return;
                }
            }

            Task.Factory.StartNew(async () =>
            {
                using (_notification.PushTaskItem("Downloading machine database..."))
                {
                    try
                    {
                        IsWorking = true;
                        InvalidateRelayCommands();
                        Thread.Sleep(1500);

                        ApplicationManager.ConnectedMachine.UseKeepAlive = false;

                        var response = await ApplicationManager.ConnectedMachine.SendRequest<DirectSynchronizationRequest, DirectSynchronizationResponse>(new DirectSynchronizationRequest(), TimeSpan.FromSeconds(60));

                        using (_notification.PushTaskItem("Generating temporary files..."))
                        {
                            var tempFolder = TemporaryManager.CreateFolder();

                            //File path for the reflected remote data base SQLite.
                            _masterDBFile = Path.Combine(tempFolder, "Remote.db");
                            //File path for the received machine SQLite db.
                            _slaveDBFile = Path.Combine(tempFolder, "Local.db");

                            //Save the machine db to file.
                            File.WriteAllBytes(_slaveDBFile, response.Message.LocalDB.ToByteArray());

                            //Copy the SQLite db template.
                            File.Copy(Path.Combine(PathHelper.GetStartupPath(), "Tango.db"), _masterDBFile);

                            //Synchronize the SQL Server db with the new SQLite template. (Overwrite basically)
                            RemoteDBSynchronizer.Synchronize(_masterDBFile, SelectedMachine.SerialNumber, true);

                            _comparedSerialNumber = SelectedMachine.SerialNumber;

                            using (_notification.PushTaskItem("Comparing database..."))
                            {
                                _comparer = new LocalDBComparer(new SQLiteDataBase(_masterDBFile), new SQLiteDataBase(_slaveDBFile));
                                _comparer.Progress += Comparer_Progress;

                                var diffs = _comparer.Compare();
                                Differences = new ObservableCollection<Diff>(diffs);

                                if (diffs.Where(x => x.Action != DiffAction.ReplaceTableDataInSlave).Count() > 0)
                                {
                                    ShowInfo("Found " + Differences.Where(x => x.Action != DiffAction.ReplaceTableDataInSlave).Count() + " differences.");
                                }
                                else
                                {
                                    ShowInfo("The machine database is synchronized.");
                                }
                            }
                        }
                    }
                    catch (DbEntityValidationException ex)
                    {
                        String message = "The following validation errors occurred." + Environment.NewLine + Environment.NewLine;

                        foreach (var error in ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).ToList())
                        {
                            message += error.ErrorMessage + Environment.NewLine;
                        }

                        ShowError(message);
                    }
                    catch (Exception ex)
                    {
                        ShowError(ex.Message);
                    }
                    finally
                    {
                        IsWorking = false;
                        SelectedDifference = null;
                        InvalidateRelayCommands();
                        ApplicationManager.ConnectedMachine.UseKeepAlive = true;
                    }
                }
            });
        }


        /// <summary>
        /// Synchronizes the selected machine with the remote database.
        /// </summary>
        private void Synchronize()
        {
            if (IsClearMachine)
            {
                if (!_notification.ShowQuestion("This will erase and override the existing machine database. Do you want to proceed?"))
                {
                    return;
                }
            }

            if (SelectedMachine.SerialNumber != _comparedSerialNumber)
            {
                _notification.ShowError("You have selected a different machine serial number after comparing. Please compare again if you wish to synchronize a different machine.");
                return;
            }

            Task.Factory.StartNew(async () =>
            {
                using (_notification.PushTaskItem("Synchronizing..."))
                {
                    try
                    {
                        ApplicationManager.ConnectedMachine.UseKeepAlive = false;

                        IsWorking = true;
                        InvalidateRelayCommands();
                        Thread.Sleep(1500);

                        for (int i = 0; i < Differences.Count; i++)
                        {
                            var diff = Differences[i];

                            diff.Commit();
                            InvokeUINow(() => Differences.Remove(diff));
                            i--;
                        }

                        _comparer.Dispose();

                        byte[] remoteDbBytes = IsClearMachine ? File.ReadAllBytes(_masterDBFile) : File.ReadAllBytes(_slaveDBFile);

                        var response = await ApplicationManager.ConnectedMachine.SendRequest<OverrideDataBaseRequest, OverrideDataBaseResponse>(new OverrideDataBaseRequest()
                        {
                            RemoteDB = ByteString.CopyFrom(remoteDbBytes)
                        }, TimeSpan.FromSeconds(30));

                        if (!response.Message.Successful)
                        {
                            ShowError("The remote machine has reported some error while trying to override the database.");
                        }
                        else
                        {
                            //Synchronize the SQL Server db with the synchronized master DB.
                            RemoteDBSynchronizer.Synchronize(_masterDBFile, _comparedSerialNumber, false);

                            PathHelper.TryDeleteFile(_slaveDBFile);
                            PathHelper.TryDeleteFile(_masterDBFile);
                            _slaveDBFile = null;
                            _masterDBFile = null;
                            InvalidateRelayCommands();
                        }
                    }
                    catch (Exception ex)
                    {
                        ShowError(ex.Message);
                    }
                    finally
                    {
                        IsWorking = false;
                        SelectedDifference = null;
                        InvalidateRelayCommands();
                        ApplicationManager.ConnectedMachine.UseKeepAlive = true;
                    }
                }
            });
        }

        /// <summary>
        /// Displays an error message.
        /// </summary>
        /// <param name="message">The message.</param>
        private void ShowError(String message)
        {
            InvokeUINow(() => _notification.ShowError(message));
        }

        /// <summary>
        /// Displays an information message.
        /// </summary>
        /// <param name="message">The message.</param>
        private void ShowInfo(String message)
        {
            InvokeUINow(() => _notification.ShowInfo(message));
        }

        #endregion
    }
}
generated by cgit v1.3.1 (git 2.54.0) at 2026-07-10 10:05:01 +0000