private void CustomerOrderDetails_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
tbCustomer.Text = _selectedCustomer.FullName;
tbOrderID.Text = _selectedOrder.OrderID.ToString();
//tbEmployee.Text = _selectedOrder.Employee.FullName;
tbDateCreated.Text = _selectedOrder.DateCreated.ToShortDateString();
var productlist = ctx.OrderProducts.Where(x => x.OrderID == _selectedOrder.OrderID).Select(x => x).ToList();
foreach (var item in productlist)
{
var listproduct = new SelectedProduct
{
Name = item.Product.Name,
ProductID = item.ProductID,
Amount = item.Amount
};
_productsinorder.Add(listproduct);
}
lbProducts.DataSource = null;
lbProducts.DisplayMember = "NameAndAmount";
lbProducts.ValueMember = "ProductID";
lbProducts.DataSource = _productsinorder;
}
}
private void OrderOverview_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
if (_loggedInEmployee.AccessID == 3)
{
lblObject.Text = "Customer:";
var customerlist = ctx.Customers.ToList();
cbObject.DataSource = null;
cbObject.DisplayMember = "FullName";
cbObject.ValueMember = "CustomerID";
cbObject.DataSource = customerlist;
}
else if (_loggedInEmployee.AccessID == 2)
{
lblObject.Text = "Supplier:";
var supplierlist = ctx.Suppliers.ToList();
cbObject.DataSource = null;
cbObject.DisplayMember = "Name";
cbObject.ValueMember = "SupplierID";
cbObject.DataSource = supplierlist;
}
}
}
private void cbObject_SelectedIndexChanged(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
if (_loggedInEmployee.AccessID == 3)
{
var selectedcustomer = (Customer)cbObject.SelectedItem;
var customerorders = ctx.Orders.Where(x => x.CustomerID == selectedcustomer.CustomerID).ToList();
lbOrders.DataSource = null;
lbOrders.DisplayMember = "ShowOrder";
lbOrders.ValueMember = "OrderID";
lbOrders.DataSource = customerorders;
}
else if (_loggedInEmployee.AccessID == 2)
{
var selectedsupplier = (Supplier)cbObject.SelectedItem;
var supplierorders = ctx.Orders.Where(x => x.SupplierID == selectedsupplier.SupplierID).ToList();
lbOrders.DataSource = null;
lbOrders.DisplayMember = "ShowOrder";
lbOrders.ValueMember = "OrderID";
lbOrders.DataSource = supplierorders;
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (tbNew.Text != tbConfirm.Text)
{
MessageBox.Show("Passwords do not match.");
}
else
{
var hasher = new Hashing();
var salt = hasher.GetHashString(hasher.CreateSalt());
var hash = hasher.sha256encrypt(tbConfirm.Text, salt);
var success = hasher.VerifyHash(tbConfirm.Text, salt, hash);
if (success)
{
using (var ctx = new WarehouseDataEntity())
{
var login = new Login()
{
EmployeeID = _selectedEmployee.EmployeeID,
LastLoggedIn = DateTime.Now
};
var employee = ctx.Employees.Single(x => x.EmployeeID == _selectedEmployee.EmployeeID);
employee.Password = hash;
employee.Salt = salt;
ctx.Logins.Add(login);
ctx.SaveChanges();
Close();
}
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (_selectedCustomer == null)
{
var dialogResult = MessageBox.Show("Are you sure you want to create this new customer?", "New customer", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var newCustomer = new Customer()
{
Firstname = tbFirstname.Text,
Lastname = tbLastname.Text,
Address = tbAddress.Text,
Housenumber = tbNumber.Text,
Bus = tbBus.Text,
ZIP_code = Convert.ToInt32(tbZIP.Text),
City = tbCity.Text,
Phonenumber = tbPhone.Text,
e_mail = tbemail.Text,
Note = tbNote.Text,
JoinDate = DateTime.Now
};
ctx.Customers.Add(newCustomer);
ctx.SaveChanges();
MessageBox.Show("Customer added.");
Close();
}
}
}
else
{
var dialogResult = MessageBox.Show("Are you sure you want to edit this customer?", "Edit customer", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var getCustomer = ctx.Customers.Find(_selectedCustomer.CustomerID);
getCustomer.Firstname = tbFirstname.Text;
getCustomer.Lastname = tbLastname.Text;
getCustomer.Address = tbAddress.Text;
getCustomer.Housenumber = tbNumber.Text;
getCustomer.Bus = tbBus.Text;
getCustomer.ZIP_code = Convert.ToInt32(tbZIP.Text);
getCustomer.City = tbCity.Text;
getCustomer.Phonenumber = tbPhone.Text;
getCustomer.e_mail = tbemail.Text;
getCustomer.Note = tbNote.Text;
ctx.SaveChanges();
MessageBox.Show("Changes saved.");
Close();
}
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (_selectedProduct == null)
{
var newProduct = new Product()
{
Name = tbName.Text,
Cost = decimal.Parse(tbCost.Text),
Margin = decimal.Parse(tbMargin.Text),
Tax = Convert.ToInt32(cbTax.SelectedValue),
CategoryID = Convert.ToInt32(cbCategory.SelectedValue),
SupplierID = Convert.ToInt32(cbSupplier.SelectedValue),
InStock = rbYes.Checked ? true : false,
AmountInStock = tbAmount.Text == string.Empty ? 0 : int.Parse(tbAmount.Text),
};
using (var ctx = new WarehouseDataEntity())
{
var dialogResult = MessageBox.Show("Are you sure you want to create this new product?", "New product", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
ctx.Products.Add(newProduct);
ctx.SaveChanges();
Close();
}
}
}
else
{
using (var ctx = new WarehouseDataEntity())
{
var dialogResult = MessageBox.Show("Are you sure you want to save changes?", "Edit product", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
var productToEdit = ctx.Products.Find(_selectedProduct.ProductID);
if (productToEdit == null)
{
MessageBox.Show("Something went wrong.");
}
else
{
productToEdit.Name = tbName.Text;
productToEdit.Cost = decimal.Parse(tbCost.Text);
productToEdit.Margin = decimal.Parse(tbMargin.Text);
productToEdit.Tax = Convert.ToInt32(cbTax.SelectedValue);
productToEdit.CategoryID = Convert.ToInt32(cbCategory.SelectedValue);
productToEdit.SupplierID = Convert.ToInt32(cbSupplier.SelectedValue);
productToEdit.InStock = rbYes.Checked ? true : false;
ctx.SaveChanges();
Close();
}
}
}
}
}
private void CustomerOrderOverview_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var customerlist = ctx.Customers.ToList();
cbCustomer.DisplayMember = "FullName";
cbCustomer.ValueMember = "CustomerID";
cbCustomer.DataSource = customerlist;
}
}
private void NewUser_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var accesslist = ctx.Accesses.ToList();
cbDepartment.DisplayMember = "AccessName";
cbDepartment.ValueMember = "AccessID";
cbDepartment.DataSource = accesslist;
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (_selectedSupplier == null)
{
var dialogResult = MessageBox.Show("Are you sure you want to create this new supplier?", "New supplier", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var newSupplier = new Supplier()
{
Name = tbName.Text,
Phonenumber = tbPhone.Text,
e_mail = tbEmail.Text,
Address = tbAddress.Text,
HouseNumber = int.Parse(tbNumber.Text),
Bus = tbBus.Text,
ZIP_Code = int.Parse(tbZIP.Text),
City = tbCity.Text
};
ctx.Suppliers.Add(newSupplier);
ctx.SaveChanges();
MessageBox.Show("Supplier added.");
Close();
}
}
}
else
{
var dialogResult = MessageBox.Show("Are you sure you want to edit this supplier?", "Edit supplier", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var getSupplier = ctx.Suppliers.Find(_selectedSupplier.SupplierID);
getSupplier.Name = tbName.Text;
getSupplier.Phonenumber = tbPhone.Text;
getSupplier.e_mail = tbEmail.Text;
getSupplier.Address = tbAddress.Text;
getSupplier.HouseNumber = int.Parse(tbNumber.Text);
getSupplier.Bus = tbBus.Text;
getSupplier.ZIP_Code = int.Parse(tbZIP.Text);
getSupplier.City = tbCity.Text;
ctx.SaveChanges();
MessageBox.Show("Changes saved.");
Close();
}
}
}
}
private void StockOverview_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var categorylist = ctx.Categories.ToList();
cbCategories.DataSource = null;
cbCategories.DisplayMember = "CategoryName";
cbCategories.ValueMember = "CategoryID";
cbCategories.DataSource = categorylist;
}
}
private void SupplierOrdersOverview_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var supplierlist = ctx.Suppliers.ToList();
cbSuppliers.DataSource = null;
cbSuppliers.DisplayMember = "Name";
cbSuppliers.ValueMember = "SupplierID";
cbSuppliers.DataSource = supplierlist;
}
}
private void cbCategories_SelectedIndexChanged(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var selectedCategory = (Category)cbCategories.SelectedItem;
var productList = ctx.Products.Where(x => x.CategoryID == selectedCategory.CategoryID).ToList();
cbProducts.DisplayMember = "Name";
cbProducts.ValueMember = "ProductID";
cbProducts.DataSource = productList;
}
}
private void cbCustomer_SelectedIndexChanged(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var selectedCustomer = (Customer)cbCustomer.SelectedItem;
var customerOrderlist = ctx.OrderProducts.Where(x => x.Order.CustomerID == selectedCustomer.CustomerID);
lbOrders.DisplayMember = "GetProductName";
lbOrders.ValueMember = "OrderProductID";
lbOrders.DataSource = customerOrderlist;
}
}
private void cbCustomers_SelectedIndexChanged(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var selectedCustomer = (Customer)cbCustomers.SelectedItem;
var orderlist = ctx.Orders.Where(x => x.CustomerID == selectedCustomer.CustomerID).ToList();
lbOrders.DisplayMember = "ShowOrder";
lbOrders.ValueMember = "OrderID";
lbOrders.DataSource = orderlist;
}
}
private void CustomerOverview_Load(object sender, EventArgs e)
{
if (_loggedInEmployee.AccessID == 3 || _loggedInEmployee.AccessID == 1)
{
using (var ctx = new WarehouseDataEntity())
{
var customerlist = ctx.Customers.ToList();
cbCustomers.DataSource = null;
cbCustomers.DisplayMember = "FullName";
cbCustomers.ValueMember = "CustomerID";
cbCustomers.DataSource = customerlist;
}
}
}
public void FillCategoryBox()
{
using (var ctx = new WarehouseDataEntity())
{
var categorylist = ctx.Categories.ToList();
cbCategory.DisplayMember = "CategoryName";
cbCategory.ValueMember = "CategoryID";
cbCategory.DataSource = categorylist;
if (_selectedProduct != null)
{
cbCategory.SelectedValue = _selectedProduct.CategoryID;
}
}
}
private void SupplierOverview_Load(object sender, EventArgs e)
{
if (_loggedInEmployee.AccessID == 2 || _loggedInEmployee.AccessID == 1)
{
using (var ctx = new WarehouseDataEntity())
{
var supplierlist = ctx.Suppliers.ToList();
cbSuppliers.DataSource = null;
cbSuppliers.DisplayMember = "Name";
cbSuppliers.ValueMember = "SupplierID";
cbSuppliers.DataSource = supplierlist;
}
}
}
public void FillSupplierBox()
{
using (var ctx = new WarehouseDataEntity())
{
var supplierlist = ctx.Suppliers.ToList();
cbSupplier.DisplayMember = "Name";
cbSupplier.ValueMember = "SupplierID";
cbSupplier.DataSource = supplierlist;
if (_selectedProduct != null)
{
cbSupplier.SelectedValue = _selectedProduct.SupplierID;
}
}
}
private void ObjectManagementOverview_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
switch (_userchoice)
{
case "Employees":
var employeelist = ctx.Employees.ToList();
lbObjects.DisplayMember = "FullName";
lbObjects.ValueMember = "EmployeeID";
lbObjects.DataSource = employeelist;
break;
case "Stock":
var productlist = ctx.Products.ToList();
lbObjects.DisplayMember = "Name";
lbObjects.ValueMember = "ProductID";
lbObjects.DataSource = productlist;
break;
case "Customers":
var customerlist = ctx.Customers.ToList();
lbObjects.DisplayMember = "FullName";
lbObjects.ValueMember = "CustomerID";
lbObjects.DataSource = customerlist;
break;
case "Suppliers":
var supplierlist = ctx.Suppliers.ToList();
lbObjects.DisplayMember = "Name";
lbObjects.ValueMember = "SupplierID";
lbObjects.DataSource = supplierlist;
break;
case "Categories":
var categorylist = ctx.Categories.ToList();
lbObjects.DisplayMember = "CategoryName";
lbObjects.ValueMember = "CategoryID";
lbObjects.DataSource = categorylist;
break;
case "Customer Orders":
break;
}
}
}
private void OrderOverview_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
if (_selectedSupplier != null)
{
lblObject.Text = _selectedSupplier.Name;
}
else if (_selectedCustomer != null)
{
lblObject.Text = _selectedCustomer.FullName;
}
if (_selectedOrder != null)
{
btnCreate.Text = "Edit order";
if (_selectedOrder.CustomerID != null)
{
_selectedProducts = ctx.OrderProducts.Where(x => x.OrderID == _selectedOrder.OrderID).Select(x => new SelectedProduct {
ProductID = x.ProductID, Name = x.Product.Name, Amount = x.Amount
}).ToList();
RefreshProductlist();
}
else
{
_selectedProducts = ctx.OrderProducts.Where(x => x.OrderID == _selectedOrder.OrderID).Select(x => new SelectedProduct {
ProductID = x.ProductID, Name = x.Product.Name, Amount = x.Amount
}).ToList();
RefreshProductlist();
}
}
else
{
btnCreate.Text = "Create order";
}
var categoryList = ctx.Categories.ToList();
cbCategories.DisplayMember = "CategoryName";
cbCategories.ValueMember = "CategoryID";
cbCategories.DataSource = categoryList;
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (_selectedEmployee == null)
{
var dialogResult = MessageBox.Show("Are you sure you want to create this new employee?", "New employee", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var newEmployee = new Employee()
{
Firstname = tbFirstname.Text,
Lastname = tbLastname.Text,
EmploymentDate = dtpEmploymentDate.Value,
StartingSalary = decimal.Parse(tbStartingSalary.Text),
AccessID = Convert.ToInt32(cbAccess.SelectedValue),
Password = "******"
};
ctx.Employees.Add(newEmployee);
ctx.SaveChanges();
Close();
}
}
}
else
{
var dialogResult = MessageBox.Show("Are you sure you want to edit this employee?", "Edit employee", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var editEmployeeQuery = ctx.Employees.Single(x => x.EmployeeID == _selectedEmployee.EmployeeID);
editEmployeeQuery.Firstname = tbFirstname.Text;
editEmployeeQuery.Lastname = tbLastname.Text;
editEmployeeQuery.AccessID = Convert.ToInt32(cbAccess.SelectedValue);
editEmployeeQuery.EmploymentDate = dtpEmploymentDate.Value;
ctx.SaveChanges();
}
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (_selectedCategory == null)
{
var dialogResult = MessageBox.Show("Are you sure you want to create this new category?", "New category", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var newCategory = new Category()
{
CategoryName = tbName.Text
};
ctx.Categories.Add(newCategory);
ctx.SaveChanges();
MessageBox.Show("Category added.");
Close();
}
}
}
else
{
var dialogResult = MessageBox.Show("Are you sure you want to edit this category?", "Edit category", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new WarehouseDataEntity())
{
var getCategory = ctx.Categories.Find(_selectedCategory.CategoryID);
getCategory.CategoryName = tbName.Text;
ctx.SaveChanges();
MessageBox.Show("Changes saved.");
Close();
}
}
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbName.Text) && !string.IsNullOrEmpty(tbSurname.Text))
{
Employee newEmployee = new Employee
{
Firstname = tbName.Text,
Lastname = tbSurname.Text,
Password = string.Empty,
AccessID = (int)cbDepartment.SelectedValue,
StartingSalary = int.Parse(tbStartingSalary.Text),
EmploymentDate = dtpEmployment.Value
};
using (var ctx = new WarehouseDataEntity())
{
ctx.Employees.Add(newEmployee);
ctx.SaveChanges();
Close();
}
}
}
private void StockDetails_Load(object sender, EventArgs e)
{
if (_selectedProduct != null)
{
using (var ctx = new WarehouseDataEntity())
{
tbName.Text = _selectedProduct.Name;
tbCost.Text = _selectedProduct.Cost.ToString();
tbMargin.Text = _selectedProduct.Margin.ToString();
FillTaxBox();
FillCategoryBox();
FillSupplierBox();
cbTax.Text = _selectedProduct.Tax.ToString();
if (_selectedProduct.InStock)
{
rbYes.Checked = true;
tbAmount.Text = _selectedProduct.AmountInStock.ToString();
}
else
{
rbNo.Checked = true;
tbAmount.Enabled = false;
}
}
}
else
{
FillTaxBox();
FillCategoryBox();
FillSupplierBox();
}
}
private void EmployeeDetails_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
var accesslist = ctx.Accesses.ToList();
cbAccess.DisplayMember = "AccessName";
cbAccess.ValueMember = "AccessID";
cbAccess.DataSource = accesslist;
if (_selectedEmployee != null)
{
tbFirstname.Text = _selectedEmployee.Firstname;
tbLastname.Text = _selectedEmployee.Lastname;
tbStartingSalary.Text = _selectedEmployee.StartingSalary.ToString();
dtpEmploymentDate.Value = _selectedEmployee.EmploymentDate;
cbAccess.SelectedValue = _selectedEmployee.AccessID;
}
else
{
return;
}
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
if (_selectedOrder == null)
{
if (_selectedSupplier == null)
{
var newOrder = new Order
{
DateCreated = DateTime.Now,
EmployeeID = _loggedInEmployee.EmployeeID,
CustomerID = _selectedCustomer.CustomerID
};
ctx.Orders.Add(newOrder);
ctx.SaveChanges();
foreach (var item in _selectedProducts)
{
var newOrderProduct = new OrderProduct
{
OrderID = newOrder.OrderID,
ProductID = item.ProductID,
Amount = item.Amount
};
ctx.OrderProducts.Add(newOrderProduct);
ctx.SaveChanges();
var dialogresult = MessageBox.Show("Orders created, do you wish to print the invoice?", "Created", MessageBoxButtons.YesNo);
if (dialogresult == DialogResult.Yes)
{
var newInvoice = new Invoice();
newInvoice.GenerateInvoice(newOrder.OrderID);
}
Close();
}
}
else
{
var newOrder = new Order
{
DateCreated = DateTime.Now,
EmployeeID = _loggedInEmployee.EmployeeID,
SupplierID = _selectedSupplier.SupplierID
};
ctx.Orders.Add(newOrder);
ctx.SaveChanges();
foreach (var item in _selectedProducts)
{
var newOrderProduct = new OrderProduct
{
OrderID = newOrder.OrderID,
ProductID = item.ProductID,
Amount = item.Amount
};
ctx.OrderProducts.Add(newOrderProduct);
ctx.SaveChanges();
var reactionresult = MessageBox.Show("Order created, do you wish to print the invoice?", "Created", MessageBoxButtons.YesNo);
if (reactionresult == DialogResult.Yes)
{
var newInvoice = new Invoice();
newInvoice.GenerateInvoice(newOrder.OrderID);
}
Close();
}
}
}
else
{
var editOrder = ctx.Orders.Single(x => x.OrderID == _selectedOrder.OrderID);
editOrder.EmployeeID = _loggedInEmployee.EmployeeID;
var orderProductList = ctx.OrderProducts.Where(x => x.OrderID == _selectedOrder.OrderID).ToList();
var orderproducttodelete = ctx.OrderProducts.Where(x => x.OrderID == _selectedOrder.OrderID && _productsToRemove.Contains(x.ProductID));
ctx.OrderProducts.RemoveRange(orderproducttodelete);
ctx.SaveChanges();
foreach (var item in _selectedProducts)
{
var newOrderProduct = new OrderProduct
{
OrderID = editOrder.OrderID,
ProductID = item.ProductID,
Amount = item.Amount
};
if (orderProductList.Contains(newOrderProduct))
{
continue;
}
else
{
ctx.OrderProducts.Add(newOrderProduct);
ctx.SaveChanges();
}
}
MessageBox.Show("Order edited", "Edited");
Close();
}
}
}