private void buttonUpdate_Click(object sender, EventArgs e)
{
try
{
if (Ivaild())
{
quyen q = new quyen {
id = Convert.ToInt32(textBoxID.Text), tenQuyen = textBoxName.Text, moTa = textBoxMoTa.Text
};
if (q.update())
{
loadQuyen();
}
else
{
MessageBox.Show("fail");
}
}
else
{
MessageBox.Show("Dien Du Thong Tin");
}
}
catch (SqlException ex)
{
MessageBox.Show("Lỗi SQL exception !\n" + ex.Message);
}
}
private void buttonInsert_Click(object sender, EventArgs e)
{
try
{
if (Ivaild())
{
quyen q = new quyen {
tenQuyen = textBoxName.Text, moTa = textBoxMoTa.Text
};
if (q.Insert())
{
loadQuyen();
}
else
{
MessageBox.Show("Fail");
}
}
else
{
MessageBox.Show("Dien Du Thong Tin");
}
}
catch (SqlException ex)
{
MessageBox.Show("Lỗi SQL exception !\n" + ex.Message);
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
try
{
if (textBoxID.Text != string.Empty)
{
quyen q = new quyen {
id = Convert.ToInt32(textBoxID.Text)
};
if (q.delete())
{
loadQuyen();
}
else
{
MessageBox.Show("fail");
}
}
else
{
MessageBox.Show("Dien Du Thong Tin");
}
}
catch (SqlException ex)
{
MessageBox.Show("Lỗi SQL exception !\n" + ex.Message);
}
}
public void loadQuyen()
{
try
{
quyen quyen = new quyen();
dataGridViewQuyen.DataSource = quyen.ShowtableQuyen();
}
catch (SqlException ex)
{
MessageBox.Show("Lỗi SQL exception !\n" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
quyen q = new quyen();
ddlNhomquyen.DataSource = q.quyen_laydanhsach();
ddlNhomquyen.DataTextField = "tenquyen";
ddlNhomquyen.DataValueField = "id";
ddlNhomquyen.DataBind();
// load checklistbox
frmQuantriWS qt = new frmQuantriWS();
cblQuyen.DataSource = qt.quantri_select_trang_theoquyen(-1); //select all
cblQuyen.DataTextField = "tentrang";
cblQuyen.DataValueField = "trang_id";
cblQuyen.DataBind();
check_quyen();
}
}
public void loadcombox()
{
loaiNguoiDung loainguoidung = new loaiNguoiDung();
nguoiDung nguoidung = new nguoiDung();
quyen q = new quyen();
quyen Quyen = new quyen();
comboBoxLoaiNguoiDung.DataSource = loainguoidung.ShowtableNguoiDung();
comboBoxLoaiNguoiDung.DisplayMember = "tenLoaiNguoiDung";
comboBoxLoaiNguoiDung.ValueMember = "id";
comboBoxNhomQuyen.DataSource = q.ShowtableQuyen();
comboBoxNhomQuyen.DisplayMember = "tenQuyen";
comboBoxNhomQuyen.ValueMember = "id";
comboBoxUser.DataSource = nguoidung.ShowtableNguoiDung();
comboBoxUser.DisplayMember = "username";
comboBoxUser.ValueMember = "id";
comboBoxQuyen.DataSource = Quyen.ShowtableQuyen();
comboBoxQuyen.DisplayMember = "tenQuyen";
comboBoxQuyen.ValueMember = "id";
}
