public IActionResult AddTesteNatura(NaturaTeste naturaTeste, [FromServices] NaturaDAO naturaDAO)
{
if (!ModelState.IsValid)
{
List <NaturaTeste> naturaTestes = naturaDAO.ListaTestes_Natura(naturaTeste.cod_release);
ViewBag.CodRelease = (from x in naturaTestes select x.cod_release).First();
ViewBag.Cenario = (from x in naturaTestes select x.numero_teste).Max() + 1;
return(View());
}
naturaTeste.execucao_status = 0;
naturaTeste.chamado_status = 0;
_logger.LogInformation("Natura- [HttpPost] Adicionar Teste a release cod: {0}/ User: {1}", naturaTeste.cod_release, User.Identity.Name);
naturaDAO.AddTest_Natura(naturaTeste);
return(RedirectToAction("TestesNatura", "Natura", new { codRelease = naturaTeste.cod_release }));
}
public IActionResult InsertTestesNatura(string codRelease, int qtdTeste, IFormFile file, [FromServices] NaturaDAO naturaDAO)
{
if (qtdTeste < 1)
{
ModelState.AddModelError("", "Informe a quantidade de testes!");
return(View());
}
else
{
if (file is null)
{
ModelState.AddModelError("", "Planilha não encontrada!");
return(View());
}
List <NaturaTeste> naturaTestes = naturaDAO.ListaTestes_Natura(codRelease);
ViewBag.CodRelease = codRelease;
int nTeste = (from x in naturaTestes select x.numero_teste).Max() + 1;
string webRootPath = _hostingEnvironment.WebRootPath;
StringBuilder sb = new StringBuilder();
if (file.Length > 0)
{
List <NaturaTeste> lista = new List <NaturaTeste>();
string sFileExtension = Path.GetExtension(file.FileName).ToLower();
ISheet sheet;
string fullPath = Path.Combine(webRootPath, file.FileName);
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
stream.Position = 0;
if (sFileExtension == ".xls")
{
HSSFWorkbook hssfwb = new HSSFWorkbook(stream); //This will read the Excel 97-2000 formats
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
else
{
XSSFWorkbook hssfwb = new XSSFWorkbook(stream); //This will read 2007 Excel format
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
IRow headerRow = sheet.GetRow(0); //Get Header Row
int cellCount = headerRow.LastCellNum;
for (int i = (sheet.FirstRowNum + 1); i <= qtdTeste; i++) //Read Excel File
{
IRow row = sheet.GetRow(i);
var dataExec = row.GetCell(12)?.ToString();
DateTime?data = null;
if (dataExec == "" || dataExec is null)
{
}
else
{
data = Convert.ToDateTime(dataExec);
}
NaturaTeste naturaTeste = new NaturaTeste
{
cod_release = codRelease,
numero_teste = nTeste,
sistema = row.GetCell(1)?.ToString(),
funcionalidade = row.GetCell(2)?.ToString(),
cenario = row.GetCell(3)?.ToString(),
pre_condicao = row.GetCell(4)?.ToString(),
passos = row.GetCell(5)?.ToString(),
result_esperado = row.GetCell(6)?.ToString(),
pos_condicao = row.GetCell(7)?.ToString(),
executor = row.GetCell(8)?.ToString(),
massa = row.GetCell(9)?.ToString(),
observacao = row.GetCell(10)?.ToString(),
url_doc = row.GetCell(11)?.ToString(),
data_execucao = data,
prioridade = Convert.ToUInt16(row.GetCell(13)?.ToString()),
cn_login = row.GetCell(14)?.ToString(),
cn_senha = row.GetCell(15)?.ToString(),
gr_login = row.GetCell(16)?.ToString(),
gr_senha = row.GetCell(17)?.ToString(),
lider_login = row.GetCell(18)?.ToString(),
lider_senha = row.GetCell(19)?.ToString(),
browser = row.GetCell(20)?.ToString(),
execucao_status = 0,
chamado_status = 0
};
lista.Add(naturaTeste);
nTeste += 1;
}
}
//Add Testes
foreach (NaturaTeste teste in lista)
{
naturaDAO.AddTest_Natura(teste);
}
//Deleta arquivo criado
FileInfo fileInfo = new FileInfo(Path.Combine(webRootPath, file.FileName));
fileInfo.Delete();
}
}
return(RedirectToAction("TestesNatura", "Natura", new { codRelease }));
}
public IActionResult CadReleaseNatura(NaturaRelease naturaRelease, IFormFile file, [FromServices] NaturaDAO naturaDAO)
{
_logger.LogInformation("Natura- [HttPost] Cadastra nova release / User: {0}", User.Identity.Name);
if (naturaRelease.sistema == "null")
{
ModelState.AddModelError("sistema", "Campo 'Ambiente' é obrigatorio");
return(View());
}
if (!ModelState.IsValid)
{
return(View());
}
else
{
int maxId = naturaDAO.GetMaxId_Release();
string webRootPath = _hostingEnvironment.WebRootPath;
StringBuilder sb = new StringBuilder();
if (file is null)
{
ModelState.AddModelError("", "Planilha não encontrada!");
return(View());
}
naturaRelease.cod_release = "Release_" + maxId.ToString();
List <NaturaTeste> listTestes = new List <NaturaTeste>();
if (file.Length > 0)
{
string sFileExtension = Path.GetExtension(file.FileName).ToLower();
ISheet sheet;
string fullPath = Path.Combine(webRootPath, file.FileName);
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
stream.Position = 0;
if (sFileExtension == ".xls")
{
HSSFWorkbook hssfwb = new HSSFWorkbook(stream); //This will read the Excel 97-2000 formats
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
else
{
XSSFWorkbook hssfwb = new XSSFWorkbook(stream); //This will read 2007 Excel format
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
IRow headerRow = sheet.GetRow(0); //Get Header Row
int cellCount = headerRow.LastCellNum;
for (int i = (sheet.FirstRowNum + 1); i <= naturaRelease.qtdTestes; i++) //Read Excel File
{
IRow row = sheet.GetRow(i);
var dataExec = row.GetCell(12)?.ToString();
DateTime?data = null;
if (dataExec == "" || dataExec is null)
{
}
else
{
data = Convert.ToDateTime(dataExec);
}
var prioridadeExcel = row.GetCell(13)?.ToString();
int prioridadeTeste = 0;
if (prioridadeExcel == "" || prioridadeExcel is null)
{
}
else
{
prioridadeTeste = Convert.ToInt16(row.GetCell(13)?.ToString());
}
NaturaTeste naturaTeste = new NaturaTeste
{
cod_release = naturaRelease.cod_release,
numero_teste = Convert.ToInt16(row.GetCell(0)?.ToString()),
sistema = row.GetCell(1)?.ToString(),
funcionalidade = row.GetCell(2)?.ToString(),
cenario = row.GetCell(3)?.ToString(),
pre_condicao = row.GetCell(4)?.ToString(),
passos = row.GetCell(5)?.ToString(),
result_esperado = row.GetCell(6)?.ToString(),
pos_condicao = row.GetCell(7)?.ToString(),
executor = row.GetCell(8)?.ToString(),
massa = row.GetCell(9)?.ToString(),
observacao = row.GetCell(10)?.ToString(),
url_doc = row.GetCell(11)?.ToString(),
data_execucao = data,
prioridade = prioridadeTeste,
cn_login = row.GetCell(14)?.ToString(),
cn_senha = row.GetCell(15)?.ToString(),
gr_login = row.GetCell(16)?.ToString(),
gr_senha = row.GetCell(17)?.ToString(),
lider_login = row.GetCell(18)?.ToString(),
lider_senha = row.GetCell(19)?.ToString(),
browser = row.GetCell(20)?.ToString(),
execucao_status = 0,
chamado_status = 0
};
listTestes.Add(naturaTeste);
}
}
//Registra na tabela de releases da natura.
naturaDAO.AddRelease_Natura(naturaRelease);
//Add Testes
foreach (NaturaTeste teste in listTestes)
{
naturaDAO.AddTest_Natura(teste);
}
//Deleta arquivo criado
FileInfo fileInfo = new FileInfo(Path.Combine(webRootPath, file.FileName));
fileInfo.Delete();
}
return(RedirectToAction("ReleasesNatura", "Natura"));
}
}
