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(); }
public void ClearAllDisableBox() { tenDaiLy_txt.Clear(); diaChi_txt.Clear(); dt_txt.Clear(); Email_txt.Clear(); }
public void ClearTextBox() { Name_txt.Clear(); Address_txt.Clear(); Company_txt.Clear(); Contact_txt.Clear(); Email_txt.Clear(); }
private void Add_Click(object sender, EventArgs e) { //if (emp.Verify_User_ID(User_ID.Text).Rows.Count == 0) //{ try { emp.add_user(ID_txt.Text, Name_txt.Text, password_txt.Text, permission_combo.Text, Address_txt.Text, Email_txt.Text, isLogged_txt.Text); MessageBox.Show("The user was successfully added to the database!", "Adding user", MessageBoxButtons.OK, MessageBoxIcon.Information); ID_txt.Clear(); Name_txt.Clear(); password_txt.Clear(); Address_txt.Clear(); Email_txt.Clear(); permission_combo.Text = ""; }catch (Exception exp) { exp.ToString(); } //} //else // MessageBox.Show("This user already exist in database!", "Adding user", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); }
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"; } }