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