private void BindItem()
{
string policyName = (SqlDatabases.GetDatabasesGroupName(Settings).ToLower().StartsWith("mssql"))
? UserSettings.MSSQL_POLICY : UserSettings.MYSQL_POLICY;
try
{
if (!IsPostBack)
{
// load item if required
if (PanelRequest.ItemID > 0)
{
// existing item
try
{
item = ES.Services.DatabaseServers.GetSqlUser(PanelRequest.ItemID);
}
catch (Exception ex)
{
ShowErrorMessage("SQL_GET_USER", ex);
return;
}
if (item != null)
{
// save package info
ViewState["PackageId"] = item.PackageId;
usernameControl.SetPackagePolicy(item.PackageId, policyName, "UserNamePolicy");
passwordControl.SetPackagePolicy(item.PackageId, policyName, "UserPasswordPolicy");
BindDatabases(item.PackageId);
}
else
{
RedirectToBrowsePage();
}
}
else
{
// new item
ViewState["PackageId"] = PanelSecurity.PackageId;
usernameControl.SetPackagePolicy(PanelSecurity.PackageId, policyName, "UserNamePolicy");
passwordControl.SetPackagePolicy(PanelSecurity.PackageId, policyName, "UserPasswordPolicy");
BindDatabases(PanelSecurity.PackageId);
}
}
// load provider control
LoadProviderControl((int)ViewState["PackageId"], SqlDatabases.GetDatabasesGroupName(Settings),
providerControl, "EditUser.ascx");
IDatabaseEditUserControl ctrl = (IDatabaseEditUserControl)providerControl.Controls[0];
ctrl.InitControl(SqlDatabases.GetDatabasesGroupName(Settings));
if (!IsPostBack)
{
// bind item to controls
if (item != null)
{
// bind item to controls
usernameControl.Text = item.Name;
usernameControl.EditMode = true;
passwordControl.EditMode = true;
foreach (string database in item.Databases)
{
foreach (ListItem li in dlDatabases.Items)
{
if (String.Compare(database, li.Value, true) == 0)
{
li.Selected = true;
break;
}
}
}
// other controls
ctrl.BindItem(item);
}
}
}
catch
{
ShowWarningMessage("INIT_SERVICE_ITEM_FORM");
DisableFormControls(this, btnCancel);
return;
}
}
