using System;

using System.Collections;

using System.IO;

using System.Linq;

using System.Text.RegularExpressions;

using Scriban;

using Scriban.Runtime;

​

public class Program

{

    //Aquí puedes editar lo que será considerado el nombre del fichero de origen.

    private string OriginFileName = "Distribuidor-Ventas-20220510.csv";

    //Fila de datos a procesar.

    private string[] Input = {

        "Fabricante S.L.",

        "05/10/2021",

        "Refresco de Naranja",

        "5.00",

        "42.75",

        "1",

    };

    //Fórmula Scriban a aplicar sobre la fila de datos.

    private string Formula = "{{ (row[4] | uve.div row[3]) | uve.sum row[5]}}";

    private string Validation = @"

            {{for row in rows}}

                {{if row[0] != ""Brebajes Instantáneos""}}

                    var_error: El nombre del fabricante no es ""Brebajes Instantáneos"".

                    var_alert_code:CUCS0002

                    {{break}}

                {{end}}

            {{end}}

        ";

    //

    //NO EDITAR NADA POR DEBAJO DE ESTA LÍNEA

    //

    private int countAutoInc = 0;

​

    public static void Main()

    {

        var program = new Program();

        Console.WriteLine("--- Validación de cabecera ---");

        program.TryValidation();

        Console.WriteLine("--- Procesado de fila ---");

        program.TryScriban();

    }

    private void TryValidation()

    {

        this.PrepareDummyFile();

        var fileInfo = new FileInfo(this.OriginFileName);

        var context = BuildScribanContextInfo(fileInfo);

        context.Add("rows", new string[][] { Input });

        try {

            var scribanTemplate = Template.Parse(Validation);

            var processedTemplate = scribanTemplate.Render(context);

            Console.WriteLine(processedTemplate);

        } catch (Exception exc) {

            Console.WriteLine("ERROR: " + exc.Message); 

        }

    }

    private void TryScriban()

    {

        this.PrepareDummyFile();

        var fileInfo = new FileInfo(this.OriginFileName);

        var context = BuildScribanContextInfo(fileInfo);

        context.Add("row", Input);

        try {

            var scribanTemplate = Template.Parse(Formula);

            var processedTemplate = scribanTemplate.Render(context);

            Console.WriteLine(processedTemplate);

        } catch (Exception exc) {

            Console.WriteLine("ERROR: " + exc.Message); 

        }

    }

    private void PrepareDummyFile()

    {

        var file = File.Open(this.OriginFileName, FileMode.OpenOrCreate);

        var writer = new StreamWriter(file);

        writer.WriteLine("Dummy data");

        file.Flush();

        file.Close();

    }

    private ScriptObject BuildScribanContextInfo(FileInfo originFileInfo)

    {

        var context = new ScriptObject();

        int autoinc = 0;

​

        context.Add("fileInfo", originFileInfo);

        context.Add("now", DateTime.Now);

        context.Add("uve", new CustomScribanContext(

            originFileInfo,

            (string val, int len) => "placeholder",

            () => ++autoinc

        ));

​

        return context;

    }

    public class CustomScribanContext : ScriptObject

    {

        public delegate string CodeGenerator(string value, int length);

        public delegate int AutoIncGenerator();

​

        private CodeGenerator CodeProvider;

        private AutoIncGenerator AutoIncProvider;

​

        public CustomScribanContext(FileInfo originFileInfo, CodeGenerator codeGenerator, AutoIncGenerator autoIncGenerator) : base()

        {

            this.CodeProvider = codeGenerator;

            this.AutoIncProvider = autoIncGenerator;

​

            this["file_info"] = originFileInfo;

            this["now"] = DateTime.Now;

            this["def"] = new DelegateCustomFunction(new Func<string, string, object>(Def));

            this["pad_left"] = new DelegateCustomFunction(new Func<string, int, string, string>(PadLeft));

            this["pad_right"] = new DelegateCustomFunction(new Func<string, int, string, string>(PadRight));

            this["right"] = new DelegateCustomFunction(new Func<string, int, string>(Right));

            this["left"] = new DelegateCustomFunction(new Func<string, int, string>(Left));

            this["position"] = new DelegateCustomFunction(new Func<IList, int, object>(Position));

            this["trim_start"] = new DelegateCustomFunction(new Func<string, string, string>(TrimStart));

            this["trim_end"] = new DelegateCustomFunction(new Func<string, string, string>(TrimEnd));

            this["only_chars"] = new DelegateCustomFunction(new Func<string, string>(OnlyChars));

            this["only_numbers"] = new DelegateCustomFunction(new Func<string, string>(OnlyNumbers));

            this["sum"] = new DelegateCustomFunction(new Func<string, string, float>(Sum));

            this["sub"] = new DelegateCustomFunction(new Func<string, string, float>(Sub));

            this["prod"] = new DelegateCustomFunction(new Func<string, string, float>(Prod));

            this["div"] = new DelegateCustomFunction(new Func<string, string, float>(Div));

            this["code"] = new DelegateCustomFunction(new Func<string, int, string>(Code));

            this["autoinc"] = new DelegateCustomFunction(new Func<int>(Autoinc));

        }

​

        public string Def(string current, string def)

        {

            return current != null && current.Trim() != "" ? current : def;

        }

​

        public string PadLeft(string value, int width, string character)

        {

            return value.PadLeft(width, character.First());

        }

​

        public string PadRight(string value, int width, string character)

        {

            return value.PadRight(width, character.First());

        }

​

        public string Right(string value, int length)

        {

            return value.Substring(value.Length - length, length);

        }

​

        public string Left(string value, int length)

        {

            return value.Substring(0, length);

        }

​

        public object Position (IList list, int position)

        {

            if (list.Count <= position)

            {

                return null;

            }

            return position >= 0 ? list[position] : list[list.Count - Math.Abs(position)];

        }

​

        public string TrimStart(string value, string chars)

        {

            return value.TrimStart(chars.ToCharArray());

        }

        public string TrimEnd(string value, string chars)

        {

            return value.TrimEnd(chars.ToCharArray());

        }

​

        public string OnlyChars(string value)

        {

            string charsRegex = @"[^a-zA-ZáéíóúÁÉÍÓÚàèìòùÀÈÌÒÙÑñ]";

            return Regex.Replace(value, charsRegex, "");

        }

​

        public string OnlyNumbers(string value)

        {

            string charsRegex = @"[^0-9]";

            return Regex.Replace(value, charsRegex, "");

        }

​

        public float Sum(string a, string b)

        {

            float aNumber;

            float bNumber;

            if (!float.TryParse(a, out aNumber) || !float.TryParse(b, out bNumber)) {

                return 0;

            }

​

            return aNumber + bNumber;

        }

​

        public float Sub(string a, string b) {

            float aNumber;

            float bNumber;

            if (!float.TryParse(a, out aNumber) || !float.TryParse(b, out bNumber)) {

                return 0;

            }

​

            return aNumber - bNumber;

        }

​

        public float Prod(string a, string b)

        {

            float aNumber;

            float bNumber;

            if (!float.TryParse(a, out aNumber) || !float.TryParse(b, out bNumber)) {

                return 0;

            }

​

            return aNumber * bNumber;

        }

​

        public float Div(string a, string b)

        {

            float aNumber;

            float bNumber;

            if (!float.TryParse(a, out aNumber) || !float.TryParse(b, out bNumber)) {

                return 0;

            }

​

            return aNumber / bNumber;

        }

​

        public string Code(string value, int length)

        {

            return CodeProvider(value, length);

        }

​

        public int Autoinc()

        {

            return AutoIncProvider();

        }

    }

}