public DataTable mdl_quiz_DS_moodle() { string procname = @"SELECT * FROM `mdl_quiz`"; DbAccessMySqlOffline db = new DbAccessMySqlOffline(); db.CreateNewSqlCommand_Text(); return(db.ExecuteDataTable(procname)); }
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)); }
//---------------------------- 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)); }
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)); }
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)); }
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)); }
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)); }