public InvoiceItemVM(int BusinessNumber, int InvoiceId) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { this.Items = context.Items.Where(x => x.BusinessNumber == BusinessNumber).ToList(); this.Ordered = context.InvoiceItems.Where(x => x.InvoiceId == InvoiceId).ToList(); foreach (var order in this.Ordered) { var item = context.Items.Where(x => x.ItemNumber == order.ItemId).First(); order.ItemName = item.ItemName; } var orderItems = context.InvoiceItems.Where(x => x.InvoiceId == InvoiceId).ToList(); Subtotal = (decimal)0.00; foreach (var item in orderItems) { var itemCost = context.Items.Where(x => x.ItemNumber == item.ItemId).First(); var quantity = item.ItemQuantity; var cost = itemCost.Cost; var totalCost = cost * quantity; Subtotal += totalCost; } var invoice = context.Invoices.Where(x => x.InvoiceNumber == InvoiceId).FirstOrDefault(); Total = Subtotal + ((Subtotal / 100) * invoice.Tax); this.BusinessNumber = BusinessNumber; this.InvoiceId = InvoiceId; } }
public InvoiceDetails(int id) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var invoice = context.Invoices.Where(x => x.InvoiceNumber == id).FirstOrDefault(); InvoiceNumber = id; CreationDate = invoice.CreationDate; invoiceComplete = invoice.invoiceComplete; BusinessNumber = invoice.BusinessNumber; BusinessName = invoice.BusinessName; BusinessOwner = invoice.BusinessOwner; PhoneNumber = invoice.PhoneNumber; Email = invoice.Email; Website = invoice.Website; Logo = invoice.Logo; ABN = invoice.ABN; CustomerId = invoice.CustomerId; CustomerName = invoice.CustomerName; CustomerAddress = invoice.CustomerAddress; CustomerPhone = invoice.CustomerPhone; CustomerEmail = invoice.CustomerEmail; Notes = invoice.Notes; InvoiceItem = context.InvoiceItems.Where(x => x.InvoiceId == id).ToList(); Tax = invoice.Tax; SubTotal = invoice.SubTotal; TotalCost = invoice.TotalCost; } }
public InvoiceDisplay([Optional] int id, [Optional] int BusinessNumber) { this.InvoiceNumber = id; using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var invoice = context.Invoices.Where(x => x.InvoiceNumber == id).First(); this.InvoiceNumber = invoice.InvoiceNumber; this.CreationDate = invoice.CreationDate; this.BusinessNumber = invoice.BusinessNumber; this.BusinessName = invoice.BusinessName; this.BusinessOwner = invoice.BusinessOwner; this.PhoneNumber = invoice.PhoneNumber; this.Email = invoice.Email; this.Website = invoice.Website; this.Logo = invoice.Logo; this.ABN = invoice.ABN; this.Customers = context.Customers.Where(x => x.BusinessNumber == BusinessNumber).ToList(); this.Notes = invoice.Notes; this.InvoiceItem = invoice.InvoiceItem.Where(x => x.InvoiceId == InvoiceNumber).ToList(); this.Items = context.Items.Where(x => x.BusinessNumber == BusinessNumber).ToList(); this.Tax = invoice.Tax; this.SubTotal = invoice.SubTotal; this.TotalCost = invoice.TotalCost; } }