1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
namespace WebFormsRelyingParty {
using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DotNetOpenAuth.OpenId;
using DotNetOpenAuth.OpenId.RelyingParty;
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
public partial class Setup : System.Web.UI.Page {
private bool databaseCreated;
protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
openidLogin.Focus();
}
}
protected void openidLogin_LoggingIn(object sender, OpenIdEventArgs e) {
// We don't actually want to log in... we just want the claimed identifier.
e.Cancel = true;
if (e.IsDirectedIdentity) {
noOPIdentifierLabel.Visible = true;
} else if (!databaseCreated) {
this.CreateDatabase(e.ClaimedIdentifier, openidLogin.Text);
this.MultiView1.ActiveViewIndex = 1;
// indicate we have already created the database so that if the
// identifier the user gave has multiple service endpoints,
// we won't try to recreate the database as the next one is considered.
databaseCreated = true;
}
}
private void CreateDatabase(Identifier claimedId, string friendlyId) {
const string SqlFormat = @"
CREATE DATABASE [{0}] ON (NAME='{0}', FILENAME='{0}')
GO
USE ""{0}""
GO
{1}
EXEC [dbo].[AddUser] 'admin', 'admin', '{2}', '{3}'
GO
";
string databasePath = HttpContext.Current.Server.MapPath("~/App_Data/Database.mdf");
string schemaSql = File.ReadAllText(HttpContext.Current.Server.MapPath("~/Admin/CreateDatabase.sql"));
string sql = string.Format(CultureInfo.InvariantCulture, SqlFormat, databasePath, schemaSql, claimedId, friendlyId);
var serverConnection = new ServerConnection(".\\sqlexpress");
try {
serverConnection.ExecuteNonQuery(sql);
var server = new Server(serverConnection);
server.DetachDatabase(databasePath, true);
} finally {
serverConnection.Disconnect();
}
}
}
}
|
