private string[] LoaderNaturezaLesao(ExcelWorksheet ws, string UsuarioLogado)
{
int found = 0;
int created = 0;
int i = 0;
for (i = 1; i < 50000; i++)
{
try
{
if (ws.Cells[i, 1] != null && ws.Cells[i, 1].Value != null && !string.IsNullOrEmpty(ws.Cells[i, 1].Value.ToString()))
{
found += 1;
try
{
string xCodigo = ws.Cells[i, 1].Value.ToString();
if (NaturezaLesaoBusiness.Consulta.Where(a => a.Codigo.Equals(xCodigo) && string.IsNullOrEmpty(a.UsuarioExclusao)).Count() == 0)
{
NaturezaLesaoBusiness.Inserir(new NaturezaLesao()
{
Codigo = ws.Cells[i, 1].Value.ToString(),
Descricao = ws.Cells[i, 2].Value.ToString(),
NomeCompleto = ws.Cells[i, 3].Value.ToString(),
UsuarioInclusao = UsuarioLogado
});
created += 1;
}
}
catch (Exception ex) { }
}
else
{
break;
}
}
catch { }
}
return(new string[] { "NaturezaLesao", found.ToString(), created.ToString() });
}
