public Task <SchoolSettingModel> GetBySchoolIdAsync(int schoolId)
{
var cachekey = _cache.CreateKey("TranscriptsSchoolSettingGetBySchoolId", schoolId);
return(_sql.CacheQueryAsyncSingle <SchoolSettingModel>(
cachekey,
"[ApplicationPlanner].[SchoolSettingGetBySchoolId]",
new { schoolId },
commandType: CommandType.StoredProcedure));
}
public Task <TimeZoneDetailModel> GeTimeZoneDetailByIdAsync(int timeZoneId)
{
var cachekey = _cache.CreateKey("TranscriptsGeTimeZoneDetailById", timeZoneId);
return(_sql.CacheQueryAsyncSingle <TimeZoneDetailModel>(
cachekey,
"dbo.TimeZoneDetailById",
new
{
TimeZoneId = timeZoneId
},
commandType: CommandType.StoredProcedure));
}
