Exemple #1
0
        public bool mdl_user_Them(DataTable dsuser)
        {
            DbAccess db = new DbAccess();

            db.BeginTransaction();
            try
            {
                for (int i = 0; i < dsuser.Rows.Count; i++)
                {
                    id           = Int64.Parse(dsuser.Rows[i]["id"].ToString());
                    auth         = (dsuser.Rows[i]["auth"].ToString());
                    confirmed    = bool.Parse(dsuser.Rows[i]["confirmed"].ToString());
                    policyagreed = bool.Parse(dsuser.Rows[i]["policyagreed"].ToString());
                    deleted      = bool.Parse(dsuser.Rows[i]["deleted"].ToString());
                    suspended    = bool.Parse(dsuser.Rows[i]["suspended"].ToString());
                    mnethostid   = Int64.Parse(dsuser.Rows[i]["mnethostid"].ToString());
                    username     = dsuser.Rows[i]["username"].ToString();
                    password     = dsuser.Rows[i]["password"].ToString();
                    idnumber     = dsuser.Rows[i]["idnumber"].ToString();
                    firstname    = dsuser.Rows[i]["firstname"].ToString();
                    lastname     = dsuser.Rows[i]["lastname"].ToString();
                    email        = dsuser.Rows[i]["email"].ToString();
                    emailstop    = bool.Parse(dsuser.Rows[i]["emailstop"].ToString());
                    icq          = dsuser.Rows[i]["icq"].ToString();
                    skype        = dsuser.Rows[i]["skype"].ToString();
                    yahoo        = dsuser.Rows[i]["yahoo"].ToString();
                    aim          = dsuser.Rows[i]["aim"].ToString();
                    msn          = dsuser.Rows[i]["msn"].ToString();
                    phone1       = dsuser.Rows[i]["phone1"].ToString();
                    phone2       = dsuser.Rows[i]["phone2"].ToString();
                    institution  = dsuser.Rows[i]["institution"].ToString();
                    department   = dsuser.Rows[i]["department"].ToString();
                    address      = dsuser.Rows[i]["address"].ToString();
                    city         = dsuser.Rows[i]["city"].ToString();
                    country      = dsuser.Rows[i]["country"].ToString();
                    lang         = dsuser.Rows[i]["lang"].ToString();
                    calendartype = dsuser.Rows[i]["calendartype"].ToString();
                    theme        = dsuser.Rows[i]["theme"].ToString();
                    timezone     = dsuser.Rows[i]["timezone"].ToString();
                    firstaccess  = Int64.Parse(dsuser.Rows[i]["firstaccess"].ToString());
                    lastaccess   = Int64.Parse(dsuser.Rows[i]["lastaccess"].ToString());
                    lastlogin    = Int64.Parse(dsuser.Rows[i]["lastlogin"].ToString());
                    currentlogin = Int64.Parse(dsuser.Rows[i]["currentlogin"].ToString());
                    lastip       = dsuser.Rows[i]["lastip"].ToString();
                    secret       = dsuser.Rows[i]["secret"].ToString();
                    picture      = dsuser.Rows[i]["picture"].ToString();
                    url          = dsuser.Rows[i]["url"].ToString();
                    description  = dsuser.Rows[i]["description"].ToString();
                    if (dsuser.Rows[i]["descriptionformat"].ToString() != "")
                    {
                        descriptionformat = int.Parse(dsuser.Rows[i]["descriptionformat"].ToString());
                    }
                    else
                    {
                        descriptionformat = 0;
                    }
                    if (dsuser.Rows[i]["mailformat"].ToString() != "")
                    {
                        mailformat = bool.Parse(dsuser.Rows[i]["mailformat"].ToString());
                    }
                    else
                    {
                        mailformat = false;
                    }
                    if (dsuser.Rows[i]["maildigest"].ToString() != "")
                    {
                        maildigest = bool.Parse(dsuser.Rows[i]["maildigest"].ToString());
                    }
                    else
                    {
                        maildigest = false;
                    }
                    if (dsuser.Rows[i]["maildisplay"].ToString() != "")
                    {
                        maildisplay = int.Parse(dsuser.Rows[i]["maildisplay"].ToString());
                    }
                    else
                    {
                        maildisplay = 0;
                    }
                    if (dsuser.Rows[i]["autosubscribe"].ToString() != "")
                    {
                        autosubscribe = bool.Parse(dsuser.Rows[i]["autosubscribe"].ToString());
                    }
                    else
                    {
                        autosubscribe = false;
                    }
                    if (dsuser.Rows[i]["trackforums"].ToString() != "")
                    {
                        trackforums = bool.Parse(dsuser.Rows[i]["trackforums"].ToString());
                    }
                    else
                    {
                        trackforums = false;
                    }
                    timecreated       = dsuser.Rows[i]["timecreated"].ToString();
                    timemodified      = dsuser.Rows[i]["timemodified"].ToString();
                    trustbitmask      = dsuser.Rows[i]["trustbitmask"].ToString();
                    imagealt          = dsuser.Rows[i]["imagealt"].ToString();
                    lastnamephonetic  = dsuser.Rows[i]["lastnamephonetic"].ToString();
                    firstnamephonetic = dsuser.Rows[i]["firstnamephonetic"].ToString();
                    middlename        = dsuser.Rows[i]["middlename"].ToString();
                    alternatename     = dsuser.Rows[i]["alternatename"].ToString();

                    db.CreateNewSqlCommand();
                    db.AddParameter("@id", id);
                    db.AddParameter("@auth", auth);
                    db.AddParameter("@confirmed", confirmed);
                    db.AddParameter("@policyagreed", policyagreed);
                    db.AddParameter("@deleted", deleted);
                    db.AddParameter("@suspended", suspended);
                    db.AddParameter("@mnethostid", mnethostid);
                    db.AddParameter("@username", username);
                    db.AddParameter("@password", password);
                    db.AddParameter("@idnumber", idnumber);
                    db.AddParameter("@firstname", firstname);
                    db.AddParameter("@lastname", lastname);
                    db.AddParameter("@email", email);
                    db.AddParameter("@emailstop", emailstop);
                    db.AddParameter("@icq", icq);
                    db.AddParameter("@skype", skype);
                    db.AddParameter("@yahoo", yahoo);
                    db.AddParameter("@aim", aim);
                    db.AddParameter("@msn", msn);
                    db.AddParameter("@phone1", phone1);
                    db.AddParameter("@phone2", phone2);
                    db.AddParameter("@institution", institution);
                    db.AddParameter("@department", department);
                    db.AddParameter("@address", address);
                    db.AddParameter("@city", city);
                    db.AddParameter("@country", country);
                    db.AddParameter("@lang", lang);
                    db.AddParameter("@calendartype", calendartype);
                    db.AddParameter("@theme", theme);
                    db.AddParameter("@timezone", timezone);
                    db.AddParameter("@firstaccess", firstaccess);
                    db.AddParameter("@lastaccess", lastaccess);
                    db.AddParameter("@lastlogin", lastlogin);
                    db.AddParameter("@currentlogin", currentlogin);
                    db.AddParameter("@lastip", lastip);
                    db.AddParameter("@secret", secret);
                    db.AddParameter("@picture", picture);
                    db.AddParameter("@url", url);
                    db.AddParameter("@description", description);
                    db.AddParameter("@descriptionformat", descriptionformat);
                    db.AddParameter("@mailformat", mailformat);
                    db.AddParameter("@maildigest", maildigest);
                    db.AddParameter("@maildisplay", maildisplay);
                    db.AddParameter("@autosubscribe", autosubscribe);
                    db.AddParameter("@trackforums", trackforums);
                    db.AddParameter("@timecreated", timecreated);
                    db.AddParameter("@timemodified", timemodified);
                    db.AddParameter("@trustbitmask", trustbitmask);
                    db.AddParameter("@imagealt", imagealt);
                    db.AddParameter("@lastnamephonetic", lastnamephonetic);
                    db.AddParameter("@firstnamephonetic", firstnamephonetic);
                    db.AddParameter("@middlename", middlename);
                    db.AddParameter("@alternatename", alternatename);
                    db.ExecuteNonQueryWithTransaction("mdl_user_Them");
                }
                db.CommitTransaction();
                return(true);
            }
            catch
            {
                db.RollbackTransaction();
                return(false);
            }
        }
        public bool mdl_quiz_them(DataTable dsquiz)
        {
            DbAccess db = new DbAccess();

            db.BeginTransaction();
            try
            {
                for (int i = 0; i < dsquiz.Rows.Count; i++)
                {
                    db.CreateNewSqlCommand();
                    id                          = float.Parse(dsquiz.Rows[i]["id"].ToString());
                    course                      = float.Parse(dsquiz.Rows[i]["course"].ToString());
                    name                        = dsquiz.Rows[i]["name"].ToString();
                    intro                       = dsquiz.Rows[i]["intro"].ToString();
                    introformat                 = float.Parse(dsquiz.Rows[i]["introformat"].ToString());
                    timeopen                    = float.Parse(dsquiz.Rows[i]["timeopen"].ToString());
                    timeclose                   = float.Parse(dsquiz.Rows[i]["timeclose"].ToString());
                    timelimit                   = float.Parse(dsquiz.Rows[i]["timelimit"].ToString());
                    overduehandling             = dsquiz.Rows[i]["overduehandling"].ToString();
                    graceperiod                 = float.Parse(dsquiz.Rows[i]["graceperiod"].ToString());
                    preferredbehaviour          = dsquiz.Rows[i]["preferredbehaviour"].ToString();
                    canredoquestions            = float.Parse(dsquiz.Rows[i]["canredoquestions"].ToString());
                    attempts                    = int.Parse(dsquiz.Rows[i]["attempts"].ToString());
                    attemptonlast               = float.Parse(dsquiz.Rows[i]["attemptonlast"].ToString());
                    grademethod                 = float.Parse(dsquiz.Rows[i]["grademethod"].ToString());
                    decimalpoints               = float.Parse(dsquiz.Rows[i]["decimalpoints"].ToString());
                    questiondecimalpoints       = float.Parse(dsquiz.Rows[i]["questiondecimalpoints"].ToString());
                    reviewattempt               = int.Parse(dsquiz.Rows[i]["reviewattempt"].ToString());
                    reviewcorrectness           = int.Parse(dsquiz.Rows[i]["reviewcorrectness"].ToString());
                    reviewmarks                 = int.Parse(dsquiz.Rows[i]["reviewmarks"].ToString());
                    reviewspecificfeedback      = int.Parse(dsquiz.Rows[i]["reviewspecificfeedback"].ToString());
                    reviewgeneralfeedback       = int.Parse(dsquiz.Rows[i]["reviewgeneralfeedback"].ToString());
                    reviewrightanswer           = int.Parse(dsquiz.Rows[i]["reviewrightanswer"].ToString());
                    reviewoverallfeedback       = int.Parse(dsquiz.Rows[i]["reviewoverallfeedback"].ToString());
                    questionsperpage            = float.Parse(dsquiz.Rows[i]["questionsperpage"].ToString());
                    navmethod                   = dsquiz.Rows[i]["navmethod"].ToString();
                    shuffleanswers              = dsquiz.Rows[i]["shuffleanswers"].ToString();
                    sumgrades                   = float.Parse(dsquiz.Rows[i]["sumgrades"].ToString());
                    grade                       = float.Parse(dsquiz.Rows[i]["grade"].ToString());
                    timecreated                 = float.Parse(dsquiz.Rows[i]["timecreated"].ToString());
                    timemodified                = float.Parse(dsquiz.Rows[i]["timemodified"].ToString());
                    password                    = dsquiz.Rows[i]["password"].ToString();
                    subnet                      = dsquiz.Rows[i]["subnet"].ToString();
                    browsersecurity             = dsquiz.Rows[i]["browsersecurity"].ToString();
                    delay1                      = float.Parse(dsquiz.Rows[i]["delay1"].ToString());
                    delay2                      = float.Parse(dsquiz.Rows[i]["delay2"].ToString());
                    showuserpicture             = float.Parse(dsquiz.Rows[i]["showuserpicture"].ToString());
                    showblocks                  = float.Parse(dsquiz.Rows[i]["showblocks"].ToString());
                    completionattemptsexhausted = bool.Parse(dsquiz.Rows[i]["completionattemptsexhausted"].ToString());
                    completionpass              = bool.Parse(dsquiz.Rows[i]["completionpass"].ToString());
                    allowofflineattempts        = bool.Parse(dsquiz.Rows[i]["allowofflineattempts"].ToString());

                    db.AddParameter("@id", id);
                    db.AddParameter("@course", course);
                    db.AddParameter("@name", name);
                    db.AddParameter("@intro", intro);
                    db.AddParameter("@introformat", introformat);
                    db.AddParameter("@timeopen", timeopen);
                    db.AddParameter("@timeclose", timeclose);
                    db.AddParameter("@timelimit", timelimit);
                    db.AddParameter("@overduehandling", overduehandling);
                    db.AddParameter("@graceperiod", graceperiod);
                    db.AddParameter("@preferredbehaviour", preferredbehaviour);
                    db.AddParameter("@canredoquestions", canredoquestions);
                    db.AddParameter("@attempts", attempts);
                    db.AddParameter("@attemptonlast", attemptonlast);
                    db.AddParameter("@grademethod", grademethod);
                    db.AddParameter("@decimalpoints", decimalpoints);
                    db.AddParameter("@questiondecimalpoints", questiondecimalpoints);
                    db.AddParameter("@reviewattempt", reviewattempt);
                    db.AddParameter("@reviewcorrectness", reviewcorrectness);
                    db.AddParameter("@reviewmarks", reviewmarks);
                    db.AddParameter("@reviewspecificfeedback", reviewspecificfeedback);
                    db.AddParameter("@reviewgeneralfeedback", reviewgeneralfeedback);
                    db.AddParameter("@reviewrightanswer", reviewrightanswer);
                    db.AddParameter("@reviewoverallfeedback", reviewoverallfeedback);
                    db.AddParameter("@questionsperpage", questionsperpage);
                    db.AddParameter("@navmethod", navmethod);
                    db.AddParameter("@shuffleanswers", shuffleanswers);
                    db.AddParameter("@sumgrades", sumgrades);
                    db.AddParameter("@grade", grade);
                    db.AddParameter("@timecreated", timecreated);
                    db.AddParameter("@timemodified", timemodified);
                    db.AddParameter("@password", password);
                    db.AddParameter("@subnet", subnet);
                    db.AddParameter("@browsersecurity", browsersecurity);
                    db.AddParameter("@delay1", delay1);
                    db.AddParameter("@delay2", delay2);
                    db.AddParameter("@showuserpicture", showuserpicture);
                    db.AddParameter("@showblocks", showblocks);
                    db.AddParameter("@completionattemptsexhausted", completionattemptsexhausted);
                    db.AddParameter("@completionpass", completionpass);
                    db.AddParameter("@allowofflineattempts", allowofflineattempts);
                    db.ExecuteNonQueryWithTransaction("mdl_quiz_them");
                }
                db.CommitTransaction();
                return(true);
            }
            catch
            {
                db.RollbackTransaction();
                return(false);
            }
        }
        public bool mdl_question_usages_Them(DataTable ds_mdl_question_attempts, DataTable ds_mdl_quiz_attempts)
        {
            DbAccess db = new DbAccess();

            db.BeginTransaction();
            try
            {
                db.CreateNewSqlCommand();
                db.AddParameter("@contextid", contextid);
                db.AddParameter("@component", component);
                db.AddParameter("@preferredbehaviour", preferredbehaviour);
                int questionusage_id = db.ExecuteScalarWithTransaction("mdl_question_usages_Them");
                //------------------
                ds_questionattempt_id.Clear();
                ds_questionattempt_id.Columns.Clear();
                ds_questionattempt_id.Columns.Add("questionusage_id");
                //------------------
                db.CreateNewSqlCommand();
                db.AddParameter("@quiz", ds_mdl_quiz_attempts.Rows[0][1].ToString());
                db.AddParameter("@userid", ds_mdl_quiz_attempts.Rows[0][2].ToString());
                db.AddParameter("@attempt", ds_mdl_quiz_attempts.Rows[0][3].ToString());
                db.AddParameter("@uniqueid", questionusage_id.ToString());
                db.AddParameter("@layout", ds_mdl_quiz_attempts.Rows[0][5].ToString());
                db.AddParameter("@currentpage", ds_mdl_quiz_attempts.Rows[0][6].ToString());
                db.AddParameter("@preview", ds_mdl_quiz_attempts.Rows[0][7].ToString());
                db.AddParameter("@state", ds_mdl_quiz_attempts.Rows[0][8].ToString());
                db.AddParameter("@timestart", ds_mdl_quiz_attempts.Rows[0][9].ToString());
                db.AddParameter("@timefinish", ds_mdl_quiz_attempts.Rows[0][10].ToString());
                db.AddParameter("@timemodified", ds_mdl_quiz_attempts.Rows[0][11].ToString());
                db.AddParameter("@timemodifiedoffline", ds_mdl_quiz_attempts.Rows[0][12].ToString());
                db.AddParameter("@timecheckstate", ds_mdl_quiz_attempts.Rows[0][13].ToString());
                db.AddParameter("@sumgrades", ds_mdl_quiz_attempts.Rows[0][14].ToString());
                db.ExecuteNonQueryWithTransaction("mdl_quiz_attempts_Them");

                //---------
                for (int i = 0; i < ds_mdl_question_attempts.Rows.Count; i++)
                {
                    db.CreateNewSqlCommand();
                    db.AddParameter("@questionusageid", questionusage_id);
                    db.AddParameter("@slot", ds_mdl_question_attempts.Rows[i][2].ToString());
                    db.AddParameter("@behaviour", ds_mdl_question_attempts.Rows[i][3].ToString());
                    db.AddParameter("@questionid", ds_mdl_question_attempts.Rows[i][4].ToString());
                    db.AddParameter("@variant", ds_mdl_question_attempts.Rows[i][5].ToString());
                    db.AddParameter("@maxmark", ds_mdl_question_attempts.Rows[i][6].ToString());
                    db.AddParameter("@minfraction", ds_mdl_question_attempts.Rows[i][7].ToString());
                    db.AddParameter("@maxfraction", ds_mdl_question_attempts.Rows[i][8].ToString());
                    db.AddParameter("@flagged", bool.Parse(ds_mdl_question_attempts.Rows[i][9].ToString()));
                    db.AddParameter("@questionsummary", ds_mdl_question_attempts.Rows[i][10].ToString());
                    db.AddParameter("@rightanswer", ds_mdl_question_attempts.Rows[i][11].ToString());
                    db.AddParameter("@responsesummary", ds_mdl_question_attempts.Rows[i][12].ToString());
                    db.AddParameter("@timemodified", ds_mdl_question_attempts.Rows[i][13].ToString());
                    questionattempt_id = db.ExecuteScalarWithTransaction("mdl_question_attempts_Them");

                    //--------------todo
                    ds_mdl_question_attempt_steps = mdl_question_attempt_steps_DS(ds_mdl_question_attempts.Rows[i][0].ToString(), 0.ToString());
                    db.CreateNewSqlCommand();
                    db.AddParameter("@questionattemptid", questionattempt_id.ToString());
                    ds_questionattempt_id.Rows.Add(questionattempt_id.ToString());
                    db.AddParameter("@sequencenumber", ds_mdl_question_attempt_steps.Rows[0][2].ToString());
                    db.AddParameter("@state", ds_mdl_question_attempt_steps.Rows[0][3].ToString());
                    if ((ds_mdl_question_attempt_steps.Rows[0][4].ToString()) == "")
                    {
                        db.AddParameter("@fraction", DBNull.Value);
                    }
                    else
                    {
                        db.AddParameter("@fraction", (ds_mdl_question_attempt_steps.Rows[0][4].ToString()));
                    }
                    db.AddParameter("@timecreated", ds_mdl_question_attempt_steps.Rows[0][5].ToString());
                    db.AddParameter("@userid", ds_mdl_question_attempt_steps.Rows[0][6].ToString());
                    attemptstep_id = db.ExecuteScalarWithTransaction("mdl_question_attempt_steps_Them");
                    ds_mdl_question_attempt_step_data = mdl_question_attempt_step_data_DS(ds_mdl_question_attempt_steps.Rows[0][0].ToString());//_order
                    db.CreateNewSqlCommand();
                    db.AddParameter("@attemptstepid", attemptstep_id.ToString());
                    db.AddParameter("@name", ds_mdl_question_attempt_step_data.Rows[0][2].ToString());
                    db.AddParameter("@value", ds_mdl_question_attempt_step_data.Rows[0][3].ToString());
                    db.ExecuteNonQueryWithTransaction("mdl_question_attempt_step_data_Them");
                }
                for (int i = 0; i < ds_mdl_question_attempts.Rows.Count; i++)
                {
                    //--------------complete
                    ds_mdl_question_attempt_steps = mdl_question_attempt_steps_DS(ds_mdl_question_attempts.Rows[i][0].ToString(), 1.ToString());//complete
                    db.CreateNewSqlCommand();
                    db.AddParameter("@questionattemptid", ds_questionattempt_id.Rows[i][0].ToString());
                    db.AddParameter("@sequencenumber", ds_mdl_question_attempt_steps.Rows[0][2].ToString());
                    db.AddParameter("@state", ds_mdl_question_attempt_steps.Rows[0][3].ToString());
                    if ((ds_mdl_question_attempt_steps.Rows[0][4].ToString()) == "")
                    {
                        db.AddParameter("@fraction", DBNull.Value);
                    }
                    else
                    {
                        db.AddParameter("@fraction", (ds_mdl_question_attempt_steps.Rows[0][4].ToString()));
                    }
                    db.AddParameter("@timecreated", ds_mdl_question_attempt_steps.Rows[0][5].ToString());
                    db.AddParameter("@userid", ds_mdl_question_attempt_steps.Rows[0][6].ToString());
                    attemptstep_id = db.ExecuteScalarWithTransaction("mdl_question_attempt_steps_Them");
                    ds_mdl_question_attempt_step_data = mdl_question_attempt_step_data_DS(ds_mdl_question_attempt_steps.Rows[0][0].ToString());//_order
                    db.CreateNewSqlCommand();
                    db.AddParameter("@attemptstepid", attemptstep_id.ToString());
                    db.AddParameter("@name", ds_mdl_question_attempt_step_data.Rows[0][2].ToString());
                    db.AddParameter("@value", ds_mdl_question_attempt_step_data.Rows[0][3].ToString());
                    db.ExecuteNonQueryWithTransaction("mdl_question_attempt_step_data_Them");
                }
                for (int i = 0; i < ds_mdl_question_attempts.Rows.Count; i++)
                {
                    //--------------grade
                    ds_mdl_question_attempt_steps = mdl_question_attempt_steps_DS(ds_mdl_question_attempts.Rows[i][0].ToString(), 2.ToString());
                    if (ds_mdl_question_attempt_steps.Rows.Count > 0)
                    {
                        db.CreateNewSqlCommand();
                        db.AddParameter("@questionattemptid", ds_questionattempt_id.Rows[i][0].ToString());
                        db.AddParameter("@sequencenumber", ds_mdl_question_attempt_steps.Rows[0][2].ToString());
                        db.AddParameter("@state", ds_mdl_question_attempt_steps.Rows[0][3].ToString());
                        if ((ds_mdl_question_attempt_steps.Rows[0][4].ToString()) == "")
                        {
                            db.AddParameter("@fraction", DBNull.Value);
                        }
                        else
                        {
                            db.AddParameter("@fraction", (ds_mdl_question_attempt_steps.Rows[0][4].ToString()));
                        }
                        db.AddParameter("@timecreated", ds_mdl_question_attempt_steps.Rows[0][5].ToString());
                        db.AddParameter("@userid", ds_mdl_question_attempt_steps.Rows[0][6].ToString());
                        attemptstep_id = db.ExecuteScalarWithTransaction("mdl_question_attempt_steps_Them");
                        ds_mdl_question_attempt_step_data = mdl_question_attempt_step_data_DS(ds_mdl_question_attempt_steps.Rows[0][0].ToString());//_order
                        db.CreateNewSqlCommand();
                        db.AddParameter("@attemptstepid", attemptstep_id.ToString());
                        db.AddParameter("@name", ds_mdl_question_attempt_step_data.Rows[0][2].ToString());
                        db.AddParameter("@value", ds_mdl_question_attempt_step_data.Rows[0][3].ToString());
                        db.ExecuteNonQueryWithTransaction("mdl_question_attempt_step_data_Them");
                    }
                }
                db.CommitTransaction();
                return(true);
            }
            catch
            {
                db.RollbackTransaction();
                return(false);
            }
        }