using System.Collections.Generic;

using System.Linq;

using System.Text.RegularExpressions;

using Synthesis.Entities;

​

namespace Synthesis.AppCode.Utils

{

    public class FormatUtility

    {

        public static int[] GetAccuracyColumns(List<TableColumn> columns)

        {

            return columns.Select(x => x.CustomFormat).Select(GetAccuracyFromFormatString).ToArray();

        }

​

        private static int GetAccuracyFromFormatString(string customFormat)

        {

            string customFormatToLower = customFormat.ToLower();

            if (string.IsNullOrWhiteSpace(customFormatToLower))

            {

                return 0;

            }

            var regex = new Regex(@"^{?\d+:(n|p|c)(?<accuracy>\d*)}?$");

            if (!regex.IsMatch(customFormatToLower))

            {

                return 0;

            }

            if (regex.Match(customFormatToLower).Groups["accuracy"] == null)

            {

                return 0;

            }

            var accuracyString = regex.Match(customFormatToLower).Groups["accuracy"].Value;

            int accuracy;

            return int.TryParse(accuracyString, out accuracy) ? accuracy : 2;

        }

​

        public static string GetDataTypesFromFormatString(string customFormat)

        {

            string customFormatToLower = customFormat.ToLower();

            if (string.IsNullOrWhiteSpace(customFormatToLower))

            {

                return ColumnData.DataTypes.dbl.ToString();

            }

            var regex = new Regex(@"^{?\d+:(?<format>n|p|c)\d*}?$");

            if (!regex.IsMatch(customFormatToLower))

            {

                return ColumnData.DataTypes.dbl.ToString();

            }

            if (regex.Match(customFormatToLower).Groups["format"] == null)

            {

                return ColumnData.DataTypes.dbl.ToString();

            }

            var formatString = regex.Match(customFormatToLower).Groups["format"].Value;

            switch (formatString)

            {

                case "n":

                    return ColumnData.DataTypes.dbl.ToString();

                case "p":

                    return ColumnData.DataTypes.percent.ToString();

                case "c":

                    return ColumnData.DataTypes.currency.ToString();

                default:

                    return ColumnData.DataTypes.dbl.ToString();

            }

        }

​

    }

}