private void Grdview_role_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (grdview_role.Columns[e.ColumnIndex].Name != "DisplayName")
{
return;
}
//get the current column details
SortOrder sortOrder = getSortOrder(e.ColumnIndex, grdview_role);
PrivilegeSets.Sort(new PrivilegeComparer(sortOrder));
grdview_role.DataSource = null;
grdview_role.DataSource = PrivilegeSets;
grdview_role.Columns[e.ColumnIndex].HeaderCell.SortGlyphDirection = sortOrder;
InitTableGrid();
}
private void BtnExport_D365_Click(object sender, EventArgs e)
{
if (PrivilegeSets.Count == 0)
{
MessageBox.Show("Please select a role first", "Select Role", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var package = new ExcelPackage();
// Create the configured tabs
foreach (SecurityTab tab in D365Tabs)
{
var wkSheet = package.Workbook.Worksheets.Add(tab.TabName);
wkSheet.Cells[1, 1].Value = "Name";
wkSheet.Cells[1, 2].Value = "Create";
wkSheet.Cells[1, 3].Value = "Read";
wkSheet.Cells[1, 4].Value = "Write";
wkSheet.Cells[1, 5].Value = "Delete";
wkSheet.Cells[1, 6].Value = "Append";
wkSheet.Cells[1, 7].Value = "Append To";
wkSheet.Cells[1, 8].Value = "Assign";
wkSheet.Cells[1, 9].Value = "Share";
PrivilegeSets.Sort(new PrivilegeComparer(SortOrder.Ascending));
int rowCount = 1;
foreach (PrivilegeSet privilegeSet in PrivilegeSets.Where(ps => tab.tables.Contains(ps.Name)))
{
rowCount++;
wkSheet.Cells[rowCount, 1].Value = chkLocalised.Checked ? privilegeSet.DisplayName : privilegeSet.Name;
wkSheet.Cells[rowCount, 2].Value = privilegeSet.Create?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 3].Value = privilegeSet.Read?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 4].Value = privilegeSet.Write?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 5].Value = privilegeSet.Delete?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 6].Value = privilegeSet.Append?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 7].Value = privilegeSet.AppendTo?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 8].Value = privilegeSet.Assign?.Tag ?? string.Empty;
wkSheet.Cells[rowCount, 9].Value = privilegeSet.Share?.Tag ?? string.Empty;
}
foreach (MisPrivilegeSet mps in MisPrivilegeSets.Where(mp => tab.miscPrivs.Contains(mp.Name)))
{
rowCount++;
wkSheet.Cells[rowCount, 1].Value = chkLocalised.Checked ? mps.DisplayName : mps.Name;
wkSheet.Cells[rowCount, 2].Value = mps.Role?.Tag ?? string.Empty;
}
var tabTable = wkSheet.Tables.Add(wkSheet.Cells[1, 1, rowCount, 9], tab.TabName.Replace(" ", string.Empty) + "Tables");
tabTable.TableStyle = TableStyles.Medium3;
tabTable.ShowHeader = true;
tabTable.ShowRowStripes = true;
wkSheet.Cells.AutoFitColumns();
}
// Create BPF Tab
var wkBPF = package.Workbook.Worksheets.Add("Business Process Flows");
wkBPF.Cells[1, 1].Value = "Name";
wkBPF.Cells[1, 2].Value = "Create";
wkBPF.Cells[1, 3].Value = "Read";
wkBPF.Cells[1, 4].Value = "Write";
wkBPF.Cells[1, 5].Value = "Delete";
wkBPF.Cells[1, 6].Value = "Append";
wkBPF.Cells[1, 7].Value = "Append To";
int rowCountBPF = 1;
foreach (PrivilegeSet privSet in PrivilegeSets.Where(ps => BPFs.Contains(ps.Name)))
{
rowCountBPF++;
wkBPF.Cells[rowCountBPF, 1].Value = chkLocalised.Checked ? privSet.DisplayName : privSet.Name;
wkBPF.Cells[rowCountBPF, 2].Value = privSet.Create?.Tag ?? string.Empty;
wkBPF.Cells[rowCountBPF, 3].Value = privSet.Read?.Tag ?? string.Empty;
wkBPF.Cells[rowCountBPF, 4].Value = privSet.Write?.Tag ?? string.Empty;
wkBPF.Cells[rowCountBPF, 5].Value = privSet.Delete?.Tag ?? string.Empty;
wkBPF.Cells[rowCountBPF, 6].Value = privSet.Append?.Tag ?? string.Empty;
wkBPF.Cells[rowCountBPF, 7].Value = privSet.AppendTo?.Tag ?? string.Empty;
}
var bpfTable = wkBPF.Tables.Add(wkBPF.Cells[1, 1, rowCountBPF, 7], "BPFTables");
bpfTable.TableStyle = TableStyles.Medium3;
bpfTable.ShowHeader = true;
bpfTable.ShowRowStripes = true;
wkBPF.Cells.AutoFitColumns();
// Create CustomEntities
var wkShtCustom = package.Workbook.Worksheets.Add("Custom Entities");
wkShtCustom.Cells[1, 1].Value = "Name";
wkShtCustom.Cells[1, 2].Value = "Create";
wkShtCustom.Cells[1, 3].Value = "Read";
wkShtCustom.Cells[1, 4].Value = "Write";
wkShtCustom.Cells[1, 5].Value = "Delete";
wkShtCustom.Cells[1, 6].Value = "Append";
wkShtCustom.Cells[1, 7].Value = "Append To";
wkShtCustom.Cells[1, 8].Value = "Assign";
wkShtCustom.Cells[1, 9].Value = "Share";
PrivilegeSets.Sort(new PrivilegeComparer(SortOrder.Ascending));
int rowCountCustom = 1;
foreach (PrivilegeSet privilegeSet in PrivilegeSets.Where(ps => !NonCustom.Contains(ps.Name)))
{
rowCountCustom++;
wkShtCustom.Cells[rowCountCustom, 1].Value = chkLocalised.Checked ? privilegeSet.DisplayName : privilegeSet.Name;
wkShtCustom.Cells[rowCountCustom, 2].Value = privilegeSet.Create?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 3].Value = privilegeSet.Read?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 4].Value = privilegeSet.Write?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 5].Value = privilegeSet.Delete?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 6].Value = privilegeSet.Append?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 7].Value = privilegeSet.AppendTo?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 8].Value = privilegeSet.Assign?.Tag ?? string.Empty;
wkShtCustom.Cells[rowCountCustom, 9].Value = privilegeSet.Share?.Tag ?? string.Empty;
}
var custTable = wkShtCustom.Tables.Add(wkShtCustom.Cells[1, 1, rowCountCustom, 9], "CustomTables");
custTable.TableStyle = TableStyles.Medium3;
custTable.ShowHeader = true;
custTable.ShowRowStripes = true;
wkShtCustom.Cells.AutoFitColumns();
var fileName = saveExcel(((SecurityRole)drp_roles.SelectedItem).Name);
if (fileName == null)
{
return;
}
try
{
package.SaveAs(new FileInfo(fileName));
}
catch (Exception exc)
{
MessageBox.Show(exc.GetBaseException().Message, exc.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
ai.WriteEvent("Privileges Exported", PrivilegeSets.Count + MisPrivilegeSets.Count);
}