Ejemplo n.º 1
0
        private void txNumber_TextChanged(object sender, TextChangedEventArgs e)
        {
            if (string.IsNullOrWhiteSpace(txNumber.Text))
            {
                txNumber.Background = Brushes.AliceBlue; txFname.Text = txSname.Text = ""; return;
            }

            int number;

            if (!int.TryParse(txNumber.Text, out number))
            {
                txNumber.Background = Brushes.MediumVioletRed; return;
            }
            else
            {
                txNumber.Background = Brushes.AliceBlue;
            }

            using (DBWokrSql db = new DBWokrSql(ConnectionString))
                try
                {
                    var user = db.GetUserLike(number);
                    if (user.ID > 0)
                    {
                        txFname.Text = user.Fname;
                        txSname.Text = user.Lname;
                    }
                    else
                    {
                        txFname.Text = txSname.Text = "";
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
        }