public static void confirmarEmail(IWebDriver driver)
{
AvilaApplication.InitializeHelpers();
AvilaApplication.DataManipulation.Configure("avilasolucoes@oe0dc5r5n9", "@vil@2015", "oe0dc5r5n9.database.windows.net,1433", "naora_dev", false);
Assert.IsTrue(AvilaApplication.DataManipulation.CheckConnection());
AvilaApplication.DataManipulation.ExecuteProcedure("confirmarEmail", new string[] { "Email" }, new string[] { "*****@*****.**" });
}
public static void DeleteProfissionalAgenda()
{
//connStr.ConnectionString = ConfigurationManager.ConnectionStrings["NaoraTeste"].ConnectionString;
AvilaApplication.InitializeHelpers();
AvilaApplication.DataManipulation.Configure("avilasolucoes@oe0dc5r5n9", "@vil@2015", "oe0dc5r5n9.database.windows.net,1433", "naora", false);
Assert.IsTrue(AvilaApplication.DataManipulation.CheckConnection());
AvilaApplication.DataManipulation.ExecuteProcedure("sp_deleteUsuarioAgenda", new string[] { "Email" }, new string[] { "*****@*****.**" });
}
public static void deletePaciente(string procedure, string[] parameterName, string[] parameterValue)
{
//connStr.ConnectionString = ConfigurationManager.ConnectionStrings["NaoraTeste"].ConnectionString;
AvilaApplication.InitializeHelpers();
AvilaApplication.DataManipulation.Configure("avilasolucoes@oe0dc5r5n9", "@vil@2015", "oe0dc5r5n9.database.windows.net,1433", "naora_dev", false);
Assert.IsTrue(AvilaApplication.DataManipulation.CheckConnection());
AvilaApplication.DataManipulation.ExecuteProcedure("sp_deleteusuario", parameterName, parameterValue);
}
public static void DeleteProfissionalUnimed()
{
AvilaApplication.InitializeHelpers();
AvilaApplication.DataManipulation.Configure("avilasolucoes@oe0dc5r5n9", "@vil@2015", "oe0dc5r5n9.database.windows.net,1433", "naora", false);
Assert.IsTrue(AvilaApplication.DataManipulation.CheckConnection());
AvilaApplication.DataManipulation.ExecuteProcedure("sp_deleteUsuario", new string[] { "Email" }, new string[] { "*****@*****.**" });
//O atributo 'importado' profissional na tabela dbo.ProfissionalImportacao
AvilaApplication.DataManipulation.ExecuteNonQuery("UPDATE [dbo].[ProfissionalImportacao] SET [importado] = 0 WHERE [id] = 2109");
}
