private void btnLuu_Click(object sender, EventArgs e)
{
RoleBUS role = new RoleBUS();
RoleNV roleID = role.getRoleID(cbbVaiTro.Text);
// MessageBox.Show(roleID);
nvBUS nvBus = new nvBUS();
NhanVien nv = new NhanVien(roleID.RoleId, txtMaNV.Text, txtUser.Text, txtPass.Text, txtTenNV.Text, txtCMND.Text, txtNgaySinh.Text, txtDiaChi.Text, txtEmail.Text, txtCaLamViec.Text);
if (check == true)
{
if (nvBus.CheckUsername(txtUser.Text))
{
MessageBox.Show(txtUser.Text + " đã tồn tại!!!");
}
else
{
nvBus.addData(nv);
disnable();
clear();
check = false;
}
}
else
{
nvBus.edit(nv);
disnable();
clear();
check = false;
}
grvNV.DataSource = nvBus.getData();
}
public int edit(RoleNV r)
{
if (role.edit(r) == 1)
{
return(1);
}
return(0);
}
private void btnTim_Click(object sender, EventArgs e)
{
RoleBUS roleBus = new RoleBUS();
RoleNV roleNV = roleBus.getRole(txtRoleID.Text);
txtRoleID.Text = roleNV.RoleId;
txtTenRole.Text = roleNV.RoleName;
txtMoTa.Text = roleNV.Description;
}
public int edit(RoleNV role)
{
string sql = "update RoleNV set roleName=N'" + role.RoleName + "',Description=N'" + role.Description + "' where ID='" + role.RoleId + "'";
if (data.Edit(sql) > 0)
{
return(1);
}
return(0);
}
private void btnSua_Click(object sender, EventArgs e)
{
RoleBUS role = new RoleBUS();
RoleNV rolenv = new RoleNV(txtRoleID.Text, txtTenRole.Text, txtMoTa.Text);
if (role.edit(rolenv) == 1)
{
MessageBox.Show("Sua thanh cong!");
grvRole.DataSource = role.getData();
}
}
public List <RoleNV> Getlist()
{
List <RoleNV> list = new List <RoleNV>();
DataTable data = role.getData();
foreach (DataRow item in data.Rows)
{
RoleNV nv = new RoleNV(item);
list.Add(nv);
}
return(list);
}
public RoleNV getIDbyRoleName(string roleName)
{
RoleNV role = null;
string sql = "select * from RoleNV where roleName = '" + roleName + "'";
DataTable table = data.getData(sql);
foreach (DataRow item in table.Rows)
{
role = new RoleNV(item);
return(role);
}
return(role);
}
public RoleNV getRoleNVByID(string id)
{
RoleNV role = null;
string sql = "select * from RoleNV where ID ='" + id + "'";
DataTable table = data.getData(sql);
foreach (DataRow item in table.Rows)
{
role = new RoleNV(item);
return(role);
}
return(role);
}
private void btnThem_Click(object sender, EventArgs e)
{
RoleBUS role = new RoleBUS();
RoleNV rolenv = new RoleNV(txtRoleID.Text, txtTenRole.Text, txtMoTa.Text);
if (role.CheckID(txtRoleID.Text) == true)
{
MessageBox.Show("Mã Role đã tồn tại!");
}
else
{
role.addData(rolenv);
grvRole.DataSource = role.getData();
}
}
private void btnTim_Click(object sender, EventArgs e)
{
RoleBUS roleBus = new RoleBUS();
RoleNV roleNV = roleBus.getRole(txtRoleID.Text);
if (roleNV == null)
{
MessageBox.Show(txtRoleID.Text + " không tồn tại!!!");
}
else
{
txtRoleID.Text = roleNV.RoleId;
txtTenRole.Text = roleNV.RoleName;
txtMoTa.Text = roleNV.Description;
}
}
public int addData(RoleNV role)
{
string sql = "insert into RoleNV values('" + role.RoleId + "',N'" + role.RoleName + "',N'" + role.Description + "')";
return(data.add(sql));
}
public int addData(RoleNV r)
{
return(role.addData(r));
}
