//[TestMethod]
//public async Task TestRegularGetCorrectContent()
//{
//}
//[TestMethod]
//public async Task TestFilteredGet()
//{
//}
//[TestMethod]
//public async Task TestPostCorrectResult()
//{
//}
//[TestMethod]
//public async Task TestPostItemAdd()
//{
//}
/* Perform a PUT linking two customers */
private async Task <IActionResult> PutLinkCombination()
{
IActionResult result = null;
using (var linksContext = new LinksContext(linksOptions))
{
CustomerLink customer1 = linksContext.CustomerLink.Where(x => x.NewID == newIDs[1]).Single();
customer1.OldID = oldIDs[1];
NewCustomersContext newContext = new NewCustomersContext(newCOptions);
OldCustomersContext oldContext = new OldCustomersContext(oldCOptions);
CustomerLinksController linksController = new CustomerLinksController(linksContext, newContext, oldContext);
result = await linksController.PutCombinedLink(customer1.ID, GetFullLinkFromContexts(customer1)) as IActionResult;
newContext.Dispose();
oldContext.Dispose();
}
return(result);
}
public void ClearDb()
{
using (var context = new LinksContext(linksOptions))
{
context.CustomerLink.RemoveRange(context.CustomerLink);
context.SaveChanges();
};
using (var context = new OldCustomersContext(oldCOptions))
{
context.OldCustomer.RemoveRange(context.OldCustomer);
context.SaveChanges();
};
using (var context = new NewCustomersContext(newCOptions))
{
context.NewCustomer.RemoveRange(context.NewCustomer);
context.SaveChanges();
};
}
/* This method packages the data from the different contexts into one combined object */
private CombinedLink GetFullLinkFromContexts(CustomerLink bareCustomerLink)
{
NewCustomer newCustomerData = null;
using (NewCustomersContext newContext = new NewCustomersContext(newCOptions))
{
if (bareCustomerLink.NewID != "")
{
IQueryable <NewCustomer> filteredContext =
newContext.NewCustomer.Where(x => x.Id == bareCustomerLink.NewID);
if (filteredContext.Count() == 1)
{
newCustomerData = filteredContext.Single();
}
}
}
OldCustomer oldCustomerData = null;
using (OldCustomersContext oldContext = new OldCustomersContext(oldCOptions))
{
if (bareCustomerLink.OldID != -1)
{
IQueryable <OldCustomer> filteredContext =
oldContext.OldCustomer.Where(x => x.Id == bareCustomerLink.OldID);
if (filteredContext.Count() == 1)
{
oldCustomerData = filteredContext.Single();
}
}
}
CombinedLink fullLink = new CombinedLink
{
Link = bareCustomerLink,
OldC = oldCustomerData,
NewC = newCustomerData
};
return(fullLink);
}
public void SetupDb()
{
using (var context = new OldCustomersContext(oldCOptions))
{
OldCustomer customer0a = new OldCustomer()
{
Id = oldIDs[0],
Username = "******",
FirstName = "Elon",
Surname = "Musk",
Address = "Los Angeles",
};
OldCustomer customer1a = new OldCustomer()
{
Id = oldIDs[1],
Username = "******",
FirstName = "Jimmy",
Surname = "Whales",
Address = "San Francisco"
};
context.OldCustomer.Add(customer0a);
context.OldCustomer.Add(customer1a);
context.SaveChanges();
}
using (var context = new NewCustomersContext(newCOptions))
{
NewCustomer customer0b = new NewCustomer()
{
Id = newIDs[0],
Username = "******",
GivenNames = { "Elon", "Reeve", "Musk" },
Email = "*****@*****.**"
};
NewCustomer customer1b = new NewCustomer()
{
Id = newIDs[1],
Username = "******",
GivenNames = { "Jimmy", "Whales" },
Email = "*****@*****.**"
};
context.NewCustomer.Add(customer0b);
context.NewCustomer.Add(customer1b);
context.SaveChanges();
}
using (var context = new LinksContext(linksOptions))
{
CustomerLink customer0 = new CustomerLink()
{
OldID = oldIDs[0],
NewID = newIDs[0]
};
CustomerLink customer1a = new CustomerLink()
{
OldID = oldIDs[1]
};
CustomerLink customer1b = new CustomerLink()
{
NewID = newIDs[1]
};
context.CustomerLink.Add(customer0);
context.CustomerLink.Add(customer1a);
context.CustomerLink.Add(customer1b);
context.SaveChanges();
}
}
public void TestRegularGetCorrectResult()
{
using (var linksContext = new LinksContext(linksOptions))
{
CustomerLink customerLink0 = linksContext.CustomerLink.Where(x => x.NewID == newIDs[0]).Single();
CustomerLink customerLink1a = linksContext.CustomerLink.Where(x => x.OldID == oldIDs[1]).Single();
CustomerLink customerLink1b = linksContext.CustomerLink.Where(x => x.NewID == newIDs[1]).Single();
CombinedLink customerData0 = GetFullLinkFromContexts(customerLink0);
CombinedLink customerData1a = GetFullLinkFromContexts(customerLink1a);
CombinedLink customerData1b = GetFullLinkFromContexts(customerLink1b);
NewCustomersContext newContext = new NewCustomersContext(newCOptions);
OldCustomersContext oldContext = new OldCustomersContext(oldCOptions);
CustomerLinksController linksController = new CustomerLinksController(linksContext, newContext, oldContext);
IEnumerable <CombinedLink> customers = linksController.GetCombinedLink();
newContext.Dispose();
oldContext.Dispose();
bool[] foundCustomer = new bool[3];
foundCustomer[0] = false;
foundCustomer[1] = false;
foundCustomer[2] = false;
System.Console.WriteLine("Looking for customers...");
System.Diagnostics.Debug.WriteLine("Looking for customers...");
foreach (CombinedLink customer in customers)
{
System.Diagnostics.Debug.WriteLine("Customer found:");
System.Console.WriteLine("Customer found");
if (customer.Equals(customerData0))
{
foundCustomer[0] = true;
}
else if (customer.Equals(customerData1a))
{
foundCustomer[1] = true;
}
else if (customer.Equals(customerData1b))
{
foundCustomer[2] = true;
}
}
if (!foundCustomer[0])
{
Assert.Fail("There was no data for Elon Musk");
}
if (!foundCustomer[1])
{
Assert.Fail("There was no old data for Jimmy Wales");
}
if (!foundCustomer[2])
{
Assert.Fail("There was no new data for Jimmy Wales");
}
if (customers.Count() != 3)
{
Assert.Fail("There were more than 3 customer links");
}
};
}
public CustomerLinksController(LinksContext context, NewCustomersContext newContext, OldCustomersContext oldContext)
{
_linkContext = context;
_newContext = newContext;
_oldContext = oldContext;
}