// This method will take in a String value of an Excel cell
        // and tries to parse to a valid Pickup Frequency
        public static Site.PickupFrequency ParseFrequency(String pickupFrequency)
        {
            //Set the parsed frequency to initially be invalid
            Site.PickupFrequency parsedFrequency = Site.PickupFrequency.Invalid;

            //Check for all allowable values for the pickup frequency string and set the parsed frequency accordingly
            switch (pickupFrequency.ToLower())
            {
            case "weekly":
                parsedFrequency = Site.PickupFrequency.Weekly;
                break;

            case "bi-weekly":
            case "biweekly":
                parsedFrequency = Site.PickupFrequency.BiWeekly;
                break;

            case "twice a week":
                parsedFrequency = Site.PickupFrequency.Weekly;
                break;

            default:
                parsedFrequency = Site.PickupFrequency.Invalid;
                break;
            }

            return(parsedFrequency);
        }
        public void TestThatParseSiteFrequencyWithInvalidFrequencyReturnsInvalid()
        {
            Site.PickupFrequency frequency = SiteParser.ParseFrequency("kljas");

            Assert.IsTrue(frequency == Site.PickupFrequency.Invalid);
        }
        public void TestThatParseSiteFrequencyBiWeeklyValidFrequency()
        {
            Site.PickupFrequency frequency = SiteParser.ParseFrequency("Bi-Weekly");

            Assert.IsTrue(frequency == Site.PickupFrequency.BiWeekly);
        }