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());
}
