private static void GetUsedPicklistInEntity(Guid tenantId, List <Entities.EntityCore.Model.PickListItem.PicklistObject> simpleNonCustomizable, List <FieldModel> fields, List <MappedItem> val) { IPicklistManager iPicklistManager = new PicklistManager(); foreach (var field in fields) { var matchingField = simpleNonCustomizable.FirstOrDefault(t => t.Name.ToLower().Equals(field.TypeOf.ToLower())); if (matchingField != null) { var values = iPicklistManager.GetPicklistValues(tenantId, matchingField.Name, null); if (values != null && values.Rows.Count > 0) { var mappedItem = new MappedItem(); mappedItem.Name = field.Name; mappedItem.TypeOf = field.TypeOf; mappedItem.Result = values; val.Add(mappedItem); } } } }
public DataTable MapResult(Guid tenantId, string entityName, DataTable source, QueryContext queryModel) { if (source == null || source.Rows.Count == 0) { return(source); } IMetadataManager iMetadataManager = new MetadataManager.Contracts.MetadataManager(); var subTypes = iMetadataManager.GetSubTypesDetails(entityName); IPicklistManager iPicklistManager = new PicklistManager(); var picklists = iPicklistManager.GetAllPicklists(tenantId); var simpleNonCustomizable = picklists.Where(t => !t.CustomizeValue).ToList(); if (!simpleNonCustomizable.Any()) { return(source); } var entity = iMetadataManager.GetEntitityByName(entityName); List <MappedItem> val = new List <MappedItem>(); if (entity.Fields != null && entity.Fields.Any()) { GetUsedPicklistInEntity(tenantId, simpleNonCustomizable, entity.Fields, val); } if (entity.VersionControl != null && entity.VersionControl.Fields != null && entity.VersionControl.Fields.Any()) { GetUsedPicklistInEntity(tenantId, simpleNonCustomizable, entity.VersionControl.Fields, val); } DataTable dtClone = source.Clone(); //just copy structure, no data for (int i = 0; i < dtClone.Columns.Count; i++) { if (dtClone.Columns[i].DataType != typeof(string)) { dtClone.Columns[i].DataType = typeof(string); } } foreach (DataRow dr in source.Rows) { dtClone.ImportRow(dr); } var customFields = new List <FieldModel>(); // string[] userQuery = null; if (queryModel.Fields != null && queryModel.Fields.Any()) { var entityDetails = iMetadataManager.GetEntitityByName(entityName); if (entityDetails?.Fields != null && entityDetails.Fields.Any()) { var userQuery = queryModel?.Fields?.Split(','); foreach (var clientField in userQuery) { var match = entityDetails.Fields.FirstOrDefault(t => t.Name.ToLower().Equals(clientField.ToString().ToLower()) && !string.IsNullOrEmpty(t.Context) && !string.IsNullOrEmpty(t.ContextType)); if (match != null) { if (match.ContextType.Equals("CustomServerFieldBase")) { dtClone.Columns.Add(match.Name, typeof(string)); customFields.Add(match); } else if (match.ContextType.Equals("CustomClientFieldBase")) { DataColumn client = new DataColumn(match.Name, typeof(string)); // client.DefaultValue = match.Context; dtClone.Columns.Add(client); } } } } } foreach (DataRow item in dtClone.Rows) { try { var subType = item["SubType"]; var mapped = subTypes.FirstOrDefault(t => t.Key.Equals(subType)); if (mapped.Key != null) { item["SubType"] = mapped.Value.ToString(); } foreach (var data in val) { if (item.Table.Columns.Contains(data.Name.ToLower())) { if (data.Result != null && data.Result.Rows.Count > 0) { var actualValue = item[data.Name].ToString(); DataRow[] rowsData = data.Result.Select(); for (int i = 0; i < rowsData.Length; i++) { var existenceValue = rowsData[i]["InternalId"]; if (actualValue.ToString().ToLower().Equals(existenceValue.ToString().ToLower())) { var text = rowsData[i]["Text"].ToString(); item[data.Name] = text.ToString(); } } } } } //------------------------- custom client field if (customFields.Any()) { foreach (var cf in customFields) { if (item.Table.Columns.Contains(cf.Name)) { var conditions = new Dictionary <string, string>(); //conditions.Add ("InternalId", item["InternalId"].ToString ()); var id = Guid.Parse(item["InternalId"].ToString()); item[cf.Name] = GetCustomFieldValue(id, cf.Context, conditions); } } } } catch { //digest exceptions } } } return(dtClone); }
public DataTable GetCustomField(Guid tenantId, string entityName, DataTable source, QueryContext queryModel) { if (source == null || source.Rows.Count == 0) { return(source); } IMetadataManager iMetadataManager = new MetadataManager.Contracts.MetadataManager(); var subTypes = iMetadataManager.GetSubTypesDetails(entityName); IPicklistManager iPicklistManager = new PicklistManager(); var entity = iMetadataManager.GetEntitityByName(entityName); List <MappedItem> val = new List <MappedItem> (); var customFields = new List <FieldModel> (); // string[] userQuery = null; if (queryModel.Fields != null && queryModel.Fields.Any()) { var entityDetails = iMetadataManager.GetEntitityByName(entityName); if (entityDetails?.Fields != null && entityDetails.Fields.Any()) { var userQuery = queryModel?.Fields?.Split(','); foreach (var clientField in userQuery) { var match = entityDetails.Fields.FirstOrDefault(t => t.Name.ToLower().Equals(clientField.ToString().ToLower()) && !string.IsNullOrEmpty(t.Context) && !string.IsNullOrEmpty(t.ContextType)); if (match != null) { if (match.ContextType.Equals("CustomServerFieldBase")) { source.Columns.Add(match.Name, typeof(string)); customFields.Add(match); } else if (match.ContextType.Equals("CustomClientFieldBase")) { DataColumn client = new DataColumn(match.Name, typeof(string)); // client.DefaultValue = match.Context; source.Columns.Add(client); } } } } } foreach (DataRow item in source.Rows) { try { if (customFields.Any()) { foreach (var cf in customFields) { if (item.Table.Columns.Contains(cf.Name)) { var conditions = new Dictionary <string, string> (); var id = Guid.Parse(item["InternalId"].ToString()); item[cf.Name] = GetCustomFieldValue(id, cf.Context, conditions); } } } } catch { //digest exceptions } } } return(source); }