private void btnSave_Click(object sender, EventArgs e)
{
BLL.Role_BLL role_BLL = new BLL.Role_BLL();
string password = txtPassword.Text;
if (password == "")
{
password = "******";
}
if (command == 1)
{
role_BLL.insert(txtUsername.Text, password);
}
else
{
if (password == "-1")
{
MessageBox.Show("Vui lòng nhập password hợp lệ(khác -1 và rỗng)!");
}
else
{
role_BLL.update(txtUsername.Text, password);
}
}
init();
}
private void init()
{
BLL.Role_BLL role_BLL = new BLL.Role_BLL();
event_end();
dataGridView1.DataSource = role_BLL.getAll();
resetText();
}
private void frmNhanVien_Load(object sender, EventArgs e)
{
DataTable dtnhanvien = new BLL.NhanVien_BLL().getall();
DataTable dtrole = new BLL.Role_BLL().getall();
cbchucvu.DataSource = dtrole;
cbchucvu.DisplayMember = "name";
cbchucvu.ValueMember = "id";
dgnhanvien.DataSource = dtnhanvien;
dgnhanvien.Columns[6].Visible = false;
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Do you want to delete role?", "Confirmation",
MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
BLL.Role_BLL role_BLL = new BLL.Role_BLL();
role_BLL.delete(txtUsername.Text);
}
init();
}
private void button5_Click(object sender, EventArgs e)
{
try
{
int id = int.Parse(txtid.Text);
new frmCongTac(id, txtusername.Text, txtpass.Text,
txthoten.Text, txtngaysinh.Text, txtsdt.Text,
int.Parse(cbchucvu.SelectedValue.ToString())).ShowDialog();
//load lai du lieu
DataTable dtnhanvien = new BLL.NhanVien_BLL().getall();
DataTable dtrole = new BLL.Role_BLL().getall();
cbchucvu.DataSource = dtrole;
cbchucvu.DisplayMember = "name";
cbchucvu.ValueMember = "id";
dgnhanvien.DataSource = dtnhanvien;
dgnhanvien.Columns[6].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show("Vui lòng chọn nhân viên");
}
}
private void ROLE_USER_Load(object sender, EventArgs e)
{
DataGridViewTextBoxColumn dgvName = new DataGridViewTextBoxColumn();
dgvName.HeaderText = "Name";
DataGridViewCheckBoxColumn dgvSelect = new DataGridViewCheckBoxColumn();
dgvSelect.HeaderText = "Select";
DataGridViewCheckBoxColumn dgvGrant = new DataGridViewCheckBoxColumn();
dgvGrant.HeaderText = "Grant";
dataGridView1.Columns.Add(dgvName);
dataGridView1.Columns.Add(dgvSelect);
dataGridView1.Columns.Add(dgvGrant);
BLL.Quyen_BLL quyen_BLL = new BLL.Quyen_BLL();
DataTable quyenTable = quyen_BLL.getByType1();
DataTable role_quyen_user = quyen_BLL.getQuyenHT_USER(role);
foreach (DataRow row in quyenTable.Rows)
{
bool select = false;
bool grant = false;
foreach (DataRow row1 in role_quyen_user.Rows)
{
if (row.ItemArray[0].ToString().ToUpper().Equals(row1.ItemArray[0].ToString().ToUpper()))
{
select = true;
if (row1.ItemArray[1].ToString().Equals("YES"))
{
grant = true;
}
quyen quyen = new quyen(row.ItemArray[0].ToString(), grant ? "1" : "-1");
listQuyen.Add(quyen);
}
}
dataGridView1.Rows.Add(row.ItemArray[0].ToString(), select, grant);
}
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AllowUserToAddRows = false;
BLL.Role_BLL role_BLL = new BLL.Role_BLL();
DataTable role_quyenrole_user = quyen_BLL.getQuyenRole_USER(role);
DataTable roleName = role_BLL.getName();
foreach (DataRow row in roleName.Rows)
{
bool select = false;
bool grant = false;
foreach (DataRow row1 in role_quyenrole_user.Rows)
{
if (row.ItemArray[0].ToString().ToUpper().Equals(row1.ItemArray[0].ToString().ToUpper()))
{
select = true;
if (row1.ItemArray[1].ToString().Equals("YES"))
{
grant = true;
}
quyen quyen = new quyen(row.ItemArray[0].ToString(), grant ? "1" : "-1");
listQuyen.Add(quyen);
}
}
dataGridView1.Rows.Add(row.ItemArray[0].ToString(), select, grant);
}
}
private void User_Of_Role_Load(object sender, EventArgs e)
{
BLL.Role_BLL role_BLL = new BLL.Role_BLL();
dataGridView1.DataSource = role_BLL.getUserOfRole(role);
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
