private void SaveItem()
{
if (!Page.IsValid)
{
return;
}
// get form data
SqlUser item = new SqlUser();
item.Id = PanelRequest.ItemID;
item.PackageId = PanelSecurity.PackageId;
item.Name = usernameControl.Text;
item.Password = passwordControl.Password;
List <string> databases = new List <string>();
foreach (ListItem li in dlDatabases.Items)
{
if (li.Selected)
{
databases.Add(li.Value);
}
}
item.Databases = databases.ToArray();
// get other props
IDatabaseEditUserControl ctrl = (IDatabaseEditUserControl)providerControl.Controls[0];
ctrl.SaveItem(item);
if (PanelRequest.ItemID == 0)
{
// new item
try
{
int result = ES.Services.DatabaseServers.AddSqlUser(item, SqlDatabases.GetDatabasesGroupName(Settings));
// Show an error message if the operation has failed to complete
if (result < 0)
{
ShowResultMessageWithContactForm(result);
return;
}
}
catch (Exception ex)
{
ShowErrorMessage("SQL_ADD_USER", ex);
return;
}
}
else
{
// existing item
try
{
int result = ES.Services.DatabaseServers.UpdateSqlUser(item);
// Show an error message if the operation has failed to complete
if (result < 0)
{
ShowResultMessageWithContactForm(result);
return;
}
}
catch (Exception ex)
{
ShowErrorMessage("SQL_UPDATE_USER", ex);
return;
}
}
// return
RedirectSpaceHomePage();
}
