Ejemplo n.º 1
0
        private static List <int> nearestNeighborIndexes = new List <int>();  // List that stores nearest neighbor indexes of neighbors

        #endregion

        #region ClusterComputer Main Computer

        public static void Start(GPSAS_DestinationsForm _instance, String _workingDirectory, String _fileName)
        {
            // Assign parent form instance
            GPSAS_DestinationsFormInstance = _instance;

            // Set working directory
            workingDirectory = _workingDirectory;

            // Load data point list into an array
            arrData = DataPoints.ToArray();
            Logger.Log("Number of valid data points: " + arrData.Length.ToString());

            // Displose of datapoint list
            DataPoints.Clear();

            // Log parameters
            logParameters();

            // Run main computer function
            try
            {
                computeClusters();
            }
            catch (Exception ex)
            {
                Logger.Log("Unable to compute clusters for file: " + _fileName);
                Logger.Log(ex.ToString());
                if (ex is OutOfMemoryException)
                {
                    MessageBox.Show("OutOfMemoryException. Computations are too large for this machine.", "Failure");
                }
                else if (ex is OverflowException)
                {
                    MessageBox.Show("OverflowException. Bounds of types have been exceeded. Parameters must be reduced to compute.", "Failure");
                }
                else
                {
                    MessageBox.Show("Parse failed.", "Failure");
                }
                return;
            }

            // Identify instance cluster times
            Dictionary <int, Double> clusterTimes = identifyClustersTimes();

            // Identify total times in area clusters
            Dictionary <int, Double> areaTimes = identifyAreaTimes(clusterTimes);

            // Write the results
            writeResults(_fileName, clusterTimes, areaTimes);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Reads the provided excel file into a data set.
        /// </summary>
        /// <param name="parentInstance">Instance of parent form</param>
        /// <param name="fileName">File name to be parsed.</param>
        public static void ReadData(GPSAS_DestinationsForm parentInstance, String fileName)
        {
            parentInstance.SetStatusText("Reading file");
            // Create file stream
            FileStream stream = File.Open(fileName, FileMode.Open, FileAccess.Read);
            // Create excel reader instance
            IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

            // Column names ARE in first row, but they are needed to determine column names
            excelReader.IsFirstRowAsColumnNames = false;
            // Assign data to DataSet
            DataSet dataSet = excelReader.AsDataSet();

            // Clean up
            excelReader.Close();
            stream.Close();
            // Parse data
            parseDataSet(dataSet);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Constructor.
        /// </summary>
        /// <param name="_path">Working directory to save report.</param>
        /// <param name="_arrData">Array of cluster data.</param>
        /// <param name="_numClusters">Number of clusters.</param>
        /// <param name="_instance">Instance of parent form.</param>
        public ExcelWriter(String _path, DataPoint[] _arrData, Dictionary <int, Double> _clusterTimes, Dictionary <int, Double> _areaTimes, GPSAS_DestinationsForm _instance)
        {
            this.path         = _path;
            this.arrData      = _arrData;
            this.instance     = _instance;
            this.clusterTimes = _clusterTimes;
            this.areaTimes    = _areaTimes;
            this.app          = new Application();
            this.workBook     = workBook = app.Workbooks.Add(System.Reflection.Missing.Value);

            // Generate report
            generateReport();

            // Select sheet and save workbook
            workBook.Application.ActiveWorkbook.Sheets[1].Select();
            workBook.SaveAs(this.path, XlFileFormat.xlWorkbookDefault);

            // Release memory, close writer
            ReleaseObject(workBook);
            ReleaseObject(workSheet);
            app.Quit();
            ReleaseObject(app);
        }