/// <summary> /// When the client select the user that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding /// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with /// the data of the selected user. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSelect_Click(object sender, EventArgs e) { Guidelbl.Hide(); CmbUser.Hide(); BtnSelect.Hide(); label1.Show(); label2.Show(); label3.Show(); label4.Show(); label5.Show(); label6.Show(); TbxFirstName.Show(); TbxLastName.Show(); TbxUsername.Show(); TbxTelephone.Show(); TbxEmail.Show(); CmbTypes.Show(); BtnEdit.Show(); SelectedData = DCom.GetData(String.Format(SqlExec, CmbUser.SelectedValue)); TbxFirstName.Text = (string)SelectedData.Rows[0]["First_Name"]; TbxLastName.Text = (string)SelectedData.Rows[0]["Last_Name"]; TbxUsername.Text = (string)SelectedData.Rows[0]["Username"]; TbxEmail.Text = (string)SelectedData.Rows[0]["Email"]; TbxTelephone.Text = (string)SelectedData.Rows[0]["Telephone"]; DataTable GetUserType = DCom.GetData(String.Format("SELECT users_types.Type FROM users, users_types WHERE users.Username='******' and users.Type=users_types.Type", CmbUser.SelectedValue)); CmbTypes.DataSource = DCom.GetData("SELECT * FROM users_types"); CmbTypes.DisplayMember = "Type"; CmbTypes.ValueMember = "Type"; CmbTypes.Text = (string)GetUserType.Rows[0]["Type"]; }
// clear the text fields private void ClearTextFields() { TbxFirstName.Clear(); TbxLastName.Clear(); TbxStreetAddress.Clear(); TbxCity.Clear(); CbxState.SelectedIndex = 0; MtbZipCode.Clear(); MtbPhone.Clear(); }
// add button click listener private void BtnAddCustomer_Click(object sender, EventArgs e) { ClearError(); if (FirstNameIsValid(out var firtname) & LastNameIsValid(out var lastName) & AddressIsValid(out var address) & CityIsValid(out var city) & StateIsValid(out var state) & ZipCodeIsValid(out var zipCode) & PhoneIsValid(out var phone)) { customer.Add(new ClassCustomer(firtname, lastName, address, city, state, zipCode, phone)); MessageBox.Show($@"{firtname} {lastName} has been successfully added to the list."); ClearTextFields(); TbxFirstName.Focus(); } }
/// <summary> /// In forms constructor the not necessarily labels, tetxboxes and comboboxes are hiding /// from the form. Then the combobox for users(CmbUser) is filling with the usernames and NAMES /// from table users. /// </summary> public EditUser() { InitializeComponent(); label1.Hide(); label2.Hide(); label3.Hide(); label4.Hide(); label5.Hide(); label6.Hide(); TbxFirstName.Hide(); TbxLastName.Hide(); TbxUsername.Hide(); TbxTelephone.Hide(); TbxEmail.Hide(); CmbTypes.Hide(); BtnEdit.Hide(); CmbUser.DataSource = DCom.GetData("SELECT Username,CONCAT(Last_name,' ' , First_Name) AS NAME FROM users"); CmbUser.DisplayMember = "NAME"; CmbUser.ValueMember = "Username"; }