} //End public SkhDS
public List <SkhlistitemVM> getDatalist(SkhVM poViewModel = null)
{
List <SkhlistitemVM> vReturn;
using (var db = new DBMAINContext())
{
var oQRY = from tb in db.Skh_infos
select new SkhlistitemVM
{
YEAR_ID = tb.YEAR_ID,
SEMESTER_ID = tb.SEMESTER_ID,
CLASSTYPE_ID = tb.CLASSTYPE_ID,
THEME_ID = tb.THEME_ID,
WEEKNUM = tb.WEEKNUM,
DATEFROM = tb.DATEFROM,
ID = tb.ID,
ACTIVITY = tb.ACTIVITY,
INDICATOR = tb.INDICATOR,
MEDIA = tb.MEDIA
};
if (poViewModel != null)
{
if (poViewModel.FILTER_YEAR_ID != null)
{
oQRY = oQRY.Where(fld => fld.YEAR_ID == poViewModel.FILTER_YEAR_ID);
} //End if (poViewModel.YEAR_ID != null)
if (poViewModel.FILTER_SEMESTER_ID != null)
{
oQRY = oQRY.Where(fld => fld.SEMESTER_ID == poViewModel.FILTER_SEMESTER_ID);
} //End if (poViewModel.SEMESTER_ID != null)
if (poViewModel.FILTER_CLASSTYPE_ID != null)
{
oQRY = oQRY.Where(fld => fld.CLASSTYPE_ID == poViewModel.FILTER_CLASSTYPE_ID);
} //End if (poViewModel.CLASSTYPE_ID != null)
if (poViewModel.FILTER_WEEKNUM != null)
{
oQRY = oQRY.Where(fld => fld.WEEKNUM == poViewModel.FILTER_WEEKNUM);
} //End if (poViewModel.CLASSTYPE_ID != null)
if (poViewModel.FILTER_DATEFROM != null)
{
oQRY = oQRY.Where(fld => fld.DATEFROM == poViewModel.FILTER_DATEFROM);
} //End if (poViewModel.CLASSTYPE_ID != null)
if (poViewModel.FILTER_THEME_ID != null)
{
oQRY = oQRY.Where(fld => fld.THEME_ID == poViewModel.FILTER_THEME_ID);
} //End if (poViewModel.CLASSTYPE_ID != null)
} //End if (poViewModel != null)
vReturn = oQRY.ToList();
} //End using (var = new DbContext())
return(vReturn);
} //End public List<SkhlistVM> getDatalist()
} //End public Skh_Validation()
//Constructor 2
public Skh_Validation(SkhVM poViewModel)
{
oViewModelfilter = poViewModel;
} //End public Skh_Validation()