public static ClientDataSet.EntityFieldDataTable GetEntityField(Guid entityFieldId, Guid organizationId)
{
using (EntityFieldTableAdapter adapter = new EntityFieldTableAdapter(OrganizationProvider.GetConnectionString(organizationId)))
{
return(adapter.GetEntityField(entityFieldId));
}
}
public static void DeleteEntityField(Guid entityFieldId, Guid organizationId)
{
using (EntityFieldTableAdapter adapter = new EntityFieldTableAdapter(OrganizationProvider.GetConnectionString(organizationId)))
{
adapter.Delete(entityFieldId);
}
RemoveFromCache();
}
public async Task <IActionResult> AuthorSearch(AuthorSearchRequestViewModel viewModel)
{
if (!ModelState.IsValid)
{
return(View(viewModel));
}
var authorSearchRequest = viewModel.AuthorSearchRequest;
var organizationAlternativeNames = OrganizationProvider.GetAlternativeNames(authorSearchRequest.Organization);
var possibleOrganizations = new List <string>();
if (!string.IsNullOrEmpty(authorSearchRequest.Organization))
{
possibleOrganizations.Add(authorSearchRequest.Organization);
possibleOrganizations.AddRange(organizationAlternativeNames);
}
var profiles = new List <AuthorSearchResult>(await PageParser.GetProfilesFromAuthorSearch(authorSearchRequest.NameSurname, authorSearchRequest.NumberOfRecords, possibleOrganizations));
IEnumerable <AuthorSearchResult> orderedProfiles = new List <AuthorSearchResult>();
if (!string.IsNullOrEmpty(authorSearchRequest.Keywords))
{
var correlationProfiles = new Dictionary <AuthorSearchResult, double>();
var lsa = new LSA(authorSearchRequest.Keywords, profiles.Select(a => string.Join("; ", a.Publications.Select(p => p.Name))));
var correlations = new List <CorrelationItem>(lsa.GetCorrelations());
for (var i = 0; i < profiles.Count(); i++)
{
correlationProfiles.Add(profiles[i], correlations[i].Value);
}
var orderedCorrelationProfiles = correlationProfiles.OrderByDescending(k => k.Value).ToDictionary(pair => pair.Key, pair => pair.Value);
orderedProfiles = orderedCorrelationProfiles.Keys;
}
else
{
orderedProfiles = profiles.OrderByDescending(p => p.HIndex);
}
return(View("AuthorSearchResults", new AuthorSearchResultsViewModel
{
Authors = orderedProfiles,
PublicationActivity = viewModel.PublicationActivity,
IsNum1 = viewModel.IsNum1,
IsNum2 = viewModel.IsNum2
}));
}
public static Guid InsertEntityField(int entityFieldTypeId, string name, string description, int dataTypeId, string defaultValue
, bool allowDBNull, bool unique, int maxLength, string minValue, string maxValue, int decimalDigits, int orderNumber
, Guid entityId, Guid organizationId, Guid?instanceId, bool active)
{
ClientDataSet.EntityFieldDataTable table = new ClientDataSet.EntityFieldDataTable();
ClientDataSet.EntityFieldRow row = table.NewEntityFieldRow();
row.EntityFieldId = Guid.NewGuid();
row.EntityFieldTypeId = entityFieldTypeId;
row.Name = name;
row.Description = description;
row.DataTypeId = dataTypeId;
if ((EntityFieldType)entityFieldTypeId == EntityFieldType.Value)
{
row.DefaultValue = defaultValue;
}
row.AllowDBNull = allowDBNull;
row.Unique = unique;
row.MaxLength = maxLength;
if (minValue != null)
{
row.MinValue = minValue;
}
if (maxValue != null)
{
row.MaxValue = maxValue;
}
row.DecimalDigits = decimalDigits;
row.OrderNumber = orderNumber;
row.EntityId = entityId;
row.OrganizationId = organizationId;
if (instanceId.HasValue)
{
row.InstanceId = instanceId.Value;
}
row.Active = active;
table.AddEntityFieldRow(row);
using (EntityFieldTableAdapter adapter = new EntityFieldTableAdapter(OrganizationProvider.GetConnectionString(organizationId)))
{
adapter.Update(row);
}
RemoveFromCache();
return(row.EntityFieldId);
}
public static ClientDataSet.EntityFieldDataTable GetEntityFields(Guid entityId, Guid organizationId, Guid?instanceId, bool?active)
{
ClientDataSet.EntityFieldDataTable table = null;
using (EntityFieldTableAdapter adapter = new EntityFieldTableAdapter(OrganizationProvider.GetConnectionString(organizationId)))
{
table = adapter.GetEntityFields(entityId, organizationId, instanceId, active);
}
if (!FrameworkConfiguration.Current.WebApplication.EnableMultipleInstances)
{
foreach (ClientDataSet.EntityFieldRow row in table.Select(string.Format(CultureInfo.InvariantCulture, "{0} IS NOT NULL", table.InstanceIdColumn.ColumnName)))
{
table.RemoveEntityFieldRow(table.FindByEntityFieldId(row.EntityFieldId));
}
table.AcceptChanges();
}
return(table);
}
