Beispiel #1
0
        /// <summary>
        /// Initializes the excel bot.
        /// </summary>
        public static void Initialize()
        {
            Debug.Listeners.Add(new ConsoleTraceListener());

            string currentDirectory = Path.GetDirectoryName(Path.GetFullPath(Assembly.GetExecutingAssembly().Location));
            string inputPath        = Path.Combine(currentDirectory, "BotConfig.xlsx");

            InitializationHelper.BotConfigFilePath = Path.Combine(currentDirectory, "BotConfig.xml");
            BotInfo botInfo = InteropHelper.LoadExcelSpreadsheet(inputPath, InitializationHelper.BotConfigFilePath);

            Logger.Log("Spreadhseet loaded, xml generated at " + InitializationHelper.BotConfigFilePath);

            UCBotHost ucBotHost = new UCBotHost(botInfo.ApplicationUserAgent, botInfo.ApplicationUserAgent, "Sorry, I was not able to understand you.".EncloseRtf());

            ucBotHost.Run();

            ucBotHost.ErrorOccurred += new BuildABot.Core.ErrorEventHandler(ucBotHost_ErrorOccurred);

            Logger.Log("UCBotHost created, now initializing...");
            ucBotHost.Run();
        }
Beispiel #2
0
        /// <summary>
        /// Loads the excel spreadsheet.
        /// </summary>
        /// <param name="inputFilePath">The input file path.</param>
        /// <param name="outputFilePath">The output file path.</param>
        /// <returns>Bot configuration information.</returns>
        internal static BotInfo LoadExcelSpreadsheet(string inputFilePath, string outputFilePath)
        {
            Excel.Application xlApp      = null;
            Excel.Workbook    xlWorkBook = null;
            BotInfo           botInfo    = new BotInfo();

            try
            {
                xlApp      = new Excel.Application();
                xlWorkBook = xlApp.Workbooks.Open(inputFilePath);

                XDocument xDoc = new XDocument();
                xDoc.Add(new XElement("bot"));

                foreach (Excel.Worksheet worksheet in xlWorkBook.Worksheets)
                {
                    Excel.Range range = worksheet.UsedRange;
                    if (worksheet.Name == "botInfo")
                    {
                        for (int rowCount = 1; rowCount <= range.Rows.Count; rowCount++)
                        {
                            string propertyName  = (string)(range.Cells[rowCount, 1] as Excel.Range).Value2;
                            string propertyValue = (string)(range.Cells[rowCount, 2] as Excel.Range).Value2;
                            switch (propertyName)
                            {
                            case "ApplicationUrn":
                                botInfo.ApplicationUrn = propertyValue;
                                break;

                            case "ApplicationUserAgent":
                                botInfo.ApplicationUserAgent = propertyValue;
                                break;
                            }
                        }
                    }
                    else
                    {
                        XElement qaRootNode;
                        if (worksheet.Name == "static")
                        {
                            qaRootNode = new XElement("parameterlessQAs");
                            PopulateQARootNode(range, qaRootNode, "qa", "question", "answer");
                        }
                        else
                        {
                            qaRootNode = new XElement("parameterizedQA");
                            qaRootNode.Add(new XAttribute("regexPattern", worksheet.Name.Replace('<', '[').Replace('>', ']')));
                            PopulateQARootNode(range, qaRootNode, "match", "term", "reply");
                        }
                        xDoc.Root.Add(qaRootNode);
                        ReleaseObject(worksheet);
                    }
                }

                xDoc.Save(outputFilePath);
                return(botInfo);
            }
            finally
            {
                if (xlWorkBook != null)
                {
                    xlWorkBook.Close(true, null, null);
                }
                if (xlApp != null)
                {
                    xlApp.Quit();
                }

                ReleaseObject(xlWorkBook);
                ReleaseObject(xlApp);
            }
        }