private void btnTimKiem_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
try
{
DataGridView_ResetLaiCot();
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
int _GiangVienId = O2S_Common.TypeConvert.Parse.ToInt32(cboGiangVien.SelectedValue.ToString());
if (_KhoaHocId != 0 && _GiangVienId != 0)
{
LopHocFilter _filter = new LopHocFilter();
_filter.KhoaHocId = _KhoaHocId;
_filter.GiangVienId = _GiangVienId;
List <LopHoc_PlusDTO> _lstLopHoc = LopHocLogic.SelectGroupTheoLopHoc(_filter);
if (_lstLopHoc != null && _lstLopHoc.Count > 0)
{
TaoCot_DataGridView(_lstLopHoc);
LayDuLieuLenGridView(_lstLopHoc, _GiangVienId, _KhoaHocId);
}
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.VUI_LONG_NHAP_DAY_DU_THONG_TIN);
frmthongbao.Show();
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void btnInAn_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
string tungay = DateTime.ParseExact(date_TuNgay.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("HH:mm dd/MM/yyyy");
string denngay = DateTime.ParseExact(date_DenNgay.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("HH:mm dd/MM/yyyy");
string tungaydenngay = "( Từ " + tungay + " - " + denngay + " )";
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
reportExcelDTO reportitem = new reportExcelDTO();
reportitem.name = Base.bienTrongBaoCao.THOIGIANBAOCAO;
reportitem.value = tungaydenngay;
thongTinThem.Add(reportitem);
//khoa hoc, lop hoc
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(_KhoaHocId);
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
reportExcelDTO _item_makhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MAKHOAHOC,
value = _khoahoc.MaKhoaHoc,
};
thongTinThem.Add(_item_makhoahoc);
reportExcelDTO _item_tenkhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENKHOAHOC,
value = _khoahoc.TenKhoaHoc,
};
thongTinThem.Add(_item_tenkhoahoc);
//
reportExcelDTO _item_malophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MALOPHOC,
value = _lophoc.MaLopHoc,
};
thongTinThem.Add(_item_malophoc);
reportExcelDTO _item_tenlophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENLOPHOC,
value = _lophoc.TenLopHoc,
};
thongTinThem.Add(_item_tenlophoc);
string fileTemplatePath = "BC03_ThongKeTheoDoiDiem.xlsx";
DataTable _databaocao = O2S_Common.DataTables.Convert.ListToDataTable(this.lstBangDiem);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, _databaocao);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void btnLuuLop_Click(object sender, EventArgs e)
{
try
{
//insert + Xoa tai BANGDIEM
int _LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
foreach (var item in this.dsXepLopHocVien)
{
//kiem tra ton tai hay khong
List <BANGDIEM> _kiemtratontai = BangDiemLogic.SelectTheoPhieuGhiDanh(item.PhieuGhiDanhId ?? 0);
if (_kiemtratontai == null || _kiemtratontai.Count == 0)
{
BANGDIEM _bangdiem = new BANGDIEM();
_bangdiem.HocVienId = item.HocVienId ?? 0;
_bangdiem.LopHocId = _LopHocId;
_bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0;
_bangdiem.KhoaHocId = item.KhoaHocId ?? 0;
_bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thuc
BangDiemLogic.Insert(_bangdiem);
}
}
List <BANGDIEM> _lstBangDiem_LopHoc = BangDiemLogic.SelectTheoLopHoc(_LopHocId);
if (_lstBangDiem_LopHoc != null && _lstBangDiem_LopHoc.Count > 0)
{
List <BANGDIEM> _bangdiem_Xoa = (from p in _lstBangDiem_LopHoc
where !(from q in this.dsXepLopHocVien select q.PhieuGhiDanhId).Contains(p.PhieuGhiDanhId)
select p).ToList();
if (_bangdiem_Xoa != null && _bangdiem_Xoa.Count > 0)
{
BangDiemLogic.DeleteList(_bangdiem_Xoa);
}
}
//Update SiSo cua LOPHOC
LOPHOC _lophoc = LopHocLogic.SelectSingle(_LopHocId);
LopHocLogic.Update(new LOPHOC()
{
LopHocId = _lophoc.LopHocId,
TenLopHoc = _lophoc.TenLopHoc,
NgayBatDau = _lophoc.NgayBatDau,
NgayKetThuc = _lophoc.NgayKetThuc,
SiSoToiDa = _lophoc.SiSoToiDa,
SiSo = this.dsXepLopHocVien.Count,
KhoaHocId = _lophoc.KhoaHocId,
IsLock = _lophoc.IsLock
});
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG);
frmthongbao.Show();
}
catch (Exception ex)
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI);
frmthongbao.Show();
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void btnInAn_DSLop_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
if (cboLopHoc.SelectedValue != null)
{
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
//khoa hoc, lop hoc
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(_KhoaHocId);
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
reportExcelDTO _item_makhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MAKHOAHOC,
value = _khoahoc.MaKhoaHoc,
};
thongTinThem.Add(_item_makhoahoc);
reportExcelDTO _item_tenkhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENKHOAHOC,
value = _khoahoc.TenKhoaHoc,
};
thongTinThem.Add(_item_tenkhoahoc);
//
reportExcelDTO _item_malophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MALOPHOC,
value = _lophoc.MaLopHoc,
};
thongTinThem.Add(_item_malophoc);
reportExcelDTO _item_tenlophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENLOPHOC,
value = _lophoc.TenLopHoc,
};
thongTinThem.Add(_item_tenlophoc);
List <XepLopDTO> _lstXepLop = BangDiemLogic.SelectDSHV_Lop(_lophocId);
string fileTemplatePath = "FUN_XepLop_DanhSachLopHoc.xlsx";
DataTable _databaocao = O2S_Common.DataTables.Convert.ListToDataTable(_lstXepLop);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, _databaocao);
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void gridKetQuaTimKiem_Click(object sender, EventArgs e)
{
try
{
LoadUI(LopHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(gridKetQuaTimKiem.SelectedRows[0].Cells["clmLopHocId"].Value.ToString())));
}
catch
{
LoadUI();
}
}
private void LoadLopTrongCuaKhoaHoc()
{
try
{
cboLopHoc.DataSource = LopHocLogic.DanhSachLopTrong(O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()));
cboLopHoc.DisplayMember = "TenLopHoc";
cboLopHoc.ValueMember = "LopHocId";
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnThemVaoLop_Click(object sender, EventArgs e)
{
try
{
if (gridViewHV_ChuaXepLop.RowCount > 0)
{
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
if (gridViewHV_XepLop.RowCount < _lophoc.SiSoToiDa ||
MessageBox.Show("Số học viên tối đa của lớp là " + _lophoc.SiSoToiDa + Environment.NewLine + "Bạn có chắc sẽ thêm?",
"Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
var rowHandle = gridViewHV_ChuaXepLop.FocusedRowHandle;
int _phieughidanhId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewHV_ChuaXepLop.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString());
PHIEUGHIDANH _phieuGD = PhieuGhiDanhLogic.SelectSingle(_phieughidanhId);
XepLopDTO _hocvienLop = new XepLopDTO();
_hocvienLop.HocVienId = _phieuGD.HocVienId;
_hocvienLop.MaHocVien = _phieuGD.HOCVIEN.MaHocVien;
_hocvienLop.TenHocVien = _phieuGD.HOCVIEN.TenHocVien;
_hocvienLop.PhieuGhiDanhId = _phieuGD.PhieuGhiDanhId;
_hocvienLop.MaPhieuGhiDanh = _phieuGD.MaPhieuGhiDanh;
_hocvienLop.NgayGhiDanh = _phieuGD.NgayGhiDanh;
_hocvienLop.NgaySinh = _phieuGD.HOCVIEN.NgaySinh;
_hocvienLop.GioiTinh = _phieuGD.HOCVIEN.GioiTinh;
_hocvienLop.DiaChi = _phieuGD.HOCVIEN.DiaChi;
_hocvienLop.Sdt = _phieuGD.HOCVIEN.Sdt;
_hocvienLop.Email = _phieuGD.HOCVIEN.Email;
_hocvienLop.KhoaHocId = _phieuGD.KhoaHocId;
_hocvienLop.MaKhoaHoc = _phieuGD.KHOAHOC.MaKhoaHoc;
_hocvienLop.TenKhoaHoc = _phieuGD.KHOAHOC.TenKhoaHoc;
this.dsXepLopHocVien.Add(_hocvienLop);
XepLopDTO _xoa = this.dsChuaCoLop.Where(o => o.PhieuGhiDanhId == _hocvienLop.PhieuGhiDanhId && o.KhoaHocId == _hocvienLop.KhoaHocId).FirstOrDefault();
this.dsChuaCoLop.Remove(_xoa);
gridControlHV_ChuaXepLop.DataSource = null;
gridControlHV_ChuaXepLop.DataSource = this.dsChuaCoLop;
gridControlHV_XepLop.DataSource = null;
gridControlHV_XepLop.DataSource = this.dsXepLopHocVien;
}
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void LoadLopHocTheoKhoaHoc()
{
try
{
LopHocFilter _filter = new LopHocFilter();
_filter.KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
cboLopHoc.DataSource = LopHocLogic.Select(_filter);
cboLopHoc.DisplayMember = "TenLopHoc";
cboLopHoc.ValueMember = "LopHocId";
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Bạn có muốn xóa?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var rowHandle = gridViewLopHoc.FocusedRowHandle;
int _lopHocId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewLopHoc.GetRowCellValue(rowHandle, "LopHocId").ToString());
if (LopHocLogic.Delete(_lopHocId))
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.XOA_THANH_CONG);
frmthongbao.Show();
LoadGridLopHoc();
}
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void LoadLopCuaKhoaHoc()
{
try
{
int _khoahocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
if (_khoahocId != 0)
{
LopHocFilter _filter = new LopHocFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.KhoaHocId = _khoahocId;
List <LopHoc_PlusDTO> _lstLopHoc = LopHocLogic.Select(_filter);
cboLopHoc.DataSource = _lstLopHoc;
cboLopHoc.DisplayMember = "TenLopHoc";
cboLopHoc.ValueMember = "LopHocId";
cboLopHoc.SelectedIndex = 0;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void LoadGridLopHoc()
{
try
{
LopHocFilter _filter = new LopHocFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
List <LopHoc_PlusDTO> _lstLopHoc = LopHocLogic.SelectOption1(_filter);
if (_lstLopHoc != null && _lstLopHoc.Count > 0)
{
gridControlLopHoc.DataSource = _lstLopHoc;
}
else
{
gridControlLopHoc.DataSource = null;
}
lblTongCong.Text = string.Format("Tổng cộng: {0} ca/tiết học", gridViewLopHoc.RowCount);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void gridViewLopHoc_Click(object sender, EventArgs e)
{
try
{
if (gridViewLopHoc.RowCount > 0)
{
var rowHandle = gridViewLopHoc.FocusedRowHandle;
int _LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewLopHoc.GetRowCellValue(rowHandle, "LopHocId").ToString());
this.LopHocSelect = LopHocLogic.SelectSingle(_LopHocId);
if (this.LopHocSelect != null)
{
LopHoc_ClickData(this.LopHocSelect);
LockAndUnLookPanelControl(false);
}
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnLuuThongTin_Click(object sender, EventArgs e)
{
try
{
if (isInsert)
{
int _khoaHocId = 0;
if (LopHocLogic.Insert(LoadLopHoc(), ref _khoaHocId))
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THEM_MOI_THANH_CONG);
frmthongbao.Show();
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THEM_MOI_THAT_BAI);
frmthongbao.Show();
}
}
else
{
if (LopHocLogic.Update(LoadLopHoc()))
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG);
frmthongbao.Show();
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI);
frmthongbao.Show();
}
}
LoadGridLopHoc();
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
