public async Task <GlobalSettingModel> SaveHasSeenCartTooltipForTranscriptsInSavedSchoolsModeAsync(int portfolioId) { var result = await _sql.QueryAsync <GlobalSettingModel>("[Student].[GlobalSettingHasSeenCartTooltipForTranscriptsInSavedSchoolsModeSave]", new { portfolioId }, commandType : CommandType.StoredProcedure); return(result.FirstOrDefault()); }
public async Task <int> GeTimeZoneIdByPortfolioIdAsync(int portfolioId) { var result = await _sql.QueryAsync <int>( "dbo.TimeZoneIdGetByPortfolioId", new { portfolioId }, commandType : CommandType.StoredProcedure); return(result.FirstOrDefault()); }
public async Task <IEnumerable <TranscriptInstitutionModel> > SavedSchoolsByPortfolioIdAsync(int portfolioId, int translationLanguageId) { var savedSchools = await _sql.QueryAsync <TranscriptInstitutionModel>( sql : "[ApplicationPlanner].[SavedSchoolsGetByPortfolioId]", param : new { portfolioId, translationLanguageId }, commandType : CommandType.StoredProcedure); return(savedSchools); }
public async Task <StudentGeneralInfoModel> StudentGeneralInfoGetByPortfolioIdAsync(int portfolioId) { var data = await _sql.QueryAsync <StudentGeneralInfoModel>("[ApplicationPlanner].[StudentGeneralInfoGetByPortfolioId]", new { portfolioId }, commandType : CommandType.StoredProcedure); return(data.FirstOrDefault()); }
public async Task <IEnumerable <TranscriptImportedViewModel> > GetTranscriptImportedBySchoolIdAsync(int schoolId) { return(await _sql.QueryAsync <TranscriptImportedViewModel>( sql : "[ApplicationPlanner].[TranscriptImportedGetBySchoolId]", param : new { schoolId }, commandType : CommandType.StoredProcedure)); }
public async Task <GlobalSettingModel> GetByPortfolioIdAsync(int portfolioId) { var result = await _sql.QueryAsync <GlobalSettingModel>("[Student].[GlobalSettingGet]", new { portfolioId }, commandType : CommandType.StoredProcedure); return(result.FirstOrDefault()); }
public async Task <int> CreateTranscriptRequestAsync( int portfolioId, string inunId, int transcriptRequestTypeId, int?receivingInstitutionCode, string receivingInstitutionName, string receivingInstitutionCity, string receivingInstitutionStateCode, int createdById) { var result = await _sql.QueryAsync <int>( sql : "[ApplicationPlanner].[TranscriptRequestCreate]", param : new { portfolioId, inunId, transcriptRequestTypeId, receivingInstitutionCode, receivingInstitutionName, receivingInstitutionCity, receivingInstitutionStateCode, createdById }, commandType : CommandType.StoredProcedure); return(result.FirstOrDefault()); }