protected override void OnLoad(EventArgs e)
{
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)));
}
SqlDatabase database = SqlDatabase.CurrentDatabase(server);
RolesGrid.DataSource = database.DatabaseRoles;
RolesGrid.DataBind();
//CreateRoleLink.NavigateUrl = "CreateDatabaseRole.aspx?database=" + Server.UrlEncode(Request["database"]);
server.Disconnect();
}
base.OnLoad(e);
}
protected void UsersGrid_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
UsersGrid.Selection.UnselectAll();
if (RolesGrid.FocusedRowIndex > -1)
{
Master.UserObject.ListRoleUsers((int)RolesGrid.GetRowValues(RolesGrid.FocusedRowIndex, "ID")).ForEach(u =>
{
UsersGrid.Selection.SelectRow(UsersGrid.FindVisibleIndexByKeyValue(u.ID.ToString()));
});
}
}
protected void PermissionsTree_CustomCallback(object sender, DevExpress.Web.ASPxTreeList.TreeListCustomCallbackEventArgs e)
{
PermissionsTree.UnselectAll();
if (RolesGrid.FocusedRowIndex > -1)
{
new Permission().ListRolePermissions((int)RolesGrid.GetRowValues(RolesGrid.FocusedRowIndex, "ID")).ForEach(p =>
{
PermissionsTree.FindNodeByKeyValue(p.ID.ToString()).Selected = true;
});
}
}
protected void RolesGrid_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
RolesGrid.Selection.UnselectAll();
if (PermissionsTree.FocusedNode != null)
{
new Role().ListPermissionRoles((int)PermissionsTree.FocusedNode.GetValue("ID")).ForEach(r =>
{
RolesGrid.Selection.SelectRow(RolesGrid.FindVisibleIndexByKeyValue(r.ID.ToString()));
});
}
}
protected void RolesGrid_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
RolesGrid.Selection.UnselectAll();
if (UsersGrid.FocusedRowIndex > -1)
{
new Role().ListUserRoles((long)UsersGrid.GetRowValues(UsersGrid.FocusedRowIndex, "ID")).ForEach(r =>
{
RolesGrid.Selection.SelectRow(RolesGrid.FindVisibleIndexByKeyValue(r.ID.ToString()));
});
}
}
//protected HyperLink CreateRoleLink;
protected override void OnLoad(EventArgs e)
{
if (!Page.IsPostBack)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
SqlDatabase database = SqlDatabase.CurrentDatabase(server);
RolesGrid.DataSource = database.DatabaseRoles;
RolesGrid.DataBind();
//CreateRoleLink.NavigateUrl="CreateDatabaseRole.aspx?database=" + Request["database"];
server.Disconnect();
}
base.OnLoad(e);
}
void Save()
{
StringBuilder sb = new StringBuilder();
sb.Append("<data>")
.AppendFormat("<user_id>{0}</user_id>", UsersGrid.GetRowValues(UsersGrid.FocusedRowIndex, "ID"))
.Append("<roles>");
RolesGrid.GetSelectedFieldValues("ID").ToList().ForEach(r => sb.AppendFormat("<role><id>{0}</id></role>", r));
sb.Append("</roles><permissions>");
PermissionsTree.GetSelectedNodes().ForEach(n => sb.AppendFormat("<permission><id>{0}</id></permission>", n.Key));
sb.Append("</permissions></data>");
//System.IO.File.WriteAllText(AppDomain.CurrentDomain.BaseDirectory + "file.xml", xml);
Master.UserObject.TX_UM(0, sb.ToString());
if (Master.UserObject.IsError)
{
throw new Exception(General.Utilities.GetMessage("Abort"));
}
}
private void BindRoleList()
{
rolesArray = Roles.GetAllRoles();
RolesGrid.DataSource = rolesArray;
RolesGrid.DataBind();
}
public void RolesGridDataBind()
{
RolesGrid.DataBind();
}
