private void setTime(object sender, EventArgs e) { try { connectDB conn = new connectDB(); string sqlDate = null; //Send actual time to textBlock actualTimeBlock.Text = getTime().ToString(); //Get Time from DB sqlDate = conn.selectTimeDB().Rows[0][0].ToString(); DateTime time = DateTime.Parse(sqlDate); //Porównanie tylko w sekundach bo bedzie problem z godiznami 15:03 != 14:30 if ((Convert.ToInt32(getTime().ToString("mm"))) >= (Convert.ToInt32(time.ToString("mm")))) { startTime(true); //Set enable button to start enterEg.IsEnabled = true; tabGame.Visibility = Visibility.Visible; } }catch (Exception xe) { } }
private void loginBtn_Click(object sender, RoutedEventArgs e) { connectDB conn = new connectDB(); player p = new player(); string sqlDate = null; if (loginBox.Text.ToString() != null && emailBox.Text.ToString() != null && passwordBox.Password != null) { try { p.game(loginBox.Text.ToString(), emailBox.Text.ToString()); conn.decodeConnection(passwordBox.Password); MessageBox.Show("Pomyslnie zarejestrowano uzytkownika! Czekaj na start matury!"); loginBtn.IsEnabled = false; timeToStartBlock.Visibility = Visibility.Visible; sqlDate = conn.selectTimeDB().Rows[0][0].ToString(); DateTime time = DateTime.Parse(sqlDate); //When start? timeToStartBlock.Text = time.ToString(); //MessageBox.Show(time.ToString()); startTime(false); } catch (Exception xe) { MessageBox.Show("Error: " + xe.Message); } } }
public void sendStats(string time) { connectDB con = new connectDB(); MessageBox.Show("Gracz: " + nick + " email: " + email + " punktów: " + points + " czas: " + time); con.insertDB(nick, email, points, time); }
private void DRadial_Checked(object sender, RoutedEventArgs e) { connectDB con = new connectDB(); player p = new player(); int qN = Convert.ToInt32(qNumberBox.Text.ToString()); DataTable dt = con.getQ(qN) as DataTable; string z = dt.Rows[0]["PoprawnaOdpowiedz"].ToString(); if (DRadial.Content.ToString() == z) { MessageBox.Show("Correct!"); p.addPoints(); } }
private void Button_Click(object sender, RoutedEventArgs e) { connectDB con = new connectDB(); try { //con.getQ(1); DataTable dt = con.getQ(2) as DataTable; MessageBox.Show(dt.Rows[0]["TrescPytania"].ToString()); } catch (Exception xe) { MessageBox.Show(xe.Message); } }
private void setQuestion(int qN) { connectDB con = new connectDB(); player p = new player(); DataTable dt = con.getQ(qN) as DataTable; string q = "SELECT MAX(NumerPytania) FROM matura;"; DataTable cdt = con.customSelect(q); // Select MAX("NumerPytania") FROM matura; allQuestion.Text = cdt.Rows[0][0].ToString(); qNumberBox.Text = dt.Rows[0]["NumerPytania"].ToString(); if (Convert.ToInt32(qNumberBox.Text) == Convert.ToInt32(allQuestion.Text)) { finishBtn.IsEnabled = true; } questionBox.Text = dt.Rows[0]["TrescPytania"].ToString(); answerA.Text = dt.Rows[0]["OdpowiedzA"].ToString(); answerB.Text = dt.Rows[0]["OdpowiedzB"].ToString(); answerC.Text = dt.Rows[0]["OdpowiedzC"].ToString(); answerD.Text = dt.Rows[0]["OdpowiedzD"].ToString(); }