public DataTable mdl_quiz_DS_moodle()
        {
            string procname         = @"SELECT * FROM `mdl_quiz`";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
Пример #2
0
        public DataTable mdl_quiz_attempts_DS_uniqueid(string uniqueid_)
        {
            string procname         = @"select * from mdl_quiz_attempts where uniqueid=" + uniqueid_ + "";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
Пример #3
0
        //----------------------------
        public DataTable mdl_quiz_grades_DS(string userid)
        {
            string procname         = @"select * from mdl_quiz_grades where userid=" + userid + "";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
Пример #4
0
        public DataTable mdl_block_recentlyaccesseditems_CMID(string CMID)
        {
            string procname         = @"SELECT * FROM `mdl_block_recentlyaccesseditems` WHERE cmid=" + CMID + "";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        public DataTable mdl_groups_members_ds()
        {
            string procname         = @"SELECT * FROM `mdl_groups_members`";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
Пример #6
0
        public DataTable mdl_user_lastaccess_DS_Top1()
        {
            string procname         = @"SELECT * FROM `mdl_user_lastaccess` ORDER by timeaccess DESC LIMIT 1";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
Пример #7
0
        public DataTable mdl_course_modules_completion_userid()
        {
            string procname         = @"SELECT * FROM `mdl_course_modules_completion` WHERE completionstate=1 ORDER by timemodified ASC";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        public DataTable mdl_question_usages_DS_state_finished()
        {
            string procname         = @"SELECT mdl_question_usages.id, mdl_question_usages.contextid, mdl_question_usages.component, mdl_question_usages.preferredbehaviour, mdl_quiz_attempts.timefinish FROM mdl_question_usages INNER JOIN mdl_quiz_attempts ON mdl_question_usages.id = mdl_quiz_attempts.uniqueid WHERE (mdl_quiz_attempts.state = 'finished') ORDER BY mdl_quiz_attempts.timefinish ASC";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
Пример #9
0
        public DataTable mdl_grade_grades_ds_userid(int userid)
        {
            string procname         = @"select * from mdl_grade_grades WHERE userid=" + userid + " and finalgrade <>'' ";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        //------------------------
        public DataTable mdl_question_usages_DS()
        {
            string procname         = @"select * from mdl_question_usages";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        public DataTable mdl_question_usages_max()
        {
            string procname         = @"SELECT max(id) FROM `mdl_question_usages`";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        public DataTable mdl_question_attempts_DS()
        {
            string procname         = @"SELECT * FROM mdl_question_attempts";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        public DataTable mdl_question_attempt_step_data_DS(string attemptstep_id)
        {
            string procname         = @"SELECT * FROM `mdl_question_attempt_step_data` WHERE attemptstepid=" + attemptstep_id + "";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }
        public DataTable mdl_question_attempt_steps_DS(string questionattempt_id, string sequencenumber_)
        {
            string procname         = @"SELECT * FROM `mdl_question_attempt_steps` WHERE questionattemptid=" + questionattempt_id + " AND sequencenumber=" + sequencenumber_ + "";
            DbAccessMySqlOffline db = new DbAccessMySqlOffline();

            db.CreateNewSqlCommand_Text();
            return(db.ExecuteDataTable(procname));
        }