public void CreateNewProduct() { using (SimpleSaleDbContext _contex = new SimpleSaleDbContext()) { Product p = new Product(); p.ProductName = txtProductName.Text.ToString(); p.Barcode = txtBarcode.Text.ToString(); p.ProductDescription = txtProductDescription.Text.ToString(); p.PurchasePrice = Decimal.Parse(txtProductPurchasePrice.Text); p.SellingPrice = Decimal.Parse(txtProductSellingPrice.Text); //Checks for duplication using the products Barcode if (_contex.Products.ToList().Any(x => x.Barcode == p.Barcode)) { MessageBox.Show("Product Already Exsits in table products."); return; } else { _contex.Products.Add(p); _contex.SaveChanges(); MessageBox.Show("Product Successfully Added"); txtProductName.Clear(); txtBarcode.Clear(); txtProductDescription.Clear(); txtProductPurchasePrice.Clear(); txtProductSellingPrice.Clear(); PopulateDataGridWithProductsList(); } } }
public void DeleteProduct() { using (SimpleSaleDbContext _context = new SimpleSaleDbContext()) { var p = _context.Products.FirstOrDefault(x => x.Barcode == lblDeleteInFoBarcode.Text.ToString()); _context.Remove(p); _context.SaveChanges(); lblDeleteInFoBarcode.Text = ""; lblDeleteInFoName.Text = ""; txtGetDeleteBarcode.Clear(); MessageBox.Show("Product Successfully Deleted!!!"); } }
public void AddNewVat() { using (SimpleSaleDbContext _context = new SimpleSaleDbContext()) { ValueAddedTax vat = new ValueAddedTax(); vat.VATName = txtVatName.Text.ToString(); vat.VATValue = Convert.ToDecimal(txtVatValue.Text.ToString()); _context.ValueAddedTaxes.Add(vat); _context.SaveChanges(); txtVatName.Clear(); txtVatValue.Clear(); MessageBox.Show("VAT Successfully Added To Table", "VAT"); } }
public void UpdateProduct() { using (SimpleSaleDbContext _context = new SimpleSaleDbContext()) { var p = _context.Products.FirstOrDefault(x => x.Barcode == txtGetBarcode.Text.ToString()); p.ProductName = txtUpdateProductName.Text.ToString(); p.Barcode = txtGetBarcode.Text.ToString(); p.ProductDescription = txtUpdateProductDescription.Text.ToString(); p.PurchasePrice = Decimal.Parse(txtUpdateProductPurchasePrice.Text.ToString()); p.SellingPrice = Decimal.Parse(txtUpdateProductSellingPrice.Text.ToString()); _context.SaveChanges(); txtUpdateProductName.Clear(); txtUpdateProductDescription.Clear(); txtUpdateProductPurchasePrice.Clear(); txtUpdateProductSellingPrice.Clear(); txtGetBarcode.Clear(); PopulateDataGridWithProductsList(); MessageBox.Show("Product Successfully Updated"); } }
public void CreateSale() { Sale newSale = new Sale(); newSale.SaleSubTotal = GetCartSubTotal(); newSale.SaleTotalTax = GetCartVatTotal(); newSale.SaleTotalTax = GetCartTotal(); if (newSale.SaleSubTotal < 0) { MessageBox.Show("Please provide a subtotal.", "Error - Invaild Value", MessageBoxButton.OK, MessageBoxImage.Error); } else if (newSale.SaleTotalTax < 0) { MessageBox.Show("Please provide a tax total.", "Error - Invaild Value", MessageBoxButton.OK, MessageBoxImage.Error); } else if (newSale.SaleTotal < 0) { MessageBox.Show("Please provide a total.", "Error - Invaild Value", MessageBoxButton.OK, MessageBoxImage.Error); } else { using (SimpleSaleDbContext _context = new SimpleSaleDbContext()) { _context.Sales.Add(newSale); _context.SaveChanges(); Sale sale = _context.Sales.OrderBy(p => p.DateCreated).LastOrDefault(); if (sale == null) { MessageBox.Show("Unable to find Sale.", "Error - Null Return"); return; } else { if (dgSaleItem.Items.Count <= 0) { MessageBox.Show("No items in cart, Please add items to cart", "Error - Empty Value", MessageBoxButton.OK, MessageBoxImage.Error); return; } else { foreach (SaleItem item in dgSaleItem.Items) { item.SaleId = sale.Id; _context.SalesItems.Add(item); _context.SaveChanges(); } Receipt newReceipt = new Receipt(); newReceipt.SaleId = sale.Id; newReceipt.AmountTendered = decimal.Parse(txtAmountTendred.Text.Remove(0, 1)); newReceipt.Change = CalculateChange(); if (CalculateChange() < 0) { MessageBox.Show("Amount tendred is below total amount, Please enter a amount greater than the total.", "Error - Amount Invalid", MessageBoxButton.OK, MessageBoxImage.Error); txtAmountTendred.Focus(); return; } else { _context.Receipts.Add(newReceipt); _context.SaveChanges(); dgSaleItem.Items.Clear(); lblDiscountTotal.Text = string.Empty; lblSubTotal.Text = string.Empty; lblTotalVat.Text = string.Empty; lblPriceTotalVat.Text = string.Empty; txtSaleGrandTotal.Clear(); txtAmountTendred.Clear(); } } } } } }