private void load_cboLop()
{
cboLop.Properties.DataSource = LOP_BUS.LayLopTheoNamHoc(NAMHOC_BUS.LayNamHocHienTai().MANAMHOC);
cboLop.Properties.DisplayMember = "TENLOP";
cboLop.Properties.ValueMember = "MALOP";
cboLop.EditValue = null;
}
private void load_cboNamHoc()
{
cboNamHoc.Text = NAMHOC_BUS.LayNamHocHienTai().TENNAMHOC;
//cboNamHoc.Properties.DataSource = NAMHOC_BUS.LayTatCaNamHoc();
//cboNamHoc.Properties.DisplayMember = "TENNAMHOC";
//cboNamHoc.Properties.ValueMember = "MANAMHOC";
}
private void btnDeletebindingNavigatorDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc chắn xóa lớp này không?", "DELETE", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string maNamHoc = dgvNamHoc.GetFocusedRowCellDisplayText(col_maNamHoc);
NAMHOC_BUS.Delete(maNamHoc);
load_DSNamHoc();
}
}
private void load_cboKhoiLop()
{
if (cboNamHoc.Text != "")
{
string maNamHoc = NAMHOC_BUS.LayNamHocHienTai().MANAMHOC;
cboKhoiLop.Properties.DataSource = KHOILOP_BUS.LayKhoiTheoNamHoc(maNamHoc);
cboKhoiLop.Properties.DisplayMember = "TENKHOI";
cboKhoiLop.Properties.ValueMember = "MAKHOI";
}
}
private void bindingNavigatorXemDiemItem_Click(object sender, EventArgs e)
{
string maHS = dgvDiem.GetFocusedRowCellDisplayText(col_maHS);
string hoTen = dgvDiem.GetFocusedRowCellDisplayText(col_hoTen);
string maHocKy = cboHocKy.EditValue.ToString();
string maNamHoc = NAMHOC_BUS.LayNamHocHienTai().MANAMHOC;
frmDiemChiTiet frm = new frmDiemChiTiet(maHS, maHocKy, maNamHoc);
frm.Show();
}
private void load_cboNamHoc()
{
string maHS = "";
if (cboHocSinh.EditValue != null)
{
maHS = cboHocSinh.EditValue.ToString();
}
cboNamHoc.Properties.DataSource = NAMHOC_BUS.LayNamHocTheoMaHS(maHS);
cboNamHoc.Properties.DisplayMember = "TENNAMHOC";
cboNamHoc.Properties.ValueMember = "MANAMHOC";
}
private void load_cboNamHocMoi()
{
if (cboNamHocCu.Text != "")
{
string maNamHocCu = cboNamHocCu.EditValue.ToString();
cboNamHocMoi.Properties.DataSource = NAMHOC_BUS.LayNamHocTiepTheo(maNamHocCu);
cboNamHocMoi.Properties.DisplayMember = "TENNAMHOC";
cboNamHocMoi.Properties.ValueMember = "MANAMHOC";
//cboNamHocMoi.EditValue = null;
}
else
{
cboNamHocMoi.Properties.DataSource = null;
}
cboNamHocMoi.EditValue = null;
}
private void load_BangDiem()
{
if (cboLop.Text != "" && cboMonHoc.Text != "" && cboHocKy.Text != "")
{
string maLop = cboLop.EditValue.ToString();
string maMonHoc = cboMonHoc.EditValue.ToString();
string maHocKy = cboHocKy.EditValue.ToString();
string maNamHoc = NAMHOC_BUS.LayNamHocHienTai().MANAMHOC;
bindingSourceDiem.DataSource = HOCTAP_BUS.LayDiemMonHocTheoLop(maLop, maMonHoc, maHocKy, maNamHoc);
bindingNavigatorXemDiemItem.Enabled = true;
}
else
{
bindingSourceDiem.DataSource = null;
}
}
private void load_cboNamHoc()
{
cboNamHoc.DataSource = NAMHOC_BUS.LayTatCaNamHoc();
cboNamHoc.DisplayMember = "TENNAMHOC";
cboNamHoc.ValueMember = "MANAMHOC";
}
private void bindingNavigatorAdd_Click(object sender, EventArgs e)
{
NAMHOC_BUS.Insert();
load_DSNamHoc();
}
private void load_DSNamHoc()
{
bindingSourceNamHoc.DataSource = NAMHOC_BUS.LayTatCaNamHoc();
}
private void frmManHinhChinh_Load(object sender, EventArgs e)
{
staticNamHoc.Caption = "Năm học: " + NAMHOC_BUS.LayNamHocHienTai().TENNAMHOC.ToString();
staticNguoiDung.Caption = "Người dùng: " + NGUOIDUNG_BUS.LayTenNguoiDung(username).ToString();
}
private void load_colNamHoc()
{
col_namHoc_edit.DataSource = NAMHOC_BUS.LayTatCaNamHoc();
}
