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 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 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 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 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 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 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 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 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 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 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 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 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 List <string> ConsultarPerfilUsuarioDB(string platform, string os, string osVersion) { string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Users/consultaPerfilUsuario.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); return(DataBaseHelpers.ObtemDados(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); }
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 string InserirPerfilUsuarioDB(string platform, string os, string osVersion, string description) { string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Users/inseriPerfilUsuario.sql", Encoding.UTF8); query = query.Replace("$platform", platform) .Replace("$os", os) .Replace("$version", osVersion) .Replace("$description", description); ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Plataforma = " + platform + "SO = " + os + "Versão SO = " + osVersion); return(DataBaseHelpers.ObtemRegistroUnico <string>(query)); }
public UserDomain InserirUsuarioDB(string username, string realname, string enabled, string cookie, string email) { string query = File.ReadAllText(GeneralHelpers.GetProjectPath() + "Queries/Users/inseriUsuario.sql", Encoding.UTF8); query = query.Replace("$username", username) .Replace("$realname", realname) .Replace("$enabled", enabled) .Replace("$cookie", cookie) .Replace("$email", email); ExtentReportHelpers.AddTestInfoDB(2, "PARAMETERS: Username = "******" | Realname = " + realname + " | Enabled = " + enabled + " | E-mail = " + email); return(DataBaseHelpers.ObtemRegistroUnico <UserDomain>(query)); }