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();
}
}
}
}
}
}
}
}
