Exemple #1
0
        private void GrangeForm_Load(object sender, EventArgs e)
        {
            // initiate the parser to read from the current user profile directory
            excelParser = new ExcelParser(System.IO.Path.Combine(System.Environment.GetEnvironmentVariable("USERPROFILE"), "Metrics.xlsx"));

            // read the spreadsheet data into the employee list
            employeeList = excelParser.getEmployeeList();

            totalScoreRanking = new TotalScoreRanking();

            // add the employees from the list into the ranking object
            foreach (Employee employee in employeeList)
            {
                totalScoreRanking.addEmployee(employee);
            }

            // add the ranked employees to the listbox
            foreach (Employee employee in totalScoreRanking.getRanks())
            {
                RanksListBox.Items.Add((totalScoreRanking.getRanks().IndexOf(employee) + 1).ToString() + "          " + employee.getName());
            }
        }
        private void GrangeForm_Load(object sender, EventArgs e)
        {
            // initiate the parser to read from the current user profile directory
            excelParser = new ExcelParser(System.IO.Path.Combine(System.Environment.GetEnvironmentVariable("USERPROFILE"), "Metrics.xlsx"));

            // read the spreadsheet data into the employee list
            employeeList = excelParser.getEmployeeList();

            totalScoreRanking = new TotalScoreRanking();

            // add the employees from the list into the ranking object
            foreach(Employee employee in employeeList)
            {
                totalScoreRanking.addEmployee(employee);
            }

            // add the ranked employees to the listbox
            foreach(Employee employee in totalScoreRanking.getRanks())
            {
                RanksListBox.Items.Add((totalScoreRanking.getRanks().IndexOf(employee) + 1).ToString() + "          " +employee.getName());

            }
        }