private void CreateTest(object sender, RoutedEventArgs e) { if (test == null) { test = new Test(); testGrid.DataContext = test; } else { TestEditor editor = new TestEditor(userID, userName); editor.Show(); editor.CreateTest(editor, new RoutedEventArgs()); } }
private void AuthorizationButton_Click(object sender, RoutedEventArgs e) { string user = loginTextBox.Text; string pass = passTextBox.Password; string sqlInsert = "if not exists(select * from[User] where name=N'" + user + "') insert into[dbo].[User] ([name], [pass], [group]) VALUES(N'" + user + "', N'" + pass + "', (select FIRST_VALUE(id) OVER(Order by id) " + "from [group] where [group].[name]=N'default'))"; command = new SqlCommand(sqlInsert, connection); string sql = "select [User].id as id, [User].[name] as [name], [group].[name] as [group] " + "from [User] inner join [group] on [group].[id]=[User].[group] Where [User].[name]=N'" + user + "' and [User].[pass]=N'" + pass + "'"; usersTable = new DataTable(); command = new SqlCommand(sql, connection); adapter = new SqlDataAdapter(command); DataRow userRow; int userID; string userName; string userGroup; try { adapter.Fill(usersTable); userRow = usersTable.Rows[0]; userID = (int)userRow["id"]; userName = userRow["name"].ToString(); userGroup = userRow["group"].ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка авторизации", MessageBoxButton.OK, MessageBoxImage.Error); connection.Close(); e.Handled = false; return; } if (userGroup == "admin") { TestEditor testEditor = new TestEditor(userID, userName); Close(); testEditor.Show(); } else { TestSelection testSelection = new TestSelection(userID, userName, userGroup); Close(); testSelection.Show(); } }