public async Task <IActionResult> GetCompanySurvey(SurveyPropDto surveyprop) { if (surveyprop.CompanyId == 0) { return(NotFound()); } var company = await uw.CompanyDetailedRepo.GetCompanySurvey(surveyprop); return(Ok(company)); }
public async Task <Survey> GetSurveyQuestions(SurveyPropDto surveyprop) { var survey = await db.Surveys .Include(t => t.SurveyTypes) .Include(c => c.Company) .Include(q => q.SurveyQuestions) .ThenInclude(o => o.SurveyOptions) .Where(s => s.CompanyId == surveyprop.CompanyId && s.SurveyId == surveyprop.SurveyId) .FirstOrDefaultAsync(); return(survey); }
public async Task <Company> GetCompanySurvey(SurveyPropDto surveyprop) { var company = await db.Companies .Include(surv => surv.Surveys) .Where(c => c.Surveys.Any(sr => sr.CompanyId == surveyprop.CompanyId)) .FirstOrDefaultAsync(); //var optionTypes = await db.SurveyOptionTypes.ToListAsync(); var surveys = await db.Surveys .Where(a => a.Active == true && a.CompanyId == surveyprop.CompanyId && a.SurveyId == surveyprop.SurveyId) .Include(s => s.SurveyTypes) .Include(q => q.SurveyQuestions) .ThenInclude(o => o.SurveyOptions) .ToListAsync(); company.Surveys = surveys; return(company); }