private void BtnEdit_Click(object sender, RoutedEventArgs e)
{
if (controlsEnabled == false)
{
controlsEnabled = EnableControls();
btnEdit.Content = "Save Changes";
btnBack.Content = "Cancel";
}
else
{
MessageBoxResult result = MessageBox.Show("Save Changes?", "Confirmation", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
int role;
string queryEditUserData = string.Format(
"BEGIN TRAN; " +
"UPDATE users_information " +
"SET " +
"fname = @fname, " +
"lname = @lname " +
"WHERE " +
"emp_id = @emp_id; " +
"UPDATE users " +
"SET " +
"role_id = @role_id " +
"WHERE " +
"emp_id = @emp_id; " +
"COMMIT;");
if (isRbAdmin.IsChecked == true)
{
role = 1;
}
else
{
role = 2;
}
if (SqlQueries.EditUserData(queryEditUserData, Convert.ToInt32(txtEmpID.Text), role, txtFName.Text, txtLName.Text) == true)
{
MessageBox.Show("Edit Complete");
main.Load_ActiveUsers();
this.Close();
}
else
{
MessageBox.Show("Something went wrong");
}
}
}
}
