Exemple #1
0
        internal static void LoadEmpresa(ExcelWorksheet ws, Orb OrbEffect)
        {
            var start = ws.Dimension.Start;
            var end   = ws.Dimension.End;

            for (int row = start.Row + 1; row <= end.Row; row++)
            {
                string UK              = ws.Cells[row, 1].Text;
                string CNPJ            = ws.Cells[row, 2].Text;
                string RazaoSocial     = ws.Cells[row, 3].Text;
                string NomeFantasia    = ws.Cells[row, 4].Text;
                string URLSite         = ws.Cells[row, 5].Text;
                string URLAD           = ws.Cells[row, 6].Text;
                string URLWS           = ws.Cells[row, 7].Text;
                string UsuarioInclusao = ws.Cells[row, 8].Text;

                OrbEffect.CadastrarEmpresa(new GISModel.Entidades.Empresa()
                {
                    UniqueKey       = Guid.Parse(UK),
                    CNPJ            = CNPJ,
                    RazaoSocial     = RazaoSocial,
                    NomeFantasia    = NomeFantasia,
                    URL_Site        = URLSite,
                    URL_AD          = URLAD,
                    URL_WS          = URLWS,
                    UsuarioInclusao = UsuarioInclusao
                });
            }
        }