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