public void populateCustomers()
        {
            CCINVEntities _db = new CCINVEntities();
            Customer thisCustomer = new Customer();
            List<string> CFirstName = new List<string>();
            CFirstName.Add("Steve");
            CFirstName.Add("Nancy");
            CFirstName.Add("Roger");
            CFirstName.Add("Dan");
            CFirstName.Add("Scott");
            CFirstName.Add("Nick");
            CFirstName.Add("Brandon");
            CFirstName.Add("Rachel");
            CFirstName.Add("Melissa");
            CFirstName.Add("Thomas");

            List<string> CLastName = new List<string>();
            CLastName.Add("Johnson");
            CLastName.Add("Jameson");
            CLastName.Add("Morrison");
            CLastName.Add("Einstein");
            CLastName.Add("Kwalski");
            CLastName.Add("Smith");
            CLastName.Add("Moore");
            CLastName.Add("Jones");
            CLastName.Add("Laughridge");
            CLastName.Add("Abole");

            string email_add = "@fakemail.com";
            foreach (string fname in CFirstName)
            {
                foreach (string lname in CLastName)
                {
                    thisCustomer.FirstName = fname;
                    thisCustomer.LastName = lname;
                    thisCustomer.Email = fname + "." + lname + email_add;
                    _db.Customers.Add(thisCustomer);
                }
            }
            try
            {
                _db.SaveChanges();
            }
            catch (Exception e)
            {
                //Do nothing yet
            }
        }
        public void populateItems()
        {
            CCINVEntities _db = new CCINVEntities();
            Item thisItem = new Item();

            List<string> FirstWord = new List<string>();
            List<string> SecondWord = new List<string>();

            FirstWord.Add("Small");
            FirstWord.Add("Medium");
            FirstWord.Add("Large");

            SecondWord.Add("Coffee");
            SecondWord.Add("Styrofoam");
            SecondWord.Add("Insulated");

            for (int i = 1; i < 10; i++)
            {
                foreach (string fword in FirstWord)
                {
                    foreach (string sword in SecondWord)
                    {
                        thisItem.Manufacturer_ID = i;
                        thisItem.Name = fword + " " + sword + " cup";
                        _db.Items.Add(thisItem);
                        _db.SaveChanges();
                    }
                }
            }
            try
            {
                _db.SaveChanges();
            }
            catch (Exception e)
            {
                //Do nothing yet
            }
        }
        public void populateManufacturers()
        {
            CCINVEntities _db = new CCINVEntities();
            Manufacturer thisManufacturer = new Manufacturer();

            List<string> Names = new List<string>();
            Names.Add("America's Cups");
            Names.Add("Charlie's Cup Emporium");
            Names.Add("Greenville Cups Inc");
            Names.Add("Tervis");
            Names.Add("Paper Products Cupers");
            Names.Add("Charleston's Cup Company");
            Names.Add("New York's Cups Inc");
            Names.Add("Chinese Can Cup");
            Names.Add("English Tea Cozies");

            foreach (string name in Names)
            {
                thisManufacturer.Name = name;
                _db.Manufacturers.Add(thisManufacturer);
            }
            try
            {
                _db.SaveChanges();
            }
            catch (Exception e)
            {
                //Do nothing yet
            }
        }