private void Button_Click_DelPro(object sender, RoutedEventArgs e) { db = new managementdbEntities(); if (selectedPro == null) { return; } if (selectedPro.BARCODE == null) { return; } PRODUCT delPro = db.PRODUCTs.Where(x => x.BARCODE == selectedPro.BARCODE).Select(x => x).SingleOrDefault(); string message = "Do you surely want to delete this product? "; string caption = "Delete Product"; var result = MessageBox.Show(message, caption, MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { delPro.PSTATUS = 0; db.SaveChanges(); MessageBox.Show("Deleted category"); this.Page_Loaded(sender, e); } else { } db.SaveChanges(); this.Page_Loaded(sender, e); selectedPro = null; }
// Add new category private void Button_Click_Add(object sender, RoutedEventArgs e) { addform = new CAdd(); addform.DatabaseChanged += addform_DatabaseChanged; addform.ShowDialog(); if (newCate == null) { return; } db = new managementdbEntities(); CATEGORY newCategory = db.CATEGORies.Where(x => x.CNAME == newCate).Select(x => x).FirstOrDefault(); if (newCategory == null) { newCategory = new CATEGORY(); newCategory.CNAME = newCate; newCategory.CSTATUS = 1; db.CATEGORies.Add(newCategory); } else { newCategory.CSTATUS = 1; } db.SaveChanges(); this.Page_Loaded(sender, e); newCate = null; }
private void Button_Click_UpdPro(object sender, RoutedEventArgs e) { if (selectedPro == null) { return; } if (selectedPro.BARCODE == null) { return; } pupdform = new PUpdate(selectedPro); pupdform.DatabaseChanged += pupdform_DatabaseChanged; pupdform.ShowDialog(); if (updPro == "" || updPro == null) { return; } var result = updPro.ToString(); //MessageBox.Show(result); var tokens = updPro.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries) .Select(token => token.Trim()) .ToArray(); PRODUCT updProduct = db.PRODUCTs.Where(x => x.BARCODE == selectedPro.BARCODE).Select(x => x).FirstOrDefault(); // update = add + delete if (updProduct != null) { // Not edit Barcode if (updProduct.BARCODE != tokens[0]) { PRODUCT newProduct = new PRODUCT(); newProduct.BARCODE = tokens[0]; newProduct.PNAME = tokens[1]; newProduct.PRICE = int.Parse(tokens[2]); newProduct.QTY = int.Parse(tokens[3]); newProduct.CATE = tokens[4]; newProduct.PSTATUS = 1; updProduct.PSTATUS = 0; db.PRODUCTs.Add(newProduct); } else { updProduct.PNAME = tokens[1]; updProduct.PRICE = int.Parse(tokens[2]); updProduct.QTY = int.Parse(tokens[3]); updProduct.CATE = tokens[4]; updProduct.PSTATUS = 1; } } db.SaveChanges(); this.Page_Loaded(sender, e); selectedPro = null; }
private void Button_Click_Delete(object sender, RoutedEventArgs e) { db = new managementdbEntities(); if (selectedCate == null) { return; } if (selectedCate.CNAME == null) { return; } CATEGORY delEntry = db.CATEGORies.Where(x => x.CNAME == selectedCate.CNAME).Select(x => x).FirstOrDefault(); bool productOfCate = db.PRODUCTs.Where(x => x.CATE == selectedCate.CNAME).Any(); if (productOfCate) { string message = selectedCate.CNAME + " has already contained product(s). Do you still want to delete this category? "; string caption = "Delete Category"; var result = MessageBox.Show(message, caption, MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { delEntry.CSTATUS = 0; db.SaveChanges(); MessageBox.Show("Deleted product"); this.Page_Loaded(sender, e); } else { } } else { delEntry.CSTATUS = 0; db.SaveChanges(); MessageBox.Show("Deleted product"); this.Page_Loaded(sender, e); } selectedCate = null; }
private void Button_Click_AddOrder(object sender, RoutedEventArgs e) { oaddform = new OAdd(); oaddform.DatabaseChanged += oadddform_DatabaseChanged; oaddform.ShowDialog(); if (newOrd == null) { return; } var result = newOrd.ToString(); var tokens = newOrd.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries) .Select(token => token.Trim()) .ToArray(); // BARCODE, QUANTITY, DATE, TOTAL, COUPON db = new managementdbEntities(); // add to transaction data ORDER newOrder = new ORDER(); newOrder.BARCODE = tokens[0]; newOrder.QTY = int.Parse(tokens[1]); newOrder.DATE = DateTime.Parse(tokens[2]); newOrder.TOTAL = int.Parse(tokens[3]); db.ORDERs.Add(newOrder); // modify master data PRODUCT updProduct = db.PRODUCTs.Where(x => x.BARCODE == newOrder.BARCODE).Select(x => x).SingleOrDefault(); if (updProduct != null) { updProduct.QTY = updProduct.QTY - newOrder.QTY; } //db.SaveChanges(); // modify coupon date string couponCode = tokens[4].ToString(); COUPON updCoupon = db.COUPONs.Where(x => x.CODE == couponCode).Select(x => x).SingleOrDefault(); if (updCoupon != null) { updCoupon.AVAILABLE = updCoupon.AVAILABLE - 1; } //db.SaveChanges(); db.SaveChanges(); this.Page_Loaded(sender, e); }
private void Button_Click_AddPro(object sender, RoutedEventArgs e) { paddform = new PAdd(); paddform.DatabaseChanged += paddform_DatabaseChanged; paddform.ShowDialog(); db = new managementdbEntities(); if (newPro == null) { return; } //MessageBox.Show(newPro.ToString()); var result = newPro.ToString(); var tokens = newPro.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries) .Select(token => token.Trim()) .ToArray(); string barcode = tokens[0].ToString(); PRODUCT newProduct = db.PRODUCTs.Where(x => x.BARCODE == barcode).Select(x => x).FirstOrDefault(); if (newProduct == null) { newProduct = new PRODUCT(); newProduct.BARCODE = tokens[0]; newProduct.PNAME = tokens[1]; newProduct.PRICE = int.Parse(tokens[2]); newProduct.QTY = int.Parse(tokens[3]); newProduct.CATE = tokens[4]; newProduct.PSTATUS = 1; db.PRODUCTs.Add(newProduct); } else if (newProduct.PSTATUS == 0) { newProduct.PNAME = tokens[1]; newProduct.PRICE = int.Parse(tokens[2]); newProduct.QTY = int.Parse(tokens[3]); newProduct.CATE = tokens[4]; newProduct.PSTATUS = 1; } db.SaveChanges(); this.Page_Loaded(sender, e); newPro = null; }