public static List <BANGDIEM> SelectFilter(BangDiemFilter _filter)
{
try
{
var query = (from p in Database.BANGDIEMs
where p.IsRemove != 1
select p).ToList();
if (_filter.HocVienId != null && _filter.HocVienId != 0)
{
query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList();
}
if (_filter.KhoaHocId != null && _filter.KhoaHocId != 0)
{
query = query.Where(o => o.KhoaHocId == _filter.KhoaHocId).ToList();
}
if (_filter.LopHocId != null && _filter.LopHocId != 0)
{
query = query.Where(o => o.LopHocId == _filter.LopHocId).ToList();
}
if (_filter.PhieuGhiDanhId != null && _filter.PhieuGhiDanhId != 0)
{
query = query.Where(o => o.PhieuGhiDanhId == _filter.PhieuGhiDanhId).ToList();
}
return(query);
}
catch (Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void ValidateSuaKhoaHoc(int _KhoaHocId)
{
//kiem tra neu khóa học đã có trong BANGDIEM thì không cho sửa
BangDiemFilter _filter = new BangDiemFilter();
_filter.KhoaHocId = _KhoaHocId;
List <BANGDIEM> _lstBangDiem = BangDiemLogic.SelectFilter(_filter);
if (_lstBangDiem != null && _lstBangDiem.Count > 0)
{
throw new ArgumentException("Khóa học đã được sử dụng nên không thể sửa");
}
}
