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"; }