public static void TestInitialize(TestContext context)
{
Initialize();
//Setting the FUNCTION privileges for user
var userToExport = MDSWrapper.UserSecurityPrincipalsGet(UserToExport).Users.FirstOrDefault();
}
public void GetModels()
{
Cursor.Current = Cursors.WaitCursor;
try
{
List <Model> modelList = MDSWrapper.ModelGet();
this.cbModel.Items.Clear();
if (modelList != null && modelList.Count > 0)
{
foreach (MdmDataContractOfIdentifier contractOfIdentifier in modelList)
{
this.cbModel.Items.Add((object)contractOfIdentifier.Identifier);
}
this.cbModel.DisplayMember = "Name";
}
else
{
this.lblError.Text = "can't retrieve models or no models to display";
}
}
catch (Exception ex)
{
this.lblError.Text = ex.Message;
throw ex;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void DisplayMembers(Identifier modelId, CustomVersion versionId, CustomEntity entity, string searchTerm)
{
try
{
if (modelId == null || versionId == null || entity == null)
{
return;
}
List <Member> members = MDSWrapper.GetMembers(modelId, versionId.Identifier, entity, searchTerm);
this.lstMembers.Items.Clear();
(this.FindForm() as Form1).ProgressBar.Maximum = members.Count;
foreach (Member m in members)
{
((ListBox.ObjectCollection) this.lstMembers.Items).Add((object)new CustomMember(m));
(this.FindForm() as Form1).ProgressBar.PerformStep();
}
this.lstMembers.DisplayMember = this.rbNameCode.Checked ? "NameCode" : "CodeName";
(this.FindForm() as Form1).ProgressBar.Value = 0;
//this.lblCntMembers.Text = this.lstMembers.Items.Count.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
public void SecurityPrincipalsImportTest()
{
var userToExport = MDSWrapper.UserSecurityPrincipalsGet(UserToExport);
Assert.IsTrue(userToExport != null & userToExport.Users.Any(), "No security principals returned! Connection: " + MDSWrapper.Configuration.EndpointAddress);
var fileName = String.Format(global::Common.Constants.StringFormatUserPrincipals, userToExport.Users.FirstOrDefault().Identifier.Id);
MDSWrapper.SecurityPrincipalsExport(Path.Combine(folderToExport, fileName), new SecurityInformation(userToExport.Users));
//switching to another environment
var config = ConfigurationManager.AppSettings;
MDSWrapper.Configuration = new ConfigValue("MDS Local 2", config.Get("Domain"), config.Get("UserName"), config.Get("Password"), new Uri("http://localhost:82/Service/service.svc"), BindingType.WSHttpBinding);
MDSWrapper.SecurityPrincipalsImport(Path.Combine(folderToExport, fileName), PrincipalType.UserAccount, SecurityPrincipalsOptions.ExcludeAllPrivileges, false);
var principals = MDSWrapper.UserSecurityPrincipalsGet(UserToExport);
var importedUser = principals.Users.FirstOrDefault();
//checking if the principal exists in the 2nd environment
Assert.IsTrue(importedUser.Identifier.Name == importedUser.Identifier.Name, "The user identifier does not match the expected result");
Assert.IsTrue(importedUser.SecurityPrivilege.FunctionPrivileges.Count == 0, "The function privileges were not copied correctly");
Assert.IsTrue(importedUser.SecurityPrivilege.ModelPrivileges.Count == 0, "The model privileges were not copied correctly");
Assert.IsTrue(importedUser.SecurityPrivilege.HierarchyMemberPrivileges.Count == 0, "The hierarc privileges were not copied correctly");
//Deleting the user
MDSWrapper.SecurityPrincipalsDelete(principals, PrincipalType.UserAccount);
}
public void DisplayDerivedHierarchies(Identifier modelId)
{
try
{
Cursor.Current = Cursors.WaitCursor;
Metadata metadata = new Metadata();
OperationResult or = new OperationResult();
Metadata metaData = MDSWrapper.GetMetaData(new International(), ref or, modelId, (Identifier)null, (Identifier)null, MDAction.DerivedHierarchiesOnly);
if (metaData == null)
{
return;
}
this.lstDerivedHierarchies.Items.Clear();
(this.FindForm() as Form1).ProgressBar.Maximum = metaData.DerivedHierarchies.Count;
foreach (MdmDataContractOfModelContextIdentifier contextIdentifier in metaData.DerivedHierarchies)
{
this.lstDerivedHierarchies.Items.Add((object)contextIdentifier.Identifier);
(this.FindForm() as Form1).ProgressBar.PerformStep();
}
this.lstDerivedHierarchies.DisplayMember = "Name";
(this.FindForm() as Form1).ProgressBar.Value = 0;
this.initialDHlist = Enumerable.ToList <Identifier>(Enumerable.Cast <Identifier>((IEnumerable)this.lstDerivedHierarchies.Items));
}
catch (Exception ex)
{
this.lblError.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void LoadSecurityPrincipals()
{
try
{
Cursor.Current = Cursors.WaitCursor;
var users = MDSWrapper.UserSecurityPrincipalsGet();
lstUsers.Items.Clear();
foreach (User u in users.Users)
{
this.lstUsers.Items.Add(new CustomUser(u));
}
//Note the security principals are server-level objects, not model specific
var groups = MDSWrapper.GroupSecurityPrincipalsGet();
lstGroups.Items.Clear();
foreach (Group group in groups.Groups)
{
this.lstGroups.Items.Add(new CustomGroup(group));
}
}
catch (Exception ex)
{
statusStrip1.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btExportXML_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
saveFileDialog1.Filter = "XML files|*.xml";
if (this.saveFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
var users = MDSWrapper.UserSecurityPrincipalsGet();
var groups = MDSWrapper.GroupSecurityPrincipalsGet();
var securityinfo = new SecurityInformation(users.Users, groups.Groups);
MDSWrapper.SecurityPrincipalsExport(this.saveFileDialog1.FileName, securityinfo);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void GetModelByNameTest()
{
var model = MDSWrapper.GetModelByName(modelName, global::Common.MDSService.ResultType.Identifiers);
Trace.Write(model.Identifier.Name);
Assert.IsNotNull(model);
Assert.IsTrue(model.Identifier.Name.Equals(modelName));
}
public void UserSecurityPrincipalsGet()
{
var model = MDSWrapper.GetModelByName(modelName, global::Common.MDSService.ResultType.Identifiers);
var userToExport = MDSWrapper.UserSecurityPrincipalsGet(UserToExport);
Assert.IsTrue(userToExport != null);
Assert.IsTrue(userToExport.Users.Count == 1);
Assert.IsTrue(userToExport.Users.FirstOrDefault().Identifier.Name.Equals(UserToExport, StringComparison.InvariantCultureIgnoreCase));
}
private void cbModel_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.cbModel.SelectedItem == null)
{
return;
}
OperationResult or = new OperationResult();
this.DisplayVersions(MDSWrapper.GetMetaData(new International(), ref or, this.cbModel.SelectedItem as Identifier, (Identifier)null, (Identifier)null, MDAction.VersionsOnly));
}
public void GroupSecurityPrincipalsGetTest()
{
//var model = _wrapper.GetModelByName(modelName, global::Common.MDSService.ResultType.Identifiers);
var users = MDSWrapper.GroupSecurityPrincipalsGet();
Trace.Write("Groups from instance:");
foreach (User user in users.Users)
{
Trace.Write(user.DisplayName);
}
Assert.IsNotNull(users.Users);
}
public void SecurityPrincipalsExportTest()
{
var userToExport = MDSWrapper.UserSecurityPrincipalsGet(UserToExport);
Assert.IsTrue(userToExport != null && userToExport.Users.Any(), "No security principals returned! Connection: " + MDSWrapper.Configuration.EndpointAddress);
var fileName = String.Format(global::Common.Constants.StringFormatUserPrincipals, userToExport.Users.FirstOrDefault().Identifier.Id);
MDSWrapper.SecurityPrincipalsExport(Path.Combine(folderToExport, fileName), new SecurityInformation(userToExport.Users));
Assert.IsTrue(File.Exists(Path.Combine(folderToExport, fileName)));
//File.Delete(Path.Combine(folderToExport, fileName));
}
public static List <Identifier> GetDBAEntities(Identifier modelId, Identifier customVersionId, Entity ent)
{
List <Entity> collection = new List <Entity>();
OperationResult or = new OperationResult();
Metadata metaData = MDSWrapper.GetMetaData(new International(), ref or, modelId, customVersionId, (Identifier)ent.Identifier, MDAction.EntitiesOnly);
if (metaData != null)
{
return(CustomEntity.GetChildDBAEntitiesId(modelId, customVersionId, metaData));
}
return((List <Identifier>)null);
}
public void ExportSecurityPrivilegesTest()
{
var model = MDSWrapper.GetModelByName(modelName, global::Common.MDSService.ResultType.Identifiers);
var userToExport = MDSWrapper.UserSecurityPrincipalsGet(UserToExport);
Assert.IsTrue(userToExport != null && userToExport.Users.Any(), "No security principals returned! Connection: " + MDSWrapper.Configuration.EndpointAddress);
var fileName = String.Format(global::Common.Constants.StringFormatUserPrivileges, userToExport.Users.FirstOrDefault().Identifier.Id);
MDSWrapper.SecurityPrivilegesExport(model.Identifier, folderToExport, fileName, userToExport.Users.FirstOrDefault());
Assert.IsTrue(File.Exists(Path.Combine(folderToExport, fileName)));
//File.Delete(Path.Combine(folderToExport, fileName));
}
public void DisplayEntities(Identifier modelId, Identifier versionId = null)
{
try
{
Cursor.Current = Cursors.WaitCursor;
Metadata metadata = new Metadata();
OperationResult or = new OperationResult();
Metadata metaData = MDSWrapper.GetMetaData(new International(), ref or, modelId, (Identifier)null, (Identifier)null, MDAction.EntitiesOnly);
if (metaData == null)
{
return;
}
this.lstEntities.Items.Clear();
Form1 form1 = this.FindForm() as Form1;
//Using the progress bar requires using the asyncmethods
//if (form1 != null)
//{
// form1.progressBar1.Maximum = metaData.Entities.Count;
// form1.progressBar1.Update();
//}
foreach (Entity e in metaData.Entities)
{
this.lstEntities.Items.Add((object)new CustomEntity(e, versionId));
//if (form1 != null)
//{
// form1.progressBar1.PerformStep();
// form1.progressBar1.Update();
//}
}
this.lstEntities.DisplayMember = "Name";
//if (form1 != null)
//{
// form1.progressBar1.Value = 0;
// form1.progressBar1.Update();
//}
this.initialEntitylist = Enumerable.ToList <CustomEntity>(Enumerable.Cast <CustomEntity>((IEnumerable)this.lstEntities.Items));
}
catch (Exception ex)
{
this.lblError.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btExportGroupPrivileges_Click(object sender, EventArgs e)
{
MDSWrapper mdsWrapper = null;
try
{
Cursor.Current = Cursors.WaitCursor;
if (this.cbModel.SelectedItem != null)
{
if (this.folderBrowserDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
var modelId = this.cbModel.SelectedItem as Identifier;
var path = this.folderBrowserDialog1.SelectedPath;
if (lstGroups.SelectedItem != null)
{
var fileName = String.Format(Constants.StringFormatGroupPrivileges, (lstGroups.SelectedItem as Group).Identifier.InternalId);
MDSWrapper.SecurityPrivilegesExport(modelId, path, fileName, lstGroups.SelectedItem as Group);
}
if (MessageBox.Show("Group principals successfully exported to " + path.Replace("\\\\", "\\") + "\r\nDo you want to open the destination folder ?", "Yes or No", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
Process.Start("explorer.exe", path);
}
}
else
{
MessageBox.Show("Please select a model first");
}
}
catch (Exception ex)
{
statusStrip1.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
if (mdsWrapper != null)
{
mdsWrapper.Dispose();
}
}
}
private void btUserPrivilegesExport_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
if (this.cbModel.SelectedItem == null)
{
MessageBox.Show("Please select a model first.");
return;
}
if (lstUsers.SelectedItem == null)
{
MessageBox.Show("Please select a user.");
return;
}
if (this.folderBrowserDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
var modelId = this.cbModel.SelectedItem as Identifier;
var path = this.folderBrowserDialog1.SelectedPath;
if (lstUsers.SelectedItem == null)
{
return;
}
var user = (CustomUser)lstUsers.SelectedItem;
MDSWrapper.SecurityPrivilegesExport(modelId, path, String.Format(Constants.StringFormatUserPrivileges, user.Identifier.InternalId), user);
if (MessageBox.Show("User privileges for " + user.Identifier.Name + " successfully exported to " + path.Replace("\\\\", "\\") + "\r\nDo you want to open the destination folder ?", "Yes or No", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
Process.Start("explorer.exe", path);
}
}
catch (Exception ex)
{
statusStrip1.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void cbConnection_SelectedIndexChanged(object sender, EventArgs e)
{
var config = (sender as ComboBox).SelectedItem as ConfigValue;
if (config != null)
{
//using a hack to open the XML file instead of the connection.
if (String.IsNullOrEmpty(config.EndpointAddress))
{
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
BusinessRules businessRules;
try
{
businessRules = MDSWrapper.BusinessRuleDeserialize(openFileDialog1.FileName);
}
catch (MDSManagerException exc)
{
MessageBox.Show(exc.Message);
return;
}
var dataSet = MDSDataUtils.NewBusinessRuleDataTable();
foreach (BusinessRule businessRule in businessRules.BusinessRulesMember)
{
MDSDataUtils.NewBRDataRow(dataSet, businessRule);
}
if ((sender as ComboBox) == cbConnection.ComboBox)
{
dgRules.DataSource = dataSet;
}
if ((sender as ComboBox) == cbConnection2.ComboBox)
{
businessRules2 = businessRules;
dgRules2.DataSource = dataSet;
}
}
}
else
{
MDSWrapper.Configuration = config;
RefreshPermissionsList(sender);
}
}
}
public static void CreateEntity(string ModelName, string newEntityName)
{
OperationResult OperationResult = new OperationResult();
Metadata Metadata = new Metadata();
Identifier identifier = new Identifier()
{
Name = ModelName
};
Metadata.Entities = new List <Entity>();
List <Entity> entities = Metadata.Entities;
Entity entity1 = new Entity();
Entity entity2 = entity1;
EntityContextIdentifier contextIdentifier1 = new EntityContextIdentifier();
contextIdentifier1.Name = newEntityName;
contextIdentifier1.ModelId = identifier;
EntityContextIdentifier contextIdentifier2 = contextIdentifier1;
entity2.Identifier = (ModelContextIdentifier)contextIdentifier2;
entity1.IsFlat = true;
Entity entity3 = entity1;
List <ExplicitHierarchy> collection1 = new List <ExplicitHierarchy>();
List <ExplicitHierarchy> collection2 = collection1;
ExplicitHierarchy explicitHierarchy1 = new ExplicitHierarchy();
ExplicitHierarchy explicitHierarchy2 = explicitHierarchy1;
EntityContextIdentifier contextIdentifier3 = new EntityContextIdentifier();
contextIdentifier3.ModelId = identifier;
contextIdentifier3.Name = newEntityName;
EntityContextIdentifier contextIdentifier4 = contextIdentifier3;
explicitHierarchy2.Identifier = contextIdentifier4;
ExplicitHierarchy explicitHierarchy3 = explicitHierarchy1;
collection2.Add(explicitHierarchy3);
List <ExplicitHierarchy> collection3 = collection1;
entity3.ExplicitHierarchies = collection3;
Entity entity4 = entity1;
entities.Add(entity4);
MDSWrapper.MetadataCreate(Metadata, true);
}
void ConfigureView()
{
// Update the user interface for the detail item
if (IsViewLoaded && DetailItem != null)
{
detailDescriptionLabel.Text = DetailItem.ToString();
var myDel = new MySimpleCBCentralManagerDelegate();
var myMgr = new CBCentralManager(myDel, DispatchQueue.CurrentQueue);
System.Threading.Thread.Sleep(200);
MDSWrapper wrapper = new MDSWrapper();
MDSResponseBlock block = new MDSResponseBlock(async(arg0) => DoThing(arg0, wrapper));
MDSEventBlock eventBlock = (MDSEvent arg0) => DoTheOtherThing(arg0, wrapper);
wrapper.DoSubscribe("MDS/ConnectedDevices", new Foundation.NSDictionary(), block, eventBlock);
}
}
public static void TestInitialize(TestContext context)
{
Initialize();
//Setting the FUNCTION privileges for user
var userToExport = MDSWrapper.UserSecurityPrincipalsGet(UserToExport).Users.FirstOrDefault();
var functionPriv = new List <FunctionPrivilege> {
new FunctionPrivilege {
Function = FunctionalArea.SystemAdministration, IsAuthorized = true, PrincipalId = userToExport.Identifier, PrincipalType = PrincipalType.UserAccount
},
new FunctionPrivilege {
Function = FunctionalArea.Versions, IsAuthorized = true, PrincipalId = userToExport.Identifier, PrincipalType = PrincipalType.UserAccount
}
};
var securityPrivilege = userToExport.SecurityPrivilege;
securityPrivilege.FunctionPrivileges = functionPriv;
var result = MDSWrapper.SecurityPrivilegesCreate(securityPrivilege);
}
public void DoTheOtherThing(MDSEvent anEvent, MDSWrapper wrapper)
{
System.Diagnostics.Debug.WriteLine("Mooooo ");
var m = anEvent.BodyDictionary.ValueForKey(new NSString("Method"));
System.Diagnostics.Debug.WriteLine(m);
var serial = anEvent.BodyDictionary.ValueForKey(new NSString("Body")).ValueForKey(new NSString("Serial")).ToString();
//if (!serial.EndsWith("08")) return;
//var body = new NSDictionary();
var ledOn = NSDictionary.FromObjectsAndKeys(new object[] {
true,
0
}, new object[] {
"IsOn",
"LedColor"
});
var body = NSDictionary.FromObjectAndKey(ledOn, new NSString("LedState"));
//wrapper.DoGet(String.Format("{0}/Component/Leds", serial), new NSDictionary(), (resp) =>
//{
// wrapper.DisconnectPeripheralWithUUID(new Foundation.NSUuid("4CC5B0ED-08A0-C062-B1C2-B4B91D6B254A"));
//});
wrapper.DoPut(String.Format("{0}/Component/Leds/0", serial), body, (arg0) =>
{
System.Diagnostics.Debug.WriteLine("YOU SHOULD SEE THE LIGHT!!!!");
wrapper.DisconnectPeripheralWithUUID(new Foundation.NSUuid("4CC5B0ED-08A0-C062-B1C2-B4B91D6B254A"));
});
//wrapper.DoGet(String.Format("{0}/Time", serial), new NSDictionary(),
//(arg0) =>
//{
// System.Diagnostics.Debug.WriteLine("Response" + arg0.BodyDictionary.ValueForKey(new NSString("Content")).ToString());
// wrapper.DisconnectPeripheralWithUUID(new Foundation.NSUuid("4CC5B0ED-08A0-C062-B1C2-B4B91D6B254A"));
//});
}
private void btImportUR_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
if (this.openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
MDSWrapper.SecurityPrincipalsImport(openFileDialog1.FileName, PrincipalType.UserAccount, SecurityPrincipalsOptions.ExcludeAllPrivileges, false);
}
catch (Exception ex)
{
statusStrip1.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void DisplayAttributes()
{
try
{
Cursor.Current = Cursors.WaitCursor;
OperationResult or = new OperationResult();
Form1 form1 = this.FindForm() as Form1;
CustomEntity customEntity = ((ucManageEntities)form1.FilterControlsOne(c => c is ucManageEntities)).lstEntities.SelectedItem as CustomEntity;
if (customEntity == null || customEntity.entityId == null)
{
return;
}
Metadata metaData = MDSWrapper.GetMetaData(new International(), ref or, (Identifier)form1.lstModels.SelectedItem, ((CustomVersion)form1.lstVersions.SelectedItem).Identifier, (Identifier)customEntity.entityId, MDAction.AttributesOnly);
object selectedItem = this.lstAttributes.SelectedItem;
int selectedIndex = this.lstAttributes.SelectedIndex;
this.lstAttributes.Items.Clear();
form1.ProgressBar.Maximum = metaData.Attributes.Count;
foreach (MetadataAttribute attribute in metaData.Attributes)
{
this.lstAttributes.Items.Add((object)new CustomMetaDataAttribute(attribute));
form1.ProgressBar.PerformStep();
}
form1.ProgressBar.Value = 0;
this.lstAttributes.DisplayMember = this.rbNameType.Checked ? "NameType" : "TypeName";
//this.lstAttributes.Items.Count.ToString();
if (this.IsAttributeExists(selectedItem as CustomMetaDataAttribute, this.lstAttributes.Items))
{
this.lstAttributes.SelectedIndex = selectedIndex;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btExportGroups_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
if (cbModel.SelectedItem != null)
{
if (folderBrowserDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
//SecurityPrincipals are instance-level
//var modelId = this.cbModel.SelectedItem as Identifier;
var path = folderBrowserDialog1.SelectedPath;
MDSWrapper.SecurityPrincipalsExport(Path.Combine(path, String.Format(Constants.StringFormatGroupPrincipals, MDSWrapper.Configuration.ConfigName.Replace(' ', '_'))), PrincipalType.Group);
if (MessageBox.Show("Group principals successfully exported to " + path.Replace("\\\\", "\\") + "\r\nDo you want to open the destination folder ?", "Yes or No", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
Process.Start("explorer.exe", path);
}
}
else
{
MessageBox.Show("Please select a model first");
}
}
catch (Exception ex)
{
statusStrip1.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void GetModels()
{
try
{
List <Model> modelList = MDSWrapper.ModelGet();
this.cbModel.Items.Clear();
if (modelList != null && modelList.Count > 0)
{
foreach (MdmDataContractOfIdentifier contractOfIdentifier in modelList)
{
this.cbModel.Items.Add((object)contractOfIdentifier.Identifier);
}
this.cbModel.DisplayMember = "Name";
}
else
{
statusStrip1.Text = "can't retrieve models or no models to display";
}
}
catch (Exception exc)
{
statusStrip1.Text = exc.Message;
}
}
public void DoThing(MDSResponse arg0, MDSWrapper wrapper)
{
System.Diagnostics.Debug.WriteLine("I have been called: " + arg0.StatusCode);
wrapper.ConnectPeripheralWithUUID(new Foundation.NSUuid("4CC5B0ED-08A0-C062-B1C2-B4B91D6B254A"));
}
private void RefreshPermissionsList(object sender)
{
try
{
DataGridView ruleDataGrid = null;
if (sender == cbConnection.ComboBox)
{
ruleDataGrid = dgRules;
}
if (sender == cbConnection2.ComboBox)
{
ruleDataGrid = dgRules2;
}
Cursor.Current = Cursors.WaitCursor;
var dataSet = MDSDataUtils.NewPermissionDataTable();
var users = MDSWrapper.UserSecurityPrincipalsGet();
foreach (var user in users.Users)
{
foreach (var modelPrivilege in user.SecurityPrivilege.ModelPrivileges)
{
MDSDataUtils.NewPermissionDataRow(dataSet, user.Identifier, modelPrivilege);
}
foreach (var hierarchPrivilege in user.SecurityPrivilege.HierarchyMemberPrivileges)
{
MDSDataUtils.NewPermissionDataRow(dataSet, user.Identifier, hierarchPrivilege);
}
}
var groups = MDSWrapper.GroupSecurityPrincipalsGet();
foreach (var group in groups.Groups)
{
foreach (var modelPrivilege in group.SecurityPrivilege.ModelPrivileges)
{
MDSDataUtils.NewPermissionDataRow(dataSet, group.Identifier, modelPrivilege);
}
foreach (var hierarchPrivilege in group.SecurityPrivilege.HierarchyMemberPrivileges)
{
MDSDataUtils.NewPermissionDataRow(dataSet, group.Identifier, hierarchPrivilege);
}
}
ruleDataGrid.DataSource = dataSet;
//hiding the column ID
ruleDataGrid.Columns[0].Visible = false;
btExport.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void CheckIfServiceUp()
{
Cursor.Current = Cursors.WaitCursor;
MDSWrapper.CheckIfServiceUp();
}
private void btExportDiagram_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
try
{
System.Data.SqlClient.SqlConnectionStringBuilder builder = null;
if (rbUseSingleConString.Checked && !string.IsNullOrWhiteSpace(txtSingleConString.Text))
{
builder = new System.Data.SqlClient.SqlConnectionStringBuilder(txtSingleConString.Text);
this.cbDataSource.Text = builder.DataSource;
this.cbInitialCatalog.Text = builder.InitialCatalog;
this.txtAttachDbFilename.Text = builder.AttachDBFilename;
}
else
if (rbUseConStringElements.Checked)
{
builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.AttachDBFilename = txtAttachDbFilename.Text;
builder.DataSource = cbDataSource.Text;
builder.InitialCatalog = cbInitialCatalog.Text;
this.txtSingleConString.Text = builder.ConnectionString;
}
if (!string.IsNullOrEmpty(this.cbDataSource.Text) && !string.IsNullOrEmpty(this.txtModellingDb.Text))
{
if (this.cbModel.SelectedItem != null)
{
this.txtDefaultSchema.Text = string.IsNullOrEmpty(this.txtDefaultSchema.Text) ? "dbo" : this.txtDefaultSchema.Text;
if (this.chkDropExistingDB.Checked)
{
try
{
MDSModelling.DropExistingDb(txtSingleConString.Text, txtModellingDb.Text);
}
catch (Exception ex)
{
this.lblError.Text = ex.Message + ";" + ex.InnerException != null ? ex.InnerException.Message : "";
}
}
if (this.ckCreateDb.Checked)
{
try
{
MDSModelling.CreateNewDb(txtSingleConString.Text, txtModellingDb.Text);
}
catch (Exception ex)
{
this.lblError.Text = ex.Message + ";" + ex.InnerException != null ? ex.InnerException.Message : "";
}
}
foreach (CustomEntity customEntity in this.ucManageEntities1.lstEntities.Items)
{
MDSModelling.CreateTable(txtSingleConString.Text, customEntity.Name, txtAttachDbFilename.Text, txtModellingDb.Text, this.txtDefaultSchema.Text);
}
foreach (CustomEntity customEntity in this.ucManageEntities1.lstEntities.Items)
{
OperationResult or = new OperationResult();
Metadata metaData = MDSWrapper.GetMetaData(new International(), ref or, (Identifier)this.cbModel.SelectedItem, ((CustomVersion)this.cbVersion.SelectedItem).Identifier, (Identifier)customEntity.entityId, MDAction.AttributesOnly);
if (metaData != null)
{
foreach (MetadataAttribute att in metaData.Attributes)
{
AttributeType?attributeType = att.AttributeType;
if ((attributeType.GetValueOrDefault() != AttributeType.Domain ? 0 : (attributeType.HasValue ? 1 : 0)) != 0)
{
MDSModelling.CreateRelationShips(this.cbDataSource.Text, this.cbInitialCatalog.Text, this.txtModellingDb.Text, att.DomainEntityId.Name, att.Identifier.EntityId.Name);
}
else
{
MDSModelling.AddColumn(txtSingleConString.Text, this.txtModellingDb.Text, customEntity.Name, att);
}
}
}
}
}
else
{
this.lblError.Text = "You must select a model first!";
}
}
else
{
this.lblError.Text = "You must enter a data source, an initial catalog and a modelling database name or a connection string!";
}
}
catch (Exception ex)
{
this.lblError.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
