public Question GetOneQuestion(int questionID)
        {
            var query = "select qns.qns_id QuestionID, qns.qns_likes QuestionLikes, qns.qns_views QuestionViews, qns.qns_comments QuestionAnswers, qns.qns_text QuestionText, qns.qns_name QuestionName, qns.qns_creation_date QuestionCreationDate from questions qns where qns.qns_id = " + questionID;

            return(db.GetItem <Question>(query));
        }
Exemple #2
0
        public Course GetCourse(int courseID)
        {
            var query = "select cou.cou_id CourseID, cou.cou_name CourseName, cou.cou_difficulty CourseDifficulty, cou.cou_description CourseDescription, cou.cou_creation_date CourseCreationDate from courses cou where cou.cou_id = " + courseID;

            return(db.GetItem <Course>(query));
        }