using DocuWare.Gapi.Client;
using DocuWare.Gapi.Command.Document;
using DocuWare.Gapi.Command.FileCabinet;
using DocuWare.Gapi.Document;
using DocuWare.Gapi.FileCabinet;
using DocuWare.Gapi.Organization;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AirgasFileDownloader
{
    class Program
    {
        static void Main(string[] args)
        {
            string dwUsername = ConfigurationManager.AppSettings["DW_USER"];
            string dwPassword = ConfigurationManager.AppSettings["DW_PASS"];
            string dwAuth = ConfigurationManager.AppSettings["DW_WINAUTH"];

            IGapiClient gapiClient = Gapi.newClient();

            bool auth = Boolean.Parse(dwAuth);
            if (auth)
            {
                gapiClient.LoginWindowsAuthentication();
            }
            else
            {
                try
                {
                    gapiClient.LoginDocuWareAuthentication(dwUsername, dwPassword);
                }
                catch (System.Exception ex)
                {
                    Console.WriteLine(ex.Message);
                    return;
                }
            }

            if (gapiClient.ClientStatus == GapiClientStatus.LoggedIn)
            {
                IFileCabinet fileCabinet;
                DataTable dataTable;
                try
                {
                    dataTable = BuildExportTable(gapiClient, out fileCabinet);
                    StartExport(dataTable, fileCabinet);
                } catch(Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                
            }
            else
            {
                Console.WriteLine("Not connected.");
                return;
            }

        }

        static DataTable BuildExportTable(IGapiClient gapiClient, out IFileCabinet fileCabinet)
        {
                         
            DataTable result = new DataTable();

            IOrganization org = gapiClient.Organization;

            fileCabinet = org.GetFileCabinet(
                Guid.Parse(ConfigurationManager.AppSettings["DW_FILECAB_GUID"].ToString())
            );

            SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DWData"].ToString());
            sqlConnection.Open();
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(
                //"SELECT DISTINCT [DWDOCID], [FILE_TYPE] FROM [dbo].[" + fileCabinet.DBName + "];", 
                String.Format(
                    ConfigurationManager.AppSettings["DW_SQL"].ToString(),
                    new object[]
                    {
                        fileCabinet.DBName
                    }
                ),
                sqlConnection
            );
            DataSet dataSet = new DataSet();
            sqlDataAdapter.Fill(dataSet);
            sqlDataAdapter.Dispose();
            sqlConnection.Close();
            sqlConnection.Dispose();

            result = dataSet.Tables[0];

            return result;

        }

        static void StartExport(DataTable dataTable, IFileCabinet fileCabinet)
        {
            foreach (DataRow dataRow in dataTable.Rows)
            {
                long DWDOCID;

                try
                {
                    DWDOCID = long.Parse(dataRow["DWDOCID"].ToString());

                    IFiledDocument filedDocument = fileCabinet.GetDocument(DWDOCID);
                    IExportCommand exportCommand = filedDocument.Commands.newExport();
                    
                    exportCommand.ExportMode = ExportMode.DocuWareName;

                    DirectoryInfo diExportFolder = new DirectoryInfo(
                        Path.Combine(
                            ConfigurationManager.AppSettings["DW_EXPORT_DIR"],
                            DWDOCID.ToString()
                        )
                    );

                    if (!diExportFolder.Exists)
                    {
                        try
                        {
                            diExportFolder.Create();
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine("ERROR : " + ex.Message);
                            continue;
                        }
                    }

                    exportCommand.TargetPath = diExportFolder.FullName;

                    exportCommand.Execute();

                    string[] exportedFiles = exportCommand.Ret_ExportedFiles;

                    if (exportedFiles.Length > 1)
                    {
                        foreach (string exportedFile in exportedFiles)
                        {
                            Console.WriteLine(exportedFile);
                        }
                    }

                    exportCommand.Dispose();
                    Console.WriteLine(
                        String.Format(
                            "Document with DWDOCID = {0} exported.",
                            new object[]
                            {
                                DWDOCID
                            }
                        )
                    );
                } catch (Exception ex)
                {
                    Console.WriteLine("ERROR : " + ex.Message);
                    continue;
                }                                                             
            }
        }
    }
}