public List <Customer> GetCustomerAddresses()
{
AdventureWorksLT2019Context efCore = new AdventureWorksLT2019Context();
var result = efCore.Customers.Include(c => c.CustomerAddresses);
return(result.ToList());
}
//public IActionResult Index()
//{
// using (AdventureWorksLT2019Context db = new AdventureWorksLT2019Context())
// {
// var salesOrder = db.SalesOrderHeader
// .Include(soh => soh.Customer)
// .Include(soh => soh.ShipToAddress)
// .Take(10).ToList();
// return View(salesOrder);
// }
// //KeyVaultModel keyVaultModel = new KeyVaultModel();
// return View();
//}
public IActionResult Index()
{
using (AdventureWorksLT2019Context db = new AdventureWorksLT2019Context())
{
var salesOrder = db.SalesOrderHeader
.Include(soh => soh.Customer)
.Include(soh => soh.ShipToAddress)
.Select(soh => new SalesOrderHeader()
{
SalesOrderId = soh.SalesOrderId,
SalesOrderNumber = soh.SalesOrderNumber,
PurchaseOrderNumber = soh.PurchaseOrderNumber,
TotalDue = soh.TotalDue,
Customer = new Customer()
{
FirstName = soh.Customer.FirstName,
LastName = soh.Customer.LastName,
EmailAddress = soh.Customer.EmailAddress,
},
ShipToAddress = new Address()
{
AddressLine1 = soh.ShipToAddress.AddressLine1
},
BillToAddress = new Address()
{
AddressLine1 = soh.BillToAddress.AddressLine1
}
})
.Take(10)
.ToList();
return(View(salesOrder));
}
return(View());
}
public AddressController(AdventureWorksLT2019Context db)
{
_db = db;
}
