public void TestDeleteAddressBooks()
{
List <AddressBook> list = new List <AddressBook>();
AddressBookModule abMod = new AddressBookModule();
for (int i = 1; i < 10; i++)
{
AddressBook addressBook = new AddressBook();
addressBook.Name = "Test" + i.ToString();
list.Add(addressBook);
}
abMod.AddressBook.AddAddressBooks(list).Apply();
list[0].CompanyName = "test";
abMod.AddressBook.UpdateAddressBook(list[0]).Apply();
IQueryable <AddressBook> query = abMod.AddressBook.Query().GetAddressBooksByExpression(a => a.Name.Contains("Test"));
list.Clear();
foreach (var item in query)
{
list.Add(item);
}
abMod.AddressBook.DeleteAddressBooks(list).Apply();
Assert.True(true);
}
public void TestAddandDeleteAddressBook()
{
AddressBook addressBook = new AddressBook();
addressBook.FirstName = "James";
addressBook.LastName = "Dean";
addressBook.Name = "James Dean";
AddressBookModule abMod = new AddressBookModule();
abMod.AddressBook.AddAddressBook(addressBook).Apply();
IQueryable <AddressBook> query = abMod.AddressBook.Query().GetAddressBooksByExpression(a => a.Name == "James Dean");
foreach (var item in query)
{
Assert.Equal("James Dean", item.Name);
abMod.AddressBook.DeleteAddressBook(item);
}
abMod.AddressBook.Apply(); //Avoid the thread problem
Assert.True(true);
}
public async Task TestUpdateAddressBook()
{
long addressId = 1;
AddressBookModule abMod = new AddressBookModule();
AddressBookView addressBookView = new AddressBookView();
addressBookView.AddressId = addressId;
addressBookView.FirstName = "David2";
addressBookView.LastName = "Nishimoto";
addressBookView.Name = "David Nishimoto";
abMod.AddressBook.UpdateAddressBookByView(addressBookView).Apply();
AddressBook addressBook2 = await abMod.AddressBook.Query().GetEntityById(addressId);
string name = addressBook2.FirstName;
Assert.Equal("David2", name);
addressBook2.FirstName = "David";
abMod.AddressBook.UpdateAddressBook(addressBook2).Apply();
AddressBook addressBook3 = await abMod.AddressBook.Query().GetEntityById(addressId);
name = addressBook3.FirstName;
Assert.Equal("David", name);
}
public async Task TestGetEmployeeByEmployeeId()
{
int employeeId = 3;
AddressBookModule abMod = new AddressBookModule();
EmployeeView employeeView = await abMod.Employee.Query().GetViewById(employeeId);
Assert.True(employeeView != null);
}
public async Task TestGetSupervisorBySupervisorId()
{
int supervisorId = 1;
AddressBookModule abMod = new AddressBookModule();
SupervisorView view = await abMod.Supervisor.Query().GetViewById(supervisorId);
Assert.Equal(view.ParentSupervisorName.ToUpper().ToString(), "PAM NISHIMOTO".ToString());
}
public async Task TestGetSupplierBySupplierId()
{
int supplierId = 1;
AddressBookModule abMod = new AddressBookModule();
SupplierView supplierView = await abMod.Supplier.Query().GetViewById(supplierId);
Assert.True(supplierView != null);
}
public async Task TestGetCarrierByCarrierId()
{
int carrierId = 1;
AddressBookModule abMod = new AddressBookModule();
CarrierView carrierView = await abMod.Carrier.Query().GetViewById(carrierId);
Assert.Equal("United Parcel Service", carrierView.CarrierName.ToString());
}
public async Task TestAddressBookPaging()
{
long addressId = 1;
AddressBookModule abMod = new AddressBookModule();
PageListViewContainer <AddressBookView> container = await abMod.AddressBook.Query().GetViewsByPage(predicate: e => e.AddressId == addressId, order: e => e.AddressId, pageSize: 1, pageNumber: 1);
Assert.True(container.TotalItemCount > 0);
}
public async Task TestGetEmployeesBySupervisorId()
{
int supervisorId = 1;
AddressBookModule abMod = new AddressBookModule();
List <EmployeeView> list = await abMod.Employee.Query().GetViewsBySupervisorId(supervisorId);
Assert.True(list.Count > 0);
}
public async Task TestGetBuyerByBuyerId()
{
int buyerId = 1;
AddressBookModule abMod = new AddressBookModule();
BuyerView buyerView = await abMod.Buyer.Query().GetViewById(buyerId);
Assert.Equal("Regional Purchasing Clerk", buyerView.Title);
}
public async Task TestGetAddressBooks()
{
AddressBookModule abMod = new AddressBookModule();
List <AddressBookView> addressBooks = await abMod.AddressBook.Query().GetAddressBookByName("David");
IList <string> list = new List <string>();
foreach (var item in addressBooks)
{
output.WriteLine($"{item.Name}");
list.Add(item.Name.ToUpper());
}
Assert.True(list.Contains("DAVID NISHIMOTO"));
}
public async Task TestGetPhonesByAddressId()
{
long addressId = 1;
AddressBookModule abMod = new AddressBookModule();
IList <PhoneEntity> list = await abMod.Phone.Query().GetPhonesByAddressId(addressId);
List <string> intCollection = new List <string>();
foreach (var item in list)
{
output.WriteLine($"{item.PhoneNumber}");
intCollection.Add(item.PhoneNumber);
}
bool results = intCollection.Any(s => s.Contains("401-4333"));
Assert.True(results);
}
public async Task TestGetEmailsByAddressId()
{
long addressId = 1;
AddressBookModule abMod = new AddressBookModule();
IList <EmailEntity> list = await abMod.Email.Query().GetEmailsByAddressId(addressId);
List <string> intCollection = new List <string>();
foreach (var item in list)
{
output.WriteLine($"{item.Email}");
intCollection.Add(item.Email);
}
bool results = intCollection.Any(s => s.Contains("*****@*****.**"));
Assert.True(results);
}
