public async Task <IActionResult> Edit(Guid id, [Bind("Id,Role,IsInactive")] SecurityRoles securityRoles)
{
if (id != securityRoles.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(securityRoles);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SecurityRolesExists(securityRoles.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(securityRoles));
}
public DomainUser(int userID) : base(userID)
{
SecurityRoles.Add(new Role {
RoleNumber = 0, RoleTitle = "None", RoleDescription = "Unknown Role"
});
SecurityAccess.Add(new Access {
AccessNumber = 0, AccessTitle = "None", AccessDescription = "No Access"
});
}
public async Task <IActionResult> Create([Bind("Id,Role,IsInactive")] SecurityRoles securityRoles)
{
if (ModelState.IsValid)
{
securityRoles.Id = Guid.NewGuid();
_context.Add(securityRoles);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(securityRoles));
}
public async Task <bool> CreateRole()
{
var roles = ApplicationRoleManager.Create(HttpContext.GetOwinContext());
foreach (string role in SecurityRoles.GetRoleList())
{
if (!await roles.RoleExistsAsync(role))
{
await roles.CreateAsync(new IdentityRole { Name = role });
}
}
return(true);
}
public async Task <IActionResult> CreateRole([Bind("RoleName")] SecurityRoles securityRoles)
{
if (ModelState.IsValid)
{
securityRoles.RoleId = Guid.NewGuid();
securityRoles.CreatedBy = new Guid(HttpContext.Session.GetString("memberId"));
securityRoles.CreatedDate = DateTime.Now;
securityRoles.EditedBy = new Guid(HttpContext.Session.GetString("memberId"));
securityRoles.EditedDate = DateTime.Now;
securityRoles.x_status = "Y";
securityRoles.RoleName = securityRoles.RoleName.Trim();
_scontext.Add(securityRoles);
SecurityRoleMenus rm1 = new SecurityRoleMenus();
rm1.RoleId = securityRoles.RoleId;
rm1.MenuId = 951000;
rm1.EditedBy = securityRoles.EditedBy;
rm1.EditedDate = securityRoles.EditedDate;
_scontext.Add(rm1);
SecurityRoleMenus rm2 = new SecurityRoleMenus();
rm2.RoleId = securityRoles.RoleId;
rm2.MenuId = 951030;
rm2.EditedBy = securityRoles.EditedBy;
rm2.EditedDate = securityRoles.EditedDate;
_scontext.Add(rm2);
SecurityRoleMenus rm3 = new SecurityRoleMenus();
rm3.RoleId = securityRoles.RoleId;
rm3.MenuId = 951040;
rm3.EditedBy = securityRoles.EditedBy;
rm3.EditedDate = securityRoles.EditedDate;
_scontext.Add(rm3);
SecurityRoleMenus rm4 = new SecurityRoleMenus();
rm4.RoleId = securityRoles.RoleId;
rm4.MenuId = 951050;
rm4.EditedBy = securityRoles.EditedBy;
rm4.EditedDate = securityRoles.EditedDate;
_scontext.Add(rm4);
try
{
await _scontext.SaveChangesAsync();
}
catch (Exception e)
{
//"Violation of UNIQUE KEY constraint 'UK_SecurityRoles'. Cannot insert duplicate key in object 'dbo.SecurityRoles'. The duplicate key value is (??????).\r\nThe statement has been terminated."
if (e.InnerException.Message.Contains("UNIQUE"))
{
return(Json(new { result = "dup", RoleName = securityRoles.RoleName }));
}
else
{
return(Json(new { result = "fail" }));
}
}
return(Json(new { result = "success" }));
}
return(Json(new { result = "fail" }));
}
static void Main(string[] args)
{
CrmSdkLibrary.Connection conn = new CrmSdkLibrary.Connection();
var myid = conn.ConnectServiceOAuth("https://test.crm5.dynamics.com", "clientid", "id", "pw", "tenantid");
#region SecurityRoles
var role = new SecurityRoles();
var privilegesRole = new Privilege();
//var list = role.RetrieveSecurityRolesList(Connection.OrgService);
//foreach (var entity in list)
//{
// Console.WriteLine($"{entity[SecurityRoles.PrimaryKeyAttribute]}({entity.Id})");
//}
//var currentPrivileges = role.RetrievePrivilegesRole(Connection.OrgService, new Guid("84e8f3e2-de6c-ea11-b817-005056a1b19b"));
////foreach (var privilege in privileges)
////{
//// Console.WriteLine($"{privilege.PrivilegeId}({privilege.Depth})");
////}
//var priv = privilegesRole.RetrievePrivileges(Connection.OrgService, currentPrivileges);
//foreach (var entity in priv)
//{
// if(entity[Privilege.PrimaryKeyAttribute].ToString().ToLower().Contains("contact"))
// Console.WriteLine($"{entity.Id}({entity[Privilege.PrimaryKeyAttribute]})");
//}
#endregion
//var allEntities = Messages.RetrieveAllEntities(Connection.OrgService);
//var uis = allEntities.Where(x => x.LogicalName.Contains("view"));
//foreach (var ui in uis)
//{
// Console.WriteLine(ui.LogicalName);
//}
////foreach (var entityMetadata in cc)
////{
//// if (entityMetadata.LogicalName.Contains("new_"))
//// {
//// Console.WriteLine(entityMetadata.LogicalName + ", " + count);
//// }
//// count++;
////}
//QueryExpression query = new QueryExpression
//{
// EntityName = "userentityuisettings",
// ColumnSet = new ColumnSet(true),
// Criteria =
// {
// Filters =
// {
// new FilterExpression
// {
// FilterOperator = LogicalOperator.And,
// Conditions =
// {
// new ConditionExpression("owninguser",
// ConditionOperator.Equal, myid),
// new ConditionExpression("recentlyviewedxml",
// ConditionOperator.NotNull)
// }
// }
// }
// }
//};
//DataCollection<Entity> result =
// Connection.OrgService.RetrieveMultiple(query).Entities;
//var qe = new QueryExpression("organizationui")
//{
// ColumnSet = new ColumnSet(true)
//};
//var ec = Connection.OrgService.RetrieveMultiple(qe);
//var views = SystemView.RetrieveViews(Connection.OrgService, "account");
//var view = views.Entities.Where(x => x["name"].ToString() == "All Accounts");
//var aa = Messages.RetrieveEntity(Connection.OrgService, "contact", EntityFilters.All);
//var b = CrmSdkLibrary.Entities.SystemView.RetrieveAttributes(Connection.OrgService,
// new Guid("{00000000-0000-0000-00aa-000010001004}"));
//var c = CrmSdkLibrary.Entities.SystemView.RetrieveView(Connection.OrgService,
// new Guid("{00000000-0000-0000-00aa-000010001004}"));
//var d = Messages.FetchXmlToQueryExpression(Connection.OrgService, c["fetchxml"].ToString());
//var converted = SqlConverter.Convert(d, c["layoutxml"].ToString());
//var dd = CrmSdkLibrary.Entities.SystemView.RetrieveAttributeMetadata(Connection.OrgService,
// new Guid("{00000000-0000-0000-00aa-000010001004}"), true);
//var Systemview = SystemView.RetrieveViews(Connection.OrgService, "account");
////var xml = new XmlDocument();
////xml.LoadXml(c["layoutxml"].ToString());
////var xnList = xml.GetElementsByTagName("cell");
////foreach (XmlNode xn in xnList)
////{
//// if (xn.Attributes != null) Console.WriteLine(xn.Attributes["name"].Value);
////}
////foreach (var entity in Systemview.Entities)
////{
//// foreach (var att in entity.Attributes)
//// {
//// Console.WriteLine($"{att.Key} : {att.Value}");
//// }
////}
Program app = new Program();
Task.WaitAll(Task.Run(async() => await app.RunAsync()));
//Console.WriteLine(converted.GenerateSql());
Console.WriteLine("(End)");
}
