private void ButtonUpdate_Click(object sender, RoutedEventArgs e) { switch (TabControlConsole.SelectedIndex) { case 2: if (LvEmployee.SelectedIndex < 0) { MessageBox.Show("Please select an Employee", "Warning", MessageBoxButton.OK, MessageBoxImage.Information); return; } Employee ep = (Employee)LvEmployee.Items[LvEmployee.SelectedIndex]; TbEmployeeId.Text = ep.Id + ""; TbFirstName.Text = ep.FirstName; TbLastName.Text = ep.LastName; TbUserName.Text = ep.UserName; TbPassWord.Text = ep.PSword; TbSalary.Text = ep.Salary.ToString("$#.##"); TabControlSearch.SelectedIndex = 2; TabControlConsole.SelectedIndex = 2; break; case 1: if (LvOrders.SelectedIndex < 0) { MessageBox.Show("Please select a Order Item", "Warning", MessageBoxButton.OK, MessageBoxImage.Information); return; } Order o = (Order)LvOrders.Items[LvOrders.SelectedIndex]; TbOrderID.Text = o.OrderId + ""; TbInvoiceNo.Text = o.InvoiceNr + ""; TbCustomerId.Text = o.CustomerId + ""; TbEmployeeID.Text = o.EmpId + ""; TbTotalPrice.Text = o.TotalPrice.ToString("$ ###.00"); TbPaymentMethod.Text = o.PaymentMethod + ""; TbOderDate.Text = o.OrderDate.ToString(); TabControlSearch.SelectedIndex = 1; TabControlConsole.SelectedIndex = 1; break; case 0: if (LvItems.SelectedIndex < 0) { MessageBox.Show("Please select a Item", "Warning", MessageBoxButton.OK, MessageBoxImage.Information); return; } InStock ins = (InStock)LvItems.Items[LvItems.SelectedIndex]; TbProductName.Text = ins.ProductName; TbAlertUnit.Text = ins.TriggerLevel + ""; TbVendor.Text = ins.Vendor; TbSalePrice.Text = ins.SalePrice.ToString("$ ##.00"); TbCategoryId.Text = ins.CategoryId + ""; TbStockUnit.Text = ins.Quantity + ""; TbPurchasedPrice.Text = ins.UnitPrice.ToString("$ ##.00"); TbProductId.Text = ins.Id + ""; TabControlConsole.SelectedIndex = 0; TabControlSearch.SelectedIndex = 0; break; } }
private void ButtonDelete_Click(object sender, RoutedEventArgs e) { switch (TabControlConsole.SelectedIndex) { case 2: if (LvEmployee.SelectedIndex < 0) { MessageBox.Show("Please select an Employee", "Warning", MessageBoxButton.OK, MessageBoxImage.Information); return; } Employee ep = (Employee)LvEmployee.Items[LvEmployee.SelectedIndex]; db1.DeleteEmployeeById(ep.Id); ReadEmployee(); break; case 1: if (LvOrders.SelectedIndex < 0) { MessageBox.Show("Please select a Order Item", "Warning", MessageBoxButton.OK, MessageBoxImage.Information); return; } Order o = (Order)LvOrders.Items[LvOrders.SelectedIndex]; db1.DeleteOrderById(o.OrderId); ReadOrders(); break; case 0: if (LvItems.SelectedIndex < 0) { MessageBox.Show("Please select a Item", "Warning", MessageBoxButton.OK, MessageBoxImage.Information); return; } InStock ins = (InStock)LvItems.Items[LvItems.SelectedIndex]; db1.DeleteProductById(ins.Id); ReadStocks(); break; } }
private void ButtonConfirm_Click(object sender, RoutedEventArgs e) { switch (TabControlSearch.SelectedIndex) { case 2: int Id; Int32.TryParse(TbEmployeeId.Text, out Id); decimal salary; decimal.TryParse(TbSalary.Text, out salary); Employee ep = new Employee(Id, TbFirstName.Text, TbLastName.Text, TbUserName.Text, TbPassWord.Text, salary); List <Employee> list = db1.GetAllEmployees(); if (list != null) { foreach (Employee emp in list) { if (emp.Id == Id) { db1.UpdateEmployee(ep); ReadEmployee(); return; } } db1.AddEmployee(ep); ReadEmployee(); } return; case 1: int orderId; Int32.TryParse(TbOrderID.Text, out orderId); decimal totalPrice; decimal.TryParse(TbTotalPrice.Text, out totalPrice); int invoiceNr; Int32.TryParse(TbInvoiceNo.Text, out invoiceNr); int customerId; Int32.TryParse(TbCustomerId.Text, out customerId); int empId; Int32.TryParse(TbEmployeeID.Text, out empId); string paymentMethod = TbPaymentMethod.Text; DateTime orderDate; DateTime.TryParse(TbOderDate.Text, out orderDate); Order od = new Order(orderId, empId, orderDate, customerId, totalPrice, paymentMethod, invoiceNr); // Order o = new Order(currentOrderId, 1, dpDate.SelectedDate.Value.Date, 100, total, ComboCard.Text, invoiceNo); List <Order> oList = db1.GetAllOrders(); if (oList != null) { foreach (Order o in oList) { if (o.OrderId == orderId) { db1.UpdateOrder(od); ReadOrders(); return; } } db1.AddOrder(od); ReadOrders(); } return; case 0: int productId; Int32.TryParse(TbProductId.Text, out productId); int categoryId; Int32.TryParse(TbCategoryId.Text, out categoryId); string productName = TbProductName.Text; decimal unitPrice; decimal.TryParse(TbPurchasedPrice.Text, out unitPrice); decimal salePrice; decimal.TryParse(TbSalePrice.Text, out salePrice); int quantity; Int32.TryParse(TbStockUnit.Text, out quantity); int triggerLevel; Int32.TryParse(TbAlertUnit.Text, out triggerLevel); string vendor = TbVendor.Text; DateTime expyDate = DateTime.Today; // DateTime.TryParse(TbExpDate.Text, out expyDate); InStock ins = new InStock(productId, categoryId, productName, unitPrice, salePrice, quantity, triggerLevel, vendor, expyDate); List <InStock> insList = db1.GetAllProducts(); if (insList != null) { foreach (InStock insL in insList) { if (insL.Id == productId) { db1.UpdateProduct(ins); ReadStocks(); return; } } db1.AddProduct(ins); ReadStocks(); } return; } }