ValidarEANTest.cs

using System;
using sage.addons.idatos.Negocio.Clases;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System.Data;
using System.Collections.Generic;
using System.IO;
using Sage.ES.S50.UnitTest.Tools;
using sage.ew.global.DependencyInjection;
using sage.addons.idatos.Negocio.Interficies;
using Sage.ES.S50.UnitTest.Mock;
using System.Windows.Forms;
using sage.ew.botones;
using sage.ew.txtbox.UserControls;
using sage.addons.idatos.Negocio.Mantes;
using System.Linq;
using Sage.ES.S50.Extensions;
using System.Text;

namespace Sage.ES.S50.UnitTest.addons.idatos
{
    [TestClass]
    [DeploymentItem(@"Idatos\", "Idatos")]
    public class ValidarEANTest
    {
        #region Properties

        private DataTable dtPlinter_c = new DataTable();
        private DataTable dtPlinter_d = new DataTable();
        private DataTable dtPlinter_d1 = new DataTable();
        private DataTable dtPlinter_d2 = new DataTable();

        private TestContext testContextInstance;

        public TestContext TestContext
        {
            get
            {
                return testContextInstance;
            }
            set
            {
                testContextInstance = value;
            }
        }
        #endregion Properties

        #region Additional test attributes
        // 
        //You can use the following additional attributes as you write your tests:
        //
        //Use ClassInitialize to run code before running the first test in the class
        [ClassInitialize()]
        public static void MyClassInitialize(TestContext testContext)
        {
            //Conexion a Base de Datos
            testContext.__Test_LoadRandomConfig();
        }
     
        #endregion

        #region Members

      //  private CargarDatos _CargarDatos = new CargarDatos();
        #endregion

        [Owner(Owners.Luisa_Galvan), TestMethod()]
        [Priority(1)]
        public void ValidarEAN_IdatosTest()
        {
            sage.addons.idatos.Negocio.Clases.idatosConfig.testMode = true;
            string lcCarpetaAleatoria = System.IO.Path.GetRandomFileName().ToUpper();

            GuiaTools loGuiaTools = new GuiaTools();
            loGuiaTools.Tools("0ARTICULOS_20230307.guide", "0ARTICULOS_20230307.csv", lcCarpetaAleatoria);

            loGuiaTools.DeleteTmp(lcCarpetaAleatoria);

            bool lbExiste = false;
            int posic = PosicionEANTabla(loGuiaTools, out lbExiste);

            if (lbExiste)
            {
                foreach(DataRow loRow in loGuiaTools.dtCSV.Rows)
                {
                    string valor = Convert.ToString(loRow.ItemArray[posic]);

                    if (!string.IsNullOrEmpty(valor))
                    {
                        ValidarEAN loValidaEAN = new ValidarEAN();
                        ValidationResult vrResult = loValidaEAN.Validar(valor, loRow);

                        if (vrResult.result)
                            Assert.IsTrue(vrResult.result, vrResult.mensaje);
                        else
                            Assert.IsFalse(vrResult.result);              
                    }    
                }
            }
        }


        #region Métodos privados

        private int PosicionEANTabla(GuiaTools loGuiaTools, out bool existeRegistro)
        {
            int valor = 0;
            bool lbFind = false;

            string id_d = Convert.ToString(loGuiaTools.dtPlinter_d1.AsEnumerable().Where(g => g.Field<int>("idcampo") == 956).Select(g => g.Field<string>("id_d")).ToList().FirstOrDefault());

            if (!string.IsNullOrEmpty(id_d))
            {
                string columna = Convert.ToString(loGuiaTools.dtPlinter_d.AsEnumerable().Where(g => g.Field<string>("id_rela") == id_d).Select(g => g.Field<string>("columna")).ToList().FirstOrDefault());

                if (!string.IsNullOrEmpty(columna))
                {
                    lbFind = true;
                    int pos = posicionColumna(columna);
                    valor = pos;
                }
            }

            existeRegistro = lbFind;

            return valor;
        }

        private int posicionColumna(string nombreColumna)
        {
            int ret = 0;
            if (nombreColumna.Length == 1)
            {
                ret = Encoding.ASCII.GetBytes(nombreColumna)[0] - 65;
            }
            else
            {
                if (!string.IsNullOrWhiteSpace(nombreColumna))
                {
                    Int32 times = Convert.ToInt32(nombreColumna.Substring(0, 1));
                    ret = ((Encoding.ASCII.GetBytes("Z")[0] - 65) * times) + (Encoding.ASCII.GetBytes(nombreColumna)[1] - 65) + 1;
                }
            }

            return ret;
        }

        #endregion Métodos privados
    }
}