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