/// <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}"); } } }