Example #1
0
 private void bwRemoveCategory_DoWork(object sender, DoWorkEventArgs e)
 {
     if (DB_Delete.DeleteCategory(game.Categories[game.NumCategories].Id) > 0)
     {
         game.Categories.RemoveAt(game.NumCategories);
     }
 }
Example #2
0
 private void bwDeleteChoices_DoWork(object sender, DoWorkEventArgs e)
 {
     for (int i = 0; i < currentQuestion.Choices.Count; i++)
     {
         DB_Delete.DeleteChoice(currentQuestion.Choices[i].Id);
     }
 }
Example #3
0
 private void bwRemoveChoices_DoWork(object sender, DoWorkEventArgs e) //now only runs on form close
 {
     if (!bwCreateChoices.IsBusy && question.Choices != null && question.Choices.Count > 0)
     {
         foreach (Choice c in question.Choices)
         {
             DB_Delete.DeleteChoice(c.Id);
         }
     }
 }
Example #4
0
 private void bwRemoveQuestions_DoWork(object sender, DoWorkEventArgs e)
 {
     for (int i = 0; i < game.NumCategories; i++)
     {
         if (DB_Delete.DeleteQuestion(game.Categories[i].Questions[game.NumQuestionsPerCategory].Id) > 0) //deleting question happens here
         {
             game.Categories[i].Questions.RemoveAt(game.NumQuestionsPerCategory);                         //if deleting from db was successful, also remove from game object
         }
         else
         {
             MessageBox.Show("Failed to delete questions");
         }
     }
 }
Example #5
0
        private void bwImportCategory_DoWork(object sender, DoWorkEventArgs e)
        {
            if (importCategoryForm.SelectedCategory.Questions.Count > 0) //only import questions if there are any
            {
                //only imports questions to the max size of the grid and the max size of the other game grid
                for (int i = 0; i < category.Questions.Count && i < importCategoryForm.SelectedCategory.Questions.Count; i++)
                {
                    //if going from multiple choice to another type, delete the choices
                    if (category.Questions[i].Type == "mc" && importCategoryForm.SelectedCategory.Questions[i].Type != "mc")
                    {
                        for (int j = 0; j < 4 && j < category.Questions[i].Choices.Count; j++)
                        {
                            DB_Delete.DeleteChoice(category.Questions[i].Choices[j].Id);
                        }
                    }
                    // going from other type of question to multiple choice, make the choices
                    else if (category.Questions[i].Type != "mc" && importCategoryForm.SelectedCategory.Questions[i].Type == "mc")
                    {
                        category.Questions[i].Choices = new List <Choice>(new Choice[4]);
                        for (int j = 0; j < 4 && j < category.Questions[i].Choices.Count; j++)
                        {
                            category.Questions[i].Choices[j]            = new Choice();
                            category.Questions[i].Choices[j].QuestionId = (int)category.Questions[i].Id;
                            category.Questions[i].Choices[j].Index      = j;
                            category.Questions[i].Choices[j].Text       = importCategoryForm.SelectedCategory.Questions[i].Choices[j].Text;
                            category.Questions[i].Choices[j].Id         = DB_Insert.InsertChoice(category.Questions[i].Choices[j]);
                        }
                    }
                    //if both are multiple choice, just do a simple update
                    else if (category.Questions[i].Type == "mc" && importCategoryForm.SelectedCategory.Questions[i].Type == "mc")
                    {
                        for (int j = 0; j < 4; j++)
                        {
                            category.Questions[i].Choices[j].Text = importCategoryForm.SelectedCategory.Questions[i].Choices[j].Text;
                            DB_Update.UpdateChoice(category.Questions[i].Choices[j]);
                        }
                    }

                    //set the other new properties of the importing questions. This needs to go after the previous code
                    category.Questions[i].Type         = importCategoryForm.SelectedCategory.Questions[i].Type;
                    category.Questions[i].QuestionText = importCategoryForm.SelectedCategory.Questions[i].QuestionText;
                    category.Questions[i].Answer       = importCategoryForm.SelectedCategory.Questions[i].Answer;

                    //update the question (import the question)
                    DB_Update.UpdateQuestion(category.Questions[i]);
                }
            }
        }
Example #6
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            frmImportQuestion importQuestionForm = new frmImportQuestion();
            DialogResult      dialogResult       = importQuestionForm.ShowDialog();

            if (dialogResult == DialogResult.OK)
            {
                //if going from multiple choice to another type, delete the choices
                if (question.Type == "mc" && importQuestionForm.selectedQuestion.Type != "mc")
                {
                    for (int j = 0; j < 4 && j < question.Choices.Count; j++)
                    {
                        DB_Delete.DeleteChoice(question.Choices[j].Id);
                    }
                }
                // going from other type of question to multiple choice, make the choices
                else if (question.Type != "mc" && importQuestionForm.selectedQuestion.Type == "mc")
                {
                    question.Choices = new List <Choice>(new Choice[4]);
                    for (int j = 0; j < 4 && j < question.Choices.Count; j++)
                    {
                        question.Choices[j]            = new Choice();
                        question.Choices[j].QuestionId = (int)question.Id;
                        question.Choices[j].Index      = j;
                        question.Choices[j].Text       = importQuestionForm.selectedQuestion.Choices[j].Text;
                        question.Choices[j].Id         = DB_Insert.InsertChoice(question.Choices[j]);
                    }
                }
                //if both are multiple choice, just do a simple update
                else if (question.Type == "mc" && importQuestionForm.selectedQuestion.Type == "mc")
                {
                    for (int j = 0; j < 4; j++)
                    {
                        question.Choices[j].Text = importQuestionForm.selectedQuestion.Choices[j].Text;
                        DB_Update.UpdateChoice(question.Choices[j]);
                    }
                }

                //get info from the selected question (not a complete clone because the IDs have to be different)
                question.Type         = importQuestionForm.selectedQuestion.Type;
                question.QuestionText = importQuestionForm.selectedQuestion.QuestionText;
                question.Answer       = importQuestionForm.selectedQuestion.Answer;

                frmEditQuestion_Load(sender, e); //reload this form with the info
            }
        }
Example #7
0
 private void bwDeleteGame_DoWork(object sender, DoWorkEventArgs e)
 {
     int numRows = DB_Delete.DeleteGame(selectedGame.Id);
 }