public async Task <HttpResponseMessage> GetByEmployeeAndPeriod([FromUri] GetByEmployeeAndPeriodReq req) { var obj = await SubPrincipalCriteriaBE.GetByEmployeeAndPeriod(req); if (obj != null) { return(this.OkResult(obj)); } return(this.ErrorResult(new Error(EnumError.SubPrincipalCriteriaNotExits))); }
public async Task <List <SubPrincipalEmployeeAndPeriodRes> > GetByEmployeeAndPeriod(GetByEmployeeAndPeriodReq req) { var obj = from s in _uoW.Context.SubPrincipalCriterias join dt in _uoW.Context.EvalCriterias on s.EvalCriteriaId equals dt.EvalCriteriaId join mt in _uoW.Context.EvalStandards on dt.EvalStandardId equals mt.EvalStandardId where s.EvalPeriodId == req.EvalPeriodId && s.SubPrincipalId == req.SubPrincipalId select new SubPrincipalEmployeeAndPeriodRes { EvalCriteriaId = s.EvalCriteriaId, EvalPeriodId = s.EvalPeriodId, EvalCriteriaName = dt.EvalCriteriaName, EvalStandardName = mt.EvalStandardName, Idx = dt.Idx ?? 0, SubPrincipalId = s.SubPrincipalId }; // await GetAsync(c => c.EvalPeriodId == req.EvalPeriodId && c.SubPrincipalId == req.SubPrincipalId); if (obj != null && obj.Any()) { return(obj.ToList()); } return(null); }