/// <summary>
        /// Sets a ship date and adjusts in stock quantity and sold quantities.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ProductShippedBtn_Click(object sender, EventArgs e)
        {
            Invoice invoice = (Invoice)invoiceCmbBox.SelectedItem;

            if (invoice != null)
            {
                invoice.ShipDate = DateTime.Now;
                ProductDb.Update(invoice);

                List <Product>          products  = ProductDb.GetInvoiceProducts(invoice.InvoiceID);
                List <InvoiceLineItems> lineItems = ProductDb.GetInvoiceQuantities(invoice.InvoiceID);

                for (int i = 0; i < products.Count; i++)
                {
                    products[i].OnHand -= lineItems[i].Quantity;
                    products[i].Sold   -= lineItems[i].Quantity;
                    ProductDb.Update(products[i]);
                }
                messageLbl.Text = $"Ship Date set to {DateTime.Now}";
            }
            else
            {
                MessageBox.Show("No invoice selected", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Beispiel #2
0
        /// <summary>
        /// Opens Microsoft Excel to view spreadsheet of the invoice.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ViewInvoiceBtn_Click(object sender, EventArgs e)
        {
            Invoice invoice = (Invoice)invoiceListBox.SelectedItem;

            if (invoice != null)
            {
                Customer                customer  = ProductDb.GetCustomer(invoice.Customers[0].CustomerID);
                List <Product>          products  = ProductDb.GetInvoiceProducts(invoice.InvoiceID);
                List <InvoiceLineItems> lineItems = ProductDb.GetInvoiceQuantities(invoice.InvoiceID);

                // Setting up the excel spreadsheet
                object Nothing = System.Reflection.Missing.Value;
                var    app     = new Microsoft.Office.Interop.Excel.Application();
                app.Visible = true;
                Workbook  workbook  = app.Workbooks.Add(Nothing);
                Worksheet worksheet = (Worksheet)workbook.Sheets[1];
                worksheet.Name = "Worksheet";

                // Formats the columns to be bold and font to 20
                worksheet.Cells[1, 1].EntireColumn.Font.Bold = true;
                worksheet.Cells[1, 1].EntireColumn.Font.Size = 20;
                worksheet.Cells[1, 2].EntireColumn.Font.Bold = true;
                worksheet.Cells[1, 2].EntireColumn.Font.Size = 20;
                worksheet.Cells[1, 3].EntireColumn.Font.Bold = true;
                worksheet.Cells[1, 3].EntireColumn.Font.Size = 20;

                // Fills in the cells with the invoice number and customer information
                worksheet.Cells[1, 1] = "Invoice number: " + invoice.InvoiceID;
                worksheet.Cells[3, 1] = customer.Business;
                worksheet.Cells[4, 1] = customer.ContactFirstName + " " + customer.ContactLastName;
                worksheet.Cells[5, 1] = customer.Address;
                worksheet.Cells[6, 1] = customer.City + ", " + customer.State + " " + customer.ZipCode;

                worksheet.Cells[7, 2] = "Product";
                worksheet.Cells[7, 3] = "Quantity";

                // Goes through a loop and fills in product information
                int count  = 8;
                int column = 2;
                for (int i = 0; i < products.Count; i++)
                {
                    worksheet.Cells[count, column]     = products[i].InvoiceDisplayString();
                    worksheet.Cells[count, column + 1] = lineItems[i].Quantity;
                    count++;
                }
                count++;

                worksheet.Cells[count, column]     = "Date Shipped:";
                worksheet.Cells[count + 1, column] = invoice.ShipDate;

                // Adjusts all the cells size to fit the text
                worksheet.Columns.AutoFit();
            }
            else
            {
                MessageBox.Show("There are no invoices to display", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }