public IEnumerable <Subject> GetSubjectsForGrade(int gradeID)
{
return(_dbContext.Subject.FromSqlRaw(_sqlBusiness.JoinSqlParameterToStoreProc(_GetSubjectsForGradeStoredProc,
_GetSubjectsForGradeStoredProcParameterName), _sqlBusiness.SetSqlParameter(_GetSubjectsForGradeStoredProcParameterName, gradeID))
.ToList());
}
public IEnumerable <Post> GetContentForSubTopic(int id)
{
return(_dbContext.Post.FromSqlRaw(_sqlBusiness.JoinSqlParameterToStoreProc(
_getContentForSubtopic, _GetContentForSubtopicParamName)
, _sqlBusiness.SetSqlParameter(_GetContentForSubtopicParamName, id)).ToList());
}
public IEnumerable <Topic> GetTopicsForSubject(int id)
{
return(_dbContext.Topic.FromSqlRaw(_sqlBusiness.JoinSqlParameterToStoreProc(_GetSubjectTopicForChoosenGrade, _GetSubjectTopicForChoosenGradeProcParameterName)
, _sqlBusiness.SetSqlParameter(_GetSubjectTopicForChoosenGradeProcParameterName, id))
.ToArray());
}
public IEnumerable <SubTopic> GetSubTopicForTopic(int id)
{
return(_dbContext.SubTopic.FromSqlRaw(_sqlBusiness.JoinSqlParameterToStoreProc(_GetSubtopicsForTopic, _GetSubtopicsForTopicProcParameterName)
, _sqlBusiness.SetSqlParameter(_GetSubtopicsForTopicProcParameterName, id)).ToList());
}