MARKUS

using Markus.Service.StationController.Data;

using Markus.Service.StationController.Extensions;

using Microsoft.Win32;

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Telerik.Windows.Controls;

namespace Markus.Service.StationController.ViewModel

{

    class FinalPDFExcelDialogViewModel : Mvvm.ToolKit.ViewModelBase

    {

        #region Construrtor

        public FinalPDFExcelDialogViewModel()

        {

            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="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="Revision"},

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

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

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

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

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

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

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

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

                    };

                }

                return _ItemsSource;

            }

            set

            {

                _ItemsSource = value;

                OnPropertyChanged(() => ExcelSource);

            }

        }

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

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

        {

            get

            {

                if (_ExcelSource == null)

                {

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

                    _ExcelSource = FinalPDFViewModel.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();

            var today = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss");

            saveFileDialog.FileName = "Final_" + today;

            saveFileDialog.Title = "Final_" + today;

            saveFileDialog.DefaultExt = ".txt";

            saveFileDialog.CreatePrompt = true;

            saveFileDialog.OverwritePrompt = false;

            saveFileDialog.CheckFileExists = false;

            saveFileDialog.CheckPathExists = false;

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

            saveFileDialog.FilterIndex = 2;

            saveFileDialog.RestoreDirectory = true;

            if (saveFileDialog.ShowDialog() == true)

            {

                string filename = saveFileDialog.FileName;

                if (saveFileDialog.FileName.Contains("\\"))

                {

                    filename = saveFileDialog.FileName.Substring(saveFileDialog.FileName.LastIndexOf("\\") + 1);

                }

                filename = saveFileDialog.FileName.Replace(filename, "Final_" + today);

                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 });

                            }

                        }

                        DataExport dataExport = new DataExport();

                        dataExport.DataExportExcel(filename + extension, "Final PDF", ExcelSource, headers);//saveFileDialog.FileName

                    }

                }

            }

        }

        #endregion

        #endregion

    }

}