private string FormatFieldValue(DataRow article, string value, Field field, IReadOnlyDictionary <string, Dictionary <int, string> > valuesWithRelation) { if (value.Contains("\"")) { value = value.Replace("\"", "\"\""); } if (field != null && !string.IsNullOrEmpty(value)) { if (field.Type.DbType == DbType.String || field.Type.DbType == DbType.StringFixedLength) { value = $"\"{value}\""; } else if (field.ExactType == FieldExactTypes.Boolean) { value = MultistepActionHelper.BoolFormat(value); } else if (field.Type.DbType == DbType.Date || field.Type.DbType == DbType.DateTime || field.Type.DbType == DbType.DateTime2) { value = MultistepActionHelper.DateCultureFormat(value, CultureInfo.CurrentCulture.Name, _settings.Culture); } else if ((field.Type.DbType == DbType.Double || field.Type.DbType == DbType.Decimal) && field.RelationType != RelationType.ManyToMany) { value = MultistepActionHelper.NumericCultureFormat(value, CultureInfo.CurrentCulture.Name, _settings.Culture); if (value.Contains(_settings.Delimiter)) { value = $"\"{value}\""; } } } if (field != null && (field.RelationType == RelationType.ManyToMany || field.RelationType == RelationType.ManyToOne)) { value = string.Empty; var mapValue = field.RelationType == RelationType.ManyToMany ? field.LinkId.Value.ToString() : article["content_Item_id"] + "_" + field.Id; if (valuesWithRelation.TryGetValue(mapValue, out var mappings) && mappings.Any()) { var key = field.ContentId == _contentId ? IdentifierFieldName : string.Format(FieldNameHeaderTemplate, field.Content.Name, IdentifierFieldName); if (int.TryParse(article[key].ToString(), out var id)) { if (mappings.TryGetValue(id, out var items)) { value = items.Replace(",", ";"); } } } value = $"\"{value}\""; } if (string.IsNullOrEmpty(value) || value == "\"\"") { value = "NULL"; } return(value); }
private void FormatFieldValue(Field field, string value, ref FieldValue fieldDbValue) { switch (field.ExactType) { case FieldExactTypes.Numeric: fieldDbValue.Value = MultistepActionHelper.NumericCultureFormat(value, _importSettings.Culture, "en-US"); break; case FieldExactTypes.Date: fieldDbValue.Value = MultistepActionHelper.DateCultureFormat(value, _importSettings.Culture, "en-US"); break; case FieldExactTypes.Time: fieldDbValue.Value = MultistepActionHelper.DateCultureFormat(value, _importSettings.Culture, "en-US"); break; case FieldExactTypes.DateTime: fieldDbValue.Value = MultistepActionHelper.DateCultureFormat(value, _importSettings.Culture, "en-US"); break; case FieldExactTypes.O2MRelation: fieldDbValue.Value = MultistepActionHelper.O2MFormat(value); break; case FieldExactTypes.M2MRelation: fieldDbValue.NewRelatedItems = MultistepActionHelper.M2MFormat(value).ToArray(); fieldDbValue.Value = field.LinkId?.ToString(); break; case FieldExactTypes.M2ORelation: break; default: fieldDbValue.Value = value; break; } }