/// <summary>
/// Returns data format for a data type.
/// </summary>
/// <param name="value">The value.</param>
/// <returns>
/// Data format.
/// </returns>
public FieldValueInformation GetFormattedDataValue(string value)
{
var result = new FieldValueInformation
{
Value = value,
Comment = null,
IsNumeric = true,
IsNegative = false,
IsErrorValue = false,
FormattedValue = value,
Style = Parent.Parent,
NegativeColor = Color.Empty
};
var format = GetDataFormat();
var culture = CultureInfo.CreateSpecificCulture("es-ES");
switch (Type)
{
#region Type: Currency
case KnownDataType.Currency:
var currency = (CurrencyDataTypeModel)this;
if (currency.Locale != KnownCulture.Current)
{
culture = CultureInfo.GetCultureInfo(ExportsModel.GetXmlEnumAttributeFromItem(currency.Locale));
}
var isValidNumberValue = decimal.TryParse(value.Replace('.', ','), NumberStyles.Any, culture, out var currencyValue);
if (isValidNumberValue)
{
result.Value = currencyValue;
result.FormattedValue = currencyValue.ToString(format, culture);
if (currencyValue < 0)
{
result.IsNegative = true;
result.NegativeColor = currency.Negative.GetColor();
}
}
else
{
var error = currency.Error;
result.IsErrorValue = true;
result.Value = error.Value;
result.Comment = error.Comment;
result.FormattedValue = error.Value.ToString(format, culture);
if (error.Value < 0)
{
result.IsNegative = true;
result.NegativeColor = currency.Negative.GetColor();
}
}
break;
#endregion
#region Type: DateTime
case KnownDataType.Datetime:
var datetime = (DatetimeDataTypeModel)this;
if (datetime.Locale != KnownCulture.Current)
{
culture = CultureInfo.CreateSpecificCulture(ExportsModel.GetXmlEnumAttributeFromItem(datetime.Locale));
}
result.IsNumeric = false;
var isValidDateTimeValue = DateTime.TryParse(value, out var datetimeValue);
if (isValidDateTimeValue)
{
result.Value = datetimeValue;
result.FormattedValue = datetimeValue.ToString(format, culture);
}
else
{
var error = datetime.Error;
result.IsErrorValue = true;
result.Value = error.Value;
result.Comment = error.Comment;
result.FormattedValue = error.Value;
}
break;
#endregion
#region Type: Numeric
case KnownDataType.Numeric:
var numeric = (NumericDataTypeModel)this;
var isValidNumericValue = float.TryParse(value.Replace('.', ','), NumberStyles.Any, culture, out var numericValue);
if (isValidNumericValue)
{
result.Value = numericValue;
result.FormattedValue = numericValue.ToString(format, culture);
if (numericValue < 0)
{
result.IsNegative = true;
result.NegativeColor = numeric.Negative.GetColor();
}
}
else
{
var error = numeric.Error;
result.IsErrorValue = true;
result.Value = error.Value;
result.Comment = error.Comment;
result.FormattedValue = error.Value.ToString(format, culture);
if (error.Value < 0)
{
result.IsNegative = true;
result.NegativeColor = numeric.Negative.GetColor();
}
}
break;
#endregion
#region Type: Percentage
case KnownDataType.Percentage:
var percentage = (PercentageDataTypeModel)this;
var isValidPercentageValue = float.TryParse(value, NumberStyles.Any, culture, out var percentageValue);
if (isValidPercentageValue)
{
result.IsNegative = percentageValue < 0;
result.FormattedValue = percentageValue.ToString(format, culture);
}
else
{
var error = percentage.Error;
result.IsErrorValue = true;
result.Value = error.Value;
result.Comment = error.Comment;
result.FormattedValue = error.Value.ToString(format, culture);
if (error.Value < 0)
{
result.IsNegative = true;
////result.NegativeColor = percentage.Negative.GetColor();
}
}
break;
#endregion
#region Type: Scientific
case KnownDataType.Scientific:
var scientific = (ScientificDataTypeModel)this;
var isValidScientificValue = float.TryParse(value.Replace('.', ','), NumberStyles.Any, culture, out var scientificValue);
if (isValidScientificValue)
{
result.IsNegative = scientificValue < 0;
result.FormattedValue = scientificValue.ToString(format, culture);
}
else
{
var error = scientific.Error;
result.IsErrorValue = true;
result.Value = error.Value;
result.Comment = error.Comment;
result.FormattedValue = error.Value.ToString(format, culture);
if (error.Value < 0)
{
result.IsNegative = true;
////result.NegativeColor = percentage.Negative.GetColor();
}
}
break;
#endregion
#region Type: Special
////case KnownDataType.Special:
//// var special = (SpecialDataTypeModel)this;
//// var isDateTimeValue = DateTime.TryParse(value, out datetimeValue);
//// if (isDateTimeValue)
//// {
//// result.Value = datetimeValue;
//// result.FormattedValue = datetimeValue.ToString(format);
//// }
//// else
//// {
//// var isNumericValue = float.TryParse(value.Replace('.', ','), NumberStyles.Any, culture, out numericValue);
//// if (isNumericValue)
//// {
//// result.Value = numericValue;
//// result.FormattedValue = numericValue.ToString(format); ////, culture);
//// if (numericValue < 0)
//// {
//// result.IsNegative = true;
//// //// result.NegativeColor = numeric.Negative.GetColor();
//// }
//// }
//// }
//// #region old
//////// var startWithYear = special.StartsWithYear == YesNo.Yes;
//////// var resultBuilder = new StringBuilder();
//////// resultBuilder.Clear();
//////// resultBuilder.Append(string.Empty);
//////// result.IsNumeric = false;
//////// switch (specialFormat)
//////// {
//////// #region Format: ShortDateFormat '99/99/99'
//////// case KnownSpecialFormat.ShortDateFormat:
//////// if (!string.IsNullOrEmpty(value) &&
//////// !value.IsNullOrWhiteSpace() &&
//////// !value.Trim().Equals("0"))
//////// {
//////// var adjustedValue = string.Concat(new string('0', 6), value);
//////// adjustedValue = adjustedValue.Substring(adjustedValue.Length - 6, 6);
//////// if (startWithYear)
//////// {
//////// resultBuilder.Append(adjustedValue.Substring(0, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(2, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(4, 2));
//////// }
//////// else
//////// {
//////// resultBuilder.Append(adjustedValue.Substring(4, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(0, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(2, 2));
//////// }
//////// }
//////// break;
//////// #endregion
//////// #region Format: LongDateFormat '99/99/9999'
//////// case KnownSpecialFormat.LongDateFormat:
//////// if (!string.IsNullOrEmpty(value) &&
//////// !value.IsNullOrWhiteSpace() &&
//////// !value.Trim().Equals("0"))
//////// {
//////// var adjustedValue = string.Concat(new string('0', 8), value);
//////// adjustedValue = adjustedValue.Substring(adjustedValue.Length - 8, 8);
//////// if (startWithYear)
//////// {
//////// resultBuilder.Append(adjustedValue.Substring(0, 4));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(4, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(6, 2));
//////// }
//////// else
//////// {
//////// resultBuilder.Append(adjustedValue.Substring(0, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(2, 2));
//////// resultBuilder.Append('/');
//////// resultBuilder.Append(adjustedValue.Substring(4, 4));
//////// }
//////// }
//////// break;
//////// #endregion
//////// }
//////// result.FormattedValue = resultBuilder.ToString();
//// #endregion
//// break;
#endregion
#region Type: Text
case KnownDataType.Text:
result.IsNumeric = false;
break;
#endregion
}
return(result);
}
/// <summary>
/// Returns data format for a data type.
/// </summary>
/// <returns>
/// Data format.
/// </returns>
public string GetDataFormat()
{
var culture = CultureInfo.CurrentCulture;
var formatBuilder = new StringBuilder();
switch (Type)
{
#region Type: Numeric
case KnownDataType.Numeric:
var number = (NumberDataTypeModel)this;
var numberDecimals = number.Decimals;
var numberPositivePatternArray = new[] { "n" };
var numberNegativePatternArray = new[] { "(n)", "-n", "- n", "n-", "n -" };
var currentNumberPositivePattern = numberPositivePatternArray[0];
var currentNumberNegativePattern = numberNegativePatternArray[culture.NumberFormat.NumberNegativePattern];
var numberPositivePatternBuilder = new StringBuilder();
numberPositivePatternBuilder.Append(number.Separator == YesNo.Yes ? "#,##0" : "##0");
if (numberDecimals > 0)
{
var digits = new string('0', numberDecimals);
numberPositivePatternBuilder.Append(".");
numberPositivePatternBuilder.Append(digits);
}
var numberPositivePattern = numberPositivePatternBuilder.ToString();
currentNumberPositivePattern = currentNumberPositivePattern.Replace("n", numberPositivePattern);
var numberNegativePatternWithSignBuilder = new StringBuilder();
currentNumberNegativePattern = currentNumberNegativePattern.Replace("n", numberPositivePattern);
switch (number.Negative.Sign)
{
case KnownNegativeSign.None:
currentNumberNegativePattern = currentNumberNegativePattern.Replace("-", string.Empty)
.Replace("(", string.Empty)
.Replace(")", string.Empty);
numberNegativePatternWithSignBuilder.Append(currentNumberNegativePattern);
break;
case KnownNegativeSign.Standard:
if (currentNumberNegativePattern.Contains("-"))
{
currentNumberNegativePattern = currentNumberNegativePattern.Replace("-", culture.NumberFormat.NegativeSign);
}
numberNegativePatternWithSignBuilder.Append(currentNumberNegativePattern);
break;
case KnownNegativeSign.Parenthesis:
currentNumberNegativePattern = currentNumberNegativePattern.Replace("-", string.Empty)
.Replace("(", string.Empty)
.Replace(")", string.Empty);
numberNegativePatternWithSignBuilder.Append("(");
numberNegativePatternWithSignBuilder.Append(currentNumberNegativePattern);
numberNegativePatternWithSignBuilder.Append(")");
break;
case KnownNegativeSign.Brackets:
currentNumberNegativePattern = currentNumberNegativePattern.Replace("-", string.Empty)
.Replace("(", string.Empty)
.Replace(")", string.Empty);
numberNegativePatternWithSignBuilder.Append("[");
numberNegativePatternWithSignBuilder.Append(currentNumberNegativePattern);
numberNegativePatternWithSignBuilder.Append("]");
break;
}
currentNumberNegativePattern = numberNegativePatternWithSignBuilder.ToString();
formatBuilder.Append(currentNumberPositivePattern);
formatBuilder.Append(";");
formatBuilder.Append(currentNumberNegativePattern);
return(formatBuilder.ToString());
#endregion
#region Type: Currency
case KnownDataType.Currency:
var currency = (CurrencyDataTypeModel)this;
var currencyDecimals = currency.Decimals;
var currencyPositivePatternArray = new[] { "$n", "n$", "$n", "n$" };
var currencyNegativePatternArray = new[] { "($n)", "-$n", "$-n", "$n-", "(n$)", "-n$", "n-$", "n$-", "-n $", "-$ n", "n $-", "$ n-", "$ -n", "n- $", "($ n)", "(n $)" };
if (currency.Locale != KnownCulture.Current)
{
culture = CultureInfo.GetCultureInfo(ExportsModel.GetXmlEnumAttributeFromItem(currency.Locale));
}
var currentCurrencyPositivePattern = currencyPositivePatternArray[culture.NumberFormat.CurrencyPositivePattern];
var currentCurrencyNegativePattern = currencyNegativePatternArray[culture.NumberFormat.CurrencyNegativePattern];
var currencyPositivePatternBuilder = new StringBuilder();
currencyPositivePatternBuilder.Append("#,##0");
if (currencyDecimals > 0)
{
var digits = new string('0', currencyDecimals);
currencyPositivePatternBuilder.Append(".");
currencyPositivePatternBuilder.Append(digits);
}
var currencyPositivePattern = currencyPositivePatternBuilder.ToString();
currentCurrencyPositivePattern = currentCurrencyPositivePattern.Replace("$", culture.NumberFormat.CurrencySymbol)
.Replace("n", currencyPositivePattern);
var currencyNegativePatternWithSign = new StringBuilder();
currentCurrencyNegativePattern = currentCurrencyNegativePattern.Replace("$", culture.NumberFormat.CurrencySymbol)
.Replace("n", currencyPositivePattern);
switch (currency.Negative.Sign)
{
case KnownNegativeSign.None:
currentCurrencyNegativePattern = currentCurrencyNegativePattern.Replace("-", string.Empty)
.Replace("(", string.Empty)
.Replace(")", string.Empty);
currencyNegativePatternWithSign.Append(currentCurrencyNegativePattern);
break;
case KnownNegativeSign.Standard:
if (currentCurrencyNegativePattern.Contains("-"))
{
currentCurrencyNegativePattern = currentCurrencyNegativePattern.Replace("-", culture.NumberFormat.NegativeSign);
}
currencyNegativePatternWithSign.Append(currentCurrencyNegativePattern);
break;
case KnownNegativeSign.Parenthesis:
currentCurrencyNegativePattern = currentCurrencyNegativePattern.Replace("-", string.Empty)
.Replace("(", string.Empty)
.Replace(")", string.Empty);
currencyNegativePatternWithSign.Append("(");
currencyNegativePatternWithSign.Append(currentCurrencyNegativePattern);
currencyNegativePatternWithSign.Append(")");
break;
case KnownNegativeSign.Brackets:
currentCurrencyNegativePattern = currentCurrencyNegativePattern.Replace("-", string.Empty)
.Replace("(", string.Empty)
.Replace(")", string.Empty);
currencyNegativePatternWithSign.Append("[");
currencyNegativePatternWithSign.Append(currentCurrencyNegativePattern);
currencyNegativePatternWithSign.Append("]");
break;
}
currentCurrencyNegativePattern = currencyNegativePatternWithSign.ToString();
formatBuilder.Append(currentCurrencyPositivePattern);
formatBuilder.Append(";");
formatBuilder.Append(currentCurrencyNegativePattern);
return(formatBuilder.ToString());
#endregion
#region Type: Percentage
case KnownDataType.Percentage:
var percent = (PercentageDataTypeModel)this;
formatBuilder.Append("P");
formatBuilder.Append(percent.Decimals);
return(formatBuilder.ToString());
#endregion
#region Type: Scientific
case KnownDataType.Scientific:
var scientific = (ScientificDataTypeModel)this;
formatBuilder.Append("E");
formatBuilder.Append(scientific.Decimals);
return(formatBuilder.ToString());
#endregion
#region Type: DateTime
case KnownDataType.Datetime:
var datetime = (DatetimeDataTypeModel)this;
if (datetime.Locale != KnownCulture.Current)
{
culture = CultureInfo.CreateSpecificCulture(ExportsModel.GetXmlEnumAttributeFromItem(datetime.Locale));
}
switch (datetime.Format)
{
case KnownDatetimeFormat.GeneralDatePattern:
formatBuilder.Append(culture.DateTimeFormat.ShortDatePattern);
formatBuilder.Append(" ");
formatBuilder.Append(culture.DateTimeFormat.ShortTimePattern);
break;
case KnownDatetimeFormat.ShortDatePattern:
formatBuilder.Append(culture.DateTimeFormat.ShortDatePattern);
break;
case KnownDatetimeFormat.LongDatePattern:
formatBuilder.Append(culture.DateTimeFormat.LongDatePattern);
break;
case KnownDatetimeFormat.FullDatePattern:
formatBuilder.Append(culture.DateTimeFormat.FullDateTimePattern);
break;
case KnownDatetimeFormat.Rfc1123Pattern:
formatBuilder.Append(culture.DateTimeFormat.RFC1123Pattern);
break;
case KnownDatetimeFormat.ShortTimePattern:
formatBuilder.Append(culture.DateTimeFormat.ShortTimePattern);
break;
case KnownDatetimeFormat.LongTimePattern:
formatBuilder.Append(culture.DateTimeFormat.LongTimePattern);
break;
case KnownDatetimeFormat.MonthDayPattern:
formatBuilder.Append(culture.DateTimeFormat.MonthDayPattern);
break;
case KnownDatetimeFormat.YearMonthPattern:
formatBuilder.Append(culture.DateTimeFormat.YearMonthPattern);
break;
}
return(formatBuilder.ToString());
#endregion
#region Type: Special
////case KnownDataType.Special:
//// var special = (SpecialDataTypeModel)this;
//// var format = special.Format;
//// return string.IsNullOrEmpty(format)
//// ? "@"
//// : format;
#endregion
#region Type: Text
default:
return("@");
#endregion
}
}