using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data.OleDb;
using DocuWare.Platform.ServerClient;

namespace PremierMigration
{
    public class Program
    {
        public static Dictionary<string, string> TableCabinetMatch { get; set; }

        /*
public static Dictionary<string, string> TableCabinetMatch = new Dictionary<string, string>()
{
{"ACCIDENT", "Accident"},
{"ACCOUNTI", "Accounting"},
{"ACCOUNTS", "Accounts Payable"},
{"AR", "AR"},
{"AR_PAY", "ARPAY"},
{"BROKERCO", "BROKERCONTRACTS"},
{"CARGO", "CARGOCLAIMS"},
{"CHTEXPT", "CHTEXPT"},
{"CHTMAN", "CHTQCMMANIFESTS"},
{"CHTOUT", "CHTQCMOUT"},
{"CHTQCM", "CHTQCM"},
{"CONTRACT", "CONTRACTS"},
{"CORPORAT", "CORPORATE"},
{"CORRESPO", "CORRESPONDENCE"},
{"DRIVEQUA", "DRIVEQUAL"},
{"EV_AR", "EV ACCT REC"},
{"EV_PR", "EVPAYROLL"},
{"EV_SAFE", "EV_SAFETY"},
{"EVACCT", "EVANSVILLE ACCT RECEIVABLE"},
{"EXEC_DOC", "EXEC_DOCS"},
{"HR", "HR"},
{"HRINS", "HRINS"},
{"I9", "I9"},
{"MAIN_WO", "MAIN_WO"},
{"MAINT", "MAINT"},
{"MEDICALR", "MEDICAL RECORDS"},
{"MIS_VEND", "MIS_VENDORS"},
{"OO_TERM", "OWNEROPERATOR_TERM"},
{"OSD", "OSD"},
{"OUTBOUND", "OUTBOUNDQCM"},
{"PAYROLL", "PAYROLL"},
{"PNI", "PNI"},
{"PROGTRUC", "PROGTRUCK"},
{"PRTAXES", "PRTAXES"},
{"QCMMAN", "QCMMANIFESTS"},
{"QCMOUT", "QCMOUTBOUND"},
{"RESUMES", "RESUMES"},
{"SAFETY", "SAFETY"},
{"SHIPDOCS", "SHIPPING"},
{"TARIFF", "TARIFF ITEM"},
{"TARRIFFS", "TARRIFFS"},
{"TARRIFIT", "TARRIFITEMS"},
{"TEST", "TEST"},
{"TRAINING", "TRAINING"},
{"TRUCKS", "TRUCKS"},
{"TWIC", "TWIC"},
{"UPCOUNT", "UPCONTAINERS"},
{"UPLTL", "UPLTL" },
{"UPQCM", "UPQCM"},
{"VENDCERT", "VENDOR INS CERTS"},
{"VIR", "VIR"},
{"WKMNCOMP", "WORKMANS COMP"},
{"YARDAPPS", "YARDAPPS"}
};
*/

        static void Main(string[] args)
        {
            LoadTableMappings();
            CommandLineParams commandLineParams = new CommandLineParams();
            CommandLine.Parser.Default.ParseArgumentsStrict(args, commandLineParams);
            DirectoryInfo diImageRootPath = null;
            DirectoryInfo diExportPath = null;
            try
            {
                diImageRootPath = new DirectoryInfo(commandLineParams.ImagePathRoot);
                diExportPath = new DirectoryInfo(commandLineParams.ExportPath);
            }
            catch
            {
                Console.WriteLine();
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("The path specificed in the -p argument does not exist. Please specify the correct image root path.");
                Console.WriteLine("--- or ---");
                Console.WriteLine("The path specified in the -e argument does not exist and/or could not be created. Please specify the correct path or make sure you have sufficient privileges to create a directory.");
                Console.ForegroundColor = ConsoleColor.White;
                Console.WriteLine();
                return;
            }
            if (!diImageRootPath.Exists)
            {
                Console.WriteLine();
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("The path specificed in the -p argument : \"" + diImageRootPath.FullName + "\"\n\nDoes not exist. Please specify the correct image root path.");
                Console.ForegroundColor = ConsoleColor.White;
                Console.WriteLine();
                return;
            }
            if (!diExportPath.Exists)
            {
                try
                {
                    diExportPath.Create();
                }
                catch
                {
                    Console.WriteLine();
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("The path specified in the -e argument : \"" + diExportPath.FullName + "\"\n\nDoes not exist and/or could not be created. Please specify the correct path or make sure you have sufficient privileges to create a directory.");
                    Console.ForegroundColor = ConsoleColor.White;
                    Console.WriteLine();
                    return;
                }
            }

            if (diImageRootPath.Exists && diExportPath.Exists)
            {
                if (!IsSqlConnectionValid())
                {
                    Console.WriteLine();
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("Unable to connect to the SQL server, please check your app.config for the correct values.");
                    Console.ForegroundColor = ConsoleColor.White;
                    Console.WriteLine();
                    return;
                }
                if (!IsDocuwareServiceConnectionValid())
                {
                    Console.WriteLine();
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("Unable to connect to the DOCUWARE server, please check your app.config for the correct values.");
                    Console.ForegroundColor = ConsoleColor.White;
                    Console.WriteLine();
                    return;
                }
                if (!IsCabinetValid(commandLineParams.ImagePathRoot, commandLineParams.CabinetName))
                {
                    Console.WriteLine();
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("The specified cabinet does not exist.");
                    Console.ForegroundColor = ConsoleColor.White;
                    Console.WriteLine();
                    return;
                }
                Guid exportBatchId = CreateExportBatch(commandLineParams.CabinetName);
                if (exportBatchId == Guid.Empty)
                {
                    Console.WriteLine();
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("Unable to create Export Log.");
                    Console.ForegroundColor = ConsoleColor.White;
                    Console.WriteLine();
                    return;
                }
                // whew, everything is ready to go, all we have to do is check to see if the cabinet exists before trying to export
                Console.WriteLine();
                Console.ForegroundColor = ConsoleColor.Green;
                Console.WriteLine("-------------------------------------\n");
                Console.WriteLine("Image root path exists!");
                Console.WriteLine("Export path exists!");
                Console.WriteLine("Sql connection is valid!");
                Console.WriteLine("Docuware service connection is valid!");
                Console.WriteLine("Cabinet exists!");
                Console.WriteLine("Export batch created!\n");
                Console.WriteLine("-------------------------------------");
                Console.ForegroundColor = ConsoleColor.White;
                Console.WriteLine();
                // all the logic exists here.
                MigrationBuilder migrationBuilder = new MigrationBuilder(commandLineParams, exportBatchId);
                migrationBuilder.Run();
            }
            else
            {
                Console.WriteLine();
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Either the image root path doesn't exist or you do not have permission to create directories for the pdf export.");
                Console.ForegroundColor = ConsoleColor.White;
                Console.WriteLine();
                return;
            }
        }

        static void LoadTableMappings()
        {
            TableCabinetMatch = (ConfigurationManager.GetSection("tableMapping") as System.Collections.Hashtable)
                             .Cast<System.Collections.DictionaryEntry>()
                             .ToDictionary(n => n.Key.ToString(), n => n.Value.ToString());
        }

        static Guid CreateExportBatch(String cabinet)
        {
            Guid ExportBatchId = Guid.NewGuid();
            OleDbConnection oleDbConnection = GetNewOleDbConnection();
            OleDbCommand oleDbCommand = new OleDbCommand("INSERT INTO [ExportLog].[dbo].[ExportBatch] ([Id], [CabinetName]) VALUES (?, ?);", oleDbConnection);
            oleDbCommand.CommandType = System.Data.CommandType.Text;
            oleDbCommand.CommandText = "INSERT INTO [ExportLog].[dbo].[ExportBatch] ([Id], [CabinetName]) VALUES (?, ?);";
            oleDbCommand.Parameters.AddWithValue("@Id", ExportBatchId);
            oleDbCommand.Parameters.AddWithValue("@CabinetName", cabinet);
            int resultCount = oleDbCommand.ExecuteNonQuery();
            if (resultCount != 1)
                ExportBatchId = Guid.Empty;
            oleDbConnection.Close();
            oleDbConnection.Dispose();
            return ExportBatchId;
        }

        static string GetConnectionString()
        {
            String result = String.Empty;
            result = String.Format(
                "Provider=sqloledb;Data Source={0};Initial Catalog={1};User Id={2};Password={3};Connect Timeout=1200;Timeout=1200",
                new object[]
                {
                    ConfigurationManager.AppSettings["SQL_SERVER"].ToString(),
                    "DOCUWARE",
                    ConfigurationManager.AppSettings["SQL_UNAME"].ToString(),
                    ConfigurationManager.AppSettings["SQL_PASS"].ToString()
                }
            );
            return result;
        }

        static Uri GetDocuwareServiceConnectionUri()
        {
            Uri result = null;
            result = new Uri(
                String.Format(
                    "http://{0}/docuware/platform",
                    new object[]
                    {
                        ConfigurationManager.AppSettings["DW_SERVER"].ToString()
                    }
                )
            );
            return result;
        }

        static Boolean IsSqlConnectionValid()
        {
            Boolean result = false;
            OleDbConnection oleDbConnection = new OleDbConnection(GetConnectionString());
            try
            {
                oleDbConnection.Open();
                if (oleDbConnection.State == System.Data.ConnectionState.Open)
                {
                    result = true;
                }
                else
                {
                    result = false;
                }
            }
            catch
            {
                result = false;
            }
            try
            {
                oleDbConnection.Close();
                oleDbConnection.Dispose();
            }
            catch { }
            return result;
        }

        static Boolean IsDocuwareServiceConnectionValid()
        {
            Boolean result = false;
            try
            {
                ServiceConnection serviceConnection = ServiceConnection.Create(
                    GetDocuwareServiceConnectionUri(),
                    ConfigurationManager.AppSettings["DW_UNAME"].ToString(),
                    ConfigurationManager.AppSettings["DW_PASS"].ToString(),
                    userAgent: new System.Net.Http.Headers.ProductInfoHeaderValue[]
                    {
                        new System.Net.Http.Headers.ProductInfoHeaderValue("Premier+Migration+Application", "1.0")
                    }
                );

                serviceConnection.Disconnect();
                result = true;
            }
            catch
            {
                result = false;
            }
            return result;
        }

        public static OleDbConnection GetNewOleDbConnection()
        {
            OleDbConnection result = new OleDbConnection(GetConnectionString());
            result.Open();
            return result;
        }

        public static ServiceConnection GetNewServiceConnection()
        {
            ServiceConnection serviceConnection = 
                ServiceConnection.Create(
                    GetDocuwareServiceConnectionUri(),
                    ConfigurationManager.AppSettings["DW_UNAME"].ToString(),
                    ConfigurationManager.AppSettings["DW_PASS"].ToString(),
                    userAgent: new System.Net.Http.Headers.ProductInfoHeaderValue[]
                    {
                        new System.Net.Http.Headers.ProductInfoHeaderValue("Premier+Migration+Application", "1.0")
                    }
                );
            serviceConnection.HttpClient.Timeout = new System.TimeSpan(0, 20, 0);
            return serviceConnection;
        }

        static Boolean IsCabinetValid(String imageRootPath, String cabinetName)
        {
            Boolean result = false;
            String cabinetPath = Path.Combine(imageRootPath, cabinetName.ToUpper()) + ".001";
            DirectoryInfo diCabinetPath = null;
            try
            {
                diCabinetPath = new DirectoryInfo(cabinetPath);
                if (diCabinetPath.Exists) result = true; else result = false;
            }
            catch
            {
                result = false;
            }
            return result;
        }

    }
}