示例#1
0
        void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target)
        {
            switch (connectionId)
            {
            case 1:
                this.login_screen = ((WpfApp2.login)(target));
                return;

            case 2:
                this.login_ID = ((System.Windows.Controls.Label)(target));
                return;

            case 3:
                this.password = ((System.Windows.Controls.Label)(target));
                return;

            case 4:
                this.login_input = ((System.Windows.Controls.TextBox)(target));
                return;

            case 5:
                this.password_input = ((System.Windows.Controls.TextBox)(target));
                return;
            }
            this._contentLoaded = true;
        }
示例#2
0
        //when user try to enter data it will first verify and then allow user to insert data into database
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            if (username.Text.Length == 0)
            {
                errorusername.Text = "Enter username.";
                username.Focus();
            }
            else if (password.Password.Length == 0)
            {
                errorpassword.Text = "Enter a password.";
                password.Focus();
            }
            else  //to validate email
            if (!Regex.IsMatch(email.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))
            {
                erroremail.Text = "Enter a valid email.";
                email.Select(0, email.Text.Length);
                email.Focus();
            }
            else

            if (username.Text.Length != 0 && password.Password.Length != 0 && email.Text.Length != 0)
            {
                dc = new DataClasses1DataContext();
                login lg = new login();
                lg.type     = combobox.SelectedItem.ToString();
                lg.username = username.Text;
                lg.password = password.Password;
                lg.email    = email.Text;
                dc.logins.InsertOnSubmit(lg);
                dc.SubmitChanges();
                MessageBox.Show("Data Saved Successfully!!");

                // lg.Id = Convert.ToInt32("");
                combobox.SelectedItem = "";
                username.Text         = "";
                password.Password     = "";
                email.Text            = "";
                errorusername.Text    = "";
                errorpassword.Text    = "";
                erroremail.Text       = "";

                myadmingrid2.ItemsSource = dc.logins;
            }
        }
示例#3
0
        //this will populate data into user input so one can change data like update and delete
        private void myadmingrid_SelectedCellsChanged2(object sender, SelectedCellsChangedEventArgs e)
        {
            delete2.IsEnabled = true;
            update.IsEnabled  = true;
            int row;
            DataClasses1DataContext dt = new DataClasses1DataContext();
            login tb = new login();



            tb = myadmingrid2.SelectedItem as login;

            if (tb == null)
            {
                //  MessageBox.Show("Hii");
            }
            else
            {
                row = Convert.ToInt32(tb.Id);
                // MessageBox.Show(row.ToString());

                string row1 = Convert.ToString(tb.Id);


                var selectQuery = from rows in dt.logins where rows.Id == row select rows;

                foreach (var c in selectQuery)
                {
                    combobox.Text     = c.type;
                    username.Text     = c.username;
                    password.Password = c.password;
                    email.Text        = c.email;
                }

                dt.SubmitChanges();
            }
        }
示例#4
0
        void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target)
        {
            switch (connectionId)
            {
            case 1:
                this.login_screen = ((WpfApp2.login)(target));
                return;

            case 2:
                this.login_ID = ((System.Windows.Controls.Label)(target));
                return;

            case 3:
                this.password = ((System.Windows.Controls.Label)(target));
                return;

            case 4:
                this.textBox = ((System.Windows.Controls.TextBox)(target));
                return;

            case 5:
                this.passwordBox = ((System.Windows.Controls.PasswordBox)(target));
                return;

            case 6:
                this.bt_login = ((System.Windows.Controls.Button)(target));

            #line 14 "..\..\login.xaml"
                this.bt_login.Click += new System.Windows.RoutedEventHandler(this.bt_login_Click);

            #line default
            #line hidden
                return;
            }
            this._contentLoaded = true;
        }
示例#5
0
        //to update data
        private void callupdate()
        {
            DataClasses1DataContext dt = new DataClasses1DataContext();
            login tb = new login();

            tb = myadmingrid2.SelectedItem as login;
            int row         = Convert.ToInt32(tb.Id);
            var selectQuery = from rows in dt.logins where rows.Id == row select rows;

            foreach (var c in selectQuery)
            {
                c.type     = combobox.Text;
                c.username = username.Text;
                c.password = password.Password;
                c.email    = email.Text;



                myadmingrid2.ItemsSource = dt.logins;
            }
            // loadgrid();
            dt.SubmitChanges();
            MessageBox.Show("Updated Data Successfully!!");
        }
示例#6
0
        private void calldelete()
        {
            int row;

            dc = new DataClasses1DataContext();
            login lg = new login();

            lg = myadmingrid2.SelectedItem as login;

            if (MessageBox.Show("Do you want to delete data?",
                                "Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
            {
                if (lg == null)
                {
                    //  MessageBox.Show("Hii");
                }
                else
                {
                    row = Convert.ToInt32(lg.Id);
                    var selectQuery = from rows in dc.logins where rows.Id == row select rows;
                    foreach (var c in selectQuery)
                    {
                        dc.logins.DeleteOnSubmit(c);
                        dc.SubmitChanges();
                    }
                    MessageBox.Show("Data Deleted Successfully!!");
                    delete2.IsEnabled        = false;
                    myadmingrid2.ItemsSource = dc.logins;
                }
            }
            else
            {
                // Do not close the window
            }
            //MessageBox.Show(row.ToString());
        }
示例#7
0
 partial void Deletelogin(login instance);
示例#8
0
 partial void Updatelogin(login instance);
示例#9
0
 partial void Insertlogin(login instance);