public int NewInvoice(int BusinessNumber, int CustomerNumber) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var business = new BusinessAccount(BusinessNumber); var customer = new Customer(CustomerNumber); var newInvoice = new Invoice { CreationDate = DateTime.Now, BusinessNumber = business.BusinessNumber, BusinessName = business.BusinessName, BusinessOwner = business.BusinessOwner, PhoneNumber = business.PhoneNumber, Email = business.Email, Website = business.Website, Logo = business.Logo, ABN = business.ABN, CustomerId = customer.CustomerId, Tax = (decimal)3.00, CustomerName = customer.CustomerName, CustomerAddress = customer.CustomerAddress, CustomerPhone = customer.CustomerPhoneNumber, CustomerEmail = customer.CustomerEmail, }; context.Invoices.Add(newInvoice); context.SaveChanges(); return(newInvoice.InvoiceNumber); } }
//make a constructor that takes in a businessnumber and customernumber and constructs invoice public Invoice([Optional] int id) { 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.invoiceComplete = invoice.invoiceComplete; 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.CustomerId = invoice.CustomerId; this.CustomerName = invoice.CustomerName; this.CustomerAddress = invoice.CustomerAddress; this.CustomerPhone = invoice.CustomerPhone; this.CustomerEmail = invoice.CustomerEmail; this.Notes = invoice.Notes; this.InvoiceItem = invoice.InvoiceItem.Where(x => x.InvoiceId == InvoiceNumber).ToList(); this.Tax = invoice.Tax; this.SubTotal = invoice.SubTotal; this.TotalCost = invoice.TotalCost; } }
public List <BusinessAccount> RetrieveBusinessList(string userId) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var businesses = context.BusinessAccounts.Where(x => x.UserAccount == userId).OrderBy(x => x.BusinessName).ToList(); return(businesses); } }
public static void DeleteBusiness(int id) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var business = new BusinessAccount(id); context.BusinessAccounts.Attach(business); context.BusinessAccounts.Remove(business); context.SaveChanges(); } }
public static void RemoveInvoiceItem(int id, FormCollection collection) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var invoiceID = Int32.Parse(collection["removeItem"]); var invoiceItem = context.InvoiceItems.Where(x => x.InvoiceItemId == invoiceID).FirstOrDefault(); context.InvoiceItems.Attach(invoiceItem); context.InvoiceItems.Remove(invoiceItem); context.SaveChanges(); } }
public static void InvoiceCreate(int id, int option, FormCollection collection) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var notes = collection["Notes"]; var invoice = context.Invoices.Where(x => x.InvoiceNumber == option).FirstOrDefault(); invoice.Notes = notes; invoice.invoiceComplete = true; context.SaveChanges(); } }
public Item(int id, FormCollection collection) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { BusinessNumber = id; ItemName = collection["ItemName"]; ItemDescription = collection["ItemDescription"]; Cost = Decimal.Parse(collection["Cost"]); context.Items.Add(this); context.SaveChanges(); } }
public static void AddCustomer(FormCollection collection, int id) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var customer = new Customer( BusinessNumber: id, CustomerName: collection["CustomerName"], CustomerAddress: collection["CustomerAddress"], CustomerPhoneNumber: collection["CustomerPhoneNumber"], CustomerEmail: collection["CustomerEmail"] ); } }
public static void InvoiceDelete(int id) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var invoice = new Invoice { InvoiceNumber = id }; context.Invoices.Attach(invoice); context.Invoices.Remove(invoice); context.SaveChanges(); var model = context.Invoices.Where(x => x.InvoiceNumber == id).FirstOrDefault(); } }
public Customer([Optional] int id) { this.CustomerId = id; using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var customer = context.Customers.Where(x => x.CustomerId == id).First(); this.BusinessNumber = customer.BusinessNumber; this.CustomerName = customer.CustomerName; this.CustomerAddress = customer.CustomerAddress; this.CustomerPhoneNumber = customer.CustomerPhoneNumber; this.CustomerEmail = customer.CustomerEmail; } }
public Customer(int BusinessNumber, string CustomerName, string CustomerAddress, string CustomerPhoneNumber, string CustomerEmail) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var customer = new Customer(); this.BusinessNumber = BusinessNumber; this.CustomerName = CustomerName; this.CustomerAddress = CustomerAddress; this.CustomerPhoneNumber = CustomerPhoneNumber; this.CustomerEmail = CustomerEmail; context.Customers.Add(this); context.SaveChanges(); } }
public BusinessAccount(FormCollection collection, string userID) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { this.BusinessName = collection["BusinessName"]; this.BusinessOwner = collection["BusinessOwner"]; this.PhoneNumber = collection["PhoneNumber"]; this.Email = collection["Email"]; this.Website = collection["Website"]; this.Logo = collection["Logo"]; this.ABN = collection["ABN"]; this.UserAccount = userID; context.BusinessAccounts.Add(this); context.SaveChanges(); } }
public static void AddInvoiceItem(int id, int option, FormCollection collection)//Clean up { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var formItemNumber = Int32.Parse(collection["ItemNumber"]); var itemForName = context.Items.Where(x => x.ItemNumber == formItemNumber).First(); var newInvoiceItem = new InvoiceItem { InvoiceId = option, ItemId = Int32.Parse(collection["ItemNumber"]), ItemQuantity = Int32.Parse(collection["ItemQuantity"]), ItemName = itemForName.ItemName, }; context.InvoiceItems.Add(newInvoiceItem); context.SaveChanges(); var orderItems = context.InvoiceItems.Where(x => x.InvoiceId == option).ToList(); var subtotal = (decimal)0.00; foreach (var item in orderItems) { //returning nothing? var itemCost = context.Items.Where(x => x.ItemNumber == item.ItemId).First(); System.Diagnostics.Debug.WriteLine("Item Is:"); System.Diagnostics.Debug.WriteLine(itemCost); var quantity = item.ItemQuantity; var cost = itemCost.Cost; var totalCost = cost * quantity; subtotal += totalCost; } var invoice = context.Invoices.Where(x => x.InvoiceNumber == option).FirstOrDefault(); // calculate and save total/tax var tax = (decimal)0.00; tax = Decimal.Parse(collection["taxRate"]); invoice.Tax = tax; var total = subtotal + ((subtotal / 100) * tax); invoice.SubTotal = subtotal; invoice.TotalCost = total; context.SaveChanges(); } }
public BusinessAccount([Optional] int id) { this.BusinessNumber = id; using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var business = context.BusinessAccounts.Where(x => x.BusinessNumber == id).First(); this.UserAccount = business.UserAccount; this.BusinessName = business.BusinessName; this.BusinessOwner = business.BusinessOwner; this.PhoneNumber = business.PhoneNumber; this.Email = business.Email; this.Website = business.Website; this.Logo = business.Logo; this.ABN = business.ABN; this.Invoices = business.Invoices.Where(x => x.invoiceComplete == true).ToList(); this.Customers = business.Customers.Where(x => x.BusinessNumber == id).ToList(); } }
public InvoiceDisplay NewInvoiceDisplay(int Id) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var invoice = new InvoiceDisplay(); var business = new BusinessAccount(Id); invoice.BusinessNumber = business.BusinessNumber; invoice.BusinessName = business.BusinessName; invoice.BusinessOwner = business.BusinessOwner; invoice.PhoneNumber = business.PhoneNumber; invoice.Email = business.Email; invoice.Website = business.Website; invoice.Logo = business.Logo; invoice.ABN = business.ABN; //Fill Customers up invoice.Customers = context.Customers.Where(x => x.BusinessNumber == Id).ToList(); return(invoice); } }
public static void UpdateBusiness(FormCollection collection, int businessNumber) { using (CustomerManagementSystemContext context = new CustomerManagementSystemContext()) { var business = context.BusinessAccounts.Where(x => x.BusinessNumber == businessNumber).FirstOrDefault(); if (collection["BusinessName"] != null) { business.BusinessName = collection["BusinessName"]; } if (collection["BusinessOwner"] != null) { business.BusinessOwner = collection["BusinessOwner"]; } if (collection["PhoneNumber"] != null) { business.PhoneNumber = collection["PhoneNumber"]; } if (collection["Email"] != null) { business.Email = collection["Email"]; } if (collection["Website"] != null) { business.Website = collection["Website"]; } if (collection["Logo"] != null) { business.Logo = collection["Logo"]; } if (collection["ABN"] != null) { business.ABN = collection["ABN"]; } context.SaveChanges(); } }