private static void AddAddressesAndContactsToVendor(AdventureWorksContext ctx)
{
if (ctx.Vendor.Any())
{
var vendorAddresses = SampleData.GetVendorAddresses();
// AUSTRALI0001
var vendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "AUSTRALI0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var address = vendorAddresses.First(a => a.AddressLine1 == "28 San Marino Ct" && a.City == "Bellingham");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID;
ctx.Address.Add(address);
}
var contact1 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Paula" && c.MiddleName == "B." && c.LastName == "Moberly")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var contact2 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Charlene" && c.MiddleName == "J." && c.LastName == "Wojcik")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var contact3 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Jo" && c.MiddleName == "J." && c.LastName == "Zimmerman")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc1 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact1.ID, ContactTypeID = 18
};
var bc2 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact2.ID, ContactTypeID = 19
};
var bc3 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact3.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.AddRange(new List <BusinessEntityContact> {
bc1, bc2, bc3
});
// TRIKES0001
vendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "TRIKES0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
address = vendorAddresses.First(a => a.AddressLine1 == "90 Sunny Ave" && a.City == "Berkeley");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID;
ctx.Address.Add(address);
}
var contact4 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "William" && c.MiddleName == "J." && c.LastName == "Monroe")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc4 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact4.ID, ContactTypeID = 18
};
ctx.BusinessEntityContact.Add(bc4);
// LIGHTSP0001
vendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "LIGHTSP0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
address = vendorAddresses.First(a => a.AddressLine1 == "298 Sunnybrook Drive" && a.City == "Spring Valley");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID;
ctx.Address.Add(address);
}
var contact5 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Marie" && c.MiddleName == "E." && c.LastName == "Moya")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc5 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact5.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.Add(bc5);
// DFWBIRE0001
var dfwVendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "DFWBIRE0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var terriPhide = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Terri" && c.LastName == "Phide")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc6 = new BusinessEntityContact {
BusinessEntityID = dfwVendor.ID, PersonID = terriPhide.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.Add(bc6);
// DESOTOB0001
var desotoVendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "DESOTOB0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var address1 = vendorAddresses.First(a => a.AddressLine1 == "1900 Desoto Court" && a.City == "Desoto");
if (address1 != null)
{
address1.BusinessEntityAddressObj.BusinessEntityID = desotoVendor.ID;
address1.BusinessEntityAddressObj.AddressTypeID = 3;
ctx.Address.Add(address1);
}
var address2 = vendorAddresses.FirstOrDefault(a => a.AddressLine1 == "211 East Pleasant Run Rd" && a.City == "Desoto");
if (address2 != null)
{
address2.BusinessEntityAddressObj.BusinessEntityID = desotoVendor.ID;
address2.BusinessEntityAddressObj.AddressTypeID = 7;
ctx.Address.Add(address2);
}
var johnnyDough = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Johnny" && c.LastName == "Dough")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc7 = new BusinessEntityContact {
BusinessEntityID = desotoVendor.ID, PersonID = johnnyDough.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.Add(bc7);
// CYCLERU0001
var rusVendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "CYCLERU0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
address = vendorAddresses.FirstOrDefault(a => a.AddressLine1 == "6266 Melody Lane" && a.City == "Dallas");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = rusVendor.ID;
address.BusinessEntityAddressObj.AddressTypeID = 3;
ctx.Address.Add(address);
}
ctx.SaveChanges();
}
}
private static void AddAddressesToEmployees(AdventureWorksContext ctx)
{
if (ctx.Person.Any())
{
var peopleAddresses = SampleData.GetPeopleAddresses();
var query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Ken" && p.MiddleName == "J" && p.LastName == "Sanchez")
.Select(obj => new { obj.BusinessEntityID })
.SingleOrDefault();
var address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "4350 Minute Dr." && a.City == "Newport Hills");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Terri" && p.MiddleName == "Lee" && p.LastName == "Duffy")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "7559 Worth Ct." && a.City == "Renton");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Gail" && p.MiddleName == "A" && p.LastName == "Erickson")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "9435 Breck Court" && a.City == "Bellevue");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Jossef" && p.MiddleName == "H" && p.LastName == "Goldberg")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "5670 Bel Air Dr." && a.City == "Renton");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Diane" && p.MiddleName == "L" && p.LastName == "Margheim")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "475 Santa Maria" && a.City == "Everett");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
ctx.SaveChanges();
}
}