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;

using System;

using System.Windows;

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

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

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

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

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

                    };

                }

                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)//파일이름 경로 저장 및 파일 저장 하면 바로 저장되게! 

        {

            try

            {

                SaveFileDialog saveFileDialog = new SaveFileDialog();

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

                saveFileDialog.FileName = "Convert_" + today;

                saveFileDialog.Title = "Convert_" + 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, "Convert_" + 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, "Convert PDF", ExcelSource, headers);

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                System.Windows.MessageBox.Show(ex.ToString());

            }

        }

        #endregion

        #endregion

    }

}