//------------------------
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_quiz_DS_moodle()
{
string procname = @"SELECT * FROM `mdl_quiz`";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteDataTable(procname));
}
public string mdl_quiz_grades_ID_1()
{
string procname = @"ALTER TABLE `mdl_quiz_grades` AUTO_INCREMENT = 1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteData_string(procname));
}
public void mdl_quiz_grades_Xoa_ID_1()
{
string procname = @"DELETE FROM `mdl_quiz_grades` WHERE 1;ALTER TABLE `mdl_quiz_grades` AUTO_INCREMENT = 1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
}
public void mdl_quiz_grades_Them(string quiz_, string userid_, string grade_, string timemodified_)
{
string procname = @"INSERT INTO `mdl_quiz_grades`(`quiz`, `userid`, `grade`, `timemodified`) VALUES (" + quiz_ + "," + userid_ + "," + grade_ + "," + timemodified_ + ")";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(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_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_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));
}
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_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_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_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_groups_members_ds()
{
string procname = @"SELECT * FROM `mdl_groups_members`";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteDataTable(procname));
}
public string mdl_logstore_standard_log_DS_Top1()
{
string procname = @"SELECT userid from mdl_logstore_standard_log ORDER BY mdl_logstore_standard_log.timecreated DESC LIMIT 0,1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteData_string(procname));
}
public int 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 FROM mdl_question_usages INNER JOIN mdl_quiz_attempts ON mdl_question_usages.id = mdl_quiz_attempts.uniqueid WHERE mdl_quiz_attempts.state='finished'";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.Execute_int(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_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_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 string mdl_question_attempt_steps_max()
{
string procname = @"SELECT max(id) FROM `mdl_question_attempt_steps` WHERE 1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteData_string(procname));
}
public bool mdl_question_attempt_steps_MacDinh()
{
try
{
string procname = @"DELETE FROM `mdl_question_attempt_steps`;ALTER TABLE `mdl_question_attempt_steps` AUTO_INCREMENT = 1;";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction(procname);
return(true);
}
catch
{
return(false);
}
}
public bool mdl_course_modules_completion_MySql_Them(string coursemoduleid_, string userid_, string completionstate_, string viewed_, string overrideby_, string timemodified_)
{
try
{
string procname = @"INSERT INTO `mdl_course_modules_completion`( `coursemoduleid`, `userid`, `completionstate`, `viewed`, `timemodified`) VALUES (" + coursemoduleid_ + "," + userid_ + "," + completionstate_ + "," + viewed_ + "," + timemodified_ + ")";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
return(true);
}
catch
{
return(false);
}
}
public bool mmdl_question_attempts_Them(string questionusage_id, string slot_, string behaviour_, string questionid_, string variant_, string maxmark_, string minfraction_, string maxfraction_, string flagged_, string questionsummary_, string rightanswer_, string responsesummary_, string timemodified_)
{
try
{
string procname = @"INSERT INTO `mdl_question_attempts`(`questionusageid`, `slot`, `behaviour`, `questionid`, `variant`, `maxmark`, `minfraction`, `maxfraction`, `flagged`, `questionsummary`, `rightanswer`, `responsesummary`, `timemodified`) VALUES (" + questionusage_id + "," + slot_ + ",'" + behaviour_ + "'," + questionid_ + "," + variant_ + "," + maxmark_ + "," + minfraction_ + "," + maxfraction_ + "," + flagged_ + ",'" + questionsummary_ + "','" + rightanswer_ + "','" + responsesummary_ + "'," + timemodified_ + ")";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
db.CommitTransaction();
return(true);
}
catch
{
return(false);
}
}
public bool mdl_question_attempt_step_data_Them(string attemptstepid_, string name_, string value_)
{
try
{
string procname = @"INSERT INTO `mdl_question_attempt_step_data`(`attemptstepid`, `name`, `value`) VALUES (" + attemptstepid_ + ",'" + name_ + "','" + value_ + "')";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
db.CommitTransaction();
return(true);
}
catch
{
return(false);
}
}
public bool mdl_question_attempt_steps__fraction_Them(string questionattemptid_, string sequencenumber_, string state_, string fraction_, string timecreated_, string userid_)
{
try
{
string procname = @"INSERT INTO `mdl_question_attempt_steps`(`questionattemptid`, `sequencenumber`, `state`, `fraction`, `timecreated`, `userid`) VALUES (" + questionattemptid_ + "," + sequencenumber_ + ",'" + state_ + "'," + fraction_ + "," + timecreated_ + "," + userid_ + ")";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
db.CommitTransaction();
return(true);
}
catch
{
return(false);
}
}
public bool mdl_question_usages_Them(string context_id, string compone_nt, string preferredbehavio_ur)
{
try
{
string procname = @"INSERT INTO `mdl_question_usages`( `contextid`, `component`, `preferredbehaviour`) VALUES ('80','mod_quiz','deferredfeedback')";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
db.CommitTransaction();
return(true);
}
catch
{
return(false);
}
}
public bool mdl_quiz_attempts_Them(string quiz_, string userid_, string attempt_, string uniqueid_, string layout_, string currentpage_, string preview_, string state_, string timestart_, string timefinish_, string timemodified_, string timemodifiedoffline_, string timecheckstate_, string sumgrades_)
{
try
{
string procname = @"INSERT INTO `mdl_quiz_attempts`(`quiz`, `userid`, `attempt`, `uniqueid`, `layout`, `currentpage`, `preview`, `state`, `timestart`, `timefinish`, `timemodified`, `timemodifiedoffline`, `timecheckstate`, `sumgrades`) VALUES (" + quiz_ + "," + userid_ + "," + attempt_ + "," + uniqueid_ + ",'" + layout_ + "'," + currentpage_ + "," + preview_ + ",'" + state_ + "'," + timestart_ + "," + timefinish_ + "," + timemodified_ + "," + timemodifiedoffline_ + "," + timecheckstate_ + "," + sumgrades_ + ")";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
db.ExecuteNonQueryWithTransaction_Text(procname);
db.CommitTransaction();
return(true);
}
catch
{
return(false);
}
}