public void ThenIShouldBeAbleToEditCustomerRecordWithUpdatedInformation()
{
CustomersPage custobj = new CustomersPage();
// Edit Customer Test
custobj.EditCustomerTest(driver);
}
public override void StepBody()
{
CustomersPage customers = PageFactory.Init <CustomersPage>();
customers.tableCustomers["Delete Customer",
customers.tableCustomers.ItemsCount - 1].Click();
}
public void TestInit()
{
BrowserManagement.openBrowser();
loginPage = new LoginPage();
dashboardPage = loginPage.loginMethod();
customersPage = dashboardPage.navigateToCustomersPage();
}
public void ViewAddress(CustomersPage loadAddress)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
vAddressId = loadAddress.GridViewCustomers.SelectedRow.Cells[2].Text;
loadAddress.txViewAddressId.Text = vAddressId;
string sqlSelectCmd = "SELECT * FROM Addresses where addressId = '" + vAddressId + "'";
SqlCommand com = new SqlCommand(sqlSelectCmd, DatabaseConnection.dbConnection);
SqlDataReader read = com.ExecuteReader();
read.Read();
loadAddress.txViewAddressLine1.Text = read[1].ToString();
loadAddress.txViewAddressLine2.Text = read[2].ToString();
loadAddress.txViewAddressLine3.Text = read[3].ToString();
loadAddress.txViewCity.Text = read[4].ToString();
loadAddress.txViewZipPostCode.Text = read[5].ToString();
loadAddress.txViewStateProvince.Text = read[6].ToString();
read.Close();
DB.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
public void EditCustomerTest()
{
CustomersPage custobj = new CustomersPage();
// Edit Customer Test
custobj.EditCustomerTest(driver);
}
public void UpdateCustomer(CustomersPage updateCustomer)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
vCustomerId = updateCustomer.txUpdateCustomerId.Text;
vCustomerName = updateCustomer.txUpdateCustomerName.Text;
vAddressId = updateCustomer.txUpdateAddressId.Text;
vCreditCardNo = updateCustomer.txUpdateCreditCardNo.Text;
vCCExpireDate = updateCustomer.txUpdateCardExpireDate.Text;
vLine01 = updateCustomer.txUpdateAddressLine1.Text;
vLine02 = updateCustomer.txUpdateAddressLine2.Text;
vLine03 = updateCustomer.txUpdateAddressLine3.Text;
vCity = updateCustomer.txUpdateCity.Text;
vStateProvince = updateCustomer.txUpdateStateProvince.Text;
vZipPostal = updateCustomer.txUpdateZipPostCode.Text;
string sqlUpdateCom = "UPDATE Addresses SET line1Number = '" + vLine01 + "', line2Street = '" + vLine02 + "', line3Area = '" + vLine03 + "', city = '" + vCity + "', zipPostCode = '" + vZipPostal + "', stateProvinceCountry = '" + vStateProvince + "' WHERE addressId = '" + vAddressId + "'";
SqlCommand com = new SqlCommand(sqlUpdateCom, DatabaseConnection.dbConnection);
com.ExecuteNonQuery();
string sqlUpdateCmd = "UPDATE Customers SET customerName = '" + vCustomerName + "', creditCardNo = '" + vCreditCardNo + "', cardExpiryDate = '" + vCCExpireDate + "' WHERE customerId = '" + vCustomerId + "'";
SqlCommand cmd = new SqlCommand(sqlUpdateCmd, DatabaseConnection.dbConnection);
cmd.ExecuteNonQuery();
DB.closeConnection();
ScriptManager.RegisterClientScriptBlock(updateCustomer, this.GetType(), "SweetAlert", "swal('Success!', 'Customer Updated', 'success').then(function(){window.location='CustomersPage.aspx';})", true);
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
public void ThenIShouldBeAbleToCreateCustomerRecordWithValidInformation()
{
CustomersPage custobj = new CustomersPage();
//Create new customer Test
custobj.AddCustomerTest(driver);
}
private IWebElement PerformValidation(IWebDriver driver, CustomersPage customerPage, string id)
{
ValidateURL(driver, customersUrl);
IWebElement row = customerPage.SearchById(driver, id);
return(row);
}
public void TestAddCustomer()
{
HomePage homePage = new HomePage();
CustomersPage customersPage = null;
Customer customerObject = null;
// Locate Administration Menu and Click
// Locate Time & Materials Menu item and Click
try
{
customersPage = homePage.GoToCustomersPage(Driver);
Contact contactObject = new Contact(
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactFirstName"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactLastName"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactPhoneNumber"));
customerObject = new Customer(ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "CustomerName"), contactObject, contactObject);
customersPage.CreateNewCustomer(Driver, customerObject);
// go back to the summary page
// creating a new customer does not change the landing page
// have to explicitly go back to the summary page...
//Driver.Navigate().Back();
//customersPage.refreshTable(Driver);
Driver.Navigate().GoToUrl(customersUrl);
}
catch (Exception e)
{
Assert.Fail("Unexpected error has occurred - TestAddCustomer failed " + e.Message);
}
// verify
Assert.That(PerformValidation(Driver, customersPage, customerObject), Is.Not.Null, "Unable to create new customer - TestAddCustomer failed");
}
public void addWorkFlow()
{
IArclitePage personnel = new PersonnelPage(visitor, inputs);
personnel.runTests(ArcliteTestAction.add);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage customer = new CustomersPage(visitor, inputs);
customer.runTests(ArcliteTestAction.add);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage supplier = new SuppliersPage(visitor, inputs);
supplier.runTests(ArcliteTestAction.add);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage inventory = new InventoryPage(visitor, inputs);
inventory.runTests(ArcliteTestAction.add);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage workflow = new WorkflowBuilderPage(visitor, inputs);
workflow.runTests(ArcliteTestAction.add);
}
public void deleteWorkflow()
{
IArclitePage workflow = new WorkflowBuilderPage(visitor, inputs);
workflow.runTests(ArcliteTestAction.delete);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage supplier = new SuppliersPage(visitor, inputs);
supplier.runTests(ArcliteTestAction.delete);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage customer = new CustomersPage(visitor, inputs);
customer.runTests(ArcliteTestAction.delete);
visitor.switchToParentFrame();
Thread.Sleep(longSleepTime);
IArclitePage asset = new AssetsPage(visitor, inputs);
asset.runTests(ArcliteTestAction.delete);
}
public void DeleteCustomerTest()
{
CustomersPage custobj = new CustomersPage();
// Delete Customer Test
custobj.DeleteCustomerTest(driver);
}
public override void StepBody()
{
CustomersPage customers = PageFactory.Init <CustomersPage>();
Assert.AreEqual((int)Context.Get("Customers Count") + this.shift,
customers.tableCustomers.ItemsCount);
}
public void LoadCustomerUpdateData(CustomersPage loadCustomer)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
loadCustomer.txUpdateCustomerId.Text = loadCustomer.GridViewCustomers.SelectedRow.Cells[1].Text;
loadCustomer.txUpdateAddressId.Text = loadCustomer.GridViewCustomers.SelectedRow.Cells[2].Text;
loadCustomer.txUpdateCustomerName.Text = loadCustomer.GridViewCustomers.SelectedRow.Cells[3].Text;
loadCustomer.txUpdateCreditCardNo.Text = loadCustomer.GridViewCustomers.SelectedRow.Cells[5].Text;
loadCustomer.txUpdateCardExpireDate.Text = loadCustomer.GridViewCustomers.SelectedRow.Cells[6].Text;
vAddressId = loadCustomer.GridViewCustomers.SelectedRow.Cells[2].Text;
string sqlSelectCmd = "SELECT * FROM Addresses where addressId = '" + vAddressId + "'";
SqlCommand com = new SqlCommand(sqlSelectCmd, DatabaseConnection.dbConnection);
SqlDataReader read = com.ExecuteReader();
read.Read();
loadCustomer.txUpdateAddressLine1.Text = read[1].ToString();
loadCustomer.txUpdateAddressLine2.Text = read[2].ToString();
loadCustomer.txUpdateAddressLine3.Text = read[3].ToString();
loadCustomer.txUpdateCity.Text = read[4].ToString();
loadCustomer.txUpdateZipPostCode.Text = read[5].ToString();
loadCustomer.txUpdateStateProvince.Text = read[6].ToString();
read.Close();
DB.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
public void EditCustomerTest()
{
// object for customer page
CustomersPage custObj = new CustomersPage();
// edit customer test
custObj.EditCustomerTest();
}
public void CustomersPageTestScenario()
{
CustomersPage.NavigateTo();
Common.AssertDocumentStateComplete();
Common.VerifyURLTextContainsSrt("customers");
Common.AssertPageHeaderTextIsDisplayed("Customers");
Common.AssertPageFooterIsDisplayed("Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.\r\nAll Rights Reserved.");
}
public void DeleteCustomerTest()
{
// object for customer page
CustomersPage custObj = new CustomersPage();
// delete customer test
custObj.DeleteCustomerTest();
}
public override void StepBody()
{
GoToBankManagerTabPageStep <CustomersPage> navigateStep = new GoToBankManagerTabPageStep <CustomersPage>();
navigateStep.Run();
CustomersPage customers = PageFactory.Init <CustomersPage>();
Context.Put("Customers Count", customers.tableCustomers.ItemsCount);
}
public override void StepBody()
{
CustomersPage customers = PageFactory.Init <CustomersPage>();
int rows = customers.tableCustomers.ItemsCount;
Assert.AreEqual(firstName, customers.tableCustomers["First Name", rows - 1].Text);
Assert.AreEqual(lastName, customers.tableCustomers["Last Name", rows - 1].Text);
Assert.AreEqual(postCode, customers.tableCustomers["Post Code", rows - 1].Text);
}
public void ThenIShouldBeAbleToCreateCustomerRecordWithValidInformation()
{
// create object for CustomerPage
CustomersPage custObj = new CustomersPage();
// create new customer test
custObj.AddCustome(driver);
// quit driver
driver.Quit();
}
public void ThenIShouldBeAbleToDeleteCustomerRecord()
{
// create object for CustomerPage
CustomersPage custObj = new CustomersPage();
//Delete customer test
custObj.DeleteCustomer(driver);
// quit driver
driver.Quit();
}
public void ThenIShouldBeAbleToEditCustomerRecordWithUpdatedInformation()
{
// create object for CustomerPage
CustomersPage custObj = new CustomersPage();
// Edit customer test
custObj.EditCustomer(driver);
// quit driver
driver.Quit();
}
public void AddNewCustomerTest()
{
//page object for home page
HomePage homeobj = new HomePage();
homeobj.NavigateToTM(driver);
CustomersPage custobj = new CustomersPage();
//Create new customer Test
custobj.AddCustomerTest(driver);
}
public void DeleteCustonerTest()
{
// page object for Home page
HomePage homeObj = new HomePage();
homeObj.NavigateToCustomer(driver);
// create object for CustomerPage
CustomersPage custObj = new CustomersPage();
//Delete customer test
custObj.DeleteCustomer(driver);
}
public void TC_IPP8_Example()
{
const string customer = "cust111";
const string jobName = "1340close";
CustomersPage.Navigate();
CustomersPage.Table.SelectRow(customer);
CustomerOverviewPage.Status = JobStatus.AllJobs;
bool doesJobExist = CustomerOverviewPage.Table.DoesRowExists(jobName);
Assert.IsTrue(doesJobExist, "Job with name " + jobName + " does not exist in Job list for customer " + customer);
}
public void FiltrationTestsScenario()
{
CustomersPage.NavigateTo();
Common.AssertDocumentStateComplete();
Common.VerifyURLTextContainsSrt("customers");
Common.AssertPageHeaderTextIsDisplayed("Customers");
Common.AssertPageFooterIsDisplayed("Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.\r\nAll Rights Reserved.");
FiltrationAsserts.AssertFilterIsDisplayed();
FiltrationAsserts.AssertFilterCriteriaArePresented("INDUSTRY", "PRODUCT", "SOLUTION");
FiltrationBase.ClickOnSelectIndustry();
FiltrationBase.SelectIndustry("Education");
FiltrationAsserts.AssertThatSelectedOptionIsMarked("Education");
FiltrationAsserts.AssertThatDisplayedResultsAreBasedOnSelectedIndustry("Education");
}
public void DeleteCustomer(CustomersPage deleteCustomer)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
vCustomerId = deleteCustomer.GridViewCustomers.SelectedRow.Cells[1].Text;
string sqlDeleteUpdateCmd = "DELETE FROM Customers WHERE customerID = '" + vCustomerId + "'";
SqlCommand cmd = new SqlCommand(sqlDeleteUpdateCmd, DatabaseConnection.dbConnection);
cmd.ExecuteNonQuery();
DB.closeConnection();
ScriptManager.RegisterClientScriptBlock(deleteCustomer, this.GetType(), "SweetAlert", "swal('Success!', 'Customer Deleted', 'success').then(function(){window.location='CustomersPage.aspx';})", true);
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
public void TestUpdateCustomer()
{
HomePage homePage = new HomePage();
CustomersPage customersPage = null;
string id = null;
// Locate Administration Menu and Click
// Locate Time & Materials Menu item and Click
try
{
customersPage = homePage.GoToCustomersPage(Driver);
Contact contactObject = new Contact(
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactFirstName"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactLastName"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactPhoneNumber"));
Customer customerObject = new Customer(ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "CustomerName"), contactObject, contactObject);
customersPage.CreateNewCustomer(Driver, customerObject);
// go back to the summary page
Driver.Navigate().GoToUrl(customersUrl);
// verify
IWebElement customerElementRow = PerformValidation(Driver, customersPage, customerObject);
Assert.That(customerElementRow, Is.Not.Null, "Unable to create new customer - TestUpdateCustomer failed");
id = customerElementRow.FindElement(By.XPath("td[1]")).Text;
Contact updatedContactObject = new Contact(
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactFirstName"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactLastName"),
ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "ContactPhoneNumber"));
Customer updatedCustomerObject = new Customer(ExcelLibHelpers.ReadData(GenerateRandomNumber(2, 7), "CustomerName"), updatedContactObject, updatedContactObject);
customersPage.UpdateCustomer(Driver, id, updatedCustomerObject);
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
Assert.Fail("Unexpected error has occurred - TestUpdateCustomer failed " + e.Message);
}
Assert.That(PerformValidation(Driver, customersPage, id), Is.Not.Null, "Unable to update customer - TestUpdateCustomer failed");
}
public void TestAddNewCustomer()
{
bankManagerMenu = home.buttonBankManagerLogin.ClickAndWaitFor <BankManagerCommonPage>();
customers = bankManagerMenu.buttonCustomers.ClickAndWaitFor <CustomersPage>();
Assert.True(customers.tableCustomers.IsNotEmpty());
int rows = customers.tableCustomers.ItemsCount;
addCustomer = customers.buttonAddCustomer.ClickAndWaitFor <AddCustomerPage>();
Assert.True(addCustomer.AllElementsExist(
new Control[]
{
addCustomer.editFirstName,
addCustomer.editLastName,
addCustomer.editPostCode,
addCustomer.buttonSubmit
})
);
Assert.True(addCustomer.AnyOfElementsExist(new Control[] {
addCustomer.editFirstName,
addCustomer.editLastName,
addCustomer.editPostCode,
addCustomer.buttonSubmit
}));
System.Threading.Thread.Sleep(1000);
addCustomer.editFirstName.Text = "Test";
addCustomer.editLastName.Text = "User";
addCustomer.editPostCode.Text = "WWW99";
addCustomer.buttonSubmit.Click();
addCustomer.Driver.SwitchTo().Alert().Accept();
customers = addCustomer.buttonCustomers.ClickAndWaitFor <CustomersPage>();
Assert.AreEqual(rows + 1, customers.tableCustomers.ItemsCount);
Assert.AreEqual("Test", customers.tableCustomers["First Name", rows].Text);
Assert.AreEqual("User", customers.tableCustomers["Last Name", rows].Text);
Assert.AreEqual("WWW99", customers.tableCustomers["Post Code", rows].Text);
customers.tableCustomers["Delete Customer", rows].Click();
Assert.True(customers.tableCustomers.IsNotEmpty());
Assert.AreEqual(rows, customers.tableCustomers.ItemsCount);
}
public void addNewCustomer(CustomersPage addCustomer)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
vCustomerId = addCustomer.txCustomerId.Text;
vCustomerName = addCustomer.txCustomerName.Text;
vAddressId = addCustomer.ddAddress.SelectedValue;
vDateBecomeCustomer = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
vCreditCardNo = addCustomer.txCreditCardNo.Text;
vCCExpireDate = addCustomer.txCardExpireDate.Text;
vLine01 = addCustomer.txAddressLine1.Text;
vLine02 = addCustomer.txAddressLine2.Text;
vLine03 = addCustomer.txAddressLine3.Text;
vCity = addCustomer.txCity.Text;
vStateProvince = addCustomer.txStateProvince.Text;
vZipPostal = addCustomer.txZipPostCode.Text;
if (addCustomer.rbListAddress.SelectedIndex == 0)
{
vAddressId = addCustomer.txNewAddressId.Text;
string sqlInsertCom = "INSERT INTO Addresses VALUES('" + vAddressId + "', '" + vLine01 + "', '" + vLine02 + "', '" + vLine03 + "', '" + vCity + "', '" + vZipPostal + "', '" + vStateProvince + "')";
SqlCommand com = new SqlCommand(sqlInsertCom, DatabaseConnection.dbConnection);
com.ExecuteNonQuery();
}
string sqlInsertCmd = "INSERT INTO Customers VALUES('" + vCustomerId + "', '" + vAddressId + "', '" + vCustomerName + "', '" + vDateBecomeCustomer + "', '" + vCreditCardNo + "', '" + vCCExpireDate + "')";
SqlCommand cmd = new SqlCommand(sqlInsertCmd, DatabaseConnection.dbConnection);
cmd.ExecuteNonQuery();
DB.closeConnection();
ScriptManager.RegisterClientScriptBlock(addCustomer, this.GetType(), "SweetAlert", "swal('Success!', 'New Customer Registered', 'success').then(function(){window.location='CustomersPage.aspx';})", true);
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
