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;
}
}
