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