public void regenerateDepositNumber1ForCaseId1960()
{
/////////// Query to DB and validations between UI and DB ///////////
DataRowCollection rows = null;
rows = ExecuteQueryOnDBWithString(Properties.Resources.regenerateDepositNumber1ForCaseId1960);
TestsLogger.Log("Deposit # 1 regenerated for case 1960");
}
public void regenerateDeposit1ForCaseId1378()
{
DataTable results = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("DBConnectionString")))
using (SqlCommand command = new SqlCommand(Properties.Resources.regenerateDepositNumber1ForCaseId1960, conn))
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
dataAdapter.Fill(results);
TestsLogger.Log("Deposit # 1 regenerated for case 1378");
}
public void deleteAllTransactionsCase1960()
{
/////////// Query to DB and validations between UI and DB ///////////
DataRowCollection rows1 = null;
Dictionary <string, int> parameters = new Dictionary <string, int>();
parameters.Clear();
rows1 = ExecuteQueryOnDBWithString(Properties.Resources.deleteAllTransactionsForCase1960);
TestsLogger.Log("All Transactions For Case 1960 were Deleted");
}
public void createDepositWithAssetLinksForCaseId1960()
{
DataTable results = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("DBConnectionString")))
using (SqlCommand command = new SqlCommand(Properties.Resources.createDepositWithAllLinksForCaseId1960, conn))
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
dataAdapter.Fill(results);
TestsLogger.Log("Deposit #9999 created for case 1960");
}
public void regenerateAsset2ForCase2391()
{
DataTable results = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("DBConnectionString")))
using (SqlCommand command = new SqlCommand(Properties.Resources.regenerateAsset2ForCase2391, conn))
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
dataAdapter.Fill(results);
TestsLogger.Log("Asset 2 Regenerated for case 2391");
}
public void ResetMissingTaxIdForTesting()
{
DataTable results = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("DBConnectionString")))
using (SqlCommand command = new SqlCommand(Properties.Resources.ResetMissingTaxIdForTesting, conn))
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
dataAdapter.Fill(results);
TestsLogger.Log("ResetMissingTaxIdForTesting Successfully executed!!");
}
public void deleteTestReports()
{
DataTable results = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("DBConnectionString")))
using (SqlCommand command = new SqlCommand(Properties.Resources.deleteTestReports, conn))
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
dataAdapter.Fill(results);
TestsLogger.Log("Test Reports Deleted");
}
public void deleteAllAssets()
{
DataTable results = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("DBConnectionString")))
using (SqlCommand command = new SqlCommand(Properties.Resources.deleteAllAssetsFromCase2374, conn))
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
dataAdapter.Fill(results);
TestsLogger.Log("All Assets for Case 2374 were deleted!!!!");
}
public void deleteDepositForSpecificCase()
{
/////////// Query to DB and validations between UI and DB ///////////
DataRowCollection rows = null;
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Clear();
parameters.Add("depositName", "My New Deposit");
rows = ExecuteQueryOnDBWithString(Properties.Resources.deleteDepositByCaseIdAndDepositName, parameters);
TestsLogger.Log("Deposit deleted for case 1960");
}
public void deleteLastGeneratedTransactionCase1378()
{
/////////// Query to DB and validations between UI and DB ///////////
DataRowCollection rows1 = null;
DataRowCollection rows2 = null;
Dictionary <string, int> parameters = new Dictionary <string, int>();
parameters.Clear();
rows1 = ExecuteQueryOnDBWithString(Properties.Resources.getLastGeneratedTransacionIdForCase1378);
parameters.Add("transactionIdFrank", Convert.ToInt32(rows1[0].ItemArray[0].ToString()));
rows2 = ExecuteQueryOnDBWithInt(Properties.Resources.deleteDepositAndLinksForTransactionId, parameters);
TestsLogger.Log("Last Generated Transaction For Case 1378 Deleted");
}
public void saveCaseIdFromSpecificTab(string tabName)
{
WebDriverWait wait = new WebDriverWait(driver, TimeSpan.FromSeconds(20));
pleaseWaitSignDissapear();
Thread.Sleep(1000);
IWebElement assetsTab = null;
string href = "";
string caseIdString = "";
int caseIdInt = 0;
if (tabName == "Assets")
{
assetsTab = wait.Until(ExpectedConditions.ElementExists(By.XPath("//div/a[@id='navItem-Assets']")));
href = assetsTab.GetAttribute("href").ToString();
string str = href.Substring(href.IndexOf("general/") + 8);
caseIdString = str.Replace("/asset", "");
caseIdInt = Convert.ToInt32(caseIdString);
}
else if (tabName == "Banking")
{
assetsTab = wait.Until(ExpectedConditions.ElementExists(By.XPath("//div/a[@id='navItem-Banking']")));
href = assetsTab.GetAttribute("href").ToString();
string str = href.Substring(href.IndexOf("general/") + 8);
caseIdString = str.Replace("/banking", "");
caseIdInt = Convert.ToInt32(caseIdString);
}
else
{
assetsTab = wait.Until(ExpectedConditions.ElementExists(By.XPath("//div/a[@id='navItem-Claims']")));
href = assetsTab.GetAttribute("href").ToString();
string str = href.Substring(href.IndexOf("general/") + 8);
caseIdString = str.Replace("/", "");
caseIdInt = Convert.ToInt32(caseIdString);
}
ScenarioContext.Current.Add("caseId", caseIdInt);
TestsLogger.Log(caseIdString);
pleaseWaitSignDissapear();
}
