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 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 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();
}
}
}
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 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 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 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 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();
}
}
}
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 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 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 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();
}
}
}
