/// <summary> /// Show name and email for all customers /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnShowCustomers_Click(object sender, EventArgs e) { listView1.Clear(); listView1.Columns.Clear(); StoreEntities db = new StoreEntities(); var customers = (from customer in db.Customers orderby customer.CustomerLastName select new { customer.CustomerID, customer.CustomerFirstName, customer.CustomerLastName, customer.CustomerEmail }).ToList(); listView1.Columns.Add("Customer Name", 175); listView1.Columns.Add("Customer Email", 260); int i = 0; foreach (var c in customers) { listView1.Items.Add($"{c.CustomerFirstName} {c.CustomerLastName}"); listView1.Items[i].SubItems.Add(c.CustomerEmail); i += 1; } }
/// <summary> /// Show order status for all orders /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOrderStatus_Click(object sender, EventArgs e) { listView1.Clear(); listView1.Columns.Clear(); StoreEntities db = new StoreEntities(); var orders = (from order in db.Orders join orderStatus in db.OrderStatus on order.OrderStatusID equals orderStatus.OrderStatusID select new { order.OrderID, order.OrderDate, orderStatus.OrderStatusDescription }).ToList(); listView1.Columns.Add("Order ID", 100); listView1.Columns.Add("Order Date", 125); listView1.Columns.Add("Order Status", 210); int i = 0; foreach (var o in orders) { listView1.Items.Add(o.OrderID.ToString()); listView1.Items[i].SubItems.Add(o.OrderDate.ToShortDateString()); listView1.Items[i].SubItems.Add(o.OrderStatusDescription); i += 1; } }
/// <summary> /// Show products to reorder if quantity in stock /// is less than or equal to the product reorder level /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnShowProductsToReorder_Click(object sender, EventArgs e) { listView1.Clear(); listView1.Columns.Clear(); StoreEntities db = new StoreEntities(); var products = (from product in db.Products join vendorProduct in db.VendorProducts on product.ProductID equals vendorProduct.ProductID join vendor in db.Vendors on vendorProduct.VendorID equals vendor.VendorID where vendorProduct.QuantityInStock <= vendorProduct.ReorderLevel select new { product.ProductID, product.ProductName, vendorProduct.QuantityInStock, vendorProduct.ReorderLevel, vendor.VendorName }).ToList(); listView1.Columns.Add("Product ID", 67); listView1.Columns.Add("Product Name", 128); listView1.Columns.Add("Qty in Stock", 73); listView1.Columns.Add("Reorder Level", 83); listView1.Columns.Add("Vendor Name", 84); int i = 0; foreach (var p in products) { listView1.Items.Add(p.ProductID.ToString()); listView1.Items[i].SubItems.Add(p.ProductName); listView1.Items[i].SubItems.Add(p.QuantityInStock.ToString()); listView1.Items[i].SubItems.Add(p.ReorderLevel.ToString()); listView1.Items[i].SubItems.Add(p.VendorName); i += 1; } }