public void LoadDSLHP()
{
DSLHPbindingSource.DataSource = LopHocPhan_BUS.DanhSachLHP();
gcDSLHP.DataSource = DSLHPbindingSource;
int soKhoa = cboKhoa.Items.Count;
for (int i = 0; i < soKhoa; i++)
{
cboKhoa.Items.RemoveAt(0);
}
int soMonhoc = cboMonHoc.Items.Count;
int soGiaoVien = cboGiaoVien.Items.Count;
for (int i = 0; i < soMonhoc; i++)
{
repositoryItemComboBox1.Items.RemoveAt(0);
cboMonHoc.Items.RemoveAt(0);
}
for (int i = 0; i < soGiaoVien; i++)
{
repositoryItemComboBox2.Items.RemoveAt(0);
cboGiaoVien.Items.RemoveAt(0);
}
DataTable dtb = Khoa_BUS.LoadtenKhoa();
for (int i = 0; i < dtb.Rows.Count; i++)
{
string name = ChuanHoa(dtb.Rows[i][0].ToString().ToLower());
cboKhoa.Items.Add(name);
}
DataTable dtb1 = MonHoc_BUS.LoadtenMH(cboKhoa.Text);
for (int i = 0; i < dtb1.Rows.Count; i++)
{
string name = ChuanHoa(dtb1.Rows[i][0].ToString().ToLower());
repositoryItemComboBox1.Items.Add(name);
cboMonHoc.Items.Add(name);
}
DataTable dtb2 = GiaoVien_BUS.LoadtenGiaoVien(cboKhoa.Text);
for (int i = 0; i < dtb2.Rows.Count; i++)
{
string name = ChuanHoa(dtb2.Rows[i][0].ToString().ToLower());
repositoryItemComboBox2.Items.Add(name);
cboGiaoVien.Items.Add(name);
}
//cboMonHoc.ResetText();
//cboGiaoVien.ResetText();
}
public void loadInfo()
{
DataTable dtb1 = MonHoc_BUS.DSMH();
int t = cboMH.Items.Count;
for (int i = 0; i < t; i++)
{
cboMH.Items.RemoveAt(0);
}
for (int i = 0; i < dtb1.Rows.Count; i++)
{
string name = dtb1.Rows[i][0].ToString();
cboMH.Items.Add(name);
}
cboMH.SelectedIndex = 0;
tenMh = cboMH.Text;
}
public void load_DS()
{
try
{
int t = gvSV.RowCount;
for (int i = 0; i < t; i++)
{
bindingSource1.RemoveAt(0);
}
bindingSource1.DataSource = MonHoc_BUS.DSThiLai(tenMh);
gcSV.DataSource = bindingSource1;
}
catch
{
MessageBox.Show("Load không thành công!");
}
}
public static void InitDataBase()
{
BUS.SQLDataContext.CreateDataContext();
BaoCao = new BaoCao_BUS();
Diem = new Diem_BUS();
GiaoVien = new GiaoVien_BUS();
HocKy = new HocKy_BUS();
HocSinh = new HocSinh_BUS();
Lop = new Lop_BUS();
MonHoc = new MonHoc_BUS();
NamHoc = new NamHoc_BUS();
User = new User_BUS();
CaiDatBus = new CaiDat_BUS();
Data = new Data_BUS();
CaiDat = CaiDatBus.LoadDuLieuCaiDat();
IsLoaded = true;
}
//các môn học, giáo viên thuộc khoa ...
private void cboKhoa_SelectedIndexChanged(object sender, EventArgs e)
{
int soMonhoc = cboMonHoc.Items.Count;
int soGiaoVien = cboGiaoVien.Items.Count;
for (int i = 0; i < soMonhoc; i++)
{
repositoryItemComboBox1.Items.RemoveAt(0);
cboMonHoc.Items.RemoveAt(0);
}
for (int i = 0; i < soGiaoVien; i++)
{
repositoryItemComboBox2.Items.RemoveAt(0);
cboGiaoVien.Items.RemoveAt(0);
}
cboMonHoc.ResetText();
cboGiaoVien.ResetText();
DataTable dtb = MonHoc_BUS.LoadtenMH(cboKhoa.Text);
for (int i = 0; i < dtb.Rows.Count; i++)
{
string name = ChuanHoa(dtb.Rows[i][0].ToString().ToLower());
repositoryItemComboBox1.Items.Add(name);
cboMonHoc.Items.Add(name);
}
DataTable dtb1 = GiaoVien_BUS.LoadtenGiaoVien(cboKhoa.Text);
for (int i = 0; i < dtb1.Rows.Count; i++)
{
string name = ChuanHoa(dtb1.Rows[i][0].ToString().ToLower());
repositoryItemComboBox2.Items.Add(name);
cboGiaoVien.Items.Add(name);
}
//cboMonHoc.SelectedIndex = 0;
}
