public IActionResult EditarTeste(int idTeste, [FromServices] VivoDAO vivoDAO)
{
TestesVivo teste = vivoDAO.GetTesteVivo(idTeste);
ViewBag.CodRelease = teste.CodRelease;
return(View(teste));
}
public IActionResult ListaTestes(int idRelease, [FromServices] VivoDAO vivoDAO)
{
List <TestesVivo> testes = vivoDAO.ListaTestesVivo(idRelease);
ViewBag.CodRelease = testes.Select(t => t.CodRelease).FirstOrDefault();
return(View(testes));
}
public IActionResult ExportRelease(int idRelease, string codRelease, [FromServices] VivoDAO vivoDAO)
{
ReadExcel readExcel = new ReadExcel(_hostingEnvironment);
List <TestesVivo> testesVivo = vivoDAO.ListaTestesVivo(idRelease);
string url = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, $"{codRelease}.xlsx");
MemoryStream memoryStream = readExcel.DownloadTestesVivo(testesVivo, codRelease, url);
return(File(memoryStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", $"{codRelease}.xlsx"));
}
public ObjectResult ListCenarios(string codRelease, string analista, [FromServices] VivoDAO vivoDAO)
{
_logger.LogInformation($"Código da release: {codRelease}");
try
{
List <TestesVivo> cenarios = vivoDAO.ListaCenarios(codRelease, analista);
if (cenarios.Count == 0)
{
return(BadRequest("Còdigo da release não encontrado"));
}
return(new ObjectResult(cenarios));
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
return(BadRequest(ex.Message));
}
}
public IActionResult AtualizaCenario(string codRelease, int numTeste, int status, string observacao, [FromServices] VivoDAO vivoDAO)
{
try
{
_logger.LogInformation($"Param: codRelease= {codRelease}, numTeste= {numTeste}, status= {status}, observacao= {observacao}");
string result = vivoDAO.UpdateTeste(codRelease, numTeste, status, observacao);
return(Ok(result));
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
return(BadRequest(ex.Message));
}
}
public IActionResult CadastrarReleaseVivo(VivoRelease vivoRelease, IFormFile excel, int qtdTestes, [FromServices] VivoDAO vivoDAO)
{
ViewBag.Erro = false;
if (excel is null)
{
ModelState.AddModelError("", "Arquivo da planilha não encontrado!");
}
if (qtdTestes == 0)
{
ModelState.AddModelError("", "Quantidade de testes é obrigatório!");
}
if (!ModelState.IsValid)
{
return(View());
}
//Criando Release
List <VivoRelease> releases = vivoDAO.GetListReleaseVivo();
if (!releases.Any(r => r.CodRelease == vivoRelease.CodRelease))
{
bool insert = vivoDAO.InsertReleaseVivo(vivoRelease);
if (!insert)
{
ModelState.AddModelError("", "Erro ao cadastratar release! Informe o Administrador do site!");
}
}
else
{
ModelState.AddModelError("CodRelease", "CRQ já cadastrada!");
return(View());
}
//
//Lendo Planilha
releases = vivoDAO.GetListReleaseVivo();
VivoRelease releaseCadastrada = releases.Where(r => r.CodRelease == vivoRelease.CodRelease).First();
ReadExcel readExcel = new ReadExcel(_hostingEnvironment);
List <TestesVivo> listTeste = readExcel.VivoPlanTestes(excel, qtdTestes, releaseCadastrada.CodRelease, releaseCadastrada.IdRelease);
vivoDAO.InsertTestesVivo(listTeste);
//
ViewBag.Erro = true;
return(View());
}
public IActionResult ReleasesAtivasVivo([FromServices] VivoDAO vivoDAO)
{
List <VivoRelease> releases = vivoDAO.GetReleasesVivoAtivas();
return(View(releases));
}
public IActionResult EditarTeste(TestesVivo teste, [FromServices] VivoDAO vivoDAO)
{
vivoDAO.UpdateTesteVivo(teste);
return(RedirectToAction("ListaTestes", "Vivo", new { idRelease = teste.IdRelease }));
}
public IActionResult AtualizaReleaseVivo(string codRelease, int status, [FromServices] VivoDAO vivoDAO)
{
vivoDAO.AtualizaReleaseVivo(codRelease, status);
return(RedirectToAction("ReleasesAtivasVivo", "Vivo"));
}
public IActionResult DeletaReleaseVivo(string codRelease, [FromServices] VivoDAO vivoDAO)
{
vivoDAO.DeletaReleaseVivo(codRelease);
return(RedirectToAction("ReleasesAtivasVivo", "Vivo"));
}
public IActionResult HistoricoReleaseVivo([FromServices] VivoDAO vivoDAO)
{
List <VivoRelease> vivoReleases = vivoDAO.GetListReleaseVivo();
return(View(vivoReleases.OrderByDescending(r => r.DataRelease)));
}
