using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using DocuWare.Platform.ServerClient;
using DocuWare.WebIntegration;
using System.Configuration;
using M3Workflow.Data;
using M3Workflow.Data.Base;
using System.Data.Sql;
using System.Data.SqlClient;
using System.IO;

namespace M3Workflow.Web
{
    /// <summary>
    /// Summary description for PostInvoice
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class PostInvoice : System.Web.Services.WebService
    {

        [WebMethod]
        public string Complete(string cabinetId, int documentId)
        {
            Boolean autolog = (ConfigurationManager.AppSettings["M3_INVOICE_AUTOLOG"].ToString() == "1") ? true : false;

            string logDir = HttpContext.Current.Server.MapPath("~/");
            string logFile = Path.Combine(logDir, Guid.NewGuid().ToString() + ".txt");

            Guid cabinet;
            if (Guid.TryParse(cabinetId, out cabinet))
            {
                try
                {
                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Trying to connect to Docuware...\n");
                    }
                    var connection = ServiceConnection.Create(
                        new Uri(
                            String.Format(
                                "{0}://{1}/docuware/platform",
                                new object[] {
                            ConfigurationManager.AppSettings["DOCUWARE_SERVER_PROTOCOL"].ToString(),
                            ConfigurationManager.AppSettings["DOCUWARE_SERVER"].ToString()
                                }
                            )
                        ),
                        ConfigurationManager.AppSettings["DOCUWARE_ADMIN_USER"].ToString(),
                        ConfigurationManager.AppSettings["DOCUWARE_ADMIN_PASS"].ToString()

                    );

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Connected to Docuware...\n");
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile,
                            String.Format(
                                "Trying to get document from Docuware with documentId = {0} & cabinetId = {1}...\n",
                                new object[]
                                {
                                    documentId,
                                    cabinetId
                                }
                            )
                        );
                    }

                    var document = connection.GetFromDocumentForDocumentAsync(documentId, cabinetId).Result;

                    if (autolog)
                    {
                        if (document.IsSuccessStatusCode)
                        {
                            File.AppendAllText(logFile, "Got document from Docuware...\n");
                        }
                    }


                    if (autolog)
                    {
                        if (document.IsSuccessStatusCode)
                        {
                            File.AppendAllText(logFile, "Checking to see if document's field count is greater than zero...\n");
                        }
                    }

                    DocumentIndexFields fields = document.Content.GetDocumentIndexFieldsFromFieldsRelation();

                    if (autolog)
                    {
                        if (document.IsSuccessStatusCode)
                        {
                            File.AppendAllText(logFile, "Field count is " + fields.Field.Count.ToString() + "...\n");
                        }
                    }

                    if (autolog)
                    {
                            File.AppendAllText(logFile, "Trying to create json document connect to service with unencrypted credentials...\n");
                    }

                    AuthDataObject auth = JsonDataObject.FromJsonString<AuthDataObject>(
                        Encrypt.DecryptString(
                            fields["CREDS"].Item.ToString(),
                            ConfigurationManager.AppSettings["BBDS_ENCRYPT_PASSWORD"].ToString()
                        )
                    );

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Created auth object with unencrypted values (not yet attempted to connect)...\n");
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Building list of accounts...\n");
                    }

                    List<AccountPostDataObject> accounts = new List<AccountPostDataObject>();


                    if(autolog)
                    {
                        for(int i = 0; i != fields.Field.Count; i++)
                        {
                            Console.WriteLine();
                            string fieldName = fields.Field[0].FieldName;
                            string fieldValue = fields.Field[0].Item.ToString();
                        }
                    }


                    for (int i = 0; i <= 11; i++)
                    {
                        string fieldNameAccount = "ACCOUNT_" + (i + 1).ToString("000");
                        string fieldNameAmount = "AMOUNT_" + (i + 1).ToString("000");
                        if (fields[fieldNameAccount].Item.ToString() != String.Empty && fields[fieldNameAmount].Item.ToString() != "0.00")
                        {
                            string[] accountNum = fields[fieldNameAccount].Item.ToString().Split(' ');
                            accounts.Add(
                                new AccountPostDataObject(
                                    //fields[fieldNameAccount].Item.ToString(),
                                    accountNum[0],
                                    Decimal.Parse(fields[fieldNameAmount].Item.ToString()),
                                    false,
                                    i
                                )
                            );
                        }
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Found " + accounts.Count + " accounts...\n");
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Trying to connect to M3 service...\n");
                    }

