public void TestInsertAndDeletePerson()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory();
var notificationService = new FootlooseFSNotificationService();
var service = new FootlooseFSService(uowFactory, notificationService);
var person = new Person
{
FirstName = "John",
LastName = "Dorman",
EmailAddress = "*****@*****.**", // Updated email address
Phones = new List<Phone>
{
new Phone
{
Number = "813-657-2222", // Update home phone
PhoneTypeID = 1
}
},
Addresses = new List<PersonAddressAssn>
{
new PersonAddressAssn
{
Address = new Address
{
StreetAddress = "823 Newton Drive", // Updated address
State = "FL",
Zip = "33782",
AddressID = 5,
City = "Pinellas Park"
},
AddressTypeID = 1,
}
},
};
var opStatus = service.InsertPerson(person);
var insertedPerson = (Person)opStatus.Data;
// Verify that the InsertPerson method returns data of type Person
Assert.IsInstanceOf<Person>(insertedPerson);
var insertedPersonFromUoW = service.GetPersonById(insertedPerson.PersonID, new PersonIncludes { Phones = true, Addressses = true });
// Verify that email address was applied
Assert.AreEqual(insertedPersonFromUoW.EmailAddress, "*****@*****.**");
// Verify that the home phone number was updated
var homePhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 1).FirstOrDefault();
Assert.AreEqual(homePhone.Number, "813-657-2222");
// Verify that there is no work number
var workPhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 2 && ! string.IsNullOrEmpty(p.Number));
Assert.AreEqual(workPhone.Count(), 0);
// Verify that there is no cell number
var cellPhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 3 && !string.IsNullOrEmpty(p.Number));
Assert.AreEqual(cellPhone.Count(), 0);
// Verify that the address was updated
var address = insertedPersonFromUoW.Addresses.Where(a => a.AddressTypeID == 1).FirstOrDefault().Address;
Assert.AreEqual(address.StreetAddress, "823 Newton Drive");
Assert.AreEqual(address.City, "Pinellas Park");
Assert.AreEqual(address.Zip, "33782");
Assert.AreEqual(address.State, "FL");
// Now delete the person
service.DeletePerson(insertedPersonFromUoW);
// Make sure the person is deleted
var deletedPerson = service.GetPersonById(insertedPersonFromUoW.PersonID, new PersonIncludes());
Assert.IsNull(deletedPerson);
}
public void TestUpdatePerson()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory();
var notificationService = new FootlooseFSNotificationService();
var service = new FootlooseFSService(uowFactory, notificationService);
// for this test lets get all of the linked tables and verify that we can properly query for all of the this information
var person = service.GetPersonById(5, new PersonIncludes { Phones = true, Accounts = true, Addressses = true, AccountTransactions = true });
// Update the email address
person.EmailAddress = "*****@*****.**";
// Upate the home phone
var homePhone = person.Phones.Where(p => p.PhoneTypeID == 1).First();
var oldhomePhone = homePhone.Number;
homePhone.Number = "336-418-5555";
// Update the home address
var homeAddress = person.Addresses.Where(pa => pa.AddressTypeID == 1).First().Address;
var oldAddress = homeAddress.StreetAddress;
var oldCity = homeAddress.City;
var oldZip = homeAddress.Zip;
var oldState = homeAddress.State;
homeAddress.StreetAddress = "631 Glebe Road";
homeAddress.City = "Arlington";
homeAddress.Zip = "20178";
homeAddress.State = "VA";
// Now perform the update in the SQL datastore
var opStatus = service.UpdatePerson(person);
var updatedPerson = (Person)opStatus.Data;
// Verify that the UpdatePerson method returns data of type Person
Assert.IsInstanceOf<Person>(updatedPerson);
var updatedPersonFromUoW = service.GetPersonById(updatedPerson.PersonID, new PersonIncludes { Phones = true, Addressses = true });
// Verify that email address was updated
Assert.AreEqual(updatedPersonFromUoW.EmailAddress, "*****@*****.**");
// Verify that the home phone number was updated
homePhone = updatedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 1).FirstOrDefault();
Assert.AreEqual(homePhone.Number, "336-418-5555");
// Verify that the address was updated
var address = updatedPersonFromUoW.Addresses.Where(a => a.AddressTypeID == 1).FirstOrDefault().Address;
Assert.AreEqual(address.StreetAddress, "631 Glebe Road");
Assert.AreEqual(address.City, "Arlington");
Assert.AreEqual(address.Zip, "20178");
Assert.AreEqual(address.State, "VA");
// Now put the original data back
homePhone = person.Phones.Where(p => p.PhoneTypeID == 1).First();
homePhone.Number = oldhomePhone;
// Update the home address
homeAddress = person.Addresses.Where(pa => pa.AddressTypeID == 1).First().Address;
homeAddress.StreetAddress = oldAddress;
homeAddress.City = oldCity;
homeAddress.Zip = oldZip;
homeAddress.State = oldState;
// Now perform the update in the SQL datastore
opStatus = service.UpdatePerson(person);
Assert.IsTrue(opStatus.Success);
}
public void TestInsertAndDeletePerson()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory(options);
var service = new FootlooseFSService(uowFactory, options);
var person = new Person
{
FirstName = "John",
LastName = "Dorman",
EmailAddress = "*****@*****.**", // Updated email address
Phones = new List <Phone>
{
new Phone
{
Number = "813-657-2222", // Update home phone
PhoneTypeID = 1
}
},
Addresses = new List <PersonAddressAssn>
{
new PersonAddressAssn
{
Address = new Address
{
StreetAddress = "823 Newton Drive", // Updated address
State = "FL",
Zip = "33782",
City = "Pinellas Park"
},
AddressTypeID = 1,
}
},
};
var opStatus = service.InsertPerson(person);
var insertedPerson = (Person)opStatus.Data;
var insertedPersonFromUoW = service.GetPersonById(insertedPerson.PersonID, new PersonIncludes {
Phones = true, Addressses = true
});
// Verify that email address was applied
Assert.AreEqual(insertedPersonFromUoW.EmailAddress, "*****@*****.**");
// Verify that the home phone number was updated
var homePhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 1).FirstOrDefault();
Assert.AreEqual(homePhone.Number, "813-657-2222");
// Verify that there is no work number
var workPhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 2 && !string.IsNullOrEmpty(p.Number));
Assert.AreEqual(workPhone.Count(), 0);
// Verify that there is no cell number
var cellPhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 3 && !string.IsNullOrEmpty(p.Number));
Assert.AreEqual(cellPhone.Count(), 0);
// Verify that the address was updated
var address = insertedPersonFromUoW.Addresses.Where(a => a.AddressTypeID == 1).FirstOrDefault().Address;
Assert.AreEqual(address.StreetAddress, "823 Newton Drive");
Assert.AreEqual(address.City, "Pinellas Park");
Assert.AreEqual(address.Zip, "33782");
Assert.AreEqual(address.State, "FL");
// Now delete the person
service.DeletePerson(insertedPersonFromUoW);
// Make sure the person is deleted
var deletedPerson = service.GetPersonById(insertedPersonFromUoW.PersonID, new PersonIncludes());
Assert.IsNull(deletedPerson);
}
public void TestUpdatePerson()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory(options);
var service = new FootlooseFSService(uowFactory, options);
// for this test lets get all of the linked tables and verify that we can properly query for all of the this information
var person = service.GetPersonById(5, new PersonIncludes {
Phones = true, Accounts = true, Addressses = true, AccountTransactions = true
});
// Update the email address
person.EmailAddress = "*****@*****.**";
// Upate the home phone
var homePhone = person.Phones.Where(p => p.PhoneTypeID == 1).First();
var oldhomePhone = homePhone.Number;
homePhone.Number = "336-418-5555";
// Update the home address
var homeAddress = person.Addresses.Where(pa => pa.AddressTypeID == 1).First().Address;
var oldAddress = homeAddress.StreetAddress;
var oldCity = homeAddress.City;
var oldZip = homeAddress.Zip;
var oldState = homeAddress.State;
homeAddress.StreetAddress = "631 Glebe Road";
homeAddress.City = "Arlington";
homeAddress.Zip = "20178";
homeAddress.State = "VA";
// Now perform the update in the SQL datastore
var opStatus = service.UpdatePerson(person);
var updatedPerson = (Person)opStatus.Data;
var updatedPersonFromUoW = service.GetPersonById(updatedPerson.PersonID, new PersonIncludes {
Phones = true, Addressses = true
});
// Verify that email address was updated
Assert.AreEqual(updatedPersonFromUoW.EmailAddress, "*****@*****.**");
// Verify that the home phone number was updated
homePhone = updatedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 1).FirstOrDefault();
Assert.AreEqual(homePhone.Number, "336-418-5555");
// Verify that the address was updated
var address = updatedPersonFromUoW.Addresses.Where(a => a.AddressTypeID == 1).FirstOrDefault().Address;
Assert.AreEqual(address.StreetAddress, "631 Glebe Road");
Assert.AreEqual(address.City, "Arlington");
Assert.AreEqual(address.Zip, "20178");
Assert.AreEqual(address.State, "VA");
// Now put the original data back
homePhone = person.Phones.Where(p => p.PhoneTypeID == 1).First();
homePhone.Number = oldhomePhone;
// Update the home address
homeAddress = person.Addresses.Where(pa => pa.AddressTypeID == 1).First().Address;
homeAddress.StreetAddress = oldAddress;
homeAddress.City = oldCity;
homeAddress.Zip = oldZip;
homeAddress.State = oldState;
// Now perform the update in the SQL datastore
opStatus = service.UpdatePerson(person);
Assert.IsTrue(opStatus.Success);
}
public void TestUpdatePerson()
{
var testFactory = new FootlooseFSTestUnitOfWorkFactory();
var service = new FootlooseFSService(testFactory, options);
var person = new Person
{
PersonID = 1,
FirstName = "Pam",
LastName = "Scicchitano",
EmailAddress = "*****@*****.**", // Updated email address
Phones = new List <Phone>
{
new Phone
{
PersonID = 1,
Number = "336-418-5555", // Update home phone
PhoneType = new PhoneType {
Name = "Home", PhoneTypeID = 1
},
PhoneTypeID = 1
},
new Phone
{
PersonID = 1,
Number = "336-418-7777", // Updated work phone
PhoneType = new PhoneType {
Name = "Work", PhoneTypeID = 2
},
PhoneTypeID = 2
},
new Phone
{
PersonID = 1,
Number = "336-418-4444", // Updated cell phone
PhoneType = new PhoneType {
Name = "Cell", PhoneTypeID = 3
},
PhoneTypeID = 3
}
},
Addresses = new List <PersonAddressAssn>
{
new PersonAddressAssn
{
Address = new Address
{
StreetAddress = "631 Glebe Road", // Updated address
State = "VA",
Zip = "20178",
AddressID = 1,
City = "Arlington"
},
AddressID = 1,
AddressType = new AddressType {
Name = "Home", AddressTypeID = 1
},
AddressTypeID = 1,
PersonID = 1
}
},
};
var opStatus = service.UpdatePerson(person);
var updatedPerson = (Person)opStatus.Data;
// Get the updated person object from the UoW
var updatedPersonFromUoW = service.GetPersonById(updatedPerson.PersonID, new PersonIncludes {
Phones = true, Addressses = true
});
// Verify that email address was updated
Assert.AreEqual(updatedPersonFromUoW.EmailAddress, "*****@*****.**");
// Verify that the home phone number was updated
var homePhone = updatedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 1).FirstOrDefault();
Assert.AreEqual(homePhone.Number, "336-418-5555");
// Verify that the work number was updated
var workPhone = updatedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 2).FirstOrDefault();
Assert.AreEqual(workPhone.Number, "336-418-7777");
// Verify that the cell number was updated
var cellPhone = updatedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 3).FirstOrDefault();
Assert.AreEqual(cellPhone.Number, "336-418-4444");
// Verify that the address was updated
var address = updatedPersonFromUoW.Addresses.Where(a => a.AddressTypeID == 1).FirstOrDefault().Address;
Assert.AreEqual(address.StreetAddress, "631 Glebe Road");
Assert.AreEqual(address.City, "Arlington");
Assert.AreEqual(address.Zip, "20178");
Assert.AreEqual(address.State, "VA");
}