private void SuccessTimer_Tick(object sender, EventArgs e) { if (SuccessPictureBox.Visible == true) { SuccessPictureBox.Visible = false; SuccessLabel.Visible = false; } else if (SuccessPictureBox1.Visible == true) { SuccessPictureBox1.Visible = false; SuccessLabel1.Visible = false; } else if (SuccessPictureBox2.Visible == true) { SuccessPictureBox2.Visible = false; SuccessLabel2.Visible = false; BackButton.Visible = false; AddQuestPanel.Visible = false; QuestEditPanel.Visible = false; ShowQuestsPanel.Visible = true; } SuccessTimer.Stop(); }
private void DeleteButton_Click(object sender, EventArgs e) { NumberOfSelected = QuestListView.SelectedItems.Count; Connect(); foreach (ListViewItem DataOfSelected in QuestListView.SelectedItems) { QuestID = Convert.ToInt32(DataOfSelected.SubItems[0].Text); if (Mode1Button.Enabled == false) { query = new OleDbCommand("DELETE FROM Words WHERE questID = @QuestID", connect); } else if (Mode2Button.Enabled == false) { query = new OleDbCommand("DELETE FROM Expressions WHERE questID = @QuestID", connect); } query.Parameters.AddWithValue("@questID", QuestID); query.ExecuteNonQuery(); } if (Mode1Button.Enabled == false) { query = new OleDbCommand("SELECT * FROM Words ORDER BY questID", connect); } else if (Mode2Button.Enabled == false) { query = new OleDbCommand("SELECT * FROM Expressions ORDER BY questID", connect); } Clear(); List(); SuccessLabel1.Text = NumberOfSelected.ToString() + " Question(s) Deleted Successful!"; SuccessLabel1.Visible = true; SuccessPictureBox1.Visible = true; SuccessTimer.Start(); Disconnect(); }
private void EditButton_Click(object sender, EventArgs e) { foreach (ListViewItem DataOfSelected in QuestListView.SelectedItems) { QuestID = Convert.ToInt32(DataOfSelected.SubItems[0].Text); } Quest = QuestEditTextBox.Text; OptionA = OptionAEditTextBox.Text; OptionB = OptionBEditTextBox.Text; OptionC = OptionCEditTextBox.Text; OptionD = OptionDEditTextBox.Text; if (QuestModeComboBox.Text == "Expressions") { QuestMode = 2; } else if (QuestModeComboBox.Text == "Words") { QuestMode = 1; } if (QuestAnswerComboBox.Text == "Option A") { AnswerOfQuest = "A"; } else if (QuestAnswerComboBox.Text == "Option B") { AnswerOfQuest = "B"; } else if (QuestAnswerComboBox.Text == "Option C") { AnswerOfQuest = "C"; } else if (QuestAnswerComboBox.Text == "Option D") { AnswerOfQuest = "D"; } if (Quest == "" || OptionA == "" || OptionB == "" || OptionC == "" || OptionD == "" || AnswerOfQuest == "" || QuestModeEditComboBox.Text == "") { MetroMessageBox.Show(this, "Please fill the all blanks!", "WARNİNG!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { bool Exist = false; for (int i = 0; i < QuestListView.Items.Count; i++) { if (QuestListView.Items[i].SubItems[1].Text == Quest) { MetroMessageBox.Show(this, "This question already exists!", "WARNİNG!", MessageBoxButtons.OK, MessageBoxIcon.Warning); Exist = true; } } if (Exist == false) { Connect(); if (QuestMode == 1) { query = new OleDbCommand("UPDATE Words SET quest = @quest, questAnswer = @questAnswer, optionA = @optionA, optionB = @optionB, optionC = @optionC, optionD = @optionD WHERE questID = @questID", connect); } else if (QuestMode == 2) { query = new OleDbCommand("UPDATE Expressions SET quest = @quest, questAnswer = @questAnswer, optionA = @optionA, optionB = @optionB, optionC = @optionC, optionD = @optionD WHERE questID = @questID", connect); } query.Parameters.AddWithValue("@quest", Quest); query.Parameters.AddWithValue("@questAnswer", AnswerOfQuest); query.Parameters.AddWithValue("@optionA", OptionA); query.Parameters.AddWithValue("@optionB", OptionB); query.Parameters.AddWithValue("@optionC", OptionC); query.Parameters.AddWithValue("@optionD", OptionD); query.Parameters.AddWithValue("@questID", QuestID); query.ExecuteNonQuery(); if (QuestMode == 1) { Clear(); query = new OleDbCommand("SELECT * FROM Words ORDER BY questID", connect); List(); } else if (QuestMode == 2) { Clear(); query = new OleDbCommand("SELECT * FROM Expressions ORDER BY questID", connect); List(); } SuccessPictureBox.Visible = true; SuccessLabel.Visible = true; SuccessTimer.Start(); Disconnect(); } } }
private void AddButton_Click(object sender, EventArgs e) { Quest = QuestTextBox.Text; OptionA = OptionATextBox.Text; OptionB = OptionBTextBox.Text; OptionC = OptionCTextBox.Text; OptionD = OptionDTextBox.Text; if (QuestModeComboBox.Text == "Expressions") { QuestMode = 2; } else if (QuestModeComboBox.Text == "Words") { QuestMode = 1; } if (QuestAnswerComboBox.Text == "Option A") { AnswerOfQuest = "A"; } else if (QuestAnswerComboBox.Text == "Option B") { AnswerOfQuest = "B"; } else if (QuestAnswerComboBox.Text == "Option C") { AnswerOfQuest = "C"; } else if (QuestAnswerComboBox.Text == "Option D") { AnswerOfQuest = "D"; } if (Quest == "" || OptionA == "" || OptionB == "" || OptionC == "" || OptionD == "" || AnswerOfQuest == "" || QuestModeComboBox.Text == "") { MetroMessageBox.Show(this, "Please fill the all blanks!", "WARNİNG!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { bool Exist = false; for (int i = 0; i < QuestListView.Items.Count; i++) { if (QuestListView.Items[i].SubItems[1].Text == Quest) { MetroMessageBox.Show(this, "This question already exists!", "WARNİNG!", MessageBoxButtons.OK, MessageBoxIcon.Warning); Exist = true; } } if (Exist == false) { Connect(); if (QuestMode == 1) { query = new OleDbCommand("INSERT INTO Words(quest, questAnswer, optionA, optionB, optionC, optionD) VALUES(@quest, @questAnswer, @optionA, @optionB, @optionC, @optionD)", connect); } else if (QuestMode == 2) { query = new OleDbCommand("INSERT INTO Expressions(quest, questAnswer, optionA, optionB, optionC, optionD) VALUES(@quest, @questAnswer, @optionA, @optionB, @optionC, @optionD)", connect); } query.Parameters.AddWithValue("@quest", Quest); query.Parameters.AddWithValue("@questAnswer", AnswerOfQuest); query.Parameters.AddWithValue("@optionA", OptionA); query.Parameters.AddWithValue("@optionB", OptionB); query.Parameters.AddWithValue("@optionC", OptionC); query.Parameters.AddWithValue("@optionD", OptionD); query.ExecuteNonQuery(); if (QuestMode == 1) { Clear(); query = new OleDbCommand("SELECT * FROM Words ORDER BY questID", connect); List(); } else if (QuestMode == 2) { Clear(); query = new OleDbCommand("SELECT * FROM Expressions ORDER BY questID", connect); List(); } SuccessPictureBox.Visible = true; SuccessLabel.Visible = true; SuccessTimer.Start(); Disconnect(); } } }