private void UserControl_Loaded(object sender, RoutedEventArgs e) { Account temp = MainWindow.account; tb_firstname.Text = temp.firstName; tb_lastname.Text = temp.lastName; tb_mail.Text = temp.email; lbl_mail.Content = temp.email; tb_password.Password = Certify.Decrypt(temp.password); TextRange textRange = new TextRange(tb_desc.Document.ContentStart, tb_desc.Document.ContentEnd); if (temp.description != null) { textRange.Text = temp.description; } if (temp.businessusage) { btn_upgrade.Visibility = Visibility.Hidden; lbl_abu.Visibility = Visibility.Visible; lbl_license.Content = (string)FindResource("bu_account"); lbl_lastpayment.Content = temp.lastpay.ToString("dd-MM-yyyy"); } else { lbl_lastpayment.Content = (string)FindResource("lifetime_license_account"); } lbl_name.Content = temp.firstName + " " + temp.lastName; }
private void RunStatement() { while (!threadHasToStop) { if (sqlStatementIsRunning) { sqlStatementIsRunning = false; try { SqlCommand command = cnn.CreateCommand(); command.CommandText = "select acc_id, firstname, lastname, email, password, businessusage, CONVERT(varchar, lastpayment, 105), description from accounts where email='" + mail + "';"; SqlDataReader reader; bool correctInformations = false; string accLine = ""; cnn.Open(); reader = command.ExecuteReader(); while (reader.Read()) { for (short i = 0; i < reader.FieldCount; i++) { if (i == 4 && Certify.Decrypt(reader.GetValue(i).ToString()) == password) { correctInformations = true; } accLine += reader.GetValue(i).ToString() + ';'; } } cnn.Close(); Dispatcher.Invoke(new Action(() => { progring.IsActive = false; if (correctInformations) { accountLine = accLine; MainWindow.account = new Account(accountLine); MainWindow mpw = new MainWindow(); mpw.Show(); this.Close(); } else { lbl_msg.Foreground = Brushes.Red; lbl_msg.Visibility = Visibility.Visible; } })); } catch (Exception ex) { } } } }
public LoginWindow() { InitializeComponent(); this.ShowIconOnTitleBar = false; if (Properties.Settings.Default.RememberUserName != null && Properties.Settings.Default.RememberUserName != "") { tb_mail.Text = Certify.Decrypt(Properties.Settings.Default.RememberUserName); tb_pw.Focus(); } else { tb_mail.Focus(); } cnn = new SqlConnection(connectionString); thread = new Thread(RunStatement); thread.Start(); }