public IActionResult EditarTesteNatura(NaturaTeste teste, int ultimo_executado, int ultimo_chamado, [FromServices] NaturaDAO naturaDAO)
{
_logger.LogInformation("Natura- [HttpPost] Editar Teste id: {0}/ User: {1}", teste.id_natura_teste, User.Identity.Name);
if (teste.execucao_status == 3 && teste.chamado_status == 0)
{
ModelState.AddModelError("observacao", "Informe o numero do chamado aqui aberto aqui!");
ModelState.AddModelError("chamado_status", "Este campo é obrigatório!");
return(View(teste));
}
if (ultimo_chamado != 0)
{
ModelState.AddModelError("observacao", "Informe o numero do chamado aqui!");
ModelState.AddModelError("chamado_status", "Este campo é obrigatório!");
return(View(teste));
}
if (teste.execucao_status == 4 && ultimo_executado != 4)
{
teste.data_executado = DateTime.Now.Date;
}
naturaDAO.AtualizaTeste_Natura(teste);
string codRelease = teste.cod_release;
return(RedirectToAction("TestesNatura", "Natura", new { codRelease }));
}
public IActionResult EditarTesteNatura(int idTeste, [FromServices] NaturaDAO naturaDAO)
{
_logger.LogInformation("Natura- [HttpGet] Editar Teste id: {0}/ User: {1}", idTeste, User.Identity.Name);
NaturaTeste teste = naturaDAO.Teste_Natura(idTeste);
return(View(teste));
}
internal void AddTest_Natura(NaturaTeste naturaTeste)
{
try
{
_logger.LogInformation("Natura - Add Teste na release cod: {0}", naturaTeste.cod_release);
string ConnectionString = _configuracoes.GetConnectionString("Sanity");
using (var mysqlCon = new MySqlConnection(ConnectionString))
{
mysqlCon.Execute("INSERT INTO `Sanity`.`testes_natura` (`cod_release`,`numero_teste`,`executor`,`execucao_status`,`chamado_status`,`sistema`,`cenario`,`pre_condicao`,`passos`,`result_esperado`,`pos_condicao`,`observacao`,data_execucao,funcionalidade,massa, url_doc, prioridade,cn_login,cn_senha,gr_login,gr_senha,lider_login,lider_senha,browser) VALUES (@cod_release,@numero_teste,@executor,@execucao_status,@chamado_status,@sistema,@cenario,@pre_condicao,@passos,@result_esperado,@pos_condicao,@observacao,@data_execucao,@funcionalidade,@massa,@url_doc,@prioridade,@cn_login,@cn_senha,@gr_login,@gr_senha,@lider_login,@lider_senha,@browser);", naturaTeste);
}
}
catch (Exception ex)
{
_logger.LogError("Erro: {0}", ex);
}
}
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 }));
}
internal void AtualizaTeste_Natura(NaturaTeste teste)
{
try
{
string ConnectionString = _configuracoes.GetConnectionString("Sanity");
string query = @"UPDATE Sanity.testes_natura
SET
executor = @executor,
execucao_status = @execucao_status,
chamado_status = @chamado_status,
sistema = @sistema,
cenario = @cenario,
pre_condicao = @pre_condicao,
passos = @passos,
result_esperado = @result_esperado,
pos_condicao = @pos_condicao,
observacao = @observacao,
data_execucao = @data_execucao,
data_executado = @data_executado,
url_doc = @url_doc,
prioridade = @prioridade,
cn_login = @cn_login,
cn_senha = @cn_senha,
gr_login = @gr_login,
gr_senha = @gr_senha,
lider_login = @lider_login,
lider_senha = @lider_senha,
browser = @browser
WHERE id_natura_teste = @id_natura_teste;";
using (var mysqlCon = new MySqlConnection(ConnectionString))
{
mysqlCon.Execute(query, teste);
}
}
catch (Exception ex)
{
_logger.LogError("Erro: {0}", ex);
}
}
internal NaturaTeste Teste_Natura(int idTeste)
{
NaturaTeste teste = new NaturaTeste();
try
{
_logger.LogInformation("Natura carregando teste id: {0}", idTeste.ToString());
string ConnectionString = _configuracoes.GetConnectionString("Sanity");
using (MySqlConnection mysqlCon = new MySqlConnection(ConnectionString))
{
teste = mysqlCon.Query <NaturaTeste>("SELECT * FROM Sanity.testes_natura WHERE id_natura_teste = @idTeste;", new { idTeste }).SingleOrDefault();
}
}
catch (Exception ex)
{
_logger.LogError("Erro: {0}", ex);
}
return(teste);
}
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"));
}
}
