/// <summary>
/// Test query to display a list of all zipcodes in the DB
/// </summary>
public void ReadAllZips()
{
// Initialize our database context
using (var context = new Pharm2UEntities())
{
// clear the previous results
ZipList.Clear();
// Add the zip for each record found
foreach (var record in context.P2U_ZipCodes)
{
Console.WriteLine(record.Zip);
ZipList.Add(record.Zip);
}
}
}
/// <summary>
/// The query to read all orders in the database
/// </summary>
public void ReadAllOrders()
{
//// Initialize our database context
//using (var context = new Pharm2UEntities())
//{
// // clear the previous query results
// OrderList.Clear();
// // Add the orders for each record found
// foreach (var record in context.P2U_Order)
// {
// OrderList.Add(record);
// }
//}
using (var context = new Pharm2UEntities())
{
var AllOrders = (from order in context.P2U_Order
join customer in context.P2U_Customer
on order.CustomerID equals customer.ItemID
select new
{
OrderID = order.ItemID,
DateCreated = (DateTime)order.NewOrderCreatedWhen,
CustomerID = customer.ItemID,
FirstName = customer.FirstName,
LastName = customer.LastName,
Status = order.Status
}).ToList();
foreach (var p in AllOrders)
{
JoinedOrderInfoList.Add(new JoinedOrderInfo()
{
OrderId = p.OrderID,
FirstName = p.FirstName,
LastName = p.LastName,
CustomerId = p.CustomerID,
NewOrderCreatedWhen = p.DateCreated,
Status = p.Status
});
Console.WriteLine($"{p.OrderID}, {p.FirstName}, {p.LastName}");
}
}
}
