public void OpenAuthorizationWindow()
{
Views.Authorization authorization = new Views.Authorization();
authorization.Show();
foreach (Window window in App.Current.Windows)
{
// если окно - объект Registration
if (window is Views.Registration)
{
window.Close();
}
}
}
public void DeleteUserProfile()
{
using (SqlConnection dbConn = new SqlConnection())
{
dbConn.ConnectionString = ConfigurationManager.ConnectionStrings["YourPianoConnection"].ConnectionString;
dbConn.Open();
SqlTransaction transaction = dbConn.BeginTransaction();
SqlCommand command = dbConn.CreateCommand();
command.Transaction = transaction;
try
{
string sqlExpression = $"delete ProgressInfo where userID = '{CurrentUser.userID}'";
command.CommandText = sqlExpression;
command.ExecuteNonQuery();
sqlExpression = $"delete NoteSequence where ID in (select ActionInfo.noteSecuence from ActionInfo where userID = {CurrentUser.userID})";
command.CommandText = sqlExpression;
command.ExecuteNonQuery();
sqlExpression = $"delete UserInfo where username = '******'";
command.CommandText = sqlExpression;
command.ExecuteNonQuery();
// подтверждаем транзакцию
transaction.Commit();
MessageBox.Show("Пользователь успешно удален");
foreach (Window window in App.Current.Windows)
{
// если окно - объект MainWindow
if (window is Views.MainWindow)
{
window.Close();
}
} //закрытие текущего окна
Views.Authorization auth = new Views.Authorization();
auth.Show();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
transaction.Rollback();
}
finally { dbConn.Close(); }
}
}