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();
}
public static List <LopHoc_PlusDTO> Select(LopHocFilter _filter)
{
try
{
//List<LopHoc_PlusDTO> _result = null;
var query = (from p in GlobalSettings.Database.LOPHOCs
select p).AsEnumerable().Select((obj, index) => new LopHoc_PlusDTO
{
Stt = index + 1,
LopHocId = obj.LopHocId,
MaLopHoc = obj.MaLopHoc,
TenLopHoc = obj.TenLopHoc,
NgayBatDau = obj.NgayBatDau,
NgayKetThuc = obj.NgayKetThuc,
SiSoToiDa = obj.SiSoToiDa,
SiSo = obj.SiSo,
KhoaHocId = obj.KhoaHocId,
TenKhoaHoc = obj.KHOAHOC.TenKhoaHoc,
CoSoId = obj.CoSoId,
TenCoSoTrungTam = obj.COSOTRUNGTAM.TenCoSo,
IsLock = obj.IsLock,
IsRemove = obj.IsRemove,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
});
if (_filter.LopHocId != null && _filter.LopHocId != 0)
{
query = query.Where(o => o.LopHocId == _filter.LopHocId).ToList();
}
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.KhoaHocId != null && _filter.KhoaHocId != 0)
{
query = query.Where(o => o.KhoaHocId == _filter.KhoaHocId).ToList();
}
if (_filter.IsLock != null)
{
query = query.Where(o => o.IsLock == _filter.IsLock).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(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);
}
}
public static List <LopHoc_PlusDTO> SelectGroupTheoLopHoc(LopHocFilter _filter)
{
try
{
var query = (from obj in GlobalSettings.Database.XEPLICHHOCs
where (obj.KhoaHocId == _filter.KhoaHocId && (obj.GiaoVien_ChinhId == _filter.GiangVienId || obj.GiaoVien_TroGiangId == _filter.GiangVienId) && obj.IsLock == true)
select new LopHoc_PlusDTO
{
LopHocId = obj.LopHocId ?? 0,
MaLopHoc = obj.LOPHOC.MaLopHoc,
TenLopHoc = obj.TenLopHoc,
}).ToList().GroupBy(o => o.LopHocId).Select(n => n.First()).ToList();
return(query);
}
catch (System.Exception ex)
{
return(null);
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);
}
}
