private void btnTim_Click(object sender, EventArgs e)
{
if (cbTenLop.Text == (string)cbTenLop.SelectedValue)
{
LopBUL lp = new LopBUL();
string TenLop = cbTenLop.Text;
DataTable dt = lp.DanhSachHocSinh(TenLop);
dgvDanhSachHocSinh.DataSource = dt;
dgvDanhSachHocSinh.Columns[1].HeaderText = "TenLop";
dgvDanhSachHocSinh.Columns[1].Width = 100;
dgvDanhSachHocSinh.Columns[2].HeaderText = "MaHocSinh";
dgvDanhSachHocSinh.Columns[2].Width = 100;
dgvDanhSachHocSinh.Columns[3].HeaderText = "HoTen";
dgvDanhSachHocSinh.Columns[3].Width = 100;
dgvDanhSachHocSinh.Columns[4].HeaderText = "GioiTinh";
dgvDanhSachHocSinh.Columns[4].Width = 100;
dgvDanhSachHocSinh.Columns[5].HeaderText = "DiaChi";
dgvDanhSachHocSinh.Columns[5].Width = 100;
dgvDanhSachHocSinh.Columns[6].HeaderText = "HoTenBoMe";
dgvDanhSachHocSinh.Columns[6].Width = 100;
dgvDanhSachHocSinh.Columns[7].HeaderText = "SoDienThoai";
dgvDanhSachHocSinh.Columns[7].Width = 100;
for (int i = 0; i < dgvDanhSachHocSinh.Rows.Count - 1; i++)
{
dgvDanhSachHocSinh.Rows[i].Cells[0].Value = i + 1;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtMaLop.Text == txtMaLop.Text)
{
LopBUL lp = new LopBUL();
string MaLop = txtMaLop.Text;
DataTable dt = lp.TimKiem(MaLop);
dgvDSLop.DataSource = dt;
}
}
private void btnSua_Click(object sender, EventArgs e)
{
LopBUL lp = new LopBUL();
string MaLop = txtbMaLop.Text;
string TenLop = txtbTenLop.Text;
string NienKhoa = txtbNienKhoa.Text;
int SiSo = int.Parse(txtbSiSo.Text);
string GiaoVienChuNhiem = (string)cbGiaoVienChuNhiem.SelectedValue;
lp.Sua(MaLop, TenLop, NienKhoa, SiSo, GiaoVienChuNhiem);
dgvLop.DataSource = myLop.LayDsLop();
}
private void lưuToolStripMenuItem_Click(object sender, EventArgs e)
{
if (btnThem.Enabled == false)
{
LopBUL lp = new LopBUL();
string MaLop = txtbMaLop.Text;
string TenLop = txtbTenLop.Text;
string NienKhoa = txtbNienKhoa.Text;
int SiSo = int.Parse(txtbSiSo.Text);
string GiaoVienChuNhiem = (string)cbGiaoVienChuNhiem.SelectedValue;
lp.Them(MaLop, TenLop, NienKhoa, SiSo, GiaoVienChuNhiem);
dgvLop.DataSource = myLop.LayDsLop();
btnThem.Enabled = true;
}
if (btnSua.Enabled == false)
{
LopBUL lp = new LopBUL();
string MaLop = txtbMaLop.Text;
string TenLop = txtbTenLop.Text;
string NienKhoa = txtbNienKhoa.Text;
int SiSo = int.Parse(txtbSiSo.Text);
string GiaoVienChuNhiem = (string)cbGiaoVienChuNhiem.SelectedValue;
lp.Sua(MaLop, TenLop, NienKhoa, SiSo, GiaoVienChuNhiem);
dgvLop.DataSource = myLop.LayDsLop();
btnSua.Enabled = true;
}
if (btnXoa.Enabled == false)
{
try
{
LopBUL lop = new LopBUL();
string MaLop = txtbMaLop.Text;
lop.Xoa(MaLop);
}
catch (Exception)
{
MessageBox.Show("Xóa thông tin không hợp lệ!!!");
}
DialogResult dlr = MessageBox.Show("Thông báo xác nhận xóa",
"Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlr == DialogResult.No)
{
}
if (dlr == DialogResult.Yes)
{
dgvLop.DataSource = myLop.LayDsLop();
ClearLop();
btnXoa.Enabled = true;
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (cbTen.Text == (string)cbTen.SelectedValue)
{
LopBUL lp = new LopBUL();
string TenLop = cbTen.Text;
DataTable dt = lp.TimKiem1(TenLop);
dgvDSLop.DataSource = dt;
}
else
{
dgvDSLop.DataSource = myLopBUL.LayDsLop();
}
txtMaLop.Clear();
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
LopBUL lop = new LopBUL();
string MaLop = txtbMaLop.Text;
lop.Xoa(MaLop);
}
catch (Exception)
{
MessageBox.Show("Xóa thông tin không hợp lệ!!!");
}
DialogResult dlr = MessageBox.Show("Thông báo xác nhận xóa",
"Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlr == DialogResult.No)
{
}
if (dlr == DialogResult.Yes)
{
dgvLop.DataSource = myLop.LayDsLop();
ClearLop();
}
}
