public static List <CrmName> GetViewsName(string link, string username, string password)
{
List <CrmName> viewList = new List <CrmName>();
IOrganizationService service = TryConnection(link, username, password);
if (service == null)
{
return(null);
}
else
{
QueryExpression personalViews = new QueryExpression("savedquery");
personalViews.ColumnSet = new ColumnSet("name");
EntityCollection viewCollection = new EntityCollection();
try
{
viewCollection = service.RetrieveMultiple(personalViews);
}
catch
{
throw new InvalidOperationException("Connection has failed!");
}
foreach (var c in viewCollection.Entities)
{
CrmName crmName = new CrmName
{
displayName = c["name"].ToString(),
logicalName = c["name"].ToString()
};
viewList.Add(crmName);
}
var sortedList = viewList.OrderBy(x => x.displayName).ToList();
return(sortedList);
}
}
public static List <CrmName> GetTableColumns(string link, string username, string password, string table)
{
List <CrmName> columns = new List <CrmName>();
IOrganizationService service = TryConnection(link, username, password);
if (service == null)
{
throw new InvalidOperationException("Connection has failed!");
}
else
{
RetrieveEntityRequest metaDataRequest = new RetrieveEntityRequest();
RetrieveEntityResponse metaDataResponse = new RetrieveEntityResponse();
metaDataRequest.EntityFilters = EntityFilters.Attributes;
metaDataRequest.LogicalName = table.ToLower();
metaDataResponse = (RetrieveEntityResponse)service.Execute(metaDataRequest);
var entities = metaDataResponse.EntityMetadata;
foreach (var c in entities.Attributes)
{
if (c.DisplayName.LocalizedLabels.Count() > 1)
{
CrmName crmName = new CrmName
{
displayName = c.DisplayName.UserLocalizedLabel.Label,
logicalName = c.LogicalName
};
columns.Add(crmName);
}
}
}
var sortedList = columns.OrderBy(x => x.displayName).ToList();
return(sortedList);
}
public static List <CrmName> GetTablesName(string link, string username, string password)
{
List <CrmName> tableList = new List <CrmName>();
IOrganizationService service = TryConnection(link, username, password);
if (service == null)
{
return(null);
}
else
{
RetrieveAllEntitiesRequest metaDataRequest = new RetrieveAllEntitiesRequest();
RetrieveAllEntitiesResponse metaDataResponse = new RetrieveAllEntitiesResponse();
metaDataRequest.EntityFilters = EntityFilters.Entity;
metaDataResponse = (RetrieveAllEntitiesResponse)service.Execute(metaDataRequest);
var entities = metaDataResponse.EntityMetadata;
foreach (var c in entities)
{
if (c.DisplayName.LocalizedLabels.Count() > 1)
{
CrmName crmName = new CrmName
{
displayName = c.DisplayName.UserLocalizedLabel.Label,
logicalName = c.LogicalName
};
tableList.Add(crmName);
}
}
var sortedList = tableList.OrderBy(x => x.displayName).ToList();
return(sortedList);
}
}
