private void tbTimKIem_TextChanged(object sender, EventArgs e)
{
string searchtxt = tbTimKIem.Text;
HocSinhDAL hsDAL = new HocSinhDAL();
dgvHocSinh.DataSource = hsDAL.searchHS(searchtxt);
}
private void HienThiDSHocSinh()
{
dgvHocSinh.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
HocSinhDAL hsDAL = new HocSinhDAL();
dgvHocSinh.DataSource = hsDAL.LoadDS();
}
public BangDiemBUS()
{
_bangDiemDAL = new BangDiemDAL();
_lopDAL = new LopDAL();
_phanLopDAL = new PhanLopDAL();
_quyDinhBUS = new QuyDinhBUS();
_hocSinhDAL = new HocSinhDAL();
_monHocDAL = new MonHocDAL();
}
private void HienThiDSLop()
{
try
{
int maHS = Convert.ToInt32(tbMaHs.Text);
dgvLop.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
HocSinhDAL hsDAL = new HocSinhDAL();
dgvLop.DataSource = hsDAL.getDSLop(maHS);
}
catch
{
}
}
private void btXoaLop_Click(object sender, EventArgs e)
{
try
{
int maHS = Convert.ToInt32(tbMaHs.Text);
HocSinhDAL hsDAL = new HocSinhDAL();
hsDAL.XoaHSLop(maHS, idLop);
HienThiDSLop();
}
catch
{
}
}
private void btThemLop_Click(object sender, EventArgs e)
{
try
{
int maHS = Convert.ToInt32(tbMaHs.Text);
int maLop = Convert.ToInt16(cbLop.SelectedValue.ToString());
HocSinhDAL hsDAL = new HocSinhDAL();
hsDAL.ThemHSLop(maHS, maLop);
HienThiDSLop();
}
catch
{
}
}
private void btXoa_Click(object sender, EventArgs e)
{
HocSinhDAL hsDAL = new HocSinhDAL();
if (tbMaHs.TextLength == 0)
{
MessageBox.Show("Chua co ma hoc sinh", " loi ");
}
else
{
try
{
int id = Convert.ToInt16(tbMaHs.Text);
hsDAL.deleteHocSinh(id);
dgvHocSinh.DataSource = hsDAL.LoadDS();
}
catch
{
MessageBox.Show("ma hoc sinh khong thoa man", " loi ");
}
}
}
private void btThem_Click(object sender, EventArgs e)
{
HocSinh hs = new HocSinh();
HocSinhDAL hsDAL = new HocSinhDAL();
if (tbMaHs.TextLength != 0)
{
MessageBox.Show("Khong can nhap ma hoc sinh", " loi ");
}
else
{
if (tbHoTen.TextLength == 0)
{
MessageBox.Show("Chua nhap ho ten hoc sinh", " loi ");
}
else
{
hs.HoTen = tbHoTen.Text;
if (rbNam.Checked == false && rbNu.Checked == false)
{
MessageBox.Show("Chua chon gioi tinh", " loi ");
}
else
{
if (rbNam.Checked == true)
{
hs.GioiTinh = "Nam";
}
else if (rbNu.Checked == true)
{
hs.GioiTinh = "Nữ";
}
if (tbNgaySinh.Text == "dd-mm-yyyy" || tbNgaySinh.TextLength == 0)
{
MessageBox.Show("Chua nhap ngay sinh", " loi ");
}
else
{
hs.NgaySinh = Convert.ToDateTime(tbNgaySinh.Text);
if (tbNoiSinh.TextLength == 0)
{
MessageBox.Show("Chua nhap noi sinh ", " loi ");
}
else
{
hs.NoiSinh = tbNoiSinh.Text;
if (tbDanToc.TextLength == 0)
{
MessageBox.Show("Chua nhap dan toc", " loi ");
}
else
{
hs.DanToc = tbDanToc.Text;
if (tbTonGiao.TextLength == 0)
{
MessageBox.Show("Chua nhap ton giao", " loi ");
}
else
{
hs.TonGiao = tbTonGiao.Text;
hsDAL.insertHocSinh(hs);
dgvHocSinh.DataSource = hsDAL.LoadDS();
}
}
}
}
}
}
}
}
private void btSua_Click(object sender, EventArgs e)
{
HocSinh hs = new HocSinh();
hs.MaHocSinh = Convert.ToInt32(tbMaHs.Text);
HocSinhDAL hsDAL = new HocSinhDAL();
if (tbMaHs.Text != hs.MaHocSinh.ToString())
{
MessageBox.Show("Khong duoc sua ma hoc sinh", " Lỗi ");
}
else
{
if (tbHoTen.TextLength == 0)
{
MessageBox.Show("Chua nhap ho ten hoc sinh", " Lỗi ");
}
else
{
hs.HoTen = tbHoTen.Text;
if (rbNam.Checked == false && rbNu.Checked == false)
{
MessageBox.Show("Chua chon gioi tinh", " Lỗi ");
}
else
{
if (rbNam.Checked == true)
{
hs.GioiTinh = "Nam";
}
else if (rbNu.Checked == true)
{
hs.GioiTinh = "Nữ";
}
hs.NgaySinh = Convert.ToDateTime(dtpNgaySinh.Value);
if (tbNoiSinh.TextLength == 0)
{
MessageBox.Show("Chua nhap noi sinh ", " Lỗi ");
}
else
{
hs.NoiSinh = tbNoiSinh.Text;
if (tbDanToc.TextLength == 0)
{
MessageBox.Show("Chua nhap dan toc", " Lỗi ");
}
else
{
hs.DanToc = tbDanToc.Text;
if (tbTonGiao.TextLength == 0)
{
MessageBox.Show("Chua nhap ton giao", " Lỗi ");
}
else
{
hs.TonGiao = tbTonGiao.Text;
hsDAL.SuaHocSinh(hs);
dgvHocSinh.DataSource = hsDAL.LoadDS();
}
}
}
}
}
}
}
public HocSinhBUS()
{
_hocSinhDAL = new HocSinhDAL();
_quyDinhBUS = new QuyDinhBUS();
_phanLopBUS = new PhanLopBUS();
}
public PhanLopBUS()
{
_phanLopDAL = new PhanLopDAL();
_hocSinhDAL = new HocSinhDAL();
}
