private void button5_Click(object sender, EventArgs e)
{
string text = txbSearch.Text;
if (text == "")
{
return;
}
dgSearchResult.Rows.Clear();
if (comboBox1.SelectedIndex == 0)
{
EC_LopHoc LopHoc = new BUS_LopHoc().Select_ByPrimaryKey(text);
if (LopHoc != null)
{
List <EC_LichHoc> listBuoiHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", LopHoc.Ma_LopHoc);
if (listBuoiHoc.Count == 0)
{
dgSearchResult.Rows.Clear();
return;
}
List <EC_BuoiHoc_HocSinh> listBHHS = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", listBuoiHoc[0].Ma_BuoiHoc);
foreach (EC_BuoiHoc_HocSinh ec in listBHHS)
{
EC_HocSinh hs = new BUS_HocSinh().Select_ByPrimaryKey(ec.Ma_HocSinh);
dgSearchResult.Rows.Add(hs.Ma_HocSinh, hs.Ten_HocSinh, "Học sinh", hs.Email, null);
}
}
EC_HocSinh HocSinh = new BUS_HocSinh().Select_ByPrimaryKey(text);
if (HocSinh != null)
{
dgSearchResult.Rows.Add(HocSinh.Ma_HocSinh, HocSinh.Ten_HocSinh, "Học sinh", HocSinh.Email, null);
return;
}
EC_GiaoVien GiaoVien = new BUS_GiaoVien().Select_ByPrimaryKey(text);
if (GiaoVien != null)
{
dgSearchResult.Rows.Add(GiaoVien.Ma_GiaoVien, GiaoVien.Ten_GiaoVien, "Giáo viên", GiaoVien.Email, null);
return;
}
}
else
{
List <EC_HocSinh> listHocSinh = new BUS_HocSinh().SelectByFields("Ten_HocSinh", text);
foreach (EC_HocSinh HocSinh in listHocSinh)
{
dgSearchResult.Rows.Add(HocSinh.Ma_HocSinh, HocSinh.Ten_HocSinh, "Học sinh", HocSinh.Email, null);
}
List <EC_GiaoVien> listGiaoVien = new BUS_GiaoVien().SelectByFields("Ten_GiaoVien", text);
foreach (EC_GiaoVien GiaoVien in listGiaoVien)
{
dgSearchResult.Rows.Add(GiaoVien.Ma_GiaoVien, GiaoVien.Ten_GiaoVien, "Giáo viên", GiaoVien.Email, null);
}
}
}
private void dgDanhSach_LopHoc_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
string Ma_LopHoc = dgDanhSach_LopHoc.Rows[e.RowIndex].Cells["Ma_LopHoc"].Value.ToString();
List <EC_LichHoc> listLichHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", Ma_LopHoc);
foreach (EC_LichHoc i in listLichHoc)
{
EC_BuoiHoc_HocSinh BuoiHoc_HS = new BUS_BuoiHoc_HocSinh().SelectByMa(i.Ma_BuoiHoc, Ma_HocSinh);
if (BuoiHoc_HS == null)
{
continue;
}
string TrangThai = i.TrangThai == true ? "Đã học" : "Chưa học";
string DiemDanh = BuoiHoc_HS.DiemDanh == true ? "Học" : "Nghỉ";
dgDanhSach_BuoiHoc.Rows.Add(i.STT_Buoi, i.NgayHoc.ToShortDateString(), i.KipHoc, i.PhongHoc, TrangThai, DiemDanh);
}
EC_LopHoc LopHoc = new BUS_LopHoc().Select_ByPrimaryKey(Ma_LopHoc);
txbTen_GiaoVien.Text = new BUS_GiaoVien().Select_ByPrimaryKey(LopHoc.Ma_GiaoVien).Ten_GiaoVien;
txbSoBuoi.Text = LopHoc.SoBuoi.ToString();
EC_MonHoc MonHoc = new BUS_MonHoc().Select_ByPrimaryKey(LopHoc.Ma_MonHoc);
txbLop.Text = MonHoc.Lop.ToString();
txbTen_MonHoc.Text = MonHoc.Ten_MonHoc;
txbTongHP.Text = LopHoc.TongHocPhi_KhoaHoc.ToString();
txbTrinhDo.Text = LopHoc.TrinhDo;
dtNgayBatdau.Value = LopHoc.Ngay_BatDau;
dgDanhSach_HocSinh.Rows.Clear();
List <EC_LichHoc> listBuoiHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", Ma_LopHoc);
List <EC_BuoiHoc_HocSinh> listBuoiHoc_HocSinh = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", listBuoiHoc[0].Ma_BuoiHoc);
List <EC_HocSinh> listHocSinh = new List <EC_HocSinh>();
foreach (EC_BuoiHoc_HocSinh i in listBuoiHoc_HocSinh)
{
EC_HocSinh hocsinh = new BUS_HocSinh().Select_ByPrimaryKey(i.Ma_HocSinh);
listHocSinh.Add(hocsinh);
}
foreach (EC_HocSinh i in listHocSinh)
{
string GioiTinh = i.GioiTinh == true ? "Nam" : "Nữ";
dgDanhSach_HocSinh.Rows.Add(i.Ten_HocSinh, i.NgaySinh.ToShortDateString(), GioiTinh, i.DiaChi);
}
txbSoHocSinh.Text = listHocSinh.Count.ToString();
}
private void dgChiTiet_CellClick(object sender, DataGridViewCellEventArgs e)
{
string Ma_LopHoc = dgChiTiet.Rows[e.RowIndex].Cells["Ma_LopHoc"].Value.ToString();
string Ma_BuoiHoc = dgChiTiet.Rows[e.RowIndex].Cells["Ma_BuoiHoc"].Value.ToString();
EC_LopHoc LopHoc = new BUS_LopHoc().Select_ByPrimaryKey(Ma_LopHoc);
EC_LichHoc LichHoc = new BUS_LichHoc().Select_ByPrimaryKey(Ma_BuoiHoc);
EC_BuoiHoc_HocSinh BHHS = new BUS_BuoiHoc_HocSinh().SelectByMa(Ma_BuoiHoc, Ma_HocSinh);
txbMa_LopHoc.Text = LopHoc.Ma_LopHoc;
txbMa_BuoiHoc.Text = LichHoc.Ma_BuoiHoc;
txbGiaoVien.Text = new BUS_GiaoVien().Select_ByPrimaryKey(LopHoc.Ma_GiaoVien).Ten_GiaoVien;
txbMonHoc.Text = new BUS_MonHoc().Select_ByPrimaryKey(LopHoc.Ma_MonHoc).Ten_MonHoc;
txbSoTien_Buoi.Text = BHHS.SoTien_Buoi.ToString();
dtNgayHoc.Value = LichHoc.NgayHoc;
}
void Load()
{
dgDanhSachLop.Rows.Clear();
List <EC_LichHoc> listLichHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", Ma_LopHoc);
List <EC_BuoiHoc_HocSinh> listBuoiHoc_HocSinh = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", listLichHoc[0].Ma_BuoiHoc);
List <EC_HocSinh> listHocSinh = new List <EC_HocSinh>();
foreach (EC_BuoiHoc_HocSinh i in listBuoiHoc_HocSinh)
{
EC_HocSinh hocsinh = new BUS_HocSinh().Select_ByPrimaryKey(i.Ma_HocSinh);
listHocSinh.Add(hocsinh);
}
foreach (EC_HocSinh i in listHocSinh)
{
dgDanhSachLop.Rows.Add(i.Ma_HocSinh, i.Ten_HocSinh, i.NgaySinh, i.GioiTinh, i.SDT);
}
}
void Load()
{
EC_GiaoVien GiaoVien = new BUS_GiaoVien().Select_ByPrimaryKey(Ma_GiaoVien);
if (GiaoVien.Anh != null)
{
picAvt.Image = HinhAnh.ByteToImage(GiaoVien.Anh);
}
txbMa_GiaoVien.Text = GiaoVien.Ma_GiaoVien;
txbTen_GiaoVien.Text = GiaoVien.Ten_GiaoVien;
txbDiaChi.Text = GiaoVien.DiaChi;
txbEmail.Text = GiaoVien.Email;
txbSDT.Text = GiaoVien.SDT;
dtNgaySinh.Value = GiaoVien.NgaySinh;
cbGioiTinh.SelectedItem = GiaoVien.GioiTinh == true ? "Nam" : "Nữ";
cbTrinhDo.SelectedItem = GiaoVien.TrinhDo;
List <EC_PhanCong_Day> listPhanCong_Day = new BUS_PhanCong_Day().SelectByFields("Ma_GiaoVien", Ma_GiaoVien);
BUS_MonHoc busMonHoc = new BUS_MonHoc();
int index = 1;
foreach (EC_PhanCong_Day ec in listPhanCong_Day)
{
EC_MonHoc MonHoc = busMonHoc.Select_ByPrimaryKey(ec.Ma_MonHoc);
dgPhanCong_Day.Rows.Add(index.ToString(), MonHoc.Ma_MonHoc, MonHoc.Ten_MonHoc, MonHoc.Lop.ToString());
index++;
}
index = 1;
List <EC_LopHoc> listLopHoc = new BUS_LopHoc().SelectByFields("Ma_GiaoVien", Ma_GiaoVien);
foreach (EC_LopHoc ec in listLopHoc)
{
List <EC_LichHoc> listBuoiHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", ec.Ma_LopHoc);
if (listBuoiHoc.Count == 0)
{
continue;
}
List <EC_BuoiHoc_HocSinh> listBHHS = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", listBuoiHoc[0].Ma_BuoiHoc);
EC_MonHoc MonHoc = busMonHoc.Select_ByPrimaryKey(ec.Ma_MonHoc);
dgLopDay.Rows.Add(index.ToString(), ec.Ma_LopHoc, MonHoc.Ten_MonHoc, MonHoc.Lop, ec.SoBuoi, listBHHS.Count);
index++;
}
}
void Load()
{
dgDanhSachLop.Rows.Clear();
List <EC_LichHoc> listLichHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", Ma_LopHoc);
List <EC_BuoiHoc_HocSinh> listBuoiHoc_HocSinh = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", listLichHoc[0].Ma_BuoiHoc);
List <EC_HocSinh> listHocSinh = new List <EC_HocSinh>();
foreach (EC_BuoiHoc_HocSinh i in listBuoiHoc_HocSinh)
{
EC_HocSinh hocsinh = new BUS_HocSinh().Select_ByPrimaryKey(i.Ma_HocSinh);
listHocSinh.Add(hocsinh);
}
int index = 1;
foreach (EC_HocSinh i in listHocSinh)
{
string GioiTinh = i.GioiTinh == true ? "Nam" : "Nữ";
dgDanhSachLop.Rows.Add(index.ToString(), i.Ma_HocSinh, i.Ten_HocSinh, i.NgaySinh.ToShortDateString(), GioiTinh, i.SDT);
index++;
}
}
void LayDuLieu(int SttBuoi)
{
int SoHS_DiHoc = 0;
EC_LichHoc ecLichHoc = new EC_LichHoc();
DanhSachLop = new List <EC_HocSinh>();
dgLopHoc.Rows.Clear();
foreach (EC_LichHoc ec in listBuoiHoc)
{
if (ec.STT_Buoi == (SttBuoi + 1))
{
ecLichHoc = ec;
}
}
if (ecLichHoc == null)
{
return;
}
List <EC_BuoiHoc_HocSinh> listBH_HS = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", ecLichHoc.Ma_BuoiHoc);
if (listBH_HS.Count == 0)
{
return;
}
foreach (EC_BuoiHoc_HocSinh bhhs in listBH_HS)
{
EC_HocSinh hs = new BUS_HocSinh().Select_ByPrimaryKey(bhhs.Ma_HocSinh);
DanhSachLop.Add(hs);
if (bhhs.DiemDanh == true)
{
SoHS_DiHoc++;
}
}
int i = 1;
foreach (EC_HocSinh HocSinh in DanhSachLop)
{
string gioitinh = HocSinh.GioiTinh == true ? "Nam" : "Nữ";
bool DiemDanh = false;
foreach (EC_BuoiHoc_HocSinh bhhs in listBH_HS)
{
if (bhhs.Ma_HocSinh == HocSinh.Ma_HocSinh)
{
DiemDanh = bhhs.DiemDanh;
}
}
dgLopHoc.Rows.Add(i.ToString(), HocSinh.Ten_HocSinh, HocSinh.NgaySinh,
gioitinh, HocSinh.SDT, DiemDanh);
i++;
}
DateTime NgayHoc = ecLichHoc.NgayHoc;
if (NgayHoc.Day == DateTime.Now.Day && NgayHoc.Month == DateTime.Now.Month && NgayHoc.Year == DateTime.Now.Year)
{
btDiemDanh.Visible = true;
}
else
{
btDiemDanh.Visible = false;
}
dateTimePicker1.Value = NgayHoc;
txbKip.Text = ecLichHoc.KipHoc.ToString();
txbSoHocSinh.Text = DanhSachLop.Count.ToString();
int SoHS_Vang = DanhSachLop.Count - SoHS_DiHoc;
txbDiHoc.Text = SoHS_DiHoc.ToString();
txbVang.Text = SoHS_Vang.ToString();
txbTrangThai.Text = ecLichHoc.TrangThai == true ? "Đã học" : "Chưa học";
txbHocPhi_Buoi.Text = ecLichHoc.TongHocPhi_Buoi.ToString();
txbMa_BuoiHoc.Text = ecLichHoc.Ma_BuoiHoc;
}