private void tbTimKIem_TextChanged(object sender, EventArgs e) { string searchtxt = tbTimKIem.Text; GiaoVienDAL gvDAL = new GiaoVienDAL(); dgvGiaoVien.DataSource = gvDAL.searchGV(searchtxt); }
private void HienThiDSGiaoVien() { dgvGiaoVien.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; GiaoVienDAL gvDAL = new GiaoVienDAL(); dgvGiaoVien.DataSource = gvDAL.LoadDS(); }
private void LoadGVBM() { GiaoVienDAL gvDAL = new GiaoVienDAL(); DataTable dataGV = gvDAL.LoadDS(); cbGVBM.DataSource = dataGV; cbGVBM.DisplayMember = "HOTEN"; cbGVBM.ValueMember = "MAGIAOVIEN"; }
private void Lb_Click(object sender, EventArgs e) { Label lb = (Label)sender; int i = (int)lb.Tag; string maK = listKhoa[i].MaKhoa; var listGV = new GiaoVienDAL().LayGiaoVienTheoKhoa(maK, dtpNgayXem.Text); DoDuLieuDSGV(listGV); }
private void btSua_Click(object sender, EventArgs e) { GiaoVien gv = new GiaoVien(); gv.MaGiaoVien = Convert.ToInt32(tbMagv.Text); GiaoVienDAL gvDAL = new GiaoVienDAL(); if (tbMagv.Text != gv.MaGiaoVien.ToString()) { MessageBox.Show("Khong duoc sua ma giáo Viên", " loi "); } else { if (tbHoTen.TextLength == 0) { MessageBox.Show("Chua nhap ho ten hoc sinh", " loi "); } else { gv.HoTen = tbHoTen.Text; if (rbNam.Checked == false && rbNu.Checked == false) { MessageBox.Show("Chua chon gioi tinh", " loi "); } if (tbNoiSinh.TextLength == 0) { MessageBox.Show("Chua nhap noi sinh ", " loi "); } else { gv.NoiSinh = tbNoiSinh.Text; if (tbĐiaChi.TextLength == 0) { MessageBox.Show("Chua nhap dia chi", " loi "); } else { gv.DiaChi = tbĐiaChi.Text; if (tbChuyenMon.TextLength == 0) { MessageBox.Show("Chua nhap chuyen mon", " loi "); } else { gv.ChuyenMon = tbChuyenMon.Text; gvDAL.SuaGIAOVIEN(gv); dgvGiaoVien.DataSource = gvDAL.LoadDS(); } } } } } }
private void cbGiaoVien_SelectedIndexChanged(object sender, EventArgs e) { try { int ma = Convert.ToInt16(cbGiaoVien.SelectedValue.ToString()); GiaoVienDAL gvDAL = new GiaoVienDAL(); GiaoVien gv = gvDAL.getGiaoVien(ma); lbMaGV.Text = gv.MaGiaoVien.ToString(); lbName.Text = gv.HoTen; lbChuyenMon.Text = gv.ChuyenMon; this.magv = ma; } catch { } }
private void dgvLopMon_CellClick(object sender, DataGridViewCellEventArgs e) { int numrow = e.RowIndex; if (dgvLopMon.Rows[numrow].Cells[4].Value.ToString() != "") { int maGV = Convert.ToInt32(dgvLopMon.Rows[numrow].Cells[4].Value.ToString()); cbGiaoVien.SelectedValue = maGV; GiaoVienDAL gvDAL = new GiaoVienDAL(); GiaoVien gv = gvDAL.getGiaoVien(maGV); lbMaGV.Text = gv.MaGiaoVien.ToString(); lbName.Text = gv.HoTen; lbChuyenMon.Text = gv.ChuyenMon; } //textBox1.Text = dgvLopMon.Rows[numrow].Cells[0].Value.ToString(); this.mamon = Convert.ToInt16(dgvLopMon.Rows[numrow].Cells[2].Value.ToString()); this.malop = Convert.ToInt16(dgvLopMon.Rows[numrow].Cells[0].Value.ToString()); }
private void btxoa_Click(object sender, EventArgs e) { GiaoVienDAL gvDAL = new GiaoVienDAL(); if (tbMagv.TextLength == 0) { MessageBox.Show("Chua co ma giao vien", " loi "); } else { try { int id = Convert.ToInt16(tbMagv.Text); gvDAL.deleteGiaoVien(id); dgvGiaoVien.DataSource = gvDAL.LoadDS(); } catch { MessageBox.Show("ma Giao Vien khong thoa man", " loi "); } } }
public GiaoVienBUS() { _giaoVienDAL = new GiaoVienDAL(); }
private void btThem_Click(object sender, EventArgs e) { GiaoVien gv = new GiaoVien(); GiaoVienDAL gvDAL = new GiaoVienDAL(); if (tbMagv.TextLength != 0) { MessageBox.Show("Không cần nhập mã Giáo Viên", " lỗi "); } else { if (tbHoTen.TextLength == 0) { MessageBox.Show("Chưa nhập họ tên Giáo Viên", " lỗi "); } else { gv.HoTen = tbHoTen.Text; if (rbNam.Checked == false && rbNu.Checked == false) { MessageBox.Show("Chua chon gioi tinh", " loi "); } else { if (rbNam.Checked == true) { gv.GioiTinh = "Nam"; } else if (rbNu.Checked == true) { gv.GioiTinh = "Nữ"; } gv.NgaySinh = Convert.ToDateTime(dtpgv.Value); if (tbNoiSinh.TextLength == 0) { MessageBox.Show("Chưa nhập nơi sinh ", " lỗi "); } else { gv.NoiSinh = tbNoiSinh.Text; if (tbĐiaChi.TextLength == 0) { MessageBox.Show("Chưa nhập Địa chỉ", " lỗi "); } else { gv.DiaChi = tbĐiaChi.Text; if (tbChuyenMon.TextLength == 0) { MessageBox.Show("Chưa nhập chuyên môn", " lỗi "); } else { gv.ChuyenMon = tbChuyenMon.Text; if (tbSdt.TextLength == 0) { MessageBox.Show("Chưa nhập sdt", " lỗi "); } else { gv.SoDienThoai = tbSdt.Text; gvDAL.insertGiaoVien(gv); dgvGiaoVien.DataSource = gvDAL.LoadDS(); } } } } } } } }
private void btThem_Click(object sender, EventArgs e) { GiaoVien gv = new GiaoVien(); GiaoVienDAL gvDAL = new GiaoVienDAL(); if (tbMagv.TextLength != 0) { MessageBox.Show("Khong can nhap ma giao vien", " Lỗi "); } else { if (tbHoTen.TextLength == 0) { MessageBox.Show("Chua nhap ho ten giao vien", " Lỗi "); } else { gv.HoTen = tbHoTen.Text; if (rbNam.Checked == false && rbNu.Checked == false) { MessageBox.Show("Chua chon gioi tinh", " Lỗi "); } else { if (rbNam.Checked == true) { gv.GioiTinh = "Nam"; } else if (rbNu.Checked == true) { gv.GioiTinh = "Nữ"; } gv.NgaySinh = Convert.ToDateTime(dtpgv.Value); if (tbNoiSinh.TextLength == 0) { MessageBox.Show("Chua nhap noi sinh ", " Lỗi "); } else { gv.NoiSinh = tbNoiSinh.Text; if (tbĐiaChi.TextLength == 0) { MessageBox.Show("Chua nhap dia chi", " Lỗi "); } else { gv.DiaChi = tbĐiaChi.Text; if (tbChuyenMon.TextLength == 0) { MessageBox.Show("Chua nhap chuyen mon", " Lỗi "); } else { gv.ChuyenMon = tbChuyenMon.Text; if (tbSdt.TextLength == 0) { MessageBox.Show("chua nhap so dien thoai", "lỗi"); } else { gv.SoDienThoai = tbSdt.Text; gvDAL.insertGiaoVien(gv); dgvGiaoVien.DataSource = gvDAL.LoadDS(); } } } } } } } }