/*
Developer: Tyler Allen
Date Created: 08/24/2016
---------------------------------------------------
*/

using System;
using System.Configuration;
using System.Linq;
using System.Xml;
using CPE.App.NotifyConsole.Extensions;
using CPE.App.NotifyConsole.Models;
using CPE.App.NotifyConsole.Models.Enums;
using IBS.Connect.API;
using IBS.Connect.API.Enums;
using Action = IBS.Connect.API.Action;

namespace CPE.App.NotifyConsole.Helpers {
    /// <summary>
    /// </summary>
    public class AdobeHelper {
        private Session _adobeConnectSession;

        /// <summary>
        /// </summary>
        /// <returns></returns>
        private Session getAdobeConnectSession() {
            if(_adobeConnectSession == null) {
                string login = null;
                string password = null;
                string url = null;
                long? accountId = null;
                try {
                    login = ConfigurationManager.AppSettings["Adobe_Login"];
                    password = ConfigurationManager.AppSettings["Adobe_Password"];
                    url = ConfigurationManager.AppSettings["Adobe_Url"];
                    accountId = int.Parse(ConfigurationManager.AppSettings["Adobe_AccountId"]);
                } catch (Exception exception) {
                    exception.Log(LoggingLevels.Fatal);
                    return null;
                }
                var connectSession = new Session(new Uri(url)) {
                    AccountId = accountId,
                    LoginId = login,
                    Password = password
                };
                if(connectSession.Login()) {
                    _adobeConnectSession = connectSession;
                }
            }
            return _adobeConnectSession;
        }

        /// <summary>
        /// </summary>
        /// <param name="meetingSession"></param>
        /// <param name="context"></param>
        /// <returns></returns>
        public bool GetAdobeTransactions(MeetingSession meetingSession, CPEWebDataContext context) {
            var boolResult = false;

            // Test if the session has ended.
            if(!meetingSession.EndDate.HasValue) {
                return false;
            }

            // Get an Adobe Connect session and test for valid session.
            var connectSession = getAdobeConnectSession();
            if(connectSession == null) {
                return false;
            }


            // Get the transaction for the meeting session from Adobe Connect
            var dateCreatedFilter = meetingSession.StartDate.AddHours(-6)
                                                  .ToString("yyyy-MM-dd");
            var request = new Request {
                Actions = {
                    new Action("report-bulk-consolidated-transactions") {
                        Filters = {
                            new Filter {
                                Field = "sco-id",
                                Value = meetingSession.SCO_ID
                            },
                            new Filter {
                                Field = "date-created",
                                FilterModifier = FilterModifiers.GreaterThan,
                                Value = dateCreatedFilter
                            }
                        }
                    }
                }
            };
            request.ActionsXml.Log();
            request.ExecuteUrl.Log();
            var response = request.Execute(connectSession);
            response.Status.Log();
            response.XmlString.Log();
            if(response.Status == ResponseStatus.OK) {
                // Delete the old records that are no longer valid
                var oldRecords = context.AdobeTransactions.Where(x => x.MeetingSessionKey == meetingSession.MeetingSessionKey);
                context.AdobeTransactions.DeleteAllOnSubmit(oldRecords);

                var xml = response.Xml;
                var nodes = xml.SelectNodes("//row");
                foreach (XmlNode node in nodes) {
                    node.OuterXml.Log();
                    var dateString = node.SelectSingleNode("date-created")
                                         .InnerText;
                    var offSetString = dateString.Substring(dateString.Length - 6, 6);
                    var offSet = int.Parse(offSetString.Substring(1, 2));
                    dateString = dateString.Replace(offSetString, "");
                    var dateStart = DateTime.Parse(dateString)
                                            .AddHours(offSet);
                    var transaction = new AdobeTransaction {
                        Created = DateTime.UtcNow,
                        Principal_ID = int.Parse(node.Attributes["principal-id"].Value),
                        MeetingSessionKey = meetingSession.MeetingSessionKey,
                        StartDate = dateStart,
                        EndDate = node.SelectSingleNode("date-closed") == null ? (meetingSession.EndDate ?? DateTime.UtcNow) : DateTime.Parse(node.SelectSingleNode("date-closed")
                                                                                                                                                                                         .InnerText.Replace(offSetString, ""))
                                                                                                                                                                              .AddHours(offSet)
                    };

                    context.AdobeTransactions.InsertOnSubmit(transaction);
                }
                context.SubmitChanges();
                boolResult = true;
            }
            return boolResult;
        }

        /// <summary>
        /// </summary>
        /// <param name="meetingSession"></param>
        /// <param name="context"></param>
        /// <returns></returns>
        public bool GetAdobeCertificateTransactions(MeetingSession meetingSession, CPEWebDataContext context) {
            var boolResult = false;

            if(!meetingSession.EndDate.HasValue) {
                return false;
            }

            var connectSession = getAdobeConnectSession();
            if(connectSession == null) {
                return false;
            }

            var oldRecords = context.AdobeCertificateTransactions.Where(x => x.MeetingSessionKey == meetingSession.MeetingSessionKey);
            context.AdobeCertificateTransactions.DeleteAllOnSubmit(oldRecords);

            var request = new Request {
                Actions = {
                    new Action("report-bulk-objects") {
                        Filters = {
                            new Filter {
                                Field = "sco-id",
                                Value = meetingSession.SCO_ID
                            }
                        }
                    }
                }
            };
            request.ActionsXml.Log();
            request.ExecuteUrl.Log();
            var response = request.Execute(connectSession);
            response.Status.Log();
            response.XmlString.Log();
            if(response.Status == ResponseStatus.OK) {
                var xml = response.Xml;
                var nodes = xml.SelectNodes("//row");
                foreach (XmlNode node in nodes) {
                    var description = node.SelectSingleNode("description")
                                          .InnerText;
                    var fields = description.Split('|');
                    var presenter = fields.FirstOrDefault(p => p.Contains("Presenter"));
                    presenter = presenter?.Substring(presenter.IndexOf('=') + 1);
                    var fos = fields.FirstOrDefault(f => f.Contains("FOS") || f.Contains("Field of Study"));
                    fos = fos?.Substring(fos.IndexOf('=') + 1);
                    var transaction = new AdobeCertificateTransaction {
                        Created = DateTime.UtcNow,
                        MeetingSessionKey = meetingSession.MeetingSessionKey,
                        Fos = fos,
                        Presenter = presenter
                    };
                    context.AdobeCertificateTransactions.InsertOnSubmit(transaction);
                }
                boolResult = true;
            }
            return boolResult;
        }
    }
}