public MainWindow() { InitializeComponent(); try { WorkWithDatabase work = new WorkWithDatabase(); work.createNewDatabase(); } catch (Exception e) { MessageBox.Show("Cann`t create Database"); } }
private void Button_Set_Click(object sender, RoutedEventArgs e) { if (priceSet.Text.Equals("")) { MessageBox.Show("The lower price isn`t filled!"); } else { WorkWithDatabase work = new WorkWithDatabase(); work.addLowerPriceLimit(Convert.ToDouble(priceSet.Text)); priceSet.Text = ""; } }
private void Button_AddToCart_Click(object sender, RoutedEventArgs e) { if (!amountToBuy.Text.Equals("")) { WorkWithDatabase work = new WorkWithDatabase(); SQLiteDataReader dbDataReader = work.selectProducts(); ArrayList allProducts = new ArrayList(); while (dbDataReader.Read()) { allProducts.Add(new Product(dbDataReader["PRODUCT_NAME"].ToString(), Convert.ToDouble(dbDataReader["PRODUCT_PRICE"]), false)); } string selectedProduct = productsCombo.Text; foreach (Product item in allProducts) { int amount = 0; if (selectedProduct.Equals(item.Name)) { amount = Convert.ToInt32(amountToBuy.Text); for (int i = 0; i < amount; i++) { purchasedProducts.Add(new Product(item.Name, item.Price, false)); } totalPrice += item.Price * amount; purchazedProductsCobmoBox.Items.Clear(); foreach (Product prod in purchasedProducts) { ComboboxItem comboItem = new ComboboxItem(); comboItem.Text = prod.Name; if (prod.HasDiscount == false) { purchazedProductsCobmoBox.Items.Add(comboItem); } } } } productInfo.Text = "Total price " + totalPrice.ToString(); amountInTheCart += Convert.ToInt32(amountToBuy.Text); productsInTheCart.Text = "Products in the cart: " + amountInTheCart.ToString(); } else { MessageBox.Show("Enter Amount"); } }
public BuyWindow() { InitializeComponent(); WorkWithDatabase work = new WorkWithDatabase(); var dbDataReader = work.selectProducts(); ArrayList allProducts = new ArrayList(); while (dbDataReader.Read()) { ComboboxItem item = new ComboboxItem(); item.Text = dbDataReader["PRODUCT_NAME"].ToString(); productsCombo.Items.Add(item); } dbDataReader.Close(); }
private void Button_Product_Add_Click(object sender, RoutedEventArgs e) { if (nameOfProduct.Text.Equals("") || priceOfProduct.Text.Equals("")) { MessageBox.Show("Not all fields are filled!"); } else { Product product = new Product(nameOfProduct.Text, Convert.ToDouble(priceOfProduct.Text), false); WorkWithDatabase work = new WorkWithDatabase(); work.addProduct(product); nameOfProduct.Text = ""; priceOfProduct.Text = ""; } }
private void Button_Coupon_Add_Click(object sender, RoutedEventArgs e) { if (couponNumber.Text.Equals("") || Discount.Text.Equals("")) { MessageBox.Show("Not all fields are filled!"); } else { ComboBoxItem typeItem = (ComboBoxItem)comboBox.SelectedItem; Coupon coupon = new Coupon(Convert.ToInt32(couponNumber.Text), Convert.ToDouble(Discount.Text), typeItem.Content.ToString()); WorkWithDatabase work = new WorkWithDatabase(); work.addCoupon(coupon); couponNumber.Text = ""; Discount.Text = ""; } }
private void getDiscount_Click(object sender, RoutedEventArgs e) { if (!numberOfCoupon.Text.Equals("")) { if (!purchazedProductsCobmoBox.Text.Equals("")) { WorkWithDatabase work = new WorkWithDatabase(); double discount = 0; string couponType = ""; SQLiteDataReader couponnReader = work.selectCoupon(Convert.ToInt32(numberOfCoupon.Text)); if (couponnReader.HasRows) { couponnReader.Read(); discount = Convert.ToDouble(couponnReader["COUPON_DISCOUNT"]); couponType = couponnReader["COUPON_TYPE"].ToString(); couponnReader.Close(); } else { MessageBox.Show("Coupon not found"); } SQLiteDataReader lowerPriceLimitReader = work.selectLowerPrice(); lowerPriceLimitReader.Read(); double lowerPriceLimit = Convert.ToInt32(lowerPriceLimitReader["PRICE_LIMIT"]); lowerPriceLimitReader.Close(); SQLiteDataReader productForDiscount = work.selectOneProduct(purchazedProductsCobmoBox.Text); productForDiscount.Read(); double discountProductPrice = Convert.ToDouble(productForDiscount["PRODUCT_PRICE"]); int enteredCouponNumber = Convert.ToInt32(numberOfCoupon.Text); productForDiscount.Close(); WorkWithCoupons couponsWork = new WorkWithCoupons(); string productForDiscountCombo = purchazedProductsCobmoBox.Text; switch (couponType) { case "All Products": { int myInd; double totalPrice1 = couponsWork.getDiscount(purchasedProducts, totalPrice, discountProductPrice, discount, productForDiscountCombo, out myInd); //totalPrice = totalPrice - discountProductPrice * (discount / 100); totalPrice = totalPrice1; productInfo.Text = "Total price " + totalPrice.ToString(); /* Product[] prArray = purchasedProducts.ToArray<Product>(); int myIndex = 0; for (int i = 0; i < prArray.Length; i++) { if (prArray[i].Name == purchazedProductsCobmoBox.Text) { myIndex = i - 1; } }*/ int myIndex = myInd; purchasedProducts.RemoveAt(myIndex); purchazedProductsCobmoBox.Items.Clear(); foreach (Product prod in purchasedProducts) { ComboboxItem comboItem = new ComboboxItem(); comboItem.Text = prod.Name; if (prod.HasDiscount == false) { purchazedProductsCobmoBox.Items.Add(comboItem); } } work.deleteCoupon(Convert.ToInt32(numberOfCoupon.Text)); numberOfCoupon.Text = ""; } break; case "Lower Price": { if (discountProductPrice <= lowerPriceLimit) { int myInd; double totalPrice1 = couponsWork.getDiscount(purchasedProducts, totalPrice, discountProductPrice, discount, productForDiscountCombo, out myInd); totalPrice = totalPrice1; productInfo.Text = "Total price " + totalPrice.ToString(); int myIndex = myInd; purchasedProducts.RemoveAt(myIndex); purchazedProductsCobmoBox.Items.Clear(); foreach (Product prod in purchasedProducts) { ComboboxItem comboItem = new ComboboxItem(); comboItem.Text = prod.Name; if (prod.HasDiscount == false) { purchazedProductsCobmoBox.Items.Add(comboItem); } } work.deleteCoupon(Convert.ToInt32(numberOfCoupon.Text)); numberOfCoupon.Text = ""; } else { MessageBox.Show("Coupon doesn`t fay!"); } } break; case "Higher Price": { if (discountProductPrice > lowerPriceLimit) { int myInd; double totalPrice1 = couponsWork.getDiscount(purchasedProducts, totalPrice, discountProductPrice, discount, productForDiscountCombo, out myInd); totalPrice = totalPrice1; productInfo.Text = "Total price " + totalPrice.ToString(); int myIndex = myInd; purchasedProducts.RemoveAt(myIndex); purchazedProductsCobmoBox.Items.Clear(); foreach (Product prod in purchasedProducts) { ComboboxItem comboItem = new ComboboxItem(); comboItem.Text = prod.Name; if (prod.HasDiscount == false) { purchazedProductsCobmoBox.Items.Add(comboItem); } } work.deleteCoupon(Convert.ToInt32(numberOfCoupon.Text)); numberOfCoupon.Text = ""; } else { MessageBox.Show("Coupon doesn`t fay!"); } } break; default: break; } } else { MessageBox.Show("Select product for discount"); } } else { MessageBox.Show("Coupon not entered!"); } }