private void btnDelete_Click(object sender, EventArgs e) { var rs = MessageBox.Show("Do you want to delete ???", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rs == DialogResult.Yes) { if (tabControl2.SelectedIndex == 0) // Delete product { BUS_Product bus = new BUS_Product(); bus.deleteProduct(txtProID.Text); MessageBox.Show("Delete succesfull"); Clear(); } else if (tabControl2.SelectedIndex == 1) //Delete Type { BUS_ProductType bus = new BUS_ProductType(); bus.deleteProType(txtMnIDProType.Text); MessageBox.Show("Delete succesfull"); Clear(); } else //Delete Employee { BUS_Employee bus = new BUS_Employee(); bus.deleteEmployee(txtEmpID.Text); MessageBox.Show("Delete succesfull !!!"); Clear(); } } }
private void btndeletenv_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có muốn xoá thật không?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { BUS_Employee dl = new BUS_Employee(); DTO_Employee dt = new DTO_Employee(Convert.ToInt32(txtmanv.Text)); dl.Delete(dt); dgvlistnv.DataSource = GetEmployee(); MessageBox.Show(" BẠN ĐÃ XÓA NHÂN VIÊN THÀNH CÔNG", " Xác nhận"); } }
private void btnTimNV_Click(object sender, EventArgs e) { switch (typeCheck) { case 1: { DTO_Employee emp = new DTO_Employee(Convert.ToInt32(txtbTimKiem.Text)); DataTable dt = new DataTable(); BUS_Employee em = new BUS_Employee(); dt = em.SearchByMaNV(emp); dgvTimKiem.DataSource = dt; break; } } }
private void dgvView_CellClick(object sender, DataGridViewCellEventArgs e) { index = e.RowIndex; try { if (tabControl2.SelectedIndex == 0) { DataGridViewRow selectedRow = dgvView.Rows[index]; } if (tabControl2.SelectedIndex == 1) { txtMnQuantityType.ReadOnly = true; DataGridViewRow selectedRow = dgvView.Rows[index]; string quantity = selectedRow.Cells[3].Value.ToString(); txtMnQuantityType.Text = quantity; } if (tabControl2.SelectedIndex == 2) { BUS_Employee busEmp = new BUS_Employee(); DataGridViewRow selectedRow = dgvView.Rows[index]; string idEmp = selectedRow.Cells[0].Value.ToString(); employee = busEmp.getDetail(idEmp); txtEmpID.Text = idEmp; txtEmpPass.Text = employee.Password; txtEmpName.Text = employee.Fullname; txtEmpPhone.Text = employee.Phone; txtEmpAddress.Text = employee.Address; cbEmpShop.Text = employee.IDShop; txtEmpSupervisor.Text = employee.Supervisor; cbEmpRole.Text = employee.role; if (employee.Status.Equals("Off")) { rdOn.Checked = false; } else { rdOn.Checked = true; } } } catch { Clear(); } }
private void btnLogin_Click(object sender, EventArgs e) { BUS_Employee busEmp = new BUS_Employee(); string username = txtLogin.Text; string pass = txtPass.Text; string check = chekcLoginForm(); if (check.Equals("")) { emp = busEmp.Login(username, pass); if (emp != null) { if (emp.role.Equals("Cashier")) { this.Hide(); Thread t = new Thread(new ThreadStart(showfmEmployee)); t.Start(); this.Close(); } if (emp.role.Equals("Manager")) { this.Hide(); Thread t = new Thread(new ThreadStart(showfmManager)); t.Start(); this.Close(); } if (emp.role.Equals("Admin")) { this.Hide(); Thread t = new Thread(new ThreadStart(showfmAdmin)); t.Start(); this.Close(); } } else { MessageBox.Show("Invalid account"); } } else { MessageBox.Show(check); } }
private void btneditnv_Click(object sender, EventArgs e) { int manv; string honv, tennv, sdt, chucvu, gioitinh, cmnd, diachithuongtru; DateTime ngaysinh; manv = int.Parse(txtmanv.Text.Trim()); honv = txthonv.Text.Trim(); tennv = txttennv.Text.Trim(); gioitinh = txtgtnv.Text.Trim(); sdt = txtsdtnv.Text.Trim(); ngaysinh = Convert.ToDateTime(dtpnsnv.Text.ToString()); cmnd = txtcmndnv.Text.Trim(); diachithuongtru = txtdcnv.Text.Trim(); chucvu = txtchucvu.Text.Trim(); DTO_Employee emp = new DTO_Employee(manv, honv, tennv, gioitinh, sdt, ngaysinh, cmnd, diachithuongtru, chucvu); try { int i = new BUS_Employee().UpdateEmployee(emp); if (i == -2) { throw new Exception(); } MessageBox.Show("Đã sửa thành công", "Xác nhận"); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } dgvlistnv.DataSource = GetEmployee(); }
private void btnaddnv_Click(object sender, EventArgs e) { int pMaNV; string pHoNV, pTenNV, pGioiTinh, pSodienthoai, pSoCMND, pDiaChiThuongTru, pChucVu; DateTime pNgaySinh; pMaNV = Convert.ToInt32(txtmanv.Text); pHoNV = txthonv.Text.Trim(); pTenNV = txttennv.Text.Trim(); pGioiTinh = txtgtnv.Text.Trim(); pSodienthoai = txtsdtnv.Text.Trim(); pNgaySinh = Convert.ToDateTime(dtpnsnv.Text.ToString()); pSoCMND = txtcmndnv.Text.Trim(); pDiaChiThuongTru = txtdcnv.Text.Trim(); pChucVu = txtchucvu.Text.Trim(); DTO_Employee emp = new DTO_Employee(pMaNV, pHoNV, pTenNV, pGioiTinh, pSodienthoai, pNgaySinh, pSoCMND, pDiaChiThuongTru, pChucVu); try { int i = new BUS_Employee().Add(emp); if (i == -2) { throw new Exception(); } MessageBox.Show("Đã thêm thành công", "Xác nhận"); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } dgvlistnv.DataSource = GetEmployee(); }
private string checkUpdate() { string valid = ""; if (tabControl2.SelectedIndex == 0) { if (txtProID.Text.Length == 0) { valid += "ID product cannot be empty\n"; } if (txtProName.Text.Length == 0) { valid += "Name cannot be empty\n\n"; } if (!Regex.Match(txtProSize.Text, "^[1-9]{1,3}.[0-9]{1}$").Success) { valid += "Size is wrong format x.x \n\n"; } if (!Regex.Match(txtProPrice.Text, "^[0-9]{1,50}$").Success) { valid += "Price is wrong format\n\n"; } if (!Regex.Match(txtProQuantity.Text, "^[0-9]{1,9}$").Success) { valid += "Quantity is wrong format\n\n"; } if (!Regex.Match(txtProDiscount.Text, "^[0-9]{1,9}$").Success) { valid += "Discount is wrong format\n\n"; } } else if (tabControl2.SelectedIndex == 1) { BUS_ProductType bus = new BUS_ProductType(); bool check = bus.checkProType(txtMnIDProType.Text); if (!check) { valid += "ID product type is not exits\n\n"; } if (txtMnIDProType.TextLength == 0) { valid += "ID product type cannot be empty\n\n"; } if (txtMnNametype.TextLength == 0) { valid += "Name product type cannot be empty"; } return(valid); } else { BUS_Employee bus = new BUS_Employee(); bool check = bus.checkEmployee(txtEmpID.Text); if (!check) { valid += "\nThis ID is not exits!!!\n"; } if (txtEmpPass.TextLength == 0) { valid += "\nPassword cannot empty\n"; } if (txtEmpName.TextLength == 0) { valid += "\nName cannot empty\n"; } if (txtEmpPhone.TextLength == 0) { valid += "\nPhone cannot empty\n"; } if (txtEmpAddress.TextLength == 0) { valid += "\nAddress cannot empty"; } return(valid); } return(valid); }
private void loadAllData() { try { if (tabControl2.SelectedIndex == 0) { BUS_Product bus = new BUS_Product(); BUS_ProductType busProType = new BUS_ProductType(); dgvView.DataSource = bus.loadProduct(); txtProID.DataBindings.Clear(); txtProName.DataBindings.Clear(); txtProSize.DataBindings.Clear(); cbProType.DataBindings.Clear(); txtProPrice.DataBindings.Clear(); txtProQuantity.DataBindings.Clear(); txtProDiscount.DataBindings.Clear(); txtProID.DataBindings.Add("Text", dgvView.DataSource, "IDProduct").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtProName.DataBindings.Add("Text", dgvView.DataSource, "NameProduct").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtProSize.DataBindings.Add("Text", dgvView.DataSource, "Size").DataSourceUpdateMode = DataSourceUpdateMode.Never; cbProType.DataBindings.Add("Text", dgvView.DataSource, "NameProductType").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtProPrice.DataBindings.Add("Text", dgvView.DataSource, "Price").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtProQuantity.DataBindings.Add("Text", dgvView.DataSource, "Quantity").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtProDiscount.DataBindings.Add("Text", dgvView.DataSource, "Discount").DataSourceUpdateMode = DataSourceUpdateMode.Never; cbProType.DataSource = busProType.loadProType(); cbProType.DisplayMember = "NameProductType"; } else if (tabControl2.SelectedIndex == 1) { BUS_ProductType busProType = new BUS_ProductType(); dgvView.DataSource = busProType.loadProType(); txtMnNametype.DataBindings.Clear(); txtMnIDProType.DataBindings.Clear(); txtMnQuantityType.DataBindings.Clear(); cbMnProLine.DataBindings.Clear(); txtMnIDProType.DataBindings.Add("Text", dgvView.DataSource, "IDProductType").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtMnNametype.DataBindings.Add("Text", dgvView.DataSource, "NameProductType").DataSourceUpdateMode = DataSourceUpdateMode.Never; txtMnQuantityType.DataBindings.Add("Text", dgvView.DataSource, "Quantity").DataSourceUpdateMode = DataSourceUpdateMode.Never; cbMnProLine.DataBindings.Add("Text", dgvView.DataSource, "NameProductlines").DataSourceUpdateMode = DataSourceUpdateMode.Never; cbMnProLine.Items.Clear(); cbMnProLine.Items.Add("Male"); cbMnProLine.Items.Add("FeMale"); cbMnProLine.SelectedItem = "Male"; } else { BUS_Employee busEmp = new BUS_Employee(); dgvView.DataSource = busEmp.loadEmployee(); BUS_Shop busShop = new BUS_Shop(); cbEmpShop.DataSource = busShop.loadShop(); cbEmpShop.DisplayMember = "Address"; cbEmpRole.Items.Clear(); cbEmpRole.Items.Add("Cashier"); cbEmpRole.Items.Add("Manager"); cbEmpRole.SelectedItem = "Cashier"; rdOn.Checked = true; } } catch { } }
private void btnUpdate_Click(object sender, EventArgs e) { if (btnUpdate.Text.Equals("EDIT")) { btnUpdate.Text = "UPDATE"; btnAdd.Enabled = false; btnDelete.Enabled = false; Action <Control.ControlCollection> blockTextBox = null; blockTextBox = (controls) => { foreach (Control control in controls) { if (control is TextBox) { (control as TextBox).ReadOnly = false; } else { blockTextBox(control.Controls); } } }; blockTextBox(Controls); txtProID.ReadOnly = true; } else { var rs = MessageBox.Show("Do you want to update ???", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rs == DialogResult.Yes) { if (tabControl2.SelectedIndex == 0)//Update product { BUS_Product bus = new BUS_Product(); string check = checkUpdate(); if (check.Equals("")) { string idPro = txtProID.Text; string idProType = cbProType.Text; float size = float.Parse(txtProSize.Text); string name = txtProName.Text; int price = int.Parse(txtProPrice.Text); int quantity = int.Parse(txtProQuantity.Text); string discount = txtProDiscount.Text; DTO_Product x = new DTO_Product(idPro, idProType, name, size, price, quantity, discount); bool update = bus.updateProduct(x); if (update) { MessageBox.Show("Update succesfully"); Clear(); } } else { MessageBox.Show(check); } } else if (tabControl2.SelectedIndex == 1)//Update Type { BUS_ProductType bus = new BUS_ProductType(); string check = checkUpdate(); if (check.Equals("")) { txtMnIDProType.ReadOnly = true; string idProtype = txtMnIDProType.Text; string idProLine = cbMnProLine.SelectedItem.ToString(); string nameProType = txtMnNametype.Text; int quantity = int.Parse(txtMnQuantityType.Text); DTO_ProductType x = new DTO_ProductType(idProtype, idProLine, nameProType, quantity); bool update = bus.updateProType(x); if (update) { MessageBox.Show("Update succesfully"); Clear(); } } else { MessageBox.Show(check); } } else //Update Employee { BUS_Employee bus = new BUS_Employee(); string check = checkUpdate(); if (check.Equals("")) { txtEmpID.ReadOnly = true; string id = txtEmpID.Text; string pass = txtEmpPass.Text; string name = txtEmpName.Text; string idShop = cbEmpShop.Text.ToString(); string address = txtEmpAddress.Text; string supervisor = txtEmpSupervisor.Text; string phone = txtEmpPhone.Text; string role = cbEmpRole.SelectedItem.ToString(); string status = "On"; if (rdOff.Checked == true) { status = "Off"; } if (txtEmpSupervisor.Text.Equals("")) { txtEmpSupervisor.Text = "null"; } DTO_Employee x = new DTO_Employee(id, pass, name, phone, address, idShop, supervisor, role, status); bool update = bus.updateEmployee(x); if (update) { MessageBox.Show("Update succesfully"); Clear(); } } else { MessageBox.Show(check); } } btnUpdate.Text = "EDIT"; } Clear(); } }
private void btnAdd_Click(object sender, EventArgs e) { string check = checkAdd(); if (btnAdd.Text.Equals("ADD NEW")) { btnAdd.Text = "ADD"; btnUpdate.Enabled = false; btnDelete.Enabled = false; EditText(); txtProID.Text = "ID product is added automatic"; } else { if (check.Equals("")) { if (tabControl2.SelectedIndex == 0)//Add product { BUS_Product bus = new BUS_Product(); string idPro = txtProID.Text; bool checkIDProduct = bus.checkID(idPro); if (checkIDProduct) { var rs = MessageBox.Show("Do you want to update quantity of product ?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rs == DialogResult.Yes) { fmAddQuanity f = new fmAddQuanity(idPro); f.ShowDialog(); Clear(); } } else { string idProType = cbProType.Text; MessageBox.Show(idProType); float size = float.Parse(txtProSize.Text); string name = txtProName.Text; int price = int.Parse(txtProPrice.Text); int quantity = int.Parse(txtProQuantity.Text); string discount = txtProDiscount.Text; DTO_Product x = new DTO_Product(idProType, name, size, price, quantity, discount); bus.addProduct(x); MessageBox.Show("Add new product succesfully"); loadAllData(); Clear(); } } else if (tabControl2.SelectedIndex == 1)//Add Type { EditText(); try { BUS_ProductType bus = new BUS_ProductType(); string idProtype = txtMnIDProType.Text; string idProLine = cbMnProLine.Text; string nameProType = txtMnIDProType.Text; int quantity = 0; DTO_ProductType x = new DTO_ProductType(idProtype, idProLine, nameProType, quantity); bus.addProType(x); MessageBox.Show("Create product type succesfully"); loadAllData(); Clear(); } catch (Exception) { MessageBox.Show("ID product type is duplicate!!!"); } } else //Add Employee { EditText(); try { BUS_Employee bus = new BUS_Employee(); string id = txtEmpID.Text; string pass = txtEmpPass.Text; string name = txtEmpName.Text; string idShop = cbEmpShop.Text.ToString(); string address = txtEmpAddress.Text; string supervisor = txtEmpSupervisor.Text; string phone = txtEmpPhone.Text; string role = cbEmpRole.Text; DTO_Employee x = new DTO_Employee(id, pass, name, phone, address, idShop, supervisor, role, "On"); bus.addEmployee(x); MessageBox.Show("Create succesfully"); } catch (Exception) { MessageBox.Show("ID employee is duplicate!!!"); } loadAllData(); Clear(); } } else { MessageBox.Show(check); } } }