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();
}
