Example #1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            List <Customer> customerList = CustomerDB.GetCustomers();
            List <Invoice>  invoiceList  = InvoiceDB.GetInvoices();

            var invoices = from invoice in invoiceList
                           join customer in customerList
                           on invoice.CustomerID equals customer.CustomerID
                           orderby customer.Name, invoice.InvoiceTotal descending
                select new { customer.Name,
                             invoice.InvoiceID,
                             invoice.InvoiceDate,
                             invoice.InvoiceTotal };

            string customerName = "";
            int    i            = 0;

            foreach (var invoice in invoices)
            {
                if (invoice.Name != customerName)
                {
                    lvInvoices.Items.Add(invoice.Name);
                    customerName = invoice.Name;
                }
                else
                {
                    lvInvoices.Items.Add("");
                }
                lvInvoices.Items[i].SubItems.Add(invoice.InvoiceID.ToString());
                lvInvoices.Items[i].SubItems.Add(
                    Convert.ToDateTime(invoice.InvoiceDate).ToShortDateString());
                lvInvoices.Items[i].SubItems.Add(invoice.InvoiceTotal.ToString("c"));
                i += 1;
            }
        }
Example #2
0
        private void Form1_Load(object sender, EventArgs e)
        {
            List <Invoice>  invoices  = InvoiceDB.GetInvoices();
            List <Customer> customers = CustomerDB.GetCustomers();

            var Invoices = from i in invoices
                           join c in customers
                           on i.CustomerID equals c.CustomerID
                           orderby c.Name, i.InvoiceTotal descending
                select new
            {
                c.Name,
                i.InvoiceID,
                i.InvoiceDate,
                i.InvoiceTotal
            };

            foreach (var inv in Invoices)
            {
                ListViewItem item = new ListViewItem(inv.Name);
                item.SubItems.Add(inv.InvoiceID.ToString());
                item.SubItems.Add(
                    Convert.ToDateTime(inv.InvoiceDate).ToShortDateString());
                item.SubItems.Add(inv.InvoiceTotal.ToString("c"));
                lvInvoices.Items.Add(item);
            }
        }