MARKUS

using Markus.Service.StationController.Data;

using Markus.Service.StationController.Extensions;

using System.Collections.Generic;

using Microsoft.Win32;

using Telerik.Windows.Controls;

using System.Collections.ObjectModel;

namespace Markus.Service.StationController.ViewModel

{

    class ConvertExcelDialogViewModel : Mvvm.ToolKit.ViewModelBase

    {

        #region Construrtor

        public ConvertExcelDialogViewModel()

        {

            ALL_SelectedCommand = new DelegateCommand(ALL_Selected);

            ALL_DeletedCommand = new DelegateCommand(ALL_Deleted);

            SaveCommand = new DelegateCommand(Save);

        }

        #endregion

        #region Propertise

        public ObservableCollection<CheckBoxItem> _ItemsSource;

        public ObservableCollection<CheckBoxItem> ItemsSource

        {

            get

            {

                if (_ItemsSource == null)

                {

                    ItemsSource = new ObservableCollection<CheckBoxItem>

                    {

                        new CheckBoxItem { IsChecked=true, Name="ServiceID"},

                        new CheckBoxItem { IsChecked=true, Name="ConvertID"},

                        new CheckBoxItem { IsChecked=true, Name="ProjectNumber"},

                        new CheckBoxItem { IsChecked=true, Name="ConvertState"},

                        new CheckBoxItem { IsChecked=true, Name="CurrentPageNo"},

                        new CheckBoxItem { IsChecked=true, Name="TotalPage"},

                        new CheckBoxItem { IsChecked=true, Name="OriginfilePath"},

                        new CheckBoxItem { IsChecked=true, Name="ConvertPath"},

                        new CheckBoxItem { IsChecked=true, Name="CreateTime"},

                        new CheckBoxItem { IsChecked=true, Name="StartTime"},

                        new CheckBoxItem { IsChecked=true, Name="EndTime"},

                        new CheckBoxItem { IsChecked=true, Name="Exception"},

                        new CheckBoxItem { IsChecked=true, Name="ReConverter"},

                        new CheckBoxItem { IsChecked=true, Name="Revision"},

                        new CheckBoxItem { IsChecked=true, Name="UniqueKey"},

                        new CheckBoxItem { IsChecked=true, Name="Group_NO"},

                        new CheckBoxItem { IsChecked=true, Name="Document_NO"},

                        new CheckBoxItem { IsChecked=true, Name="Document_Name"}

                    };

                }

                return _ItemsSource;

            }

            set

            {

                _ItemsSource = value;

                OnPropertyChanged(() => ExcelSource);

            }

        }

        private System.Collections.ObjectModel.ObservableCollection<ConvertPDF> _ExcelSource;

        public System.Collections.ObjectModel.ObservableCollection<ConvertPDF> ExcelSource

        {

            get

            {

                if (_ExcelSource == null)

                {

                    _ExcelSource = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>();

                    _ExcelSource = DataBaseItemsModel.Return_FilterConvertSource();

                }

                return _ExcelSource;

            }

            set

            {

                _ExcelSource = value;

                OnPropertyChanged(() => ExcelSource);

            }

        }

        #endregion

        #region Command

        public DelegateCommand ALL_SelectedCommand { get; private set; }

        public DelegateCommand ALL_DeletedCommand { get; private set; }

        public DelegateCommand SaveCommand { get; private set; }

        #endregion

        #region Fuction

        #region ALL_Selected

        public void ALL_Selected(object obj)

        {

            foreach(var ItemsSource in ItemsSource)

            {

                ItemsSource.IsChecked = true;

            }

        }

        #endregion

        #region ALL_Deleted

        public void ALL_Deleted(object obj)

        {

            foreach (var ItemsSource in ItemsSource)

            {

                ItemsSource.IsChecked = false;

            }

        }

        #endregion

        #region Save

        public void Save(object obj)

        {

            SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.FileName = "Document"; // Default file name

            saveFileDialog.DefaultExt = ".txt"; // Default file extension

            saveFileDialog.Filter = "Csv documents (.Csv)|*.csv|Excel(2017~2019)Worksheets|*.xlsx"; // Filter files by extension

            if (saveFileDialog.ShowDialog() == true)

            {

                if (!string.IsNullOrWhiteSpace(saveFileDialog.FileName))

                {

                    var extension = new System.IO.FileInfo(saveFileDialog.FileName).Extension;

                    if (extension == ".xlsx" || extension == ".csv")

                    {

                        List<HeaderMember> headers = new List<HeaderMember>();

                        foreach(var ItemsSource in ItemsSource)

                        {

                            if (ItemsSource.IsChecked == true)

                            {

                                headers.Add(new HeaderMember { HeaderName = ItemsSource.Name, Property = ItemsSource.Name });

                            }

                        }

                        //    var headers = new List<HeaderMember>

                        //{

                        //new HeaderMember{HeaderName = "ServiceID", Property = "ServiceID" },

                        //new HeaderMember{HeaderName = "ConvertID", Property = "ConvertID" },

                        //new HeaderMember{HeaderName = "ProjectNumber", Property = "ProjectNumber" },

                        //new HeaderMember{HeaderName = "ConvertState", Property = "ConvertState" },

                        //new HeaderMember{HeaderName = "CurrentPageNo", Property = "CurrentPageNo" },

                        //new HeaderMember{HeaderName = "TotalPage", Property = "TotalPage" },

                        //new HeaderMember{HeaderName = "OriginfilePath", Property = "OriginfilePath" },

                        //new HeaderMember{HeaderName = "ConvertPath", Property = "ConvertPath" },

                        //new HeaderMember{HeaderName = "CreateTime", Property = "CreateTime" },

                        //new HeaderMember{HeaderName = "Exception", Property = "Exception" },

                        //new HeaderMember{HeaderName = "ReConverter", Property = "ReConverter" },

                        //new HeaderMember{HeaderName = "UniqueKey", Property = "UniqueKey" }

                        //};

                        // new HeaderMember{HeaderName = "ProcessorAffinity", Property = "ProcessorAffinity" },

                        DataExport dataExport = new DataExport();

                        dataExport.DataExportExcel(saveFileDialog.FileName, "Convert PDF", ExcelSource, headers);

                    }

                }

            }

        }

        #endregion

        #endregion

    }

}