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