private void RtrieveTest()
{
var ctx = new AdventureCtx();
PrintMessage(Wordfiy("Print SalesOrders"));
foreach (var salesOrderHeader in ctx.SalesOrderHeaders.Take(10))
{
Console.WriteLine($"{salesOrderHeader.Customer.Person} {salesOrderHeader.CreditCard.CardType} {salesOrderHeader.CreditCard.CardNumber.Substring(0, 3).PadRight(20, '*')} {salesOrderHeader.SubTotal.ToString("C0")}");
}
PrintMessage(Wordfiy("Print Addresses"));
foreach (var address in ctx.Addresses.Take(10))
{
Console.WriteLine($"{address.AddressLine1}-{address.City}");
}
PrintMessage(Wordfiy("Print SalesTerritories"));
foreach (var territory in ctx.SalesTerritories.Take(10))
{
Console.WriteLine(territory.Name);
}
PrintMessage(Wordfiy("Print ProductDescriptions"));
foreach (var productDescription in ctx.ProductDescriptions.Take(10))
{
Console.WriteLine(productDescription.Description);
}
}
public virtual async Task <Customer> GetCustomerById(int customerId)
{
DebuggerInfo.DisplayCurrentMethod(MethodBase.GetCurrentMethod());
Customer resultData;
using (_dbcontext = new AdventureCtx())
{
resultData = _dbcontext.Customers.SingleOrDefault(c => c.CustomerID == customerId);
}
return(await Task.Run(() => resultData));
}
private void CheckMetadata()
{
using (var ctx = new AdventureCtx())
{
var x = ctx.Addresses.Include(a => a.SalesOrderHeaders).Where(a => a.SalesOrderHeaders.Any()).FirstOrDefault().SalesOrderHeaders;
if (x.Any())
{
PrintMessage(x.FirstOrDefault().AccountNumber);
var y = x.FirstOrDefault().SalesOrderDetails.FirstOrDefault();
PrintMessage(y.rowguid.ToString());
}
}
}
public virtual async Task <ResultModel <Customer> > SearchCustomer(Func <IQueryable <Customer>, IQueryable <Customer> > expression)
{
Console.WriteLine($" parameter {expression} is invoked");
//await Task.Delay(5000);
List <Customer> resultData;
using (_dbcontext = new AdventureCtx())
{
resultData = expression(_dbcontext.Customers.Include("Person")).ToList();
}
return(await Task.Run(() => new ResultModel <Customer> {
ModelList = resultData, Search = expression.ToString()
}));
}
public virtual async Task <ResultModel <Customer> > GetCustomersByName(string name)
{
Console.WriteLine($" parameter {name} is invoked");
//await Task.Delay(5000);
List <Customer> resultData;
using (_dbcontext = new AdventureCtx()){
resultData = _dbcontext.Customers.Include("Person").Where(c =>
c.Person.FirstName.ToLower().Contains(name.ToLower())
||
c.Person.LastName.ToLower().Contains(name.ToLower()
)).Take(100).ToList();
}
return(await Task.Run(() => new ResultModel <Customer> {
ModelList = resultData, Search = name
}));
}
private void UpdateTest()
{
using (var ctx = new AdventureCtx())
{
PrintMessage(Wordfiy("Update address"));
var address = ctx.Addresses.FirstOrDefault();
var addresJson = JsonConvert.SerializeObject(address, Formatting.None);
var clonedAddress = JsonConvert.DeserializeObject <Address>(addresJson);
PrintMessage($"Address before change {address}");
address.City = "Sydney";
address.AddressLine1 = "1 Evanse Avenue";
ctx.SaveChanges();
var savedAddress = ctx.Addresses.SingleOrDefault(a => a.rowguid == address.rowguid);
PrintMessage($"Address after change {savedAddress}");
savedAddress.City = clonedAddress.City;
savedAddress.AddressLine1 = clonedAddress.AddressLine1;
ctx.SaveChanges();
PrintMessage($"Address after restoration {savedAddress}");
}
}
