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
}
}