using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Odbc;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Laserfiche.RepositoryAccess;

namespace LFStatementMerge
{

    class SearchResultRow
    {
        public string Name { get; set; }
        public string HitCount { get; set; }
        public string CreationDate { get; set; }
        public string LastModified { get; set; }
        public string Type { get; set; }
        public string PageCount { get; set; }
    }

    class Program
    {
        static void Main(string[] args)
        {
            string serverName = "demo.bbds.biz";
            string repoName = "DEMO";
            string username = "admin";
            string password = "admin";
            string seachCommand = "{LF:LookIn=\"Demo\\OTIS\\Parcels\\100789\\01\\Letters\", LF:Templatename=\"OTIS\" } & {LF:Name=\"*\",Type=\"D\"} & {[]:[Doc Type]=\"20 Day Letters\", [Letter Ref Id]=\"100789-01-DIF-SDS-20D-188214\"} | {[]:[Doc Type]=\"10 Day Letters\", [Letter Ref Id]=\"100789-01-DIF-SDS-20D-188214\"}";

            OdbcConnection cn = new OdbcConnection("DSN=xfODBC;");
            try
            {
                cn.Open();
                if (cn.State == System.Data.ConnectionState.Open)
                {
                    Console.WriteLine("Connection Open...");
                    DataSet ds = new DataSet();
                    OdbcDataAdapter da = new OdbcDataAdapter("SELECT TOP 10 * FROM HISHDR", cn);
                    da.Fill(ds);
                    Console.WriteLine("Getting top 10 rows...");
                    foreach (DataRow row in ds.Tables[0].Rows)
                    {
                        Console.WriteLine(
                            String.Format(
                                "Second field value is {0}",
                                new object[] { row[1].ToString() }
                            )
                        );
                    }

                    ds.Dispose();
                    da.Dispose();
                    cn.Close();
                    cn.Dispose();
                    Console.WriteLine("Test Completed...");
                }


            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }


            try
            {
                List<SearchResultRow> contents = new List<SearchResultRow>();
                RepositoryRegistration repository = new RepositoryRegistration(serverName, repoName);
                using (Session session = new Session())
                {
                    session.LogIn(username, password, repository);
                    using (Search search = new Search(session))
                    {
                        search.Command = seachCommand;
                        LongOperation longOp = search.BeginRun(false);
                        while (!longOp.IsCompleted)
                        {
                            Thread.Sleep(1000);
                            search.UpdateStatus();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
    }
}