public DataTable mdl_course_modules_completion_DS()
{
string procname = "mdl_course_modules_completion_DS";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_quiz_DS()
{
string procname = "mdl_quiz_DS";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable course_course_GROUP_Khoi()
{
string procname = "course_course_GROUP_Khoi";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_groups_members_delete()
{
string procname = "mdl_groups_members_delete";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_quiz_attempts_DS_uniqueid(string uniqueid_)
{
string procname = "mdl_quiz_attempts_DS_uniqueid";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@uniqueid", uniqueid_);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_nopdiem_DS_id(string id_)
{
string procname = "mdl_nopdiem_DS_id";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@id" + "", id_);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_question_attempt_step_data_ds_id(string id_)
{
string procname = "mdl_question_attempt_step_data_ds_id";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@id", id_);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_question_attempts_DS_questionusage_id(string questionusage_id)
{
string procname = "mdl_question_attempts_DS_questionusageid";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@questionusageid", questionusage_id);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_course_ds_summaryformat(string summaryformat)
{
string procname = "mdl_course_ds_summaryformat";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@summaryformat" + "", summaryformat);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_question_usages_DS_ID()
{
string procname = "mdl_question_usages_DS_ID";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@id", usages_ID);
return(db.ExecuteDataTable(procname));
}
public DataTable GiaoVien_MonHoc_DS_IDGV(int ID)
{
string procname = "GiaoVien_MonHoc_DS_IDGV";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
return(db.ExecuteDataTable(procname));
}
public DataTable course_DS_MonHoc(string Khoi_)
{
string procname = "course_DS_MonHoc";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Khoi", Khoi_);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_block_recentlyaccesseditems_DS_CMID_Userid(string cmid_, string userid_)
{
string procname = "mdl_block_recentlyaccesseditems_DS_CMID_Userid";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@cmid", cmid_);
db.AddParameter("@userid", userid_);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_question_attempt_steps_DS_questionattemptid_sequencenumber(string questionattempt_id, string sequencenumber_)
{
string procname = "mdl_question_attempt_steps_DS_questionattemptid_sequencenumber";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@questionattemptid", questionattempt_id);
db.AddParameter("@sequencenumber", sequencenumber_);
return(db.ExecuteDataTable(procname));
}
public DataTable GiaoVien_DangNhap(string Email, string MatKhau)
{
string procname = "GiaoVien_DangNhap";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Email", Email);
db.AddParameter("@MatKhau", MatKhau);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_grade_grades_DS_Itemid_Userid(Int64 itemid_, Int64 userid_)
{
string procname = "mdl_grade_grades_DS_Itemid_Userid";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@itemid", itemid_);
db.AddParameter("@userid", userid_);
return(db.ExecuteDataTable(procname));
}
public DataTable mdl_quiz_grades_DS_quiz_userid(Int64 quiz, Int64 userid_)
{
string procname = "mdl_quiz_grades_DS_quiz_userid";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@quiz", quiz);
db.AddParameter("@userid", userid_);
return(db.ExecuteDataTable(procname));
}
