private void saveButton_Click(object sender, EventArgs e) { string sqlCommand = "UPDATE All_Users " + "SET userType = @usrType" + (oldPassTextBox.Modified ? ", pass = @newPass" : string.Empty) + (nameTextBox.Modified ? ", name = @name" : string.Empty) + (surnameTextBox.Modified ? ", surname = @surname" : string.Empty) + (titleTextBox.Modified ? ", title = @title" : string.Empty) + (officeTextBox.Modified ? ", office = @office" : string.Empty) + (telephoneTextBox.Modified ? ", phone = @phone" : string.Empty) + (mailTextBox.Modified ? ", mail = @mail" : string.Empty) + " WHERE username = @usrName"; // create command SqlCommand sql = new SqlCommand(sqlCommand, parent.Connection); sql.Parameters.Add(new SqlParameter("@usrName", usernameTextBox.Text)); if (oldPassTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@newPass", newPassTextBox.Text)); } sql.Parameters.Add(new SqlParameter("@usrType", typeComboBox.Text)); if (nameTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@name", nameTextBox.Text)); } if (surnameTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@surname", surnameTextBox.Text)); } if (titleTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@title", titleTextBox.Text)); } if (officeTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@office", officeTextBox.Text)); } if (telephoneTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@phone", telephoneTextBox.Text)); } if (mailTextBox.Modified) { sql.Parameters.Add(new SqlParameter("@mail", mailTextBox.Text)); } sql.ExecuteNonQuery(); // if user info tab selected if (parent.baseTabControl.SelectedIndex == 0) { parent.fillUserInfo(); } if (parent is AdminApplication) { ((AdminApplication)parent).refreshAllUsersTabPage(); if (parent.Username.Equals(usernameTextBox.Text)) { parent.fillUserInfo(); } } this.clearAllComponents(); this.Hide(); }