private void connect_Click(object sender, EventArgs e)
{
SQLiteCommand cmd = new SQLiteCommand(m_dbConnection);
Globals.strUsername = username.Text;
string strPassword = password.Text;
m_dbConnection.Open();
cmd.Parameters.AddWithValue("@username", Globals.strUsername);
cmd.Parameters.AddWithValue("@password", strPassword);
cmd.CommandText = "SELECT count(*) FROM users WHERE username=@username and password=@password";
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count == 1)
{
MutliplicationTables newMutliplicationTables = new MutliplicationTables();
newMutliplicationTables.Show();
this.Hide();
}
else
{
MessageBox.Show("Ο χρήστης δεν υπάρχει ή ο κωδικός είναι λανθασμένος");
}
cmd.ExecuteNonQuery();
m_dbConnection.Close();
}
private void πΙΣΩToolStripMenuItem_Click(object sender, EventArgs e)
{
MutliplicationTables newMutliplicationTables = new MutliplicationTables();
newMutliplicationTables.Show();
this.Hide();
}
private void OKButton_Click_1(object sender, EventArgs e)
{
int correct = 0, wrong = 0;
string[] value_array = new string[10] {
textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text
};
Label[] label_array3 = new Label[10] {
label11, label12, label13, label14, label15, label16, label17, label18, label19, label20
};
for (int i = 0; i < 10; i++)
{
if (value_array[i].Equals(myvalue_array[i].ToString()))
{
label_array3[i].Text = "ΣΩΣΤΟ";
correct = correct + 1;
label_array3[i].ForeColor = System.Drawing.Color.Green;
}
else
{
label_array3[i].Text = "ΛΑΘΟΣ";
wrong = wrong + 1;
label_array3[i].ForeColor = System.Drawing.Color.Red;
}
}
int score = 100 * correct / (correct + wrong);
SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
m_dbConnection.Open();
SQLiteCommand cmd = new SQLiteCommand(m_dbConnection);
cmd.Parameters.AddWithValue("@score", score);
cmd.Parameters.AddWithValue("@username", Globals.strUsername);
cmd.CommandText = $"UPDATE mult{myvalue} SET score=@score WHERE username=@username";
cmd.ExecuteNonQuery();
m_dbConnection.Close();
if (score < 80)
{
DialogResult dialog = MessageBox.Show("Έκανες αρκετά λάθη, θα πρέπει να ξαναδιαβάσεις τη θεωρία");
if (dialog == DialogResult.OK)
{
Learning newLearning = new Learning(myvalue);
newLearning.Show();
this.Hide();
}
}
else
{
DialogResult dialog = MessageBox.Show("ΜΠΡΑΒΟ!Τα πήγες πολύ καλά");
if (dialog == DialogResult.OK)
{
MutliplicationTables newMutliplicationTables = new MutliplicationTables();
newMutliplicationTables.Show();
this.Hide();
}
}
}
private void okButton_Click(object sender, EventArgs e)
{
int correct = 0, wrong = 0;
string[] value_array = new string[22] {
textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text, textBox11.Text, textBox12.Text, textBox13.Text, textBox14.Text, textBox15.Text, textBox16.Text, textBox17.Text, textBox18.Text, textBox19.Text, textBox20.Text, textBox21.Text, textBox22.Text
};
Label[] label_array3 = new Label[22] {
label11, label12, label13, label14, label15, label16, label17, label18, label19, label20, label21, label24, label25, label26, label27, label28, label29, label30, label31, label32, label33, label34
};
for (int i = 0; i < 22; i++)
{
if (value_array[i].Equals(myvalue_array[i].ToString()))
{
label_array3[i].Text = "ΣΩΣΤΟ";
correct = correct + 1;
label_array3[i].ForeColor = System.Drawing.Color.Green;
}
else
{
label_array3[i].Text = "ΛΑΘΟΣ";
wrong = wrong + 1;
label_array3[i].ForeColor = System.Drawing.Color.Red;
}
}
int score = 100 * correct / (correct + wrong);
SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
m_dbConnection.Open();
SQLiteCommand cmd = new SQLiteCommand(m_dbConnection);
cmd.Parameters.AddWithValue("@score", score);
cmd.Parameters.AddWithValue("@username", Globals.strUsername);
for (int y = 1; y < 5; y++)
{
cmd.CommandText = $"UPDATE exams SET exscore{y}=exscore{y + 1} WHERE username=@username";
cmd.ExecuteNonQuery();
}
cmd.CommandText = $"UPDATE exams SET exscore5=@score WHERE username=@username";
cmd.ExecuteNonQuery();
m_dbConnection.Close();
DialogResult dialog = MessageBox.Show("Το σκορ σου είναι: " + score.ToString() + " % ");
if (dialog == DialogResult.OK)
{
MutliplicationTables newMutliplicationTables = new MutliplicationTables();
newMutliplicationTables.Show();
this.Hide();
}
}