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