示例#1
0
        private void connect_Click(object sender, RoutedEventArgs e)
        {
            //if (int.Parse(personalIDTextBox.Text) != 0)
            if (personalIDTextBox.Text == null || personalIDTextBox.Text == "")
            {
                var list = from p in context.Personals select p;
                ObservableCollection <Personal> personals = new ObservableCollection <Personal>(list);
                Personal personal = new Personal();
                foreach (var per in personals)
                {
                    if (per.UserID == int.Parse(personalIDTextBox.Text))
                    {
                        MessageBox.Show("personal ID is valid");
                        //var newForm = new MainPersonal(per); //create your new form.
                        ////var newForm = new MainPerson(int.Parse(personalIDTextBox.Text)); //create your new form.
                        //newForm.Show(); //show the new form
                    }
                }
            }
            else
            {
                //
                MessageBox.Show("personal ID is not valid");
            }

            MainPersonal newForm = new MainPersonal(); //create your new form.

            this.Hide();
            newForm.Show(); //show the new form
        }
示例#2
0
        private void add_Click(object sender, RoutedEventArgs e)
        {
            NorthwindEntities context = new NorthwindEntities();

            //if (int.Parse(personalIDTextBox.Text) != 0)
            if (personalIDTextBox.Text != null && personalIDTextBox.Text != "")
            {
                var list = from p in context.Personals select p;
                ObservableCollection <Personal> personals = new ObservableCollection <Personal>(list);
                Personal personal = new Personal();
                foreach (var per in personals)
                {
                    if (per.UserID == int.Parse(personalIDTextBox.Text))
                    {
                        MessageBox.Show("personal ID is exit");
                        //var newForm = new MainPersonal(per); //create your new form.
                        ////var newForm = new MainPerson(int.Parse(personalIDTextBox.Text)); //create your new form.
                        //newForm.Show(); //show the new form
                    }
                    else
                    {
                        //personal.UserID
                        //personal.FirstName
                        //personal.LastName
                        //personal.Gender
                        //personal.Status
                        //personal.CityId
                        //personal.Age
                        //personal.Children

                        //context.Expenses.Add(expense);
                        context.SaveChanges();
                        context.SaveChanges();

                        // Refresh the grids so the database generated values show up.
                        //this.p.Items.Refresh();
                        //this.productsDataGrid.Items.Refresh();
                    }
                }
            }
            else
            {
                //
                MessageBox.Show("personal ID is not valid");
            }

            MainPersonal newForm = new MainPersonal(); //create your new form.

            this.Hide();
            newForm.Show(); //show the new form
        }
示例#3
0
        private void add_Click(object sender, RoutedEventArgs e)
        {
            if (personal.Gender != 1 && personal.Gender != 2)
            {
                MessageBox.Show("Gender Required");
                return;
            }

            if ((Regex.IsMatch(personalId.Text, "[^0-9]+")) || personalId.Text == null || personalId.Text == "" || personalId.Text.Length > 9)
            {
                MessageBox.Show("personal ID is not valid");
                return;
            }

            if (Regex.IsMatch(firstName.Text, "[^a-zA-Z]+") || firstName.Text == null || firstName.Text == "")
            {
                MessageBox.Show("This textbox accepts only alphabetical characters");
                return;
            }

            if (Regex.IsMatch(lastName.Text, "[^a-zA-Z]+") || lastName.Text == null || lastName.Text == "")
            {
                MessageBox.Show("This textbox accepts only alphabetical characters");
                return;
            }

            if (Regex.IsMatch(age.Text, "[^0-9]+") || age.Text == null || age.Text == "")
            {
                MessageBox.Show("age is not valid");
                return;
            }

            if (Regex.IsMatch(numChildren.Text, "[^0-9]+") || numChildren.Text == null || numChildren.Text == "")
            {
                MessageBox.Show("num children is not valid");
                return;
            }

            if (personalId.Text != null && personalId.Text != "")
            {
                var list = from p in context.Personals select p;
                ObservableCollection <Personal> personals = new ObservableCollection <Personal>(list);
                //Personal personal = new Personal();

                foreach (var per in personals)
                {
                    if (per.UserID == int.Parse(personalId.Text))
                    {
                        MessageBox.Show("personal ID is exit");
                        return;
                        //var newForm = new MainPersonal(per); //create your new form.
                        ////var newForm = new MainPerson(int.Parse(personalIDTextBox.Text)); //create your new form.
                        //newForm.Show(); //show the new form
                    }
                }



                try
                {
                    personal.UserID    = int.Parse(personalId.Text);
                    personal.FirstName = firstName.Text;
                    personal.LastName  = lastName.Text;
                    personal.Age       = float.Parse(age.Text);
                    personal.Children  = int.Parse(numChildren.Text);
                    //personal.Gender = personal.Gender;
                    // Refresh the grids so the database generated values show up.
                    //this.p.Items.Refresh();
                    //this.productsDataGrid.Items.Refresh();

                    context.Personals.Add(personal);
                    context.SaveChanges();

                    MainPersonal newForm = new MainPersonal(); //create your new form.
                    this.Hide();
                    newForm.Show();                            //show the new form
                }
                catch (DbEntityValidationException eee)
                {
                    MessageBox.Show(eee.EntityValidationErrors.ToString());
                }
            }
            else
            {
                //
                MessageBox.Show("personal ID is not valid");
            }
        }