Ejemplo n.º 1
0
        private void btn_save_Click(object sender, RoutedEventArgs e)
        {
            string accountString = "update accounts set ";
            bool   updateable    = true;

            if (tb_firstname.Text != "")
            {
                accountString += "firstname = '" + tb_firstname.Text + "', ";
            }
            else
            {
                updateable = false;
            }

            if (tb_lastname.Text != "")
            {
                accountString += "lastname = '" + tb_lastname.Text + "', ";
            }
            else
            {
                updateable = false;
            }

            if (tb_mail.Text != "")
            {
                accountString += "email = '" + tb_mail.Text + "'";
            }
            else
            {
                updateable = false;
            }

            if (tb_password.Password != "")
            {
                if (tb_password.Password == tb_confpassword.Password)
                {
                    accountString += ", password = '******'";
                }
            }

            if (new TextRange(tb_desc.Document.ContentStart, tb_desc.Document.ContentEnd).Text != "'")
            {
                accountString += ", description = '" + new TextRange(tb_desc.Document.ContentStart, tb_desc.Document.ContentEnd).Text + "'";
            }

            if (!worker_saveAccountSettings.IsBusy && updateable)
            {
                btn_save.IsEnabled = false;
                accountString     += " where acc_id = " + MainWindow.account.id + ";";
                worker_saveAccountSettings.RunWorkerAsync(accountString);
            }
        }
Ejemplo n.º 2
0
        public MainWindow()
        {
            InitializeComponent();
            this.ShowIconOnTitleBar = false;
            this.HamburgerMenuControl.SelectedIndex = 0;
            this.selectedIndex  = 0;
            MainWindow.instance = this;
            cnn            = new SqlConnection(connectionString);
            worker         = new BackgroundWorker();
            worker.DoWork += Worker_AddProjectToDatabase;

            Properties.Settings.Default.RememberUserName = Certify.Encrypt(MainWindow.account.email);
            Properties.Settings.Default.Save();
        }
Ejemplo n.º 3
0
        private void RunStatement()
        {
            while (!threadHasToStop)
            {
                if (sqlStatementIsRunning)
                {
                    sqlStatementIsRunning = false;

                    try
                    {
                        bool       registered = false;
                        SqlCommand command    = cnn.CreateCommand();
                        command.CommandText = "select email from accounts;";
                        SqlDataReader reader;

                        cnn.Open();

                        reader = command.ExecuteReader();
                        while (reader.Read())
                        {
                            for (int i = 0; i < reader.FieldCount; i++)
                            {
                                if (mail == reader.GetValue(i).ToString())
                                {
                                    registered = true;
                                }
                            }
                        }

                        if (!registered)
                        {
                            reader.Close();
                            command.CommandText = "insert into accounts(firstname, lastname, email, password, businessusage, lastpayment, description) values('" + firstname + "', '" + lastname + "', '" + mail + "', '" + Certify.Encrypt(password) + "', '" + businessusage + "', CONVERT (date, GETDATE()), null);";

                            command.ExecuteNonQuery();

                            Dispatcher.Invoke(new Action(() =>
                            {
                                lbl_msg.Content    = (string)FindResource("msg_succ");
                                lbl_msg.Foreground = Brushes.Green;
                                lbl_msg.Visibility = Visibility.Visible;
                                progring.IsActive  = false;

                                threadHasToStop = true;
                            }));
                        }
                    } catch (Exception ex) {
                    }
                }
            }
        }