void CreateRoles(string nodeID)
{
Role role;
//Create Administrator role
role = new Role() { Name = "Administrator", Description = "Administrator Role", NodeID = nodeID, CreatedBy = ((App)Application.Current).Principal.Identity.Name, UpdatedBy = ((App)Application.Current).Principal.Identity.Name };
CommonFunctions.SaveRole(null, role, true);
//Create Editor role
role = new Role() { Name = "Editor", Description = "Editor Role", NodeID = nodeID, CreatedBy = ((App)Application.Current).Principal.Identity.Name, UpdatedBy = ((App)Application.Current).Principal.Identity.Name };
CommonFunctions.SaveRole(null, role, true);
//Create Viewer role
role = new Role() { Name = "Viewer", Description = "Viewer Role", NodeID = nodeID, CreatedBy = ((App)Application.Current).Principal.Identity.Name, UpdatedBy = ((App)Application.Current).Principal.Identity.Name };
CommonFunctions.SaveRole(null, role, true);
}
void ListBoxRoles_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (ListBoxRoles.SelectedIndex >= 0)
{
m_selectedRole = (Role)ListBoxRoles.SelectedItem;
ListBoxCurrentRoleUsers.ItemsSource = m_selectedRole.CurrentRoleUsers = CommonFunctions.GetCurrentRoleUsers(null, m_selectedRole.ID);
ListBoxCurrentRoleGroups.ItemsSource = m_selectedRole.CurrentRoleGroups = CommonFunctions.GetCurrentRoleGroups(null, m_selectedRole.ID);
ListBoxPossibleRoleUsers.ItemsSource = m_selectedRole.PossibleRoleUsers = CommonFunctions.GetPossibleRoleUsers(null, m_selectedRole.ID);
ListBoxPossibleRoleGroups.ItemsSource = m_selectedRole.PossibleRoleGroups = CommonFunctions.GetPossibleRoleGroups(null, m_selectedRole.ID);
GridManageRoles.DataContext = m_selectedRole;
m_editRoleMode = true;
ChangeRoleUserAndGroupsVisualization();
}
else
ClearRoleInformation();
}
void ClearRoleInformation()
{
m_selectedRole = null;
GridManageRoles.DataContext = new Role();
m_editRoleMode = false;
ListBoxRoles.SelectedIndex = -1;
TextBlockRoleUsersMessage.Visibility = Visibility.Collapsed;
ChangeRoleUserAndGroupsVisualization();
}
public static string SaveRole(DataConnection connection, Role role, bool isNew)
{
bool createdConnection = false;
try
{
if (connection == null)
{
connection = new DataConnection();
createdConnection = true;
}
IDbCommand command = connection.Connection.CreateCommand();
command.CommandType = CommandType.Text;
if (isNew)
command.CommandText = "Insert Into ApplicationRole (Name, Description, NodeID, UpdatedBy, UpdatedOn, CreatedBy, CreatedOn) Values (@name, @description, @nodeID, @updatedBy, @updatedOn, @createdBy, @createdOn)";
else
command.CommandText = "Update ApplicationRole Set Name = @name, Description = @description, NodeID = @nodeID, UpdatedBy = @updatedBy, UpdatedOn = @updatedOn Where ID = @id";
command.Parameters.Add(AddWithValue(command, "@name", role.Name));
command.Parameters.Add(AddWithValue(command, "@description", role.Description));
if (command.Connection.ConnectionString.Contains("Microsoft.Jet.OLEDB"))
command.Parameters.Add(AddWithValue(command, "@nodeID", "{" + role.NodeID + "}"));
else
command.Parameters.Add(AddWithValue(command, "@nodeID", role.NodeID));
command.Parameters.Add(AddWithValue(command, "@updatedBy", s_currentUser));
command.Parameters.Add(AddWithValue(command, "@updatedOn", command.Connection.ConnectionString.Contains("Microsoft.Jet.OLEDB") ? DateTime.UtcNow.Date : DateTime.UtcNow));
if (isNew)
{
command.Parameters.Add(AddWithValue(command, "@createdBy", s_currentUser));
command.Parameters.Add(AddWithValue(command, "@createdOn", command.Connection.ConnectionString.Contains("Microsoft.Jet.OLEDB") ? DateTime.UtcNow.Date : DateTime.UtcNow));
}
else
command.Parameters.Add(AddWithValue(command, "@id", role.ID));
command.ExecuteNonQuery();
return "Role Information Saved Successfully";
}
finally
{
if (createdConnection && connection != null)
connection.Dispose();
}
}