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 = {

        "20286", 

        "8410978035003", 

        "AFILADOR LICOR CAFE 0,7 LIT. (6)", 

        "5.000", 

        "42.75", 

        "0.000", 

        "2023", 

        "Enero", 

        "430042872", 

        "MESON DON GALLO", 

        "KLAUDIA PIETRZAK", 

        "Y1271018Y", 

        "C. TARRAGONA 2A, POL. IND. ELS ARCS", 

        "SANT JAUME DELS DOMENYS", 

        "43713", 

        "6", 

        "LLUIS MAÑE JANE",

    };

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

    private string Formula = @"

        {{

    case row[7];

        when 'enero'; 01;

        when 'febrero'; 02;

        when 'marzo'; 03;

        when 'abril'; 04;

        when 'mayo'; 05;

        when 'junio'; 06;

        when 'julio'; 07;

        when 'agosto'; 08;

        when 'septiembre'; 09;

        when 'octubre'; 10;

        when 'noviembre'; 11;

        when 'diciembre'; 12;

        else; 0;

    end; 

}}

    ";

    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();

        }

    }

}