protected void Page_Load(object sender, System.EventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
try
{
server.Connect();
}
catch (System.Exception ex)
{
//Response.Redirect("Error.aspx?errorPassCode=" + 2002);
Response.Redirect(String.Format("error.aspx?errormsg={0}&stacktrace={1}", Server.UrlEncode(ex.Message), Server.UrlEncode(ex.StackTrace)));
}
SqlDatabaseCollection databases = server.Databases;
server.Disconnect();
// Clear out list and populate with database names
if (!IsPostBack)
{
ExportDatabaseList.Items.Clear();
for (int i = 0; i < databases.Count; i++)
{
ExportDatabaseList.Items.Add(new ListItem(databases[i].Name));
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
try
{
server.Connect();
}
catch (System.Exception ex)
{
//Response.Redirect("Error.aspx?errorPassCode=" + 2002);
Response.Redirect(String.Format("error.aspx?errormsg={0}&stacktrace={1}", Server.UrlEncode(ex.Message), Server.UrlEncode(ex.StackTrace)));
}
SqlDatabaseCollection databases = server.Databases;
server.Disconnect();
// Create DataSet from list of databases
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("name");
ds.Tables[0].Columns.Add("encodedname");
ds.Tables[0].Columns.Add("size");
for (int i = 0; i < databases.Count; i++)
{
SqlDatabase database = databases[i];
ds.Tables[0].Rows.Add(new object[] { Server.HtmlEncode(database.Name), Server.UrlEncode(database.Name), database.Size == -1 ? "Unknown" : String.Format("{0}MB", database.Size) });
}
DatabasesDataGrid.DataSource = ds;
DatabasesDataGrid.DataBind();
}
private void txtPassword_TextChanged(object sender, System.EventArgs e)
{
SqlServer server = new SqlServer(this.txtServer.Text, this.txtUserName.Text, this.txtPassword.Text);
server.Connect();
SqlDatabaseCollection databases = server.Databases;
server.Disconnect();
// Clear out list and populate with database names
for (int i = 0; i < databases.Count; i++)
{
ExportDatabaseList.Items.Add(databases[i].Name);
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
SqlDatabaseCollection databases = server.Databases;
server.Disconnect();
// Clear out list and populate with database names
if (!IsPostBack)
{
ExportDatabaseList.Items.Clear();
for (int i = 0; i < databases.Count; i++)
{
ExportDatabaseList.Items.Add(new ListItem(databases[i].Name));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
SqlDatabaseCollection databases = server.Databases;
server.Disconnect();
// Create DataSet from list of databases
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("name");
ds.Tables[0].Columns.Add("encodedname");
ds.Tables[0].Columns.Add("size");
for (int i = 0; i < databases.Count; i++)
{
SqlDatabase database = databases[i];
ds.Tables[0].Rows.Add(new object[] { Server.HtmlEncode(database.Name), Server.UrlEncode(database.Name), database.Size == -1 ? "Unknown" : String.Format("{0}MB", database.Size) });
}
DatabasesDataGrid.DataSource = ds;
DatabasesDataGrid.DataBind();
}
protected override void OnLoad(EventArgs e)
{
if (Request["Login"] == null)
Response.Redirect("CreateLogin.aspx");
LoginLabel.Text = Request["Login"].ToUpper();
if (!Page.IsPostBack)
{
SqlServer server = SqlServer.CurrentServer;
try
{
server.Connect();
}
catch (System.Exception ex)
{
//Response.Redirect("Error.aspx?errorPassCode=" + 2002);
Response.Redirect(String.Format("error.aspx?errormsg={0}&stacktrace={1}", Server.UrlEncode(ex.Message), Server.UrlEncode(ex.StackTrace)));
}
sqlLogin = server.Logins[Request["Login"]];
if (sqlLogin == null)
Response.Redirect("CreateLogin.aspx");
if (sqlLogin.LoginType == SqlLoginType.NTUser || sqlLogin.LoginType == SqlLoginType.NTGroup)
{
SecurityAccess.Enabled = true;
SecurityAccessLabel.Enabled = true;
if (sqlLogin.NTLoginAccessType == SqlNtAccessType.Deny)
{
SecurityAccess.Items[1].Selected = true;
}
else
{
SecurityAccess.Items[0].Selected = true;
}
}
databases = server.Databases;
DefaultDatabase.DataSource = databases;
DefaultDatabase.DataBind();
DatabaseAccessGrid.DataSource = databases;
DatabaseAccessGrid.DataBind();
// Select default database
ListItem databaseItem = DefaultDatabase.Items.FindByValue(sqlLogin.Database);
if (databaseItem != null)
{
databaseItem.Selected = true;
}
else
{
databaseItem = DefaultDatabase.Items.FindByValue("master");
if (databaseItem != null)
databaseItem.Selected = true;
}
allRoles = server.Roles;
ServerRoles.DataSource = allRoles;
ServerRoles.DataBind();
// Select member roles
foreach (ListItem item in ServerRoles.Items)
{
if (sqlLogin.IsMember(item.Value))
{
item.Selected = true;
}
}
DefaultLanguage.DataSource = server.Languages;
DefaultLanguage.DataBind();
// Select default language
ListItem languageItem = DefaultLanguage.Items.FindByValue(sqlLogin.Language);
if (languageItem != null)
{
languageItem.Selected = true;
}
else
{
languageItem = DefaultLanguage.Items.FindByValue("English");
if (languageItem != null)
languageItem.Selected = true;
}
server.Disconnect();
focusPanel(GeneralPanel);
}
base.OnLoad(e);
}
private bool Save()
{
SqlServer server = SqlServer.CurrentServer;
try
{
server.Connect();
}
catch (System.Exception ex)
{
//Response.Redirect("Error.aspx?errorPassCode=" + 2002);
Response.Redirect(String.Format("error.aspx?errormsg={0}&stacktrace={1}", Server.UrlEncode(ex.Message), Server.UrlEncode(ex.StackTrace)));
}
try
{
// Save Login settings
sqlLogin = server.Logins[Request["Login"]];
if (SecurityAccess.Enabled)
{
sqlLogin.DenyNTLogin = SecurityAccess.SelectedValue == "Deny" ? true : false;
}
sqlLogin.Database = DefaultDatabase.SelectedValue;
sqlLogin.Language = DefaultLanguage.SelectedValue;
// Save server roles
foreach (ListItem item in ServerRoles.Items)
{
if (sqlLogin.IsMember(item.Value) && !item.Selected)
{
server.Roles[item.Value].DropMember(sqlLogin.Name);
}
else if (!sqlLogin.IsMember(item.Value) && item.Selected)
{
server.Roles[item.Value].AddMember(sqlLogin.Name);
}
}
databases = server.Databases;
// Save database access
foreach (DataGridItem item in DatabaseAccessGrid.Items)
{
SqlDatabase database = databases[(string)DatabaseAccessGrid.DataKeys[item.ItemIndex]];
CheckBox cb = item.FindControl("DatabaseAccess") as CheckBox;
if (database != null && cb != null)
{
string dbName = sqlLogin.GetUserName(database.Name);
if (dbName != null && !cb.Checked)
{
database.Users[dbName].Remove();
}
else if (dbName == null && cb.Checked)
{
database.Users.Add(sqlLogin.Name, sqlLogin.Name);
}
}
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
return false;
}
finally
{
server.Disconnect();
}
return true;
}
internal static async Task <SqlDatabaseResource> CreateSqlDatabase(string name, AutoscaleSettings autoscale, SqlDatabaseCollection collection)
{
SqlDatabaseCreateUpdateData sqlDatabaseCreateUpdateOptions = new SqlDatabaseCreateUpdateData(AzureLocation.WestUS,
new Models.SqlDatabaseResource(name))
{
Options = BuildDatabaseCreateUpdateOptions(TestThroughput1, autoscale),
};
var databaseLro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, name, sqlDatabaseCreateUpdateOptions);
return(databaseLro.Value);
}
protected override void OnLoad(EventArgs e)
{
if (Request["Login"] == null)
{
Response.Redirect("CreateLogin.aspx");
}
LoginLabel.Text = Request["Login"].ToUpper();
if (!Page.IsPostBack)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
sqlLogin = server.Logins[Request["Login"]];
if (sqlLogin == null)
{
Response.Redirect("CreateLogin.aspx");
}
if (sqlLogin.LoginType == SqlLoginType.NTUser || sqlLogin.LoginType == SqlLoginType.NTGroup)
{
SecurityAccess.Enabled = true;
SecurityAccessLabel.Enabled = true;
if (sqlLogin.NTLoginAccessType == SqlNtAccessType.Deny)
{
SecurityAccess.Items[1].Selected = true;
}
else
{
SecurityAccess.Items[0].Selected = true;
}
}
databases = server.Databases;
DefaultDatabase.DataSource = databases;
DefaultDatabase.DataBind();
DatabaseAccessGrid.DataSource = databases;
DatabaseAccessGrid.DataBind();
// Select default database
ListItem databaseItem = DefaultDatabase.Items.FindByValue(sqlLogin.Database);
if (databaseItem != null)
{
databaseItem.Selected = true;
}
else
{
databaseItem = DefaultDatabase.Items.FindByValue("master");
if (databaseItem != null)
{
databaseItem.Selected = true;
}
}
allRoles = server.Roles;
ServerRoles.DataSource = allRoles;
ServerRoles.DataBind();
// Select member roles
foreach (ListItem item in ServerRoles.Items)
{
if (sqlLogin.IsMember(item.Value))
{
item.Selected = true;
}
}
DefaultLanguage.DataSource = server.Languages;
DefaultLanguage.DataBind();
// Select default language
ListItem languageItem = DefaultLanguage.Items.FindByValue(sqlLogin.Language);
if (languageItem != null)
{
languageItem.Selected = true;
}
else
{
languageItem = DefaultLanguage.Items.FindByValue("English");
if (languageItem != null)
{
languageItem.Selected = true;
}
}
server.Disconnect();
focusPanel(GeneralPanel);
}
base.OnLoad(e);
}
private bool Save()
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
try
{
// Save Login settings
sqlLogin = server.Logins[Request["Login"]];
if (SecurityAccess.Enabled)
{
sqlLogin.DenyNTLogin = SecurityAccess.SelectedValue == "Deny"?true:false;
}
sqlLogin.Database = DefaultDatabase.SelectedValue;
sqlLogin.Language = DefaultLanguage.SelectedValue;
// Save server roles
foreach (ListItem item in ServerRoles.Items)
{
if (sqlLogin.IsMember(item.Value) && !item.Selected)
{
server.Roles[item.Value].DropMember(sqlLogin.Name);
}
else if (!sqlLogin.IsMember(item.Value) && item.Selected)
{
server.Roles[item.Value].AddMember(sqlLogin.Name);
}
}
databases = server.Databases;
// Save database access
foreach (DataGridItem item in DatabaseAccessGrid.Items)
{
SqlDatabase database = databases[(string)DatabaseAccessGrid.DataKeys[item.ItemIndex]];
CheckBox cb = item.FindControl("DatabaseAccess") as CheckBox;
if (database != null && cb != null)
{
string dbName = sqlLogin.GetUserName(database.Name);
if (dbName != null && !cb.Checked)
{
database.Users[dbName].Remove();
}
else if (dbName == null && cb.Checked)
{
database.Users.Add(sqlLogin.Name, sqlLogin.Name);
}
}
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
return(false);
}
finally
{
server.Disconnect();
}
return(true);
}
public async Task WebAppSqlConnectionCRUD()
{
string resourceGroupName = Recording.GenerateAssetName("SdkRg");
string webAppName = Recording.GenerateAssetName("SdkWeb");
string sqlServerName = Recording.GenerateAssetName("SdkSql");
string sqlDatabaseName = Recording.GenerateAssetName("SdkSql");
string sqlUserName = Recording.GenerateAssetName("SdkSql");
string sqlPassword = Recording.GenerateAssetName("SdkPa5$");
string linkerName = Recording.GenerateAssetName("SdkLinker");
// create resource group
await ResourceGroups.CreateOrUpdateAsync(WaitUntil.Completed, resourceGroupName, new Resources.ResourceGroupData(DefaultLocation));
ResourceGroupResource resourceGroup = await ResourceGroups.GetAsync(resourceGroupName);
// // create web app
WebSiteCollection webSites = resourceGroup.GetWebSites();
await webSites.CreateOrUpdateAsync(WaitUntil.Completed, webAppName, new WebSiteData(DefaultLocation));
WebSiteResource webapp = await webSites.GetAsync(webAppName);
// create sql database
SqlServerCollection sqlServers = resourceGroup.GetSqlServers();
SqlServerData sqlServerData = new SqlServerData(DefaultLocation)
{
AdministratorLogin = sqlUserName,
AdministratorLoginPassword = sqlPassword,
};
await sqlServers.CreateOrUpdateAsync(WaitUntil.Completed, sqlServerName, sqlServerData);
SqlServerResource sqlServer = await sqlServers.GetAsync(sqlServerName);
SqlDatabaseCollection sqlDatabases = sqlServer.GetSqlDatabases();
await sqlDatabases.CreateOrUpdateAsync(WaitUntil.Completed, sqlDatabaseName, new SqlDatabaseData(DefaultLocation));
SqlDatabaseResource sqlDatabase = await sqlDatabases.GetAsync(sqlDatabaseName);
// create service linker
LinkerResourceCollection linkers = webapp.GetLinkerResources();
var linkerData = new LinkerResourceData
{
TargetService = new Models.AzureResource
{
Id = sqlDatabase.Id,
},
AuthInfo = new SecretAuthInfo
{
Name = sqlUserName,
SecretInfo = new ValueSecretInfo
{
Value = sqlPassword,
},
},
ClientType = ClientType.Dotnet,
};
await linkers.CreateOrUpdateAsync(WaitUntil.Completed, linkerName, linkerData);
// list service linker
var linkerResources = await linkers.GetAllAsync().ToEnumerableAsync();
Assert.AreEqual(1, linkerResources.Count);
Assert.AreEqual(linkerName, linkerResources[0].Data.Name);
// get service linker
LinkerResource linker = await linkers.GetAsync(linkerName);
Assert.IsTrue(linker.Id.ToString().StartsWith(webapp.Id.ToString(), StringComparison.InvariantCultureIgnoreCase));
Assert.AreEqual(sqlDatabase.Id.ToString(), (linker.Data.TargetService as AzureResource).Id);
Assert.AreEqual(AuthType.Secret, linker.Data.AuthInfo.AuthType);
// get service linker configurations
SourceConfigurationResult configurations = await linker.GetConfigurationsAsync();
foreach (var configuration in configurations.Configurations)
{
Assert.IsNotNull(configuration.Name);
Assert.IsNotNull(configuration.Value);
}
// delete service linker
var operation = await linker.DeleteAsync(WaitUntil.Completed);
Assert.IsTrue(operation.HasCompleted);
}
