public static int RetornarQtDeCampoPersonalizadoExpecificoDB(string nome)
{
string queryPersonalizado = SelectsQueries.RetornaQuantidadeDeCampoPersonalizadoExpecifico.Replace("$personalizado", nome);
string campo = DataBaseHelpers.RetornaDadosQuery(queryPersonalizado)[0];
return(Convert.ToInt32(campo));
}
public static void CriarPerfilDB(string plat, string osDB, string build)
{
string query = InsertsQueries.MassaDeDadoCriarPerfil.Replace("$plataforma", plat).
Replace("$so", osDB).Replace("$build", build);
DataBaseHelpers.ExecuteQuery(query);
}
public static List <string> ReturnProjectIDRandom()
{
string executQuerie = ProjectsQueries.SearchIdProjectsRandom;
//return Convert.ToInt32(DataBaseHelpers.RetornaDadosQuery(executQuerie));
return(DataBaseHelpers.RetornaDadosQuery(executQuerie));
}
public static void CriarProjetoBD(string nome, string descricao)
{
string inserirProjeto = CriarProjetoQueries.MassaDeDadosCriarProjeto.Replace("$name", nome).
Replace("$descricao", descricao);
DataBaseHelpers.ExecuteQuery(inserirProjeto);
}
public static int ReturnMaxProjectsBD()
{
string executQuerie = ProjectsQueries.CountProjectBD;
ExtentReportHelpers.AddTestInfo(2, "Total search of project in table");
return(Convert.ToInt32(DataBaseHelpers.RetornaDadosQuery(executQuerie)[0]));
}
public static void CriarProjetoViaQuerieBD(string nameProjeto, string descricaoProjeto)
{
string insertQuerie = GerenciarQueries.AdicionaProjetoPadrao
.Replace("$nomeProjeto", nameProjeto)
.Replace("$descricaoProjeto", descricaoProjeto);
DataBaseHelpers.ExecuteQuery(insertQuerie);
}
public static void CriarTarefaDB()
{
string dadosCriarTarefas = CriarTarefasQueries.MassaDeDadosCriarTarefas +
CriarTarefasQueries.MassaDeDadosAdicionarMarcadores +
CriarTarefasQueries.MassaDeDadosPreencherCamposTarefa +
CriarTarefasQueries.MassaDeDadosPreencherOsCampos;
DataBaseHelpers.ExecuteQuery(dadosCriarTarefas);
}
public List <string> ConsultarCampoDB(string customFieldName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/CustomField/consultaCampo.sql", Encoding.UTF8);
query = query.Replace("$customFieldName", customFieldName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome do campo personalizado = " + customFieldName);
return(DataBaseHelpers.ObtemDados(query));
}
public void DeletarCampoDB(string customFieldName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/CustomField/deletaCampo.sql", Encoding.UTF8);
query = query.Replace("$customFieldName", customFieldName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome do campo personalizado = " + customFieldName);
DataBaseHelpers.ExecuteQuery(query);
}
public TagDomain ConsultarTagDB(string tagName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Tags/consultaTag.sql", Encoding.UTF8);
query = query.Replace("$tagName", tagName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome da tag = " + tagName);
return(DataBaseHelpers.ObtemRegistroUnico <TagDomain>(query));
}
public void DeletarTagDB(string tagName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Tags/deletaTag.sql", Encoding.UTF8);
query = query.Replace("$tagName", tagName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome da tag = " + tagName);
DataBaseHelpers.ExecuteQuery(query);
}
public ProjectDomain ConsultarCategoriaDB(string categoryName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/consultaCategoria.sql", Encoding.UTF8);
query = query.Replace("$categoryName", categoryName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome da categoria = " + categoryName);
return(DataBaseHelpers.ObtemRegistroUnico <ProjectDomain>(query));
}
public void DeletarEmailUsuarioDB(string userEmail)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Users/deletaEmailUsuario.sql", Encoding.UTF8);
query = query.Replace("$userEmail", userEmail);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: E-mail do usuário = " + userEmail);
DataBaseHelpers.ExecuteQuery(query);
}
public void DeletarVersaoProjetoDB(string versionName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/deletaVersaoProjeto.sql", Encoding.UTF8);
query = query.Replace("$versionName", versionName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome da versão criada = " + versionName);
DataBaseHelpers.ExecuteQuery(query);
}
public void DeletarProjetoDB(int projectId)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/deletaProjeto.sql", Encoding.UTF8);
query = query.Replace("$projectId", projectId.ToString());
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: ID do projeto = " + projectId);
DataBaseHelpers.ExecuteQuery(query);
}
public void DeletarCategoriaDB(string categoryName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/deletaCategoria.sql", Encoding.UTF8);
query = query.Replace("$categoryName", categoryName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome da categoria = " + categoryName);
DataBaseHelpers.ExecuteQuery(query);
}
public UserDomain ConsultarUsuarioDB(string username)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Users/consultaUsuario.sql", Encoding.UTF8);
query = query.Replace("$username", username);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Username = " + username);
return(DataBaseHelpers.ObtemRegistroUnico <UserDomain>(query));
}
public ProjectDomain InserirProjetoDB(string projectName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/inseriProjeto.sql", Encoding.UTF8);
query = query.Replace("$projectName", projectName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome do projeto = " + projectName);
return(DataBaseHelpers.ObtemRegistroUnico <ProjectDomain>(query));
}
public ProjectDomain ConsultarVersaoProjetoDB(string versionName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/consultaVersaoProjeto.sql", Encoding.UTF8);
query = query.Replace("$versionName", versionName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome da versão criada = " + versionName);
return(DataBaseHelpers.ObtemRegistroUnico <ProjectDomain>(query));
}
public List <string> ConsultarProjetoAtribuidoAoUsuarioDB(int projectId, string userId)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/consultaProjetoAtribuidoAoUsuario.sql", Encoding.UTF8);
query = query.Replace("$projectId", projectId.ToString())
.Replace("$userId", userId);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome do projeto = " + projectId + "Nome do usuário = " + userId);
return(DataBaseHelpers.ObtemDados(query));
}
public void DeletarProjetoAtribuidoAoUsuarioDB(int projectId, string userId)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/deletaProjetoAtribuidoAoUsuario.sql", Encoding.UTF8);
query = query.Replace("$projectId", projectId.ToString())
.Replace("$userId", userId);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Nome do projeto = " + projectId + "Nome do usuário = " + userId);
DataBaseHelpers.ExecuteQuery(query);
}
public DataTable RetrieveUser(string uName)
{
SqlCmdBuilder cmd = DataBaseHelpers.CreateADPPipelineCommand();
cmd.Query = @"SELECT *
FROM ADP_USER
WHERE UPPER(USERNAME)=@uName";
cmd.AddParameter("uName", SqlCmdParameterDirection.Input, uName.ToUpper());
return(cmd.GetTable());
}
public DataTable RetrieveUser(string uName, string pass)
{
SqlCmdBuilder cmd = DataBaseHelpers.CreateADPPipelineCommand();
cmd.Query = @"SELECT *
FROM ADP_USER
WHERE UPPER(USERNAME)=@uName AND PASSWORD=@pass";
cmd.AddParameter("uName", SqlCmdParameterDirection.Input, uName.ToUpper());
cmd.AddParameter("pass", SqlCmdParameterDirection.Input, ADP.Encryption.CryptoTools.ActionEncrypt(pass.ToUpper()));
return(cmd.GetTable());
}
public DataTable RetrieveRoleByName(string name)
{
SqlCmdBuilder cmd = DataBaseHelpers.CreateCommand();
cmd.Query = @"SELECT *
FROM ADP_ROLE
WHERE NAMA_ROLE=@name";
cmd.AddParameter("name", SqlCmdParameterDirection.Input, name);
return(cmd.GetTable());
}
public DataTable RetrieveRoleById(string idRole)
{
SqlCmdBuilder cmd = DataBaseHelpers.CreateADPPipelineCommand();
cmd.Query = @"SELECT *
FROM ADP_ROLE
WHERE ID_ROLE=@idRole";
cmd.AddParameter("idRole", SqlCmdParameterDirection.Input, idRole);
return(cmd.GetTable());
}
public void DeletarSubProjetoDB(int childId, int parentId)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/deletaSubProjeto.sql", Encoding.UTF8);
query = query.Replace("$childId", childId.ToString())
.Replace("$parentId", parentId.ToString());
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Child ID = " + childId + " Parent ID = " + parentId);
DataBaseHelpers.ExecuteQuery(query);
}
public ProjectDomain ConsultarSubProjetoDB(int childId, int parentId)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/consultaSubProjeto.sql", Encoding.UTF8);
query = query.Replace("$childId", childId.ToString())
.Replace("$parentId", parentId.ToString());
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Child ID = " + childId + " Parent ID = " + parentId);
return(DataBaseHelpers.ObtemRegistroUnico <ProjectDomain>(query));
}
public void DeletarPerfilUsuarioDB(string platform, string os, string osVersion)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Users/deletaPerfilUsuario.sql", Encoding.UTF8);
query = query.Replace("$platform", platform)
.Replace("$os", os)
.Replace("$version", osVersion);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Plataforma = " + platform + "SO = " + os + "Versão SO = " + osVersion);
DataBaseHelpers.ExecuteQuery(query);
}
public ProjectDomain InserirVersaoProjetoDB(int projectId, string versionName)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/inseriVersaoProjeto.sql", Encoding.UTF8);
query = query.Replace("$projectId", projectId.ToString())
.Replace("$versionName", versionName);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: ID do projeto = " + projectId + " | Nome da versão criada = " + versionName);
return(DataBaseHelpers.ObtemRegistroUnico <ProjectDomain>(query));
}
public void InserirSubProjetoDB(int childId, int parentId, string inheritParent)
{
string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Projects/inseriSubProjeto.sql", Encoding.UTF8);
query = query.Replace("$childId", childId.ToString())
.Replace("$parentId", parentId.ToString())
.Replace("$inheritParent", inheritParent);
ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: ID do projeto pai = " + parentId + " ID do projeto filho = " + childId);
DataBaseHelpers.ExecuteQuery(query);
}