private void RemoveSupplier() { Supplier supplier = GetSelectedSupplier(); using (var db = new StoreManagerContext()) { Supplier supplierToRemove = (from s in db.Suppliers where s.SupplierID == supplier.SupplierID select s).Single(); db.Suppliers.Remove(supplierToRemove); db.SaveChanges(); } }
private void RemoveProduct() { Product product = GetSelectedProduct(); using (var db = new StoreManagerContext()) { Product productToRemove = (from s in db.Products where s.ProductID == product.ProductID select s).Single(); db.Products.Remove(productToRemove); db.SaveChanges(); } }
private void RemoveUser() { User user = GetSelectedUser(); using (var db = new StoreManagerContext()) { User userToRemove = (from u in db.Users where u.UserID == user.UserID select u).Single(); db.Users.Remove(userToRemove); db.SaveChanges(); } }
private void NewUser() { User user = new User(); frmEditUser frmNewUser = new frmEditUser(user); if (frmNewUser.ShowDialog() == DialogResult.OK) { using (var db = new StoreManagerContext()) { db.Users.Add(user); db.SaveChanges(); } } }
private void NewSupplier() { Supplier supplier = new Supplier(); frmEditSupplier frmEditSupplier = new frmEditSupplier(supplier); if (frmEditSupplier.ShowDialog() == System.Windows.Forms.DialogResult.OK) { using (var db = new StoreManagerContext()) { db.Suppliers.Add(supplier); db.SaveChanges(); } } }
private void NewProduct() { Product product = new Product(); frmEditProduct frmEditProduct = new frmEditProduct(product); if (frmEditProduct.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Supplier supplier = GetSelectedSupplier(); product.SupplierID = supplier.SupplierID; using (var db = new StoreManagerContext()) { db.Products.Add(product); db.SaveChanges(); } } }
private void EditUser() { User user = GetSelectedUser(); frmEditUser frmEditUser = new frmEditUser(user); if (frmEditUser.ShowDialog() == DialogResult.OK) { using (var db = new StoreManagerContext()) { var originalUser = (from u in db.Users where u.UserID == user.UserID select u).Single(); CloneUser(user, originalUser); db.SaveChanges(); } } }
private void AddSale() { sale.SaleItems = saleItems; sale.SaleTimeStamp = DateTime.Now; using (var db = new StoreManagerContext()) { foreach (SaleItem saleItem in sale.SaleItems) { Product product = (from p in db.Products where p.ProductID == saleItem.ProductID select p).Single(); product.Stock -= saleItem.Quantity; saleItem.Product = null; } db.Sales.Add(sale); db.SaveChanges(); } }
private void RegisterShipment() { Product product = GetSelectedProduct(); frmEditShippment frmEditShippment = new frmEditShippment(product); if (frmEditShippment.ShowDialog() == DialogResult.OK) { using (var db = new StoreManagerContext()) { Product originalProduct = (from p in db.Products where p.ProductID == product.ProductID select p).Single(); originalProduct.Stock = product.Stock; db.SaveChanges(); } } }
private void EditProduct() { Product product = GetSelectedProduct(); frmEditProduct frmEditProduct = new frmEditProduct(product); if (frmEditProduct.ShowDialog() == DialogResult.OK) { using (var db = new StoreManagerContext()) { Product originalProduct = (from p in db.Products where p.ProductID == product.ProductID select p).Single(); CloneProduct(product, originalProduct); db.SaveChanges(); } } }
private void EditSupplier() { Supplier supplier = GetSelectedSupplier(); frmEditSupplier frmEditSupplier = new frmEditSupplier(supplier); if (frmEditSupplier.ShowDialog() == DialogResult.OK) { using (var db = new StoreManagerContext()) { var originalSupplier = (from s in db.Suppliers where s.SupplierID == supplier.SupplierID select s).Single(); CloneSupplier(supplier, originalSupplier); db.SaveChanges(); } } }