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));
}