public List <CSPPERIODLINE> AxPeriodLines(string periodId, DateTime date)
{
using (var db = new configurationEntities())
{
var q = db.CSPPERIODLINES.Where(x => x.CSPPERIODID == periodId && x.FROMDATE <= date && x.TODATE >= date).ToList();
return(q);
}
}
public List <CSPPERIOD> AxPeriods()
{
using (var db = new configurationEntities())
{
var q = db.CSPPERIODS.ToList();
return(q);
}
}