aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.Synchronization/Views/MenuView.xaml
blob: b7f37b022082548cb4a875c4b1e6abfbc02ba39b (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
<UserControl x:Class="Tango.MachineStudio.Synchronization.Views.MenuView"
             xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
             xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" 
             xmlns:materialDesign="http://materialdesigninxaml.net/winfx/xaml/themes"
             xmlns:d="http://schemas.microsoft.com/expression/blend/2008" 
             xmlns:local="clr-namespace:Tango.MachineStudio.Synchronization.Views"
             xmlns:global="clr-namespace:Tango.MachineStudio.Synchronization"
             mc:Ignorable="d" 
             d:DesignHeight="720" d:DesignWidth="1280" DataContext="{x:Static global:ViewModelLocator.MenuViewVM}">
    <Grid>
        <Grid>
            <Viewbox MaxWidth="1600">
                <UniformGrid Columns="3">
                    <Grid VerticalAlignment="Center">
                        <StackPanel>
                            <StackPanel HorizontalAlignment="Center" Margin="0 0 0 30">
                                <TextBlock TextAlignment="Center" FontSize="25">Local Synchronization</TextBlock>
                                <TextBlock TextAlignment="Center" FontSize="14" Foreground="#303030">Synchronize two SQLite local database files.</TextBlock>
                            </StackPanel>
                            <Viewbox RenderOptions.BitmapScalingMode="Fant" Width="400">
                                <Grid Width="450">
                                    <StackPanel>
                                        <StackPanel Orientation="Horizontal">
                                            <Image Source="../Images/sqlite.png" Width="160"></Image>
                                            <Image Source="../Images/arrow_right.png" Width="100" RenderTransformOrigin="0.5,0.5"></Image>
                                            <Image Source="../Images/sqlite.png" Width="130"></Image>
                                        </StackPanel>

                                        <Button Command="{Binding StartLocalSyncCommand}" Height="80" Margin="0 20 0 0" HorizontalAlignment="Center" Padding="10" FontSize="20" Width="200">START</Button>
                                    </StackPanel>
                                </Grid>
                            </Viewbox>
                        </StackPanel>
                    </Grid>

                    <Grid VerticalAlignment="Center">
                        <StackPanel>
                            <StackPanel HorizontalAlignment="Center" Margin="0 0 0 30">
                                <TextBlock TextAlignment="Center" FontSize="25">Direct Remote Synchronization</TextBlock>
                                <TextBlock TextAlignment="Center" FontSize="14" Foreground="#303030">Connect and synchronized a Tango machine over the network.</TextBlock>
                            </StackPanel>
                            <Viewbox RenderOptions.BitmapScalingMode="Fant" Width="400">
                                <Grid Width="450">
                                    <StackPanel>
                                        <StackPanel Orientation="Horizontal">
                                            <Image Source="../Images/remote-db.png" Width="200"></Image>
                                            <Image Source="../Images/arrow_right.png" Width="100"></Image>
                                            <Image Source="../Images/machine-trans.png" Width="120"></Image>
                                        </StackPanel>

                                        <Button Command="{Binding StartDirectRemoteSyncCommand}" Height="80"  Margin="0 20 0 0" HorizontalAlignment="Center" Padding="10" FontSize="20" Width="200">START</Button>
                                    </StackPanel>
                                </Grid>
                            </Viewbox>
                        </StackPanel>
                    </Grid>

                    <Grid VerticalAlignment="Center">
                        <StackPanel>
                            <StackPanel HorizontalAlignment="Center" Margin="0 0 0 30">
                                <TextBlock TextAlignment="Center" FontSize="25">Semi Remote Synchronization</TextBlock>
                                <TextBlock TextAlignment="Center" FontSize="14" Foreground="#303030">Synchronize local SQLite database file with the remote Twine database.</TextBlock>
                            </StackPanel>
                            <Viewbox RenderOptions.BitmapScalingMode="Fant" Width="400">
                                <Grid Width="450">
                                    <StackPanel>
                                        <StackPanel Orientation="Horizontal">
                                            <Image Source="../Images/remote-db.png" Width="200"></Image>
                                            <Image Source="../Images/arrow_right.png" Width="100"></Image>
                                            <Image Source="../Images/sqlite.png" Width="120"></Image>
                                        </StackPanel>

                                        <Button Command="{Binding StartRemoteSyncCommand}" Height="80" Margin="0 20 0 0" HorizontalAlignment="Center" Padding="10" FontSize="20" Width="200">START</Button>
                                    </StackPanel>
                                </Grid>
                            </Viewbox>
                        </StackPanel>
                    </Grid>

                </UniformGrid>
            </Viewbox>
        </Grid>
    </Grid>
</UserControl>
08800; font-weight: bold } /* Keyword */ .highlight .ch { color: #888888 } /* Comment.Hashbang */ .highlight .cm { color: #888888 } /* Comment.Multiline */ .highlight .cp { color: #cc0000; font-weight: bold } /* Comment.Preproc */ .highlight .cpf { color: #888888 } /* Comment.PreprocFile */ .highlight .c1 { color: #888888 } /* Comment.Single */ .highlight .cs { color: #cc0000; font-weight: bold; background-color: #fff0f0 } /* Comment.Special */ .highlight .gd { color: #000000; background-color: #ffdddd } /* Generic.Deleted */ .highlight .ge { font-style: italic } /* Generic.Emph */ .highlight .ges { font-weight: bold; font-style: italic } /* Generic.EmphStrong */ .highlight .gr { color: #aa0000 } /* Generic.Error */ .highlight .gh { color: #333333 } /* Generic.Heading */ .highlight .gi { color: #000000; background-color: #ddffdd } /* Generic.Inserted */ .highlight .go { color: #888888 } /* Generic.Output */ .highlight .gp { color: #555555 } /* Generic.Prompt */ .highlight .gs { font-weight: bold } /* Generic.Strong */ .highlight .gu { color: #666666 } /* Generic.Subheading */ .highlight .gt { color: #aa0000 } /* Generic.Traceback */ .highlight .kc { color: #008800; font-weight: bold } /* Keyword.Constant */ .highlight .kd { color: #008800; font-weight: bold } /* Keyword.Declaration */ .highlight .kn { color: #008800; font-weight: bold } /* Keyword.Namespace */ .highlight .kp { color: #008800 } /* Keyword.Pseudo */ .highlight .kr { color: #008800; font-weight: bold } /* Keyword.Reserved */ .highlight .kt { color: #888888; font-weight: bold } /* Keyword.Type */ .highlight .m { color: #0000DD; font-weight: bold } /* Literal.Number */ .highlight .s { color: #dd2200; background-color: #fff0f0 } /* Literal.String */ .highlight .na { color: #336699 } /* Name.Attribute */ .highlight .nb { color: #003388 } /* Name.Builtin */ .highlight .nc { color: #bb0066; font-weight: bold } /* Name.Class */ .highlight .no { color: #003366; font-weight: bold } /* Name.Constant */ .highlight .nd { color: #555555 } /* Name.Decorator */ .highlight .ne { color: #bb0066; font-weight: bold } /* Name.Exception */ .highlight .nf { color: #0066bb; font-weight: bold } /* Name.Function */ .highlight .nl { color: #336699; font-style: italic } /* Name.Label */ .highlight .nn { color: #bb0066; font-weight: bold } /* Name.Namespace */ .highlight .py { color: #336699; font-weight: bold } /* Name.Property */ .highlight .nt { color: #bb0066; 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 Microsoft.Win32;
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.DAL.Local.DB;
using Tango.BL.Entities;
using Tango.DAL.Remote.DB;
using Tango.Logging;
using Tango.MachineStudio.Common.Notifications;
using Tango.MachineStudio.Common.StudioApplication;
using Tango.MachineStudio.Synchronization.Navigation;
using Tango.Settings;
using Tango.SharedUI;
using Tango.Synchronization;
using Tango.Synchronization.Local;
using Tango.Synchronization.Remote;
using Tango.Core.DI;
using Tango.MachineStudio.Common;

namespace Tango.MachineStudio.Synchronization.ViewModels
{
    /// <summary>
    /// Represents the 'Semi Remote Synchronization' view model.
    /// </summary>
    /// <seealso cref="Tango.SharedUI.ViewModel" />
    /// <seealso cref="Tango.MachineStudio.Common.StudioApplication.IShutdownRequestBlocker" />
    public class RemoteSynchronizationViewVM : StudioViewModel<SynchronizationModule>
    {
        private SyncNavigationManager _navigation;
        private String _slaveDBFile;
        private INotificationProvider _notification;
        private bool _isWorking;
        private RemoteDBComparer _comparer;
        private RemoteDB _remoteDB;
        private LocalDB _localDB;
        private MainViewVM _mainView;
        private SynchronizationModuleSettings _settings;

        #region Constructors

        /// <summary>
        /// Initializes a new instance of the <see cref="LocalSynchronizationViewVM"/> class.
        /// </summary>
        /// <param name="navigation">The navigation.</param>
        /// <param name="notification">The notification.</param>
        public RemoteSynchronizationViewVM(SyncNavigationManager navigation, INotificationProvider notification)
        {
            _settings = SettingsManager.Default.GetOrCreate<SynchronizationModuleSettings>();

            _navigation = navigation;
            _notification = notification;

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

            Differences = new ObservableCollection<Diff>();

            BrowseSlaveDBCommand = new RelayCommand(BrowseSlaveDB, (x) => !_isWorking);
            CompareCommand = new RelayCommand(Compare, (x) => SlaveDBFile != null && !_isWorking && SelectedMachine != null);
            CommitCommand = new RelayCommand(Commit, (x) => SelectedDifference != null && !_isWorking && SelectedMachine != null);
            CommitAllCommand = new RelayCommand(CommitAll, (x) => Differences.Count > 0 && !_isWorking && SelectedMachine != null);
            CleanCommand = new RelayCommand(CleanSlave, (x) => !_isWorking && SlaveDBFile != null);

            if (File.Exists(_settings.RemoteSQLiteFile))
            {
                SlaveDBFile = _settings.RemoteSQLiteFile;
                SlaveDBName = Path.GetFileName(SlaveDBFile);
            }
        }

        #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 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 Properties

        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 String _slaveDBName;
        /// <summary>
        /// Gets or sets the name of the slave database.
        /// </summary>
        public String SlaveDBName
        {
            get { return _slaveDBName; }
            set { _slaveDBName = value; RaisePropertyChanged(nameof(SlaveDBName)); }
        }

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

        /// <summary>
        /// Gets or sets the slave database file.
        /// </summary>
        public String SlaveDBFile
        {
            get { return _slaveDBFile; }
            set { _slaveDBFile = value; RaisePropertyChangedAuto(); }
        }
        #endregion

        #region Private Methods

        /// <summary>
        /// Cleans the slave database file.
        /// </summary>
        private async void CleanSlave()
        {
            if (_notification.ShowQuestion("Are you sure you want to erase all data on slave database?"))
            {
                using (_notification.PushTaskItem("Clearing database..."))
                {
                    try
                    {
                        _isWorking = true;
                        await Task.Factory.StartNew(() =>
                        {
                            SQLiteDataBase localDB = new SQLiteDataBase(SlaveDBFile);
                            localDB.LoadTables();
                            localDB.ClearDataBase();
                            try
                            {
                                localDB.Dispose();
                            }
                            catch{ }
                        });

                        Differences.Clear();
                    }
                    catch (Exception ex)
                    {
                        ShowError(LogManager.Log(ex).Message);
                    }
                    finally
                    {
                        _isWorking = false;
                        InvalidateRelayCommands();
                        SelectedDifference = null;
                    }
                }
            }
        }

        /// <summary>
        /// Compares the remote database with the selected database file.
        /// </summary>
        private void Compare()
        {
            Task.Factory.StartNew(() =>
            {
                using (_notification.PushTaskItem("Comparing Databases..."))
                {
                    try
                    {
                        if (_comparer != null)
                        {
                            _comparer.Dispose();
                        }

                        _remoteDB = RemoteDB.CreateDefault();
                        _localDB = new LocalDB(SlaveDBFile);
                        _comparer = new RemoteDBComparer(_remoteDB, _localDB, SelectedMachine.SerialNumber);
                        _comparer.Progress += Comparer_Progress;
                        _isWorking = true;
                        InvalidateRelayCommands();
                        Thread.Sleep(1500);
                        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 master and slave databases are synchronized.");
                        }
                    }
                    catch (Exception ex)
                    {
                        ShowError(ex.Message);
                    }
                    finally
                    {
                        _isWorking = false;
                        SelectedDifference = null;
                        InvalidateRelayCommands();

                        _settings.RemoteSQLiteFile = SlaveDBFile;
                        _settings.Save();
                    }
                }
            });
        }

        /// <summary>
        /// Commits the selected difference.
        /// </summary>
        private void Commit()
        {
            Task.Factory.StartNew(() =>
            {
                using (_notification.PushTaskItem("Committing difference..."))
                {
                    try
                    {
                        _isWorking = true;
                        InvalidateRelayCommands();
                        Thread.Sleep(1500);
                        SelectedDifference.Commit();
                        _remoteDB.SaveChanges();
                        _localDB.SaveChanges();

                        InvokeUINow(() => Differences.Remove(SelectedDifference));
                    }
                    catch (Exception ex)
                    {
                        ShowError(ex.Message);
                    }
                    finally
                    {
                        _isWorking = false;
                        SelectedDifference = null;
                        InvalidateRelayCommands();
                    }
                }
            });
        }

        /// <summary>
        /// Commits all the differences.
        /// </summary>
        private void CommitAll()
        {
            Task.Factory.StartNew(() =>
            {
                using (_notification.PushTaskItem("Committing all differences..."))
                {
                    try
                    {
                        _isWorking = true;
                        InvalidateRelayCommands();
                        Thread.Sleep(1500);

                        for (int i = 0; i < Differences.Count; i++)
                        {
                            var diff = Differences[i];
                            using (_notification.PushTaskItem("Committing difference " + (Differences.IndexOf(diff) + 1) + "..."))
                            {
                                diff.Commit();
                                InvokeUINow(() => Differences.Remove(diff));
                                i--;
                            }
                        }

                        _remoteDB.SaveChanges();
                        _localDB.SaveChanges();
                    }
                    catch (DbEntityValidationException ex)
                    {
                        String message = "The following validation errors occurred while trying to update the database." + 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();
                    }
                }
            });
        }

        /// <summary>
        /// Browse for slave database file.
        /// </summary>
        private void BrowseSlaveDB()
        {
            String file = BrowseForFilePath();
            if (file != null)
            {
                SlaveDBFile = file;
                SlaveDBName = Path.GetFileName(file);
                InvalidateRelayCommands();
            }
        }

        /// <summary>
        /// Browse for database file.
        /// </summary>
        private String BrowseForFilePath()
        {
            OpenFileDialog dlg = new OpenFileDialog();
            dlg.Title = "Select SQLite Database File";
            dlg.Filter = "SQLite Database|*.db";
            if (dlg.ShowDialog().Value)
            {
                return dlg.FileName;
            }
            return null;
        }

        /// <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

        #region IStudioModuleVM

        /// <summary>
        /// Called when the application is shutting down.
        /// </summary>
        /// <returns></returns>
        public override Task<bool> OnShutdownRequest()
        {
            if (_comparer != null)
            {
                _comparer.Dispose();
            }
            return Task.FromResult(true);
        }


        #endregion
    }
}