private void btnXoaGiangVien_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("Bạn có chắc muốn xóa Giảng Viên này không?",
"Question",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
GiangVienBUS.Delete(giangVienUpdateDTO.MaGiangVien);
MessageBox.Show("Xóa Giảng Viên thành công");
layDanhSachGiangVien();
txtTenGiangVienUpdate.Text = "";
txtSoDienThoaiUpdate.Text = "";
txtDiaChiUpdate.Text = "";
txtEmailUpdate.Text = "";
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnChon_Click(object sender, EventArgs e)
{
try
{
if (listGiangVien.SelectedIndex >= 0)
{
int maGiangVien = Int32.Parse(listGiangVien.SelectedValue.ToString());
bool contains = dtGiangVienCuaMon.AsEnumerable()
.Any(row => maGiangVien == row.Field <int>("MaGiangVien"));
if (contains == false)
{
DataRow dr = dtGiangVienCuaMon.NewRow();
dr[0] = maGiangVien;
dr[1] = listGiangVien.Text;
dtGiangVienCuaMon.Rows.Add(dr);
listGiangVienMon.DataSource = dtGiangVienCuaMon;
listGiangVienMon.DisplayMember = "TenGiangVien";
listGiangVienMon.ValueMember = "MaGiangVien";
if (!GiangVienBUS.KiemTraCanBoCoiThiLan2TheoMaGiangVienMaChiTietMon(maGiangVien, maChiTietMon))
{
GiangVienBUS.ThemCanBoCoiThiLan2Mon(maGiangVien, maChiTietMon);
}
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtTimKiem_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
if (bool.Parse(radioGroup1.EditValue.ToString()))//tim theo ten
{
gridControlGV.DataSource = GiangVienBUS.DanhSachGiangVien().Where(gv => gv.HoTen.ToLower().Contains(txtTimKiem.Text.Trim().ToLower()));
}
else if (txtTimKiem.Text.Trim().Length == 6)//tim theo ma
{
gridControlGV.DataSource = GiangVienBUS.DanhSachGiangVien().Where(gv => gv.MaGV.ToLower() == txtTimKiem.Text.Trim().ToLower());
}
else
{
MsgboxUtil.Exclamation("Mã giảng viên không đúng định dạng");
}
}
}
catch (Exception ex)
{
ExceptionUtil.ThrowMsgBox(ex.Message);
}
}
private void btnCapNhatGiangVien_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("Bạn có chắc muốn cập nhật thông tin của Giảng Viên này không?",
"Question",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
giangVienUpdateDTO.TenGiangVien = txtTenGiangVienUpdate.Text;
giangVienUpdateDTO.SoDienThoai = txtSoDienThoaiUpdate.Text;
giangVienUpdateDTO.DiaChi = txtDiaChiUpdate.Text;
giangVienUpdateDTO.Email = txtEmailUpdate.Text;
GiangVienBUS.UpdateRecord(giangVienUpdateDTO);
MessageBox.Show("Cập nhật thông tin Giảng Viên thành công");
layDanhSachGiangVien();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public frmQLGiangVien()
{
khoaBUS = new KhoaBUS();
gvBUS = new GiangVienBUS();
InitializeComponent();
LoadData();
}
public frmQuanLyNguoiDung()
{
gvBUS = new GiangVienBUS();
svBUS = new SinhVienBUS();
tkBUS = new TaiKhoanBUS();
InitializeComponent();
LoadData();
}
public frmSinhVien()
{
lopBUS = new LopBUS();
cnBUS = new ChuyenNganhBUS();
gvBUS = new GiangVienBUS();
khoaBUS = new KhoaBUS();
svBUS = new SinhVienBUS();
InitializeComponent();
LoadData();
}
private void loadTeacher()
{
try
{
dtTeacher = new GiangVienBUS().getTeacher();
dgvGiangVien.DataSource = dtTeacher;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LoadSourceGiangVien()
{
try
{
giangVien = GiangVienBUS.DanhSachGiangVien();
gridControlGV.DataSource = giangVien;
}
catch (Exception ex)
{
throw ex;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count > 0)
{
for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
{
string makhoa, machuongtrinhhoc, magv, maphonghoc, mangayhoc, maca;
makhoa = new KhoaHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[2].Value.ToString());
machuongtrinhhoc = new ChuongTrinhHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[3].Value.ToString());
magv = new GiangVienBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[10].Value.ToString());
maphonghoc = new PhongHocBUS().GetMa_TheoTen_PhongHoc(dataGridViewX1.Rows[i].Cells[11].Value.ToString());
mangayhoc = new NgayHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[6].Value.ToString());
maca = new CaHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[7].Value.ToString());
_objlop = new Lop(
_objlopbus.Lop_NextID(),
dataGridViewX1.Rows[i].Cells[1].Value.ToString(),
makhoa,
machuongtrinhhoc,
DateTime.Parse(dataGridViewX1.Rows[i].Cells[4].Value.ToString()),
DateTime.Parse(dataGridViewX1.Rows[i].Cells[5].Value.ToString()),
maca,
mangayhoc,
magv,
maphonghoc);
if (_objlopbus.AddLop(_objlop))
{
dataGridViewX1.Rows.Remove(dataGridViewX1.Rows[i]);
i--;
LoadData();
}
else
{
string a = dataGridViewX1.Rows[i].Cells[0].Value.ToString();
MessageBox.Show("Lưu dòng " + a + " thất bại");
}
}
if (dataGridViewX1.Rows.Count == 0)
{
MessageBox.Show("Lưu thành công");
}
dtipNgayBatDau.Text = "";
dtipNgayKetThuc.Text = "";
}
else
{
MessageBox.Show("Không có dữ liệu để lưu ! ", "Thống báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void layDanhSachGiangVien()
{
try
{
listGiangVien.DataSource = GiangVienBUS.GetTable(txtThongTinTimKiem.Text);
listGiangVien.DisplayMember = "TenGiangVien";
listGiangVien.ValueMember = "MaGiangVien";
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmThemGiangVien_Load(object sender, EventArgs e)
{
try
{
cmbTrinhDo.Properties.DataSource = TrinhDoBUS.DanhSachTrinhDo();
cmbTrinhDo.EditValue = cmbTrinhDo.Properties.GetDataSourceValue("MaTrinhDo", 0);
txtMaGV.Text = GiangVienBUS.SinhMa();
txtHoTen.Focus();
}
catch (Exception ex)
{
ExceptionUtil.ThrowMsgBox(ex.Message);
}
}
private void btXoaGV_Click(object sender, EventArgs e)
{
try
{
int i = new GiangVienBUS().deleteTeacher(int.Parse(txtMaGV_GV.Text));
loadTeacher();
bindTeacher();
}
catch (FormatException)
{
MessageBox.Show("Ma Giao Vien bạn nhập vào không hợp lệ!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmThemCanBoCoiThiLan2TimKiem_Load(object sender, EventArgs e)
{
try
{
maChiTietMon = frmTimKiemLop.gMaChiTietMon;
dtGiangVienCuaMon = GiangVienBUS.LayDanhSachCanBoCoiThiLan2CuaMon(maChiTietMon);
listGiangVienMon.DataSource = dtGiangVienCuaMon;
listGiangVienMon.DisplayMember = "TenGiangVien";
listGiangVienMon.ValueMember = "MaGiangVien";
layDanhSachGiangVien();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void LoadSelect()
{
GiangVienBUS _objgvbus = new GiangVienBUS();
DataTable _dtgv = _objgvbus.GetMaTen();
cbGiangVien.DataSource = _dtgv;
cbGiangVien.ValueMember = "MaGV";
cbGiangVien.DisplayMember = "TenGV";
cbGiangVien.SelectedIndex = -1;
KhoaHocBUS _objkhoahocbus = new KhoaHocBUS();
DataTable _dtkh = _objkhoahocbus.GetMaTenKhoaHoc();
cbKhoaHoc.DataSource = _dtkh;
cbKhoaHoc.ValueMember = "MaKhoaHoc";
cbKhoaHoc.DisplayMember = "TenKhoaHoc";
PhongHocBUS _objphonghocbus = new PhongHocBUS();
DataTable _dtph = _objphonghocbus.GetMaTen();
cbPhongHoc.DataSource = _dtph;
cbPhongHoc.ValueMember = "MaPhong";
cbPhongHoc.DisplayMember = "TenPhong";
cbPhongHoc.SelectedIndex = -1;
CaHocBUS _objcahocbus = new CaHocBUS();
DataTable _dtch = _objcahocbus.GetMaTen();
cbCaHoc.DataSource = _dtch;
cbCaHoc.ValueMember = "MaCa";
cbCaHoc.DisplayMember = "TenCa";
cbCaHoc.Text = "";
NgayHocBUS _objngayhocbus = new NgayHocBUS();
DataTable _dtngay = _objngayhocbus.GetAllNgayHoc();
cbNgayHoc.DataSource = _dtngay;
cbNgayHoc.ValueMember = "MaNgay";
cbNgayHoc.DisplayMember = "DanhSachNgay";
cbNgayHoc.SelectedIndex = -1;
cbChuongTrinhHoc.SelectedIndex = -1;
txtGioBatDau.Text = "";
txtGioKetThuc.Text = "";
}
private void listGiangVien_MouseClick(object sender, MouseEventArgs e)
{
try
{
if (listGiangVien.SelectedIndex >= 0)
{
giangVienUpdateDTO = GiangVienBUS.TimTheoMaGiangVien(Int32.Parse(listGiangVien.SelectedValue.ToString()));
txtTenGiangVienUpdate.Text = giangVienUpdateDTO.TenGiangVien;
txtSoDienThoaiUpdate.Text = giangVienUpdateDTO.SoDienThoai;
txtDiaChiUpdate.Text = giangVienUpdateDTO.DiaChi;
txtEmailUpdate.Text = giangVienUpdateDTO.Email;
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
string makhoa, machuongtrinhhoc, magv, maphonghoc, mangayhoc, maca;
makhoa = new KhoaHocBUS().GetMa_TheoTen(cbKhoaHoc.Text);
machuongtrinhhoc = new ChuongTrinhHocBUS().GetMa_TheoTen(cbChuongTrinhHoc.Text);
magv = new GiangVienBUS().GetMa_TheoTen(cbGiangVien.Text);
maphonghoc = new PhongHocBUS().GetMa_TheoTen_PhongHoc(cbPhongHoc.Text);
mangayhoc = new NgayHocBUS().GetMa_TheoTen(cbNgayHoc.Text);
maca = new CaHocBUS().GetMa_TheoTen(cbCaHoc.Text);
_objlop = new Lop(
dataGridViewX1.CurrentRow.Cells[0].Value.ToString(),
txtTenLop.Text,
makhoa,
machuongtrinhhoc,
DateTime.Parse(dtipNgayBatDau.Value.ToShortDateString()),
DateTime.Parse(dtipNgayBatDau.Value.ToShortDateString()),
maca,
mangayhoc,
magv,
maphonghoc);
//MessageBox.Show(dataGridViewX1.CurrentRow.Cells[0].Value.ToString() +
// txtTenLop.Text+
// makhoa+
// machuongtrinhhoc+
// DateTime.Parse(dtipNgayBatDau.Value.ToShortDateString())+
// DateTime.Parse(dtipNgayBatDau.Value.ToShortDateString())+
// maca+
// mangayhoc+
// magv+
// maphonghoc);
if (_objlopbus.EditLop(_objlop))
{
MessageBox.Show("Cập nhật thành công ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadData();
resettextbox();
}
else
{
MessageBox.Show("Cập Nhật thất bại", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnBoChon_Click(object sender, EventArgs e)
{
try
{
if (listGiangVienMon.SelectedIndex >= 0)
{
GiangVienBUS.XoaCanBoCoiThiLan2Mon(Int32.Parse(listGiangVienMon.SelectedValue.ToString()), maChiTietMon);
dtGiangVienCuaMon.Rows.Remove(dtGiangVienCuaMon.Rows[listGiangVienMon.SelectedIndex]);
listGiangVienMon.DataSource = dtGiangVienCuaMon;
listGiangVienMon.DisplayMember = "TenGiangVien";
listGiangVienMon.ValueMember = "MaGiangVien";
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSendEmailToAll_Click(object sender, EventArgs e)
{
string notifyMessage;
if (cbxTatCaNamHoc.Checked)
{
notifyMessage = "Bạn có chắc muốn gửi email LỊCH GIẢNG DẠY cho tất cả giảng viên không?";
}
else
{
notifyMessage = "Bạn có chắc muốn gửi email LỊCH GIẢNG DẠY năm học " + (cmbNamHoc.SelectedItem as NamHocDTO).TenNamHoc + " cho tất cả giảng viên không?";
}
DialogResult result = MessageBox.Show(notifyMessage,
"Question",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
DataTable gv = GiangVienBUS.GetTable();
foreach (DataRow dr in gv.Rows)
{
layDanhSachMon(Int32.Parse(dr["MaGiangVien"].ToString()));
if (dtDanhSachLop.Rows.Count > 0)
{
string exportFileName = "GiangVien_" + dr["TenGiangVien"].ToString().Replace(@" ", "-").ToUpper() + "_LichGiangDay.xlsx";
string exportFilePath = Path.Combine(Directory.GetCurrentDirectory() + @"\LichGiangDay\", exportFileName);
xuatExcelAll(exportFilePath, dr["TenGiangVien"].ToString());
EmailInfo email = new EmailInfo();
email.toEmailAddress = dr["Email"].ToString();
email.filePath = exportFilePath;
ThreadPool.QueueUserWorkItem(sendEmail, email);
}
}
MessageBox.Show("Đã gửi email LỊCH GIẢNG DẠY cho tất cả giảng viên");
}
}
private void btSuaGV_Click(object sender, EventArgs e)
{
try
{
int MaGV = int.Parse(txtMaGV_GV.Text);
string Ho = txtHo_GV.Text,
Ten = txtTen_GV.Text,
DiaChi = txtDiaChiGV.Text,
GioiTinh = cbGioiTinhGV.Text,
MaNganh = cbMaNganh_GV.SelectedValue.ToString();
byte[] HinhGV = ConvertToByte(picGV_GV.Image);
GiangVien gv = new GiangVien(MaGV, Ho, Ten, DiaChi, GioiTinh, MaNganh, HinhGV);
int kq = new GiangVienBUS().updateTeacher(gv);
loadTeacher();
picGV_GV.Image = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmPhanCongGiangDay_Load(object sender, EventArgs e)
{
try
{
txtMaPC.Text = PhanCongBUS.SinhMa();
cmbGiangVien.Properties.DataSource = GiangVienBUS.DanhSachTuyChinh();
cmbGiangVien.EditValue = cmbGiangVien.Properties.GetDataSourceValue("MaGV", 0);
cmbMonHoc.Properties.DataSource = MonHocBUS.DanhSachTuyChinh();
cmbMonHoc.EditValue = cmbMonHoc.Properties.GetDataSourceValue("MaMH", 0);
cmbLop.Properties.DataSource = LopBUS.DanhSachTuyChinh();
cmbLop.EditValue = cmbLop.Properties.GetDataSourceValue("MaLop", 0);
LoadSourceGridControl();
}
catch (Exception ex)
{
ExceptionUtil.ThrowMsgBox(ex.Message);
}
}
private void btnThemGiangVien_Click(object sender, EventArgs e)
{
if (txtTenGiangVienThem.Text == "")
{
MessageBox.Show("Phải nhập tên Giảng Viên");
return;
}
try
{
DialogResult result = MessageBox.Show("Bạn có chắc muốn thêm Giảng Viên này không?",
"Question",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
GiangVienDTO giangVienDTO = new GiangVienDTO();
giangVienDTO.TenGiangVien = txtTenGiangVienThem.Text;
giangVienDTO.SoDienThoai = txtSoDienThoaiThem.Text;
giangVienDTO.DiaChi = txtDiaChiThem.Text;
giangVienDTO.Email = txtEmailThem.Text;
GiangVienBUS.Insert(giangVienDTO);
MessageBox.Show("Thêm Giảng Viên thành công");
txtTenGiangVienThem.Text = "";
txtSoDienThoaiThem.Text = "";
txtDiaChiThem.Text = "";
txtEmailThem.Text = "";
layDanhSachGiangVien();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
GiangVien gv = new GiangVien();
if (TaoMoi(gv))
{
frmMatKhau frm = new frmMatKhau();
frm.truyen += new frmMatKhau.TruyenMatKhau(GetMatKhau);
if (frm.ShowDialog() == DialogResult.OK)
{
NguoiDung user = new NguoiDung()
{
TenDangNhap = gv.MaGV.ToLower(),
MatKhau = UtilitiesClass.MaHoaMD5(_matKhau),
TenNguoiDung = gv.HoTen,
Quyen = (int)QuyenNguoiDung.GiangVien,
MoTaQuyen = "Giảng viên"
};
NguoiDungBUS.Them(user);
GiangVienBUS.Them(gv);
StaticClass.LuuThayDoi();
log.GhiFile("Thêm mới giảng viên: " + gv.MaGV);
MsgboxUtil.Success("Thành công");
ClearText();
txtMaGV.Text = GiangVienBUS.SinhMa();
}
else
{
MsgboxUtil.Exclamation("Không thể thêm giảng viên khi chưa thiết lập mật khẩu");
}
}
}
catch (Exception ex)
{
ExceptionUtil.ThrowMsgBox(ex.Message);
}
}
public frmQLHocPhan()
{
mhBUS = new MonHocBUS();
hpBUS = new HocPhanBUS();
svBUS = new SinhVienBUS();
dtBUS = new DIemThiBUS();
gvBUS = new GiangVienBUS();
InitializeComponent();
LoadData();
this.txtMaSV.AutoCompleteMode = AutoCompleteMode.Suggest;
this.txtMaSV.AutoCompleteSource = AutoCompleteSource.CustomSource;
var lstMSSV = svBUS.getMSSV();
AutoCompleteStringCollection AutoComp = new AutoCompleteStringCollection();
foreach (var sv in lstMSSV)
{
AutoComp.Add(sv);
}
this.txtMaSV.AutoCompleteCustomSource = AutoComp;
}
private void Set_cmbGiangVien()
{
try
{
cmbGiangVien.Properties.DataSource = GiangVienBUS.DanhSachTuyChinh();
//neu dang nhap bang quyen giang vien
if (StaticClass.User.Quyen == (int)QuyenNguoiDung.GiangVien)
{
xemPhieuGiangDay1.MaGV = StaticClass.User.TenDangNhap.ToUpper();
cmbGiangVien.EditValue = StaticClass.User.TenDangNhap.ToUpper();
cmbGiangVien.Properties.ReadOnly = true;
}
else//dang nhap bang quyen admin
{
cmbGiangVien.Properties.ReadOnly = false;
cmbGiangVien.EditValue = cmbGiangVien.Properties.GetDataSourceValue("MaGV", 0);
xemPhieuGiangDay1.MaGV = cmbGiangVien.EditValue.ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void lsvTables_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//bang sinh vien
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.SinhVien.ToString())
{
tenBang = "SinhVien";
gridControl1.DataSource = SinhVienBUS.LayDuLieu();
return;
}
//bang buoi hoc
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.BuoiHoc.ToString())
{
tenBang = "BuoiHoc";
gridControl1.DataSource = BuoiHocBUS.LayDuLieu();
return;
}
//bang thoi khoa bieu
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.ThoiKhoaBieu.ToString())
{
tenBang = "ThoiKhoaBieu";
gridControl1.DataSource = ThoiKhoaBieuBUS.LayDuLieu();
return;
}
//bang phong hoc
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.PhongHoc.ToString())
{
tenBang = "PhongHoc";
gridControl1.DataSource = PhongHocBUS.LayDuLieu();
return;
}
//bang đề nghị
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.DeNghi.ToString())
{
tenBang = "DeNghi";
gridControl1.DataSource = DeNghiBUS.LayDuLieu();
return;
}
//bang lop
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.Lop.ToString())
{
tenBang = "Lop";
gridControl1.DataSource = LopBUS.LayDuLieu();
return;
}
//bang phan cong
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.PhanCong.ToString())
{
tenBang = "PhanCong";
gridControl1.DataSource = PhanCongBUS.LayDuLieu();
return;
}
//bang mon hoc
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.MonHoc.ToString())
{
tenBang = "MonHoc";
gridControl1.DataSource = MonHocBUS.LayDuLieu();
return;
}
//bang nghanh hoc
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.NganhHoc.ToString())
{
tenBang = "NganhHoc";
gridControl1.DataSource = NganhHocBUS.LayDuLieu();
return;
}
//bang nguoi dung
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.NguoiDung.ToString())
{
tenBang = "NguoiDung";
gridControl1.DataSource = NguoiDungBUS.LayDuLieu();
return;
}
//bang trinh do
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.TrinhDo.ToString())
{
tenBang = "TrinhDo";
gridControl1.DataSource = TrinhDoBUS.DanhSachTrinhDo();
return;
}
//bang giang vien
if (lsvTables.Items[GetSelectedItemIndex()].Text == TableNames.GiangVien.ToString())
{
tenBang = "GiangVien";
gridControl1.DataSource = GiangVienBUS.LayDuLieu();
return;
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LayDanhSachChiTietMon()
{
try
{
dtChiTietMon = ChiTietMonBUS.GetTable(lopDTO.MaLop);
foreach (DataRow dr in dtChiTietMon.Rows)
{
DataTable dtGiangVienMon = GiangVienBUS.LayDanhSachGiangVienCuaMon(Int32.Parse(dr["MaChiTietMon"].ToString()));
if (dtChiTietMon.Rows.Count > 0)
{
string giangVien = "";
foreach (DataRow drGiangVienMon in dtGiangVienMon.Rows)
{
if (giangVien == "")
{
giangVien += drGiangVienMon["TenGiangVien"].ToString();
}
else
{
giangVien = giangVien + Environment.NewLine + drGiangVienMon["TenGiangVien"].ToString();
}
}
dr["GiangVien"] = giangVien;
}
DataTable dtCanBoCoiThiLan1 = GiangVienBUS.LayDanhSachCanBoCoiThiLan1CuaMon(Int32.Parse(dr["MaChiTietMon"].ToString()));
if (dtCanBoCoiThiLan1.Rows.Count > 0)
{
string canBoCoiThiLan1 = "";
foreach (DataRow drCanBoCoiThiLan1 in dtCanBoCoiThiLan1.Rows)
{
if (canBoCoiThiLan1 == "")
{
canBoCoiThiLan1 += drCanBoCoiThiLan1["TenGiangVien"].ToString();
}
else
{
canBoCoiThiLan1 = canBoCoiThiLan1 + Environment.NewLine + drCanBoCoiThiLan1["TenGiangVien"].ToString();
}
}
dr["CanBoCoiThiLan1"] = canBoCoiThiLan1;
}
DataTable dtCanBoCoiThiLan2 = GiangVienBUS.LayDanhSachCanBoCoiThiLan2CuaMon(Int32.Parse(dr["MaChiTietMon"].ToString()));
if (dtCanBoCoiThiLan2.Rows.Count > 0)
{
string canBoCoiThiLan2 = "";
foreach (DataRow drCanBoCoiThiLan2 in dtCanBoCoiThiLan2.Rows)
{
if (canBoCoiThiLan2 == "")
{
canBoCoiThiLan2 += drCanBoCoiThiLan2["TenGiangVien"].ToString();
}
else
{
canBoCoiThiLan2 = canBoCoiThiLan2 + Environment.NewLine + drCanBoCoiThiLan2["TenGiangVien"].ToString();
}
}
dr["CanBoCoiThiLan2"] = canBoCoiThiLan2;
}
}
dtgvChiTietMon.DataSource = dtChiTietMon;
//DataGridViewComboBoxColumn namHocCol = new DataGridViewComboBoxColumn();
//namHocCol.Name = "CmbNamHoc";
//namHocCol.HeaderText = "Năm Học";
//namHocCol.ValueType = typeof(int);
//dtgvChiTietMon.Columns.Insert(dtgvChiTietMon.Columns["TenMon"].Index + 1, namHocCol);
//IList listNamHoc = NamHocBUS.GetList();
//foreach (DataGridViewRow row in this.dtgvChiTietMon.Rows)
//{
// ((DataGridViewComboBoxCell)row.Cells["CmbNamHoc"]).DataSource = listNamHoc;
// row.Cells["CmbNamHoc"].Value = row.Cells["TenNamHoc"].Value;
//}
dtgvChiTietMon.Columns["TenMon"].HeaderText = "Môn";
dtgvChiTietMon.Columns["TenNamHoc"].HeaderText = "Năm Học";
dtgvChiTietMon.Columns["ThoiGianHoc"].HeaderText = "Thời Gian Học";
dtgvChiTietMon.Columns["GioHoc"].HeaderText = "Giờ Học";
dtgvChiTietMon.Columns["GiangDuong"].HeaderText = "Giảng Đường";
dtgvChiTietMon.Columns["GiangVien"].HeaderText = "Giảng Viên";
dtgvChiTietMon.Columns["NgayThiLan1"].HeaderText = "Ngày Thi Lần 1";
dtgvChiTietMon.Columns["GioThiLan1"].HeaderText = "Giờ Thi Lần 1";
dtgvChiTietMon.Columns["GiangDuongThiLan1"].HeaderText = "Giảng Đường Thi Lần 1";
dtgvChiTietMon.Columns["CanBoCoiThiLan1"].HeaderText = "Cán Bộ Coi Thi Lần 1";
dtgvChiTietMon.Columns["SoBaiThiLan1"].HeaderText = "Số Bài Thi Lần 1";
dtgvChiTietMon.Columns["NgayThiLan2"].HeaderText = "Ngày Thi Lần 2";
dtgvChiTietMon.Columns["GioThiLan2"].HeaderText = "Giờ Thi Lần 2";
dtgvChiTietMon.Columns["GiangDuongThiLan2"].HeaderText = "Giảng Đường Thi Lần 2";
dtgvChiTietMon.Columns["CanBoCoiThiLan2"].HeaderText = "Cán Bộ Coi Thi Lần 2";
dtgvChiTietMon.Columns["SoBaiThiLan2"].HeaderText = "Số Bài Thi Lần 2";
dtgvChiTietMon.Columns["GhiChu"].HeaderText = "Ghi Chú";
dtgvChiTietMon.Columns["TenMon"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["ThoiGianHoc"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GioHoc"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GiangDuong"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GiangVien"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["NgayThiLan1"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GioThiLan1"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GiangDuongThiLan1"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["CanBoCoiThiLan1"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["SoBaiThiLan1"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["NgayThiLan2"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GioThiLan2"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GiangDuongThiLan2"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["CanBoCoiThiLan2"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["SoBaiThiLan2"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["GhiChu"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dtgvChiTietMon.Columns["MaChiTietMon"].Visible = false;
dtgvChiTietMon.Columns["MaMon"].Visible = false;
dtgvChiTietMon.Columns["MaNamHoc"].Visible = false;
dtgvChiTietMon.Columns["TenMon"].ReadOnly = true;
dtgvChiTietMon.Columns["TenNamHoc"].ReadOnly = true;
dtgvChiTietMon.Columns["GiangVien"].ReadOnly = true;
dtgvChiTietMon.Columns["CanBoCoiThiLan1"].ReadOnly = true;
dtgvChiTietMon.Columns["CanBoCoiThiLan2"].ReadOnly = true;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// Report Quan Ly GiangVien / Diem Thi & HocPhan / CTXH / HDRL
public frmReport(string ma, int ktra)
{
InitializeComponent();
// QL CTXH
if (ktra == 10)
{
DSSV_CTXHBUS dsCTXHBUS = new DSSV_CTXHBUS();
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "dsQLCTXH";
reportDataSource.Value = dsCTXHBUS.getSVByMaCTXH(ma);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpQLCTXH.rdlc";
}
else
{
// QL HDRL
if (ktra == 11)
{
DSSV_RLBUS dsHDRL = new DSSV_RLBUS();
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "dsQLHDRL";
reportDataSource.Value = dsHDRL.getSVByMaRL(ma);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpQLHDRL.rdlc";
}
else
{
// QL Giang Vien
if (ktra == 12)
{
GiangVienBUS gvBUS = new GiangVienBUS();
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "dsQLGiangVien";
reportDataSource.Value = gvBUS.getGVTheoMaKhoa(ma);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpQLGiangVien.rdlc";
}
else
{
// QL Diem Thi
if (ktra == 13)
{
SinhVienBUS svBUS = new SinhVienBUS();
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "dsDiemThi";
reportDataSource.Value = svBUS.getSVTheoMaHP(ma);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpQLDiemThi.rdlc";
}
// QL Hoc Phan
else
{
SinhVienBUS svBUS = new SinhVienBUS();
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "dsQLHocPhan";
reportDataSource.Value = svBUS.getSVTheoMaHP(ma);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpQLHocPhan.rdlc";
}
}
}
}
ReportParameter rp = new ReportParameter("Ma", ma);
reportViewer1.LocalReport.SetParameters(rp);
}
protected void LoadData()
{
GiangVienBUS _objgvbus = new GiangVienBUS();
DataTable _dtgv = _objgvbus.GetMaTen();
cbGiangVien.DataSource = _dtgv;
cbGiangVien.ValueMember = "MaGV";
cbGiangVien.DisplayMember = "TenGV";
cbGiangVien.SelectedIndex = -1;
KhoaHocBUS _objkhoahocbus = new KhoaHocBUS();
DataTable _dtkh = _objkhoahocbus.GetMaTenKhoaHoc();
cbKhoaHoc.DataSource = _dtkh;
cbKhoaHoc.ValueMember = "MaKhoaHoc";
cbKhoaHoc.DisplayMember = "TenKhoaHoc";
PhongHocBUS _objphonghocbus = new PhongHocBUS();
DataTable _dtph = _objphonghocbus.GetMaTen();
cbPhongHoc.DataSource = _dtph;
cbPhongHoc.ValueMember = "MaPhong";
cbPhongHoc.DisplayMember = "TenPhong";
cbPhongHoc.SelectedIndex = -1;
CaHocBUS _objcahocbus = new CaHocBUS();
DataTable _dtch = _objcahocbus.GetMaTen();
cbCaHoc.DataSource = _dtch;
cbCaHoc.ValueMember = "MaCa";
cbCaHoc.DisplayMember = "TenCa";
cbCaHoc.Text = "";
NgayHocBUS _objngayhocbus = new NgayHocBUS();
DataTable _dtngay = _objngayhocbus.GetAllNgayHoc();
cbNgayHoc.DataSource = _dtngay;
cbNgayHoc.ValueMember = "MaNgay";
cbNgayHoc.DisplayMember = "DanhSachNgay";
cbNgayHoc.SelectedIndex = -1;
cbChuongTrinhHoc.SelectedIndex = -1;
txtGioBatDau.Text = "";
txtGioKetThuc.Text = "";
_dtlophoc = _objlopbus.GetAll_CT();
dataGridViewX2.DataSource = _dtlophoc;
dataGridViewX2.RowHeadersVisible = true;
_dtlophoc.Columns.Add("STT");
for (int i = 0; i < _dtlophoc.Rows.Count; i++)
{
_dtlophoc.Rows[i]["STT"] = i + 1;
}
dataGridViewX2.Columns["STT"].DisplayIndex = 0;
dataGridViewX2.Columns["MaLop"].HeaderText = "Mã Lớp";
dataGridViewX2.Columns["TenLop"].HeaderText = "Tên Lớp";
dataGridViewX2.Columns["TenKhoaHoc"].HeaderText = "Tên Khóa Học";
dataGridViewX2.Columns["TenChuongTrinhHoc"].HeaderText = "Chương Trình Học";
dataGridViewX2.Columns["NgayBatDau"].HeaderText = "Ngày Bắt Đầu";
dataGridViewX2.Columns["NgayKetThuc"].HeaderText = "Ngày Kết Thúc";
dataGridViewX2.Columns["GioBatDau"].HeaderText = "Giờ Bắt Đầu";
dataGridViewX2.Columns["GioKetThuc"].HeaderText = "Giờ Kết Thúc";
dataGridViewX2.Columns["DanhSachNgay"].HeaderText = "Ngày Học";
dataGridViewX2.Columns["TenGV"].HeaderText = "Tên Giảng Viên";
dataGridViewX2.Columns["TenPhong"].HeaderText = "Phòng Học";
dataGridViewX2.ClearSelection();
}
private void btSearchGV_Click(object sender, EventArgs e)
{
if (rdNoneBindGV.Checked)
{
try
{
string sql = @"select * from GiangVien where ";
if (txtMaGV_GV.Text != "")
{
sql += String.Format(@"MaGV = {0} ", txtMaGV_GV.Text);
}
else
{
sql += @"null is null ";
}
if (txtHo_GV.Text != "")
{
sql += String.Format(@"and Ho = N'{0}' ", txtHo_GV.Text);
}
else
{
sql += @"and null is null ";
}
if (txtTen_GV.Text != "")
{
sql += String.Format(@"and Ten = N'{0}' ", txtTen_GV.Text);
}
else
{
sql += @"and null is null ";
}
if (txtDiaChiGV.Text != "")
{
sql += String.Format(@"and DiaChi = N'{0}' ", txtDiaChiGV.Text);
}
else
{
sql += @"and null is null ";
}
if (cbGioiTinhGV.SelectedIndex != -1)
{
sql += String.Format(@"and GioiTinh = N'{0}' ", cbGioiTinhGV.Text);
}
else
{
sql += @"and null is null ";
}
if (cbMaNganh_GV.SelectedIndex != -1)
{
sql += String.Format(@"and MaNganh = N'{0}' ", cbMaNganh_GV.SelectedValue.ToString());
}
else
{
sql += @"and null is null ";
}
dtTeacher = null;
dtTeacher = new GiangVienBUS().searchGV(sql);
dgvGiangVien.DataSource = dtTeacher;
//bindTeacher();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Bạn chỉ có thể sử dụng chức năng này khi tắt chức năng binding!");
}
}