                    UserDataObject udo = M3DataProvider.Authenticate(auth.UserName, auth.Password);

                    if (autolog) {
                        if(udo.Roles.Count > 0)
                        {
                            File.AppendAllText(logFile, "Auth successful got a token : " + udo.Token.ToString() + "...\n");
                        }
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Getting vendor and creating invoiceDataObject...\n");
                    }

                    var vendor = (
                        from v in M3DataProvider.GetVendors(
                            udo.Token,
                            Guid.Parse(fields["CUSTOMER_ID"].Item.ToString()),
                            Guid.Parse(fields["COMPANYID"].Item.ToString())
                            ).Vendors
                        where v.VendorName == fields["VENDORNAME"].Item.ToString()
                        select v
                    ).SingleOrDefault();

                    InvoiceDataObject invoiceDataObject = new InvoiceDataObject(
                        vendor.Id,
                        Guid.Parse(fields["COMPANYID"].Item.ToString()),
                        fields["INVOICENUMBER"].Item.ToString(),
                        Decimal.Parse(fields["INVOICE_AMOUNT"].Item.ToString()),
                        false,
                        false,
                        true,
                        accounts,
                        null,
                        Guid.Parse(fields["PROPERTYID"].Item.ToString()),
                        DateTime.Parse(fields["INVOICEDATE"].Item.ToString()),
                        DateTime.Parse(fields["DUE_DATE"].Item.ToString()),
                        (fields["PO_NUMBER"].Item.ToString() == String.Empty) ? String.Empty : fields["PO_NUMBER"].Item.ToString(),
                        fields["DESCRIPTION"].Item.ToString(),
                        DateTime.Now,
                        DateTime.Parse(fields["ACCOUNTING_PERIOD_DATE"].Item.ToString())
                    );

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Getting vendor and creating invoiceDataObject completed...\n");
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Attempting to post invoice...\n");
                    }

                    InvoicePostDataObject pdo = new InvoicePostDataObject(invoiceDataObject);

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Invoice posted...\n");
                    }

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Trying to parse result..\n");
                    }

                    InvoicePostResultDataObject iprdo = M3DataProvider.GetInvoicePostResult(
                        udo.Token,
                        Guid.Parse(fields["CUSTOMER_ID"].Item.ToString()),
                        pdo
                    );

                    if (autolog)
                    {
                        File.AppendAllText(logFile, "Got invoice number : " + iprdo.Invoice.InvoiceNumber.ToString() + "...\n");
                    }



                    if (autolog)
                    {

                        var json = Newtonsoft.Json.JsonConvert.SerializeObject(pdo).ToString();


                        SqlConnection cn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["IntelligentIndexingWorkflow"].ToString());
                        cn2.Open();
                        SqlCommand cmd = new SqlCommand("INSERT INTO [InvoiceTransactions] (Originator, Json) VALUES (@Originator, @Json)", cn2);
                        cmd.Parameters.AddWithValue("@Originator", "Service");
                        cmd.Parameters.AddWithValue("@Json", json);
                        cmd.ExecuteNonQuery();
                        cn2.Close();
                    }


                    if (iprdo.Invoice.Success)
                    {
                        return iprdo.Invoice.InvoiceId.ToString();
                    }
                    else
                    {
                        if (iprdo.Invoice.Reason != null)
                        {
                            return iprdo.Invoice.Reason[0].Description;
                        }
                        else
                        {
                            return "SERVICE EXCEPTION";
                        }
                    }
                }
                catch
                {
                    return "SERVICE EXCEPTION";
                }
            }
            else
            {
                return "SERVICE EXCEPTION";
            }
        }
    }
}