Exemple #1
0
        public List <Term> loadTerms()
        {
            List <Term> termList = new List <Term>();
            President   p;
            Term        t;

            // 1st President
            p                      = new President();
            p.name                 = "George Washington";
            p.birthDate            = new DateTime(1732, 2, 22);
            p.deathDate            = new DateTime(1799, 12, 14);
            p.politicalAffiliation = PoliticalAffiliation.None;
            t                      = new Term(new DateTime(1789, 4, 30), new DateTime(1797, 3, 4), p);
            termList.Add(t);

            // 2nd President
            p                      = new President();
            p.name                 = "John Adams";
            p.birthDate            = new DateTime(1735, 10, 30);
            p.deathDate            = new DateTime(1826, 7, 4);
            p.politicalAffiliation = PoliticalAffiliation.Federalist;
            t                      = new Term(new DateTime(1797, 3, 4), new DateTime(1801, 3, 4), p);
            termList.Add(t);

            // 3rd President
            p                      = new President();
            p.name                 = "Thomas Jefferson";
            p.birthDate            = new DateTime(1743, 4, 13);
            p.deathDate            = new DateTime(1826, 7, 4);
            p.politicalAffiliation = PoliticalAffiliation.Federalist;
            t                      = new Term(new DateTime(1801, 3, 4), new DateTime(1809, 3, 4), p);
            termList.Add(t);

            // 4th President
            p                      = new President();
            p.name                 = "James Madison";
            p.birthDate            = new DateTime(1751, 3, 16);
            p.deathDate            = new DateTime(1836, 6, 28);
            p.politicalAffiliation = PoliticalAffiliation.DemocraticRepublican;
            t                      = new Term(new DateTime(1809, 3, 4), new DateTime(1817, 3, 4), p);
            termList.Add(t);

            // 5th President
            p                      = new President();
            p.name                 = "James Monroe";
            p.birthDate            = new DateTime(1758, 4, 28);
            p.deathDate            = new DateTime(1831, 7, 4);
            p.politicalAffiliation = PoliticalAffiliation.DemocraticRepublican;
            t                      = new Term(new DateTime(1817, 3, 4), new DateTime(1825, 3, 4), p);
            termList.Add(t);

            // 6th President
            p                      = new President();
            p.name                 = "John Quincy Adams";
            p.birthDate            = new DateTime(1767, 7, 11);
            p.deathDate            = new DateTime(1848, 2, 23);
            p.politicalAffiliation = PoliticalAffiliation.Federalist;
            t                      = new Term(new DateTime(1825, 3, 4), new DateTime(1829, 3, 4), p);
            termList.Add(t);

            // 7th President
            p                      = new President();
            p.name                 = "Andrew Jackson";
            p.birthDate            = new DateTime(1767, 3, 15);
            p.deathDate            = new DateTime(1845, 6, 8);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1829, 3, 4), new DateTime(1837, 3, 4), p);
            termList.Add(t);

            // 8th President
            p                      = new President();
            p.name                 = "Martin Van Buren";
            p.birthDate            = new DateTime(1782, 12, 5);
            p.deathDate            = new DateTime(1862, 7, 24);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1837, 3, 4), new DateTime(1841, 3, 4), p);
            termList.Add(t);

            // 9th President
            p                      = new President();
            p.name                 = "William Henry Harrison";
            p.birthDate            = new DateTime(1773, 2, 9);
            p.deathDate            = new DateTime(1841, 4, 4);
            p.politicalAffiliation = PoliticalAffiliation.Whig;
            t                      = new Term(new DateTime(1841, 3, 4), new DateTime(1841, 4, 4), p);
            termList.Add(t);

            // 10th President
            p                      = new President();
            p.name                 = "John Tyler";
            p.birthDate            = new DateTime(1790, 3, 29);
            p.deathDate            = new DateTime(1862, 1, 18);
            p.politicalAffiliation = PoliticalAffiliation.Whig;
            t                      = new Term(new DateTime(1841, 4, 4), new DateTime(1845, 3, 4), p);
            termList.Add(t);

            // 11th President
            p                      = new President();
            p.name                 = "James K. Polk";
            p.birthDate            = new DateTime(1795, 11, 2);
            p.deathDate            = new DateTime(1849, 6, 15);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1845, 3, 4), new DateTime(1849, 3, 4), p);
            termList.Add(t);

            // 12th President
            p                      = new President();
            p.name                 = "Zachary Taylor";
            p.birthDate            = new DateTime(1784, 11, 24);
            p.deathDate            = new DateTime(1850, 7, 9);
            p.politicalAffiliation = PoliticalAffiliation.Whig;
            t                      = new Term(new DateTime(1849, 3, 4), new DateTime(1850, 7, 9), p);
            termList.Add(t);

            // 13th President
            p                      = new President();
            p.name                 = "Millard Fillmore";
            p.birthDate            = new DateTime(1800, 1, 7);
            p.deathDate            = new DateTime(1874, 3, 8);
            p.politicalAffiliation = PoliticalAffiliation.Whig;
            t                      = new Term(new DateTime(1850, 7, 9), new DateTime(1853, 3, 4), p);
            termList.Add(t);

            // 14th President
            p                      = new President();
            p.name                 = "Franklin Pierce";
            p.birthDate            = new DateTime(1804, 11, 23);
            p.deathDate            = new DateTime(1869, 10, 8);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1853, 3, 4), new DateTime(1857, 3, 4), p);
            termList.Add(t);

            // 15th President
            p                      = new President();
            p.name                 = "James Buchanan";
            p.birthDate            = new DateTime(1791, 4, 23);
            p.deathDate            = new DateTime(1868, 6, 1);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1857, 3, 4), new DateTime(1861, 3, 4), p);
            termList.Add(t);

            // 16th President
            p                      = new President();
            p.name                 = "Abraham Lincoln";
            p.birthDate            = new DateTime(1809, 2, 12);
            p.deathDate            = new DateTime(1865, 4, 15);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1861, 3, 4), new DateTime(1865, 4, 15), p);
            termList.Add(t);

            // 17th President
            p                      = new President();
            p.name                 = "Andrew Johnson";
            p.birthDate            = new DateTime(1808, 12, 29);
            p.deathDate            = new DateTime(1875, 7, 31);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1865, 4, 15), new DateTime(1869, 3, 4), p);
            termList.Add(t);

            // 18th President
            p                      = new President();
            p.name                 = "Ulysses S. Grant";
            p.birthDate            = new DateTime(1822, 4, 7);
            p.deathDate            = new DateTime(1885, 7, 23);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1869, 3, 4), new DateTime(1877, 3, 4), p);
            termList.Add(t);

            // 19th President
            p                      = new President();
            p.name                 = "Rutherford B. Hayes";
            p.birthDate            = new DateTime(1822, 10, 4);
            p.deathDate            = new DateTime(1893, 1, 7);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1877, 3, 4), new DateTime(1881, 3, 4), p);
            termList.Add(t);

            // 20th President
            p                      = new President();
            p.name                 = "James A. Garfield";
            p.birthDate            = new DateTime(1831, 11, 19);
            p.deathDate            = new DateTime(1881, 9, 19);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1881, 3, 4), new DateTime(1881, 9, 19), p);
            termList.Add(t);

            // 21th President
            p                      = new President();
            p.name                 = "Chester A. Arthur";
            p.birthDate            = new DateTime(1829, 10, 5);
            p.deathDate            = new DateTime(1886, 11, 18);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1881, 9, 19), new DateTime(1885, 3, 4), p);
            termList.Add(t);

            // 22nd President
            p                      = new President();
            p.name                 = "Grover Cleveland";
            p.birthDate            = new DateTime(1837, 3, 18);
            p.deathDate            = new DateTime(1908, 6, 24);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1885, 3, 4), new DateTime(1889, 3, 4), p);
            termList.Add(t);
            t = new Term(new DateTime(1893, 3, 4), new DateTime(1897, 3, 4), p);
            termList.Add(t);

            // 23rd President
            p                      = new President();
            p.name                 = "Benjamin Harrison";
            p.birthDate            = new DateTime(1833, 8, 20);
            p.deathDate            = new DateTime(1901, 3, 13);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1889, 3, 4), new DateTime(1833, 3, 4), p);
            termList.Add(t);

            // 25th President
            p                      = new President();
            p.name                 = "William McKinley";
            p.birthDate            = new DateTime(1843, 1, 29);
            p.deathDate            = new DateTime(1901, 9, 14);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1897, 3, 4), new DateTime(1901, 9, 14), p);
            termList.Add(t);

            // 26th President
            p                      = new President();
            p.name                 = "Theodore Roosevelt";
            p.birthDate            = new DateTime(1858, 10, 27);
            p.deathDate            = new DateTime(1919, 1, 6);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1901, 9, 14), new DateTime(1909, 3, 4), p);
            termList.Add(t);

            // 27th President
            p                      = new President();
            p.name                 = "William Howard Taft";
            p.birthDate            = new DateTime(1857, 9, 15);
            p.deathDate            = new DateTime(1930, 3, 8);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1909, 3, 4), new DateTime(1913, 3, 4), p);
            termList.Add(t);

            // 28th President
            p                      = new President();
            p.name                 = "Woodrow Wilson";
            p.birthDate            = new DateTime(1856, 12, 28);
            p.deathDate            = new DateTime(1924, 2, 3);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1913, 3, 4), new DateTime(1921, 3, 4), p);
            termList.Add(t);

            // 29th President
            p                      = new President();
            p.name                 = "Warren G. Harding";
            p.birthDate            = new DateTime(1865, 11, 2);
            p.deathDate            = new DateTime(1923, 8, 3);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1921, 3, 4), new DateTime(1923, 8, 2), p);
            termList.Add(t);

            // 30th President
            p                      = new President();
            p.name                 = "Calvin Coolidge";
            p.birthDate            = new DateTime(1872, 7, 4);
            p.deathDate            = new DateTime(1933, 1, 5);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1923, 8, 2), new DateTime(1929, 3, 4), p);
            termList.Add(t);

            // 31st President
            p                      = new President();
            p.name                 = "Herbert Hoover";
            p.birthDate            = new DateTime(1874, 8, 10);
            p.deathDate            = new DateTime(1964, 10, 20);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1929, 3, 4), new DateTime(1933, 3, 4), p);
            termList.Add(t);

            // 31st President
            p                      = new President();
            p.name                 = "Herbert Hoover";
            p.birthDate            = new DateTime(1874, 8, 10);
            p.deathDate            = new DateTime(1964, 10, 20);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1929, 3, 4), new DateTime(1933, 3, 4), p);
            termList.Add(t);

            // 32nd President
            p                      = new President();
            p.name                 = "Franklin D. Roosevelt";
            p.birthDate            = new DateTime(1882, 1, 30);
            p.deathDate            = new DateTime(1845, 4, 12);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1933, 3, 4), new DateTime(1945, 4, 12), p);
            termList.Add(t);

            // 33rd President
            p                      = new President();
            p.name                 = "Harry S. Truman";
            p.birthDate            = new DateTime(1884, 5, 8);
            p.deathDate            = new DateTime(1972, 12, 26);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1945, 4, 12), new DateTime(1953, 1, 20), p);
            termList.Add(t);

            // 34th President
            p                      = new President();
            p.name                 = "Dwight D. Eisenhower";
            p.birthDate            = new DateTime(1890, 10, 14);
            p.deathDate            = new DateTime(1969, 3, 28);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1953, 1, 20), new DateTime(1961, 1, 20), p);
            termList.Add(t);

            // 35th President
            p                      = new President();
            p.name                 = "John F. Kennedy";
            p.birthDate            = new DateTime(1917, 5, 29);
            p.deathDate            = new DateTime(1963, 11, 22);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1961, 1, 20), new DateTime(1963, 11, 22), p);
            termList.Add(t);

            // 36th President
            p                      = new President();
            p.name                 = "Lyndon B. Johnson";
            p.birthDate            = new DateTime(1908, 8, 27);
            p.deathDate            = new DateTime(1973, 1, 22);
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1963, 11, 22), new DateTime(1969, 1, 20), p);
            termList.Add(t);

            // 37th President
            p                      = new President();
            p.name                 = "Richard Nixon";
            p.birthDate            = new DateTime(1913, 1, 9);
            p.deathDate            = new DateTime(1994, 4, 22);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1969, 1, 20), new DateTime(1974, 8, 9), p);
            termList.Add(t);

            // 38th President
            p                      = new President();
            p.name                 = "Gerald Ford";
            p.birthDate            = new DateTime(1913, 7, 14);
            p.deathDate            = new DateTime(2006, 12, 26);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1974, 8, 9), new DateTime(1977, 1, 20), p);
            termList.Add(t);

            // 39th President
            p                      = new President();
            p.name                 = "Jimmy Carter";
            p.birthDate            = new DateTime(1924, 10, 1);
            p.deathDate            = null;
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1977, 1, 20), new DateTime(1881, 1, 20), p);
            termList.Add(t);

            // 40th President
            p                      = new President();
            p.name                 = "Ronald Reagan";
            p.birthDate            = new DateTime(1911, 2, 6);
            p.deathDate            = new DateTime(2004, 6, 5);
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1981, 1, 20), new DateTime(1989, 1, 20), p);
            termList.Add(t);

            // 41st President
            p                      = new President();
            p.name                 = "George H.W. Bush";
            p.birthDate            = new DateTime(1924, 6, 12);
            p.deathDate            = null;
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(1989, 1, 20), new DateTime(1993, 1, 20), p);
            termList.Add(t);

            // 42nd President
            p                      = new President();
            p.name                 = "Bill Clinton";
            p.birthDate            = new DateTime(1946, 8, 19);
            p.deathDate            = null;
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(1993, 1, 20), new DateTime(2001, 1, 20), p);
            termList.Add(t);

            // 43rd President
            p                      = new President();
            p.name                 = "George W. Bush";
            p.birthDate            = new DateTime(1946, 7, 6);
            p.deathDate            = null;
            p.politicalAffiliation = PoliticalAffiliation.Republican;
            t                      = new Term(new DateTime(2001, 1, 20), new DateTime(2009, 1, 20), p);
            termList.Add(t);

            // 44th President
            p                      = new President();
            p.name                 = "Barack Obama";
            p.birthDate            = new DateTime(1961, 8, 4);
            p.deathDate            = null;
            p.politicalAffiliation = PoliticalAffiliation.Democrat;
            t                      = new Term(new DateTime(2009, 1, 20), null, p);
            termList.Add(t);

            return(termList);
        }
        public List <Term> loadTerms()
        {
            List <Term> termList = new List <Term>();
            List <Term> currentPresidentTermList;

            President presidentBeingParsed;

            Excel.Application xlApp       = new Excel.Application();
            Excel.Workbook    xlWorkbook  = xlApp.Workbooks.Open(presidentWorkbookFileName, Type.Missing, true);
            Excel.Worksheet   xlWorksheet = xlWorkbook.Sheets[1];

            // Ensures that formatting changes in 'empty' cells will not count as a cell being occupied
            xlWorksheet.Columns.ClearFormats();
            xlWorksheet.Rows.ClearFormats();

            Excel.Range xlRange  = (Excel.Range)xlWorksheet.UsedRange;
            int         rowCount = xlRange.Rows.Count;
            int         colCount = xlRange.Columns.Count;

            //Object[,] xlPresidentValues = (Object[,])xlWorksheet.Range[xlWorksheet.Cells[rowDataStart, colDataStart], xlWorksheet.Cells[rowCount, colCount]].Cells.Value2;

            // Start at 2 because the first row is the header row (and Excel indexing is NOT zero based)
            for (int i = 2; i <= rowCount; i++)
            {
                presidentBeingParsed     = new President();
                currentPresidentTermList = new List <Term>();

                for (int j = 1; j <= colCount; j++)
                {
                    switch ((PresidentDataColumn)j)
                    {
                    case PresidentDataColumn.Name:
                        if (xlRange.Cells[i, j].Text != "")
                        {
                            presidentBeingParsed.name = xlRange.Cells[i, j].Text;
                        }
                        else
                        {
                            throw new Exception("President name cannnot be null.");
                        }
                        break;

                    case PresidentDataColumn.Terms:
                        if (xlRange.Cells[i, j].Text != "")
                        {
                            currentPresidentTermList = parseExcelTermStringToTermList(xlRange.Cells[i, j].Text);
                        }
                        else
                        {
                            throw new Exception("President terms cannot be null.");
                        }
                        break;

                    case PresidentDataColumn.Born:
                        if (xlRange.Cells[i, j].Text != "")
                        {
                            //string temp = (string) xlPresidentValues[i, j];
                            presidentBeingParsed.birthDate = Convert.ToDateTime(xlRange.Cells[i, j].Text);
                        }
                        else
                        {
                            throw new Exception("President birth date cannnot be null.");
                        }
                        break;

                    case PresidentDataColumn.Died:
                        if (xlRange.Cells[i, j].Text != "")
                        {
                            presidentBeingParsed.deathDate = Convert.ToDateTime(xlRange.Cells[i, j].Text);
                        }
                        else
                        {
                            // President death date can be null if they are still alive
                            presidentBeingParsed.deathDate = null;
                        }
                        break;

                    case PresidentDataColumn.Party:
                        if (xlRange.Cells[i, j].Text != "")
                        {
                            presidentBeingParsed.politicalAffiliation = (PoliticalAffiliation)EnumUtil.GetEnumFromDescription(typeof(PoliticalAffiliation), xlRange.Cells[i, j].Text);
                        }
                        else
                        {
                            presidentBeingParsed.politicalAffiliation = PoliticalAffiliation.None;
                        }
                        break;
                    }
                }

                foreach (Term t in currentPresidentTermList)
                {
                    t.termPresident = presidentBeingParsed;
                }

                // Add currentPresidentTermList to termList
                termList.AddRange(currentPresidentTermList);
            }

            // Cleanup of interop objects
            GC.Collect();
            GC.WaitForPendingFinalizers();

            xlWorkbook.Close(false, null, null);
            xlApp.Quit();

            Marshal.ReleaseComObject(xlRange);
            Marshal.ReleaseComObject(xlWorksheet);
            Marshal.ReleaseComObject(xlWorkbook);
            Marshal.ReleaseComObject(xlApp);

            return(termList);
        }
Exemple #3
0
 public Term(DateTime startDate, DateTime?endDate, President president)
 {
     this.startDateInOffice = startDate;
     this.endDateInOffice   = endDate;
     this.termPresident     = president;
 }