public void TestPersonDocumentSearch()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory();
var notificationService = new FootlooseFSNotificationService();
var service = new FootlooseFSService(uowFactory, notificationService);
var searchCriteria = new PersonDocument();
searchCriteria.State = "NY";
var pageOfListPersonDocuments = service.SearchPersonDocuments(1, 10, "LastName", SortDirection.Ascending, searchCriteria);
// Verify that only 10 records or less are returned
Assert.IsTrue(pageOfListPersonDocuments.Data.Count <= 10);
// Verify that only NY state record are returned
Assert.IsFalse(pageOfListPersonDocuments.Data.Any(p => p.State != "NY"));
}
public void TestPersonDocumentSearch()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory();
var notificationService = new FootlooseFSNotificationService();
var service = new FootlooseFSService(uowFactory, notificationService);
var searchCriteria = new PersonDocument();
searchCriteria.State = "NY";
var pageOfListPersonDocuments = service.SearchPersonDocuments(1, 10, "LastName", SortDirection.Ascending, searchCriteria);
// Verify that only 10 records or less are returned
Assert.IsTrue(pageOfListPersonDocuments.Data.Count <= 10);
// Verify that only NY state record are returned
Assert.IsFalse(pageOfListPersonDocuments.Data.Any(p => p.State != "NY"));
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });
var service = new FootlooseFSService(new FootlooseFSSqlUnitOfWorkFactory());
var personId = service.GetPersonID(context.UserName, context.Password);
if (personId <= 0)
{
context.SetError("invalid_grant", "The username or password is incorrect.");
return;
}
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim(ClaimTypes.Name, context.UserName));
identity.AddClaim(new Claim(ClaimTypes.Role, "user"));
context.Validated(identity);
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });
var service = new FootlooseFSService(new FootlooseFSSqlUnitOfWorkFactory(), new FootlooseFSNotificationService());
var loginStatus = service.Login(context.UserName, context.Password);
if (!loginStatus.Success)
{
context.SetError("invalid_grant", loginStatus.Messages[0]);
return;
}
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim(ClaimTypes.Name, context.UserName));
identity.AddClaim(new Claim(ClaimTypes.Role, "user"));
context.Validated(identity);
}
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 TestInsertPerson()
{
var testUoW = new FootlooseFSTestUnitOfWork();
var mockUoWFactory = new Mock<IFootlooseFSUnitOfWorkFactory>();
var mockNotificationService = new Mock<IFootlooseFSNotificationService>();
// Instead of instantiating a new UoW object in the factory we want to use the one we created so we can monitor
// it's internal data and verify that the service did what is was supposed to do
mockUoWFactory.Setup(m => m.CreateUnitOfWork()).Returns(testUoW);
mockNotificationService.Setup(m => m.SendPersonUpdatedNotification(It.IsAny<int>(), It.IsAny<string>())).Returns(true);
var uowFactory = mockUoWFactory.Object;
var service = new FootlooseFSService(uowFactory, mockNotificationService.Object);
var person = new Person
{
PersonID = 5,
FirstName = "John",
LastName = "Dorman",
EmailAddress = "*****@*****.**", // Updated email address
Phones = new List<Phone>
{
new Phone
{
PersonID = 5,
Number = "813-657-2222", // Update home phone
PhoneType = new PhoneType { Name = "Home", PhoneTypeID = 1 },
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"
},
AddressID = 5,
AddressType = new AddressType { Name = "Home", AddressTypeID = 1 },
AddressTypeID = 1,
PersonID = 5
}
},
};
var opStatus = service.InsertPerson(person);
var insertedPerson = (Person)opStatus.Data;
// Verify that the InsertPerson method returns data of type Person
Assert.IsInstanceOf<Person>(insertedPerson);
// Get the inserted person object from the UoW
var insertedPersonFromUoW = testUoW.Persons.GetQueryable().Where(p => p.PersonID == 5).First();
// 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);
Assert.AreEqual(workPhone.Count(), 0);
// Verify that there is no cell number
var cellPhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 3);
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");
}
public void TestUpdatePerson()
{
var testUoW = new FootlooseFSTestUnitOfWork();
var mockUoWFactory = new Mock<IFootlooseFSUnitOfWorkFactory>();
var mockNotificationService = new Mock<IFootlooseFSNotificationService>();
// Instead of instantiating a new UoW object in the factory we want to use the one we created so we can monitor
// it's internal data and verify that the service did what is was supposed to do
mockUoWFactory.Setup(m => m.CreateUnitOfWork()).Returns(testUoW);
mockNotificationService.Setup(m => m.SendPersonUpdatedNotification(It.IsAny<int>(), It.IsAny<string>())).Returns(true);
var uowFactory = mockUoWFactory.Object;
var service = new FootlooseFSService(uowFactory, mockNotificationService.Object);
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;
// Verify that the UpdatePerson method returns data of type Person
Assert.IsInstanceOf<Person>(updatedPerson);
// Get the updated person object from the UoW
var updatedPersonFromUoW = testUoW.Persons.GetQueryable().Where(p => p.PersonID == 1).First();
// 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");
}
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 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 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");
}
public void TestPersonDocumentSearch()
{
var uowFactory = new FootlooseFSSqlUnitOfWorkFactory();
var service = new FootlooseFSService(uowFactory);
var searchCriteria = new Dictionary<PersonSearchColumn, string>();
searchCriteria.Add(PersonSearchColumn.State, "NY");
var pageOfListPersonDocuments = service.SearchPersonDocuments(1, PersonSearchColumn.LastName, SortDirection.Ascending, 10, searchCriteria);
// Verify that only 10 records or less are returned
Assert.IsTrue(pageOfListPersonDocuments.Data.Count <= 10);
// Verify that only NY state record are returned
Assert.IsFalse(pageOfListPersonDocuments.Data.Any(p => p.State != "NY"));
}
public void TestInsertPerson()
{
var testUoW = new FootlooseFSTestUnitOfWork();
var mockUoWFactory = new Mock <IFootlooseFSUnitOfWorkFactory>();
var mockNotificationService = new Mock <IFootlooseFSNotificationService>();
// Instead of instantiating a new UoW object in the factory we want to use the one we created so we can monitor
// it's internal data and verify that the service did what is was supposed to do
mockUoWFactory.Setup(m => m.CreateUnitOfWork()).Returns(testUoW);
mockNotificationService.Setup(m => m.SendPersonUpdatedNotification(It.IsAny <int>(), It.IsAny <string>())).Returns(true);
var uowFactory = mockUoWFactory.Object;
var service = new FootlooseFSService(uowFactory, mockNotificationService.Object);
var person = new Person
{
PersonID = 5,
FirstName = "John",
LastName = "Dorman",
EmailAddress = "*****@*****.**", // Updated email address
Phones = new List <Phone>
{
new Phone
{
PersonID = 5,
Number = "813-657-2222", // Update home phone
PhoneType = new PhoneType {
Name = "Home", PhoneTypeID = 1
},
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"
},
AddressID = 5,
AddressType = new AddressType {
Name = "Home", AddressTypeID = 1
},
AddressTypeID = 1,
PersonID = 5
}
},
};
var opStatus = service.InsertPerson(person);
var insertedPerson = (Person)opStatus.Data;
// Verify that the InsertPerson method returns data of type Person
Assert.IsInstanceOf <Person>(insertedPerson);
// Get the inserted person object from the UoW
var insertedPersonFromUoW = testUoW.Persons.GetQueryable().Where(p => p.PersonID == 5).First();
// 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);
Assert.AreEqual(workPhone.Count(), 0);
// Verify that there is no cell number
var cellPhone = insertedPersonFromUoW.Phones.Where(p => p.PhoneTypeID == 3);
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");
}
public void TestUpdatePerson()
{
var testUoW = new FootlooseFSTestUnitOfWork();
var mockUoWFactory = new Mock <IFootlooseFSUnitOfWorkFactory>();
var mockNotificationService = new Mock <IFootlooseFSNotificationService>();
// Instead of instantiating a new UoW object in the factory we want to use the one we created so we can monitor
// it's internal data and verify that the service did what is was supposed to do
mockUoWFactory.Setup(m => m.CreateUnitOfWork()).Returns(testUoW);
mockNotificationService.Setup(m => m.SendPersonUpdatedNotification(It.IsAny <int>(), It.IsAny <string>())).Returns(true);
var uowFactory = mockUoWFactory.Object;
var service = new FootlooseFSService(uowFactory, mockNotificationService.Object);
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;
// Verify that the UpdatePerson method returns data of type Person
Assert.IsInstanceOf <Person>(updatedPerson);
// Get the updated person object from the UoW
var updatedPersonFromUoW = testUoW.Persons.GetQueryable().Where(p => p.PersonID == 1).First();
// 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");
}
