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