public static void ExecuteQuery(string query) { using (SqlCommand cmd = new SqlCommand(query, GetDBConnection())) { cmd.CommandTimeout = Int32.Parse(BuilderJson.ReturnParameterAppSettings("DB_CONNECTION_TIMEOUT")); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public static void AddTestInfo(int methodLevel, string text) { if (BuilderJson.ReturnParameterAppSettings("GET_SCREENSHOT_FOR_EACH_STEP").ToString() == "true") { TEST.Log(Status.Pass, GeneralHelpers.GetMethodNameByLevel(methodLevel) + " || " + text, GetScreenShotMedia()); } else { TEST.Log(Status.Pass, GeneralHelpers.GetMethodNameByLevel(methodLevel) + " || " + text); } }
private static SqlConnection GetDBConnection() { string connectionString = "Data Source=" + BuilderJson.ReturnParameterAppSettings("DB_URL") + "," + BuilderJson.ReturnParameterAppSettings("DB_PORT") + ";" + "Initial Catalog=" + BuilderJson.ReturnParameterAppSettings("DB_NAME") + ";" + "User ID=" + BuilderJson.ReturnParameterAppSettings("DB_USER") + "; " + "Password="******"DB_PASSWORD") + ";"; SqlConnection connection = new SqlConnection(connectionString); return(connection); }
public static List <string> RetornaDadosQuery(string query) { DataSet ds = new DataSet(); List <string> lista = new List <string>(); using (SqlCommand cmd = new SqlCommand(query, GetDBConnection())) { cmd.CommandTimeout = Int32.Parse(BuilderJson.ReturnParameterAppSettings("DB_CONNECTION_TIMEOUT")); cmd.Connection.Open(); DataTable table = new DataTable(); table.Load(cmd.ExecuteReader()); ds.Tables.Add(table); cmd.Connection.Close(); } if (ds.Tables[0].Columns.Count == 0) { return(null); } try { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { lista.Add(ds.Tables[0].Rows[i][j].ToString()); } } } catch (Exception) { return(null); } return(lista); }
public static void CreateInstance() { string browser = BuilderJson.ReturnParameterAppSettings("BROWSER"); string execution = BuilderJson.ReturnParameterAppSettings("EXECUTION"); bool headless = bool.Parse(BuilderJson.ReturnParameterAppSettings("HEADLESS")); if (INSTANCE == null) { switch (browser) { case "chrome": if (execution.Equals("local")) { INSTANCE = headless ? Browsers.GetLocalChromeHeadless() : Browsers.GetLocalChrome(); } if (execution.Equals("remota")) { INSTANCE = headless ? Browsers.GetRemoteChromeHeadless() : Browsers.GetRemoteChrome(); } break; case "ie": if (execution.Equals("local")) { INSTANCE = Browsers.GetLocalInternetExplorer(); } if (execution.Equals("remota")) { INSTANCE = Browsers.GetRemoteInternetExplorer(); } break; case "firefox": if (execution.Equals("local")) { INSTANCE = Browsers.GetLocalFirefox(); } if (execution.Equals("remota")) { INSTANCE = Browsers.GetRemoteFirefox(); } break; case "edge": if (execution.Equals("local")) { INSTANCE = Browsers.GetLocalEdge(); } if (execution.Equals("remota")) { INSTANCE = Browsers.GetRemoteEdge(); } break; default: throw new Exception("O browser informado não existe ou não é suportado pela automação"); } } }