private void readUsers()
{
SICDbEntities use = new SICDbEntities();
IEnumerable <User> list = from U in use.Users select U;
dgvUsersList.DataSource = list.ToList();
}
private void btnSearch_Click(object sender, EventArgs e)
{
SICDbEntities User = new SICDbEntities();
IEnumerable <User> list = from u in User.Users where u.FirstName == txtSearch.Text || u.LastName == txtSearch.Text || u.JobTitle == txtSearch.Text || u.EmployeeId == txtSearch.Text || u.Email == txtSearch.Text || u.ADM == txtSearch.Text select u;
dgvUsersList.DataSource = list.ToList();
}
private void btnSearch_Click(object sender, EventArgs e)
{
SICDbEntities Cust = new SICDbEntities();
IEnumerable <Customer> list = from c in Cust.Customers where c.CompanyName == txtSearch.Text || c.BIN == txtSearch.Text || c.Email == txtSearch.Text || c.Province == txtSearch.Text || c.City == txtSearch.Text select c;
dgvCustomerList.DataSource = list.ToList();
}
private void readCustomer()
{
SICDbEntities cust = new SICDbEntities();
IEnumerable <Customer> list = from C in cust.Customers select C;
dgvCustomerList.DataSource = list.ToList();
}
private void btnSearch_Click(object sender, EventArgs e)
{
SICDbEntities Ord = new SICDbEntities();
IEnumerable <Order> list = from o in Ord.Orders where o.ProductName == txtSearch.Text || o.Brand == txtSearch.Text || o.Specification == txtSearch.Text || o.Warehouse == txtSearch.Text || o.Room == txtSearch.Text || o.Aisle == txtSearch.Text || o.Shelf == txtSearch.Text || o.ProductType == txtSearch.Text || o.Quantity == txtSearch.Text select o;
dgvOrdersList.DataSource = list.ToList();
}
private void readOrder()
{
SICDbEntities ord = new SICDbEntities();
IEnumerable <Order> list = from o in ord.Orders select o;
dgvOrdersList.DataSource = list.ToList();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
SICDbEntities context = new SICDbEntities();
int OrderId = Convert.ToInt32(txtOrderId.Text);
Order ord = context.Orders.First(o => o.OrderId == OrderId);
ord.ProductName = txtProductName.Text;
ord.Brand = txtBrand.Text;
ord.Specification = txtSpecification.Text;
ord.Currency = cmbCurrency.Text;
ord.Price = txtPrice.Text;
ord.Warehouse = cmbWarehouse.Text;
ord.Room = cmbRoom.Text;
ord.Aisle = cmbAisle.Text;
ord.ProductType = cmbProductType.Text;
ord.Shelf = cmbShelf.Text;
ord.Quantity = txtQuantity.Text;
ord.OrderId = Convert.ToInt32(txtOrderId.Text);
var m = MessageBox.Show("Are you sure?", "Update", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
context.SaveChanges();
readOrder();
}
else
{
readOrder();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
SICDbEntities context = new SICDbEntities();
int CustomerId = Convert.ToInt32(txtCustomerId.Text);
Customer cust = context.Customers.First(u => u.CustomerId == CustomerId);
cust.Email = txtEmail.Text;
cust.CompanyName = txtCompanyName.Text;
cust.Address = txtAddress.Text;
cust.City = txtCity.Text;
cust.BIN = txtBIN.Text;
cust.PostalCode = txtPostalCode.Text;
cust.CustomerId = Convert.ToInt32(txtCustomerId.Text);
cust.Phone = txtPhone.Text;
cust.Province = cmbProvince.Text;
var m = MessageBox.Show("Are you sure?", "Update", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
context.SaveChanges();
readCustomer();
}
else
{
readCustomer();
}
}
private void FindCustomerSearch(int CustomerId)
{
SICDbEntities context = new SICDbEntities();
Customer cust = context.Customers.First(u => u.CustomerId == CustomerId);
txtCustomerName.Text = cust.CompanyName;
txtCustomerId.Text = cust.CustomerId.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtProductName.Text == "")
{
MessageBox.Show("The field Product Name must be filled!", "Warning", MessageBoxButtons.OK);
}
else
{
if (txtCustomerId.Text == "" || txtCustomerName.Text == "")
{
MessageBox.Show("The fields Customer Id and Customer Name must be filled!", "Warning", MessageBoxButtons.OK);
}
else
{
using (var db = new SICDbEntities())
{
var ord = new Order();
ord.CustomerCustomerId = Convert.ToInt32(txtCustomerId.Text);
ord.ProductName = txtProductName.Text;
ord.Brand = txtBrand.Text;
ord.Specification = txtSpecification.Text;
ord.Currency = Convert.ToString(cmbCurrency.SelectedItem);
ord.Price = txtPrice.Text;
ord.Warehouse = Convert.ToString(cmbWarehouse.SelectedItem);
ord.Room = Convert.ToString(cmbRoom.SelectedItem);
ord.Aisle = Convert.ToString(cmbAisle.SelectedItem);
ord.ProductType = Convert.ToString(cmbProductType.SelectedItem);
ord.Shelf = Convert.ToString(cmbShelf.SelectedItem);
ord.Quantity = txtQuantity.Text;
db.Orders.Add(ord);
db.SaveChanges();
}
MessageBox.Show("Order released sucessfully!", "Order Release Info", MessageBoxButtons.OK);
var m = MessageBox.Show("Do you want add one more Order now?", "Warning", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
txtBrand.Text = "";
txtPrice.Text = "";
txtProductName.Text = "";
txtQuantity.Text = "";
txtSpecification.Text = "";
cmbProductType.Text = "";
}
else
{
Form.ActiveForm.Close();
}
}
}
}
private void ReportOrders_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'SICDbDataSet6.Orders' table. You can move, or remove it, as needed.
this.OrdersTableAdapter.Fill(this.SICDbDataSet6.Orders);
SICDbEntities Ord = new SICDbEntities();
IEnumerable <Order> list = from o in Ord.Orders select o;
rpwOrders.LocalReport.ReportEmbeddedResource = "ReportOrders.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource rds = new Microsoft.Reporting.WinForms.ReportDataSource("DataSetOrders", list);
rds.Name = "DataSetOrders";
rds.Value = list;
rpwOrders.LocalReport.DataSources.Add(rds);
rpwOrders.RefreshReport();
}
private void FindCustomer(int CustomerId)
{
SICDbEntities context = new SICDbEntities();
Customer cust = context.Customers.First(u => u.CustomerId == CustomerId);
txtEmail.Text = cust.Email;
txtCompanyName.Text = cust.CompanyName;
txtBIN.Text = cust.BIN;
txtAddress.Text = cust.Address;
txtCity.Text = cust.City;
txtPhone.Text = cust.Phone;
txtPostalCode.Text = cust.PostalCode;
cmbProvince.Text = cust.Province;
txtCustomerId.Text = cust.CustomerId.ToString();
}
private void manageUsersToolStripMenuItem_Click(object sender, EventArgs e)
{
SICDbEntities context = new SICDbEntities();
String Email = lblEmailUserLogonText.Text;
User user = context.Users.First(u => u.Email == Email);
if (user.ADM == "YES")
{
Form ManagerUser = new ManagerUsers();
ManagerUser.Show();
}
else
{
MessageBox.Show("You are not an Adminstrator!", "Warning", MessageBoxButtons.OK);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
SICDbEntities context = new SICDbEntities();
int CustomerId = Convert.ToInt32(txtCustomerId.Text);
Customer user = context.Customers.First(u => u.CustomerId == CustomerId);
var m = MessageBox.Show("Are you sure?", "Delete", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
context.Customers.Remove(user);
context.SaveChanges();
}
else
{
readCustomer();
}
readCustomer();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtPassword.Text != txtRetypePassword.Text)
{
lblWrongPassword.Visible = true;
}
else
{
var option = "";
if (rdbYES.Checked == true)
{
option = "YES";
}
else if (rdbNO.Checked == true)
{
option = "NO";
}
SICDbEntities context = new SICDbEntities();
int UserId = Convert.ToInt32(txtUserId.Text);
User user = context.Users.First(u => u.UserId == UserId);
user.Email = txtEmail.Text;
user.FirstName = txtFirstName.Text;
user.LastName = txtLastName.Text;
user.EmployeeId = txtEmployeeId.Text;
user.JobTitle = txtJobTitle.Text;
user.Password = txtPassword.Text;
user.UserId = Convert.ToInt32(txtUserId.Text);
user.ADM = option;
var m = MessageBox.Show("Are you sure?", "Update", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
context.SaveChanges();
readUsers();
lblWrongPassword.Visible = false;
}
else
{
readUsers();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtCompanyName.Text == "" || txtEmail.Text == "")
{
MessageBox.Show("The fields Company Name and Email must be filled!", "Warning", MessageBoxButtons.OK);
}
else
{
using (var db = new SICDbEntities())
{
var cust = new Customer();
cust.CompanyName = txtCompanyName.Text;
cust.BIN = txtBIN.Text;
cust.Email = txtEmail.Text;
cust.Address = txtAddress.Text;
cust.Phone = txtPhone.Text;
cust.City = txtCity.Text;
cust.PostalCode = txtPostalCode.Text;
cust.Province = Convert.ToString(cmbProvince.SelectedItem);
db.Customers.Add(cust);
db.SaveChanges();
}
MessageBox.Show("Customer added sucessfully!", "New Customer Info", MessageBoxButtons.OK);
var m = MessageBox.Show("Do you want add one more Customer now?", "Warning", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
txtAddress.Text = "";
txtBIN.Text = "";
txtCity.Text = "";
txtCompanyName.Text = "";
txtEmail.Text = "";
txtPhone.Text = "";
txtPostalCode.Text = "";
cmbProvince.Text = "";
}
else
{
Form.ActiveForm.Close();
}
}
}
public void btnLogin_Click_1(object sender, EventArgs e)
{
using (var db = new SICDbEntities())
{
var EmailResult =
(from em in db.Users
where em.Email == txtEmail.Text
select em.Email).SingleOrDefault();
var PasswordResult =
(from en in db.Users
where en.Email == txtEmail.Text
select en.Password).SingleOrDefault();
if (EmailResult != txtEmail.Text)
{
MessageBox.Show("Email incorrect or no registered!", "Login Error", MessageBoxButtons.OK);
}
else if (PasswordResult != txtPassword.Text)
{
MessageBox.Show("Password incorrect or no registered!", "Login Error", MessageBoxButtons.OK);
}
else
{
if (Application.OpenForms["Main"] == null)
{
string email = txtEmail.Text;
Main NewMain = new Main(email);
NewMain.Show();
//txtEmail.Text = "";
txtPassword.Text = "";
}
else
{
MessageBox.Show("You must click on Logout to allow opening as another User!", "Warning", MessageBoxButtons.OK);
}
}
}
}
private void FindOrder(int OrderId)
// private void FindOrder(int OrderId, int CustomerId)
{
SICDbEntities context = new SICDbEntities();
Order ord = context.Orders.First(o => o.OrderId == OrderId);
//Customer cust = context.Orders.First(c => c.CustomerCustomerId == CustomerId);
txtCustomerId.Text = ord.CustomerCustomerId.ToString();
txtCustomerName.Text = ord.Customer.CompanyName;
txtProductName.Text = ord.ProductName;
txtBrand.Text = ord.Brand;
txtSpecification.Text = ord.Specification;
cmbCurrency.Text = ord.Currency;
txtPrice.Text = ord.Price;
cmbWarehouse.Text = ord.Warehouse;
cmbRoom.Text = ord.Room;
cmbAisle.Text = ord.Aisle;
cmbProductType.Text = ord.ProductType;
cmbShelf.Text = ord.Shelf;
txtQuantity.Text = ord.Quantity;
txtOrderId.Text = ord.OrderId.ToString();
}
private void FindUsers(int UserId)
{
SICDbEntities context = new SICDbEntities();
User user = context.Users.First(u => u.UserId == UserId);
if (user.ADM == "YES")
{
rdbYES.Checked = true;
}
else
{
rdbNO.Checked = true;
}
txtEmail.Text = user.Email;
txtFirstName.Text = user.FirstName;
txtLastName.Text = user.LastName;
txtEmployeeId.Text = user.EmployeeId;
txtJobTitle.Text = user.JobTitle;
txtPassword.Text = user.Password;
txtRetypePassword.Text = user.Password;
txtUserId.Text = user.UserId.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtEmail.Text == "" || txtEmployeeId.Text == "" || txtPassword.Text == "")
{
MessageBox.Show("The fields Email,Password and EmployeeId must be filled!", "Warning", MessageBoxButtons.OK);
}
else
{
if (txtPassword.Text != txtRetypePassword.Text)
{
lblWrongPassword.Visible = true;
}
else
{
var option = "";
if (rdbYES.Checked)
{
option = "YES";
}
else if (rdbNO.Checked)
{
option = "NO";
}
else
{
MessageBox.Show("Error", "Warning", MessageBoxButtons.OK);
}
using (var db = new SICDbEntities())
{
var user = new User();
user.FirstName = txtFirstName.Text;
user.LastName = txtLastName.Text;
user.Email = txtEmail.Text;
user.JobTitle = txtJobTitle.Text;
user.EmployeeId = txtEmployeeId.Text;
user.Password = txtPassword.Text;
user.ADM = option;
db.Users.Add(user);
db.SaveChanges();
}
lblWrongPassword.Visible = false;
MessageBox.Show("User added sucessfully!", "New User Info", MessageBoxButtons.OK);
var m = MessageBox.Show("Do you want add one more Users now?", "Warning", MessageBoxButtons.YesNo);
if (m.ToString() == "Yes")
{
txtFirstName.Text = "";
txtEmail.Text = "";
txtEmployeeId.Text = "";
txtJobTitle.Text = "";
txtLastName.Text = "";
txtPassword.Text = "";
txtRetypePassword.Text = "";
rdbNO.Checked = true;
rdbYES.Checked = false;
lblWrongPassword.Visible = false;
}
else
{
Form.ActiveForm.Close();
}
}
}
}
