public IQueryOver <ForecastMonth, ForecastMonth> Apply(IQueryOver <ForecastMonth, ForecastMonth> queryOver, ForecastMonth monthAlias, Trex.Server.Core.Model.Forecast.Forecast forecastAlias) { ForecastProjectHours projectRegAlias = null; var projectCrit = QueryOver .Of <ForecastProjectHours>() .Where(x => x.Project.ProjectID == _projectId) .And(x => x.Parent.Id == forecastAlias.Id) .Select(x => x.Id) .Take(1); return(queryOver .JoinAlias(() => forecastAlias.ProjectRegistrations, () => projectRegAlias) .Where(Subqueries.WhereExists(projectCrit))); }
public IQueryOver <ForecastMonth, ForecastMonth> Apply(IQueryOver <ForecastMonth, ForecastMonth> queryOver, ForecastMonth monthAlias, Trex.Server.Core.Model.Forecast.Forecast forecastAlias) { Company companyAlias = null; Project projectAlias = null; ForecastProjectHours projectRegAlias = null; var projectCrit = QueryOver .Of <Company>() .Where(x => x.CustomerID == _companyId) .And(x => x.CustomerID == companyAlias.CustomerID) .Select(x => x.CustomerID) .Take(1); return(queryOver .JoinAlias(() => forecastAlias.ProjectRegistrations, () => projectRegAlias) .JoinAlias(() => projectRegAlias.Project, () => projectAlias) .JoinAlias(() => projectAlias.Company, () => companyAlias) .Where(Subqueries.WhereExists(projectCrit))); }
public IQueryOver <ForecastMonth, ForecastMonth> Apply(IQueryOver <ForecastMonth, ForecastMonth> queryOver, ForecastMonth monthAlias, Trex.Server.Core.Model.Forecast.Forecast forecastAlias) { var forecastTypeCrit = QueryOver .Of <Trex.Server.Core.Model.Forecast.Forecast>() .Where(x => x.ForecastType.Id == _forecastTypeId) .And(x => x.ForecastMonth.Id == monthAlias.Id) .Select(x => x.Id) .Take(1); return(queryOver.Where(Subqueries.WhereExists(forecastTypeCrit))); }