Exemplo n.º 1
0
        public Account(string username, string password, string ssn, string email, string fname, string lname)
        {
            this.ssn      = ssn;
            this.username = username;
            this.password = password;
            //FName_txt.Text = fname;
            this.email = email;
            this.fname = fname;
            this.lname = lname;

            InitializeComponent();
            Name_lbl.Text = username;

            UserNameAE_lbl.Text = username;
            PassAE_lbl.Text     = password;
            SSNA_lbl.Text       = ssn;
            EmailA_lbl.Text     = email;
            FNameA_lbl.Text     = fname;
            LNameA_lbl.Text     = lname;

            PassAE_lbl.Hide();
            UserNameE_txt.Hide();
            PasswordE_txt.Hide();
            interestAE_cmbo.Hide();
            InterestsAE_lbl.Hide();
            Email_txt.Hide();
            FName_txt.Hide();
            LName_txt.Hide();
            ShowToolTip.SetToolTip(show_lbl, "Show Password");
            ThemeFunction();

            con = new OracleConnection(ordb);
            con.Open();
        }
Exemplo n.º 2
0
        private void Edit_btn_Click(object sender, EventArgs e)
        {
            if (Edit_btn.Text.ToString() != "Done")
            {
                interestAE_cmbo.Show();
                InterestsAE_lbl.Show();
                UserNameE_txt.Text = username;
                UserNameE_txt.Show();
                PasswordE_txt.Text = password;
                PasswordE_txt.Show();
                Email_txt.Text = email;
                Email_txt.Show();
                FName_txt.Text = fname;
                FName_txt.Show();
                LName_txt.Text = lname;
                LName_txt.Show();
                Line7_lbl.Location = new Point(3, 269);
                Edit_btn.Text      = "Done";
            }
            else
            {
                OracleCommand c = new OracleCommand();
                c.Connection  = con;
                c.CommandText = "updateAccount";
                c.CommandType = CommandType.StoredProcedure;
                c.Parameters.Add("ussn", ssn);
                c.Parameters.Add("ufname", FName_txt.Text);
                c.Parameters.Add("ulname", LName_txt.Text);
                c.Parameters.Add("uemail", Email_txt.Text);
                c.Parameters.Add("upassword", PasswordE_txt.Text);
                c.Parameters.Add("uusername", UserNameE_txt.Text);
                c.ExecuteNonQuery();


                OracleCommand cc = new OracleCommand();
                cc.Connection  = con;
                cc.CommandText = "deleteInterests";
                cc.CommandType = CommandType.StoredProcedure;
                cc.Parameters.Add("ussn", ssn);
                cc.ExecuteNonQuery();

                OracleCommand ccc = new OracleCommand();
                ccc.Connection  = con;
                ccc.CommandText = "insertIntersts";
                ccc.CommandType = CommandType.StoredProcedure;

                for (int i = 0; i < Intr.Count; i++)
                {
                    ccc.Parameters.Clear();
                    ccc.Parameters.Add("ussn", ssn);
                    ccc.Parameters.Add("intrest", Intr[i]);
                    ccc.ExecuteNonQuery();
                }
                MessageBox.Show("Account Updated");

                interestAE_cmbo.Hide();
                InterestsAE_lbl.Hide();
                UserNameE_txt.Hide();
                PasswordE_txt.Hide();
                Email_txt.Hide();
                FName_txt.Hide();
                LName_txt.Hide();
                Line7_lbl.Location = new Point(3, 232);
                Edit_btn.Text      = "Edit Info";
            }
        }