//Ham thay doi mat khau private void changePassWord() { if (CodeDTO.getMD5Hash(txtPassOld.Text).Equals(ucLogin.m_EmployeeObject.matKhau)) { if (txtPassReplay.Text.Equals(txtPassNew.Text)) { //thục hiện Update mật khẩu ucLogin.m_EmployeeObject.matKhau = CodeDTO.getMD5Hash(txtPassReplay.Text.Trim()); // m_EmployeeObject = new CEmployeeDTO(ucLogin.m_EmployeeObject.maNhanVien, ucLogin.m_EmployeeObject.tenNhanVien, ucLogin.m_EmployeeObject.gioiTinh, ucLogin.m_EmployeeObject.ngaySinh, ucLogin.m_EmployeeObject.soDienThoai, ucLogin.m_EmployeeObject.diaChi, ucLogin.m_EmployeeObject.ngayVaoLam, ucLogin.m_EmployeeObject.maChucVu, ucLogin.m_EmployeeObject.tenDangNhap, ucLogin.m_EmployeeObject.matKhau, ucLogin.m_EmployeeObject.email); if (m_EmployeeExecute.UpdateEmployeeToDatabase(m_EmployeeObject)) { ucLogin.m_EmployeeObject = m_EmployeeObject; XtraMessageBox.Show("Đổi mật khẩu thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { txtPassNew.Text = txtPassOld.Text = txtPassReplay.Text = ""; XtraMessageBox.Show("Đổi mậu khẩu thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { txtPassNew.Text = txtPassReplay.Text = ""; XtraMessageBox.Show("Mật khẩu mới và xác nhận không hợp lệ. Vui lòng nhập lại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { XtraMessageBox.Show("Sai mật khẩu. Vui lòng nhập lại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnUpdate_Click(object sender, EventArgs e) { m_EmployeeObject = new CEmployeeDTO(txtEmployeeId.Text, txtEmployeeName.Text, cmbEmployeeGender.Text, dateBirthDay.DateTime, txtEmployeePhone.Text, txtEmployeeAddress.Text, dateToWork.DateTime, lkEmployeeCharge.EditValue.ToString(), null, null, txtEmployeeEmail.Text); m_EmployeeExecute.UpdateEmployeeToDatabase(m_EmployeeObject); m_EmployeeData = m_EmployeeExecute.getEmployeeDataFromDatabase(); grdListEmployee.DataSource = m_EmployeeData; }
public bool DeleteEmployeeToDatabase(CEmployeeDTO _EmployeeObject) { m_cmd = new SqlCommand(); m_cmd.CommandType = CommandType.StoredProcedure; m_cmd.CommandText = "DeleteEmployeeDataToDatabase"; m_cmd.Parameters.Add("MaNV", SqlDbType.NVarChar).Value = _EmployeeObject.maNhanVien; return(m_EmployeeExecute.updateData(m_cmd) > 0); }
private void btnSave_Click(object sender, EventArgs e) { m_EmployeeObject = new CEmployeeDTO(txtEmployeeId.Text, txtEmployeeName.Text, cmbEmployeeGender.Text, dateBirthDay.DateTime, txtEmployeePhone.Text, txtEmployeeAddress.Text, dateToWork.DateTime, lkEmployeeCharge.EditValue.ToString(), "", "", txtEmployeeEmail.Text); m_EmployeeExecute.AddEmployeeToDatabase(m_EmployeeObject); m_EmployeeData = m_EmployeeExecute.getEmployeeDataFromDatabase(); grdListEmployee.DataSource = m_EmployeeData; grdvListEmployee.FocusedRowHandle = grdvListEmployee.DataRowCount - 1; }
public frmEmployee() { InitializeComponent(); m_ChargeData = new DataTable(); m_ChargeExecute = new CChargeBUS(); m_ChargeObject = new CChargeDTO(); m_EmployeeData = new DataTable(); m_EmployeeExecute = new CEmployeeBUS(); m_EmployeeObject = new CEmployeeDTO(); m_EmployeeMultiSelect = new GridCheckMarksSelection(grdvListEmployee); EmployeeSno.VisibleIndex = 1; }
private void btnDelete_Click(object sender, EventArgs e) { grdvListEmployee.FocusedRowHandle -= 1; foreach (DataRowView _rowData in m_EmployeeMultiSelect.Selection) { m_EmployeeObject = new CEmployeeDTO(); m_EmployeeObject.maNhanVien = _rowData["MaNV"].ToString(); m_EmployeeExecute.DeleteEmployeeToDatabase(m_EmployeeObject); } m_EmployeeData = m_EmployeeExecute.getEmployeeDataFromDatabase(); grdListEmployee.DataSource = m_EmployeeData; }
private void btnSave_Click(object sender, EventArgs e) { if (!checkData()) { return; } try { if (m_IsAdd) { String _user = createUserName(txtEmployeeName.Text, dateBirthDay.DateTime.ToString()); String _pass = CodeDTO.getMD5Hash("123456789"); m_EmployeeObject = new CEmployeeDTO("NV0000000", txtEmployeeName.Text, cmbEmployeeGender.Text, dateBirthDay.DateTime, txtEmployeePhone.Text, txtEmployeeAddress.Text, dateToWork.DateTime, lkEmployeeCharge.EditValue.ToString(), _user, _pass, txtEmployeeEmail.Text); if (m_EmployeeExecute.AddEmployeeToDatabase(m_EmployeeObject)) { XtraCustomMessageBox.Show("Thêm dữ liệu thành công!", "Thông báo", true); } else { XtraCustomMessageBox.Show("Thêm dữ liệu thất bại!", "Lỗi", true); } } else { m_EmployeeObject = new CEmployeeDTO(txtEmployeeId.Text, txtEmployeeName.Text, cmbEmployeeGender.Text, dateBirthDay.DateTime, txtEmployeePhone.Text, txtEmployeeAddress.Text, dateToWork.DateTime, lkEmployeeCharge.EditValue.ToString(), txtEmployeeName.Text, null, txtEmployeeEmail.Text); if (m_EmployeeExecute.UpdateEmployeeToDatabase(m_EmployeeObject)) { XtraCustomMessageBox.Show("Cập nhật dữ liệu thành công!", "Thông báo", true); } else { XtraCustomMessageBox.Show("Cập nhật dữ liệu thất bại!", "Lỗi", true); } } } catch (System.Exception) { XtraCustomMessageBox.Show("Lưu dữ liệu thất bại!", "Lỗi", true); } finally { updateEnableButtonAndResetValueOfControl(ref btnSave); } }
public bool UpdateEmployeeToDatabase(CEmployeeDTO _EmployeeObject) { m_cmd = new SqlCommand(); m_cmd.CommandType = CommandType.StoredProcedure; m_cmd.CommandText = "UpdateEmployeeDataToDatabase"; m_cmd.Parameters.Add("MaNV", SqlDbType.NVarChar).Value = _EmployeeObject.maNhanVien; m_cmd.Parameters.Add("TenNV", SqlDbType.NVarChar).Value = _EmployeeObject.tenNhanVien; m_cmd.Parameters.Add("GioiTinh", SqlDbType.NVarChar).Value = _EmployeeObject.gioiTinh; m_cmd.Parameters.Add("NgaySinh", SqlDbType.SmallDateTime).Value = _EmployeeObject.ngaySinh; m_cmd.Parameters.Add("NgayVaoLam", SqlDbType.SmallDateTime).Value = _EmployeeObject.ngayVaoLam; m_cmd.Parameters.Add("DiaChi", SqlDbType.NVarChar).Value = _EmployeeObject.diaChi; m_cmd.Parameters.Add("MaCV", SqlDbType.NVarChar).Value = _EmployeeObject.maChucVu; m_cmd.Parameters.Add("SoDienThoai", SqlDbType.NVarChar).Value = _EmployeeObject.soDienThoai; m_cmd.Parameters.Add("Email", SqlDbType.NVarChar).Value = _EmployeeObject.email; return(m_EmployeeExecute.updateData(m_cmd) > 0); }
private void btnDelete_Click(object sender, EventArgs e) { try { ArrayList _listEmployeeId = new ArrayList(); grdvListEmployee.FocusedRowHandle -= 1; foreach (DataRowView _rowData in m_EmployeeMultiSelect.Selection) { m_EmployeeObject = new CEmployeeDTO(); m_EmployeeObject.maNhanVien = _rowData["MaNV"].ToString(); if (m_EmployeeExecute.DeleteEmployeeToDatabase(m_EmployeeObject)) { _listEmployeeId.Add(_rowData["MaNV"]); } } if (_listEmployeeId.Count != 0) { String _erroContent = "Không thể xóa các nhân viên có mã: \n"; foreach (var item in _listEmployeeId) { _erroContent += item.ToString() + "\n"; } XtraCustomMessageBox.Show(_erroContent, "Lỗi", true); } else { XtraCustomMessageBox.Show("Xóa dữ liệu thành công!", "Thông báo", true); } } catch (System.Exception) { XtraCustomMessageBox.Show("Xóa dữ liệu thất bại", "Lỗi", true); } finally { updateEnableButtonAndResetValueOfControl(ref btnDelete); } }
private void sbtnSave_Click(object sender, EventArgs e) { m_EmployeeObject = new CEmployeeDTO(ucLogin.m_EmployeeObject.maNhanVien, this.txtEmployeeName.Text, cmbEmployeeGender.Text, Convert.ToDateTime(dateBirthDay.Text), this.txtEmployeePhone.Text, this.txtEmployeeAddress.Text, Convert.ToDateTime(this.dateToWork.Text), ucLogin.m_EmployeeObject.maChucVu, txtUser.Text, this.txtEmployeeEmail.Text); if (m_EmployeeExecute.UpdateEmployeeToDatabaseNotPassWord(m_EmployeeObject)) { m_EmployeeObject.matKhau = ucLogin.m_EmployeeObject.matKhau; ucLogin.m_EmployeeObject = m_EmployeeObject; InitDisplay(false); XtraMessageBox.Show("Cập nhật thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("Cập nhật thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } // sbtnDetroyUpdate.Visible = false; sbtnSave.Visible = false; btnUpdate.Visible = true; btnCancel.Visible = true; }
public CEmployeeDAL() { m_EmployeeObject = null; m_EmployeeExecute = new CDataExecute(); m_cmd = new SqlCommand(); }
public CEmployeeDAL(CEmployeeDTO _EmployeeObject) { m_EmployeeObject = _EmployeeObject; m_EmployeeExecute = new CDataExecute(); m_cmd = new SqlCommand(); }
public ucLogin() { InitializeComponent(); m_EmployeeObject = new CEmployeeDTO(); m_loginExecute = new CLoginBUS(); }
public bool UpdateEmployeeToDatabase(CEmployeeDTO _EmployeeObject) { return(m_employeeDAL.UpdateEmployeeToDatabase(_EmployeeObject)); }
public bool AddEmployeeToDatabase(CEmployeeDTO _EmployeeObject) { return(m_employeeDAL.AddEmployeeToDatabase(_EmployeeObject)); }