public void WithoutName()
{
var regPage = new RegistrationPage(this.driver);
driver.Navigate().GoToUrl(regPage.URL);
var testUser = ExcelDataAccess.GetTestData("NoNames");
regPage.NavigateTo();
regPage.FillRegistrationForm(testUser);
regPage.AssertNamesErrorMessage("* This field is required");
}
public void RegistrateWithOutPhoneNumber()
{
var regPage = new RegistrationPage(this.driver);
driver.Navigate().GoToUrl(regPage.URL);
var testUser = ExcelDataAccess.GetTestData("NoPhone");
regPage.NavigateTo();
regPage.FillRegistrationForm(testUser);
regPage.AssertPhoneErrorMessage("This field is required");
}
public static void DowningRegEnterEmail(string emailAddress = "")
{
if (emailAddress == "")
{
emailAddress = Faker.NameFaker.FirstName() + NumberFaker.Number(999) + "@yopmail.com";
}
Browser.EnterText(BySelection.Id, EmailID, emailAddress);
ExcelDataAccess excelDataAccess = new ExcelDataAccess();
excelDataAccess.WriteTestData("Email address:" + "" + emailAddress);
}
public void WeakPass()
{
var regPage = new RegistrationPage(this.driver);
driver.Navigate().GoToUrl(regPage.URL);
var testUser = ExcelDataAccess.GetTestData("WeakPass");
regPage.NavigateTo();
regPage.FillRegistrationForm(testUser);
regPage.AssertShortPassErrorMessage("Very weak");
}
public void NoEmail()
{
var regPage = new RegistrationPage(driver);
driver.Navigate().GoToUrl(regPage.URL);
var testUser = ExcelDataAccess.GetTestData("NoEmail");
regPage.NavigateTo();
regPage.FillRegistrationForm(testUser);
regPage.AssertMessagesForNoEmail("* This field is required");
}
public void LoginToApplication(string testName)
{
WebDriverWait wait = new WebDriverWait(driver, TimeSpan.FromSeconds(20));
wait.Until(ExpectedConditions.ElementToBeClickable(UserName));
var userData = ExcelDataAccess.GetTestData(testName);
UserName.SendKeys(userData.Username);
Password.SendKeys(userData.Password);
LoginBtn.Click();
}
public void A1_VerifyLoginWithInValidCrdentails()
{
UserData userData = ExcelDataAccess.GetTestData("LoginScreen$", "InValidCredentials");
LoginPage_.EnterUserName(userData.Username).EnterPassword(userData.Password).ClickLoginButton();
_logger.Info($": Successfully Entered invalid username {userData.Username}and password {userData.Password} and clicked on login button");
Assert.True(LoginPage_.VerifyInvalidCredentialsAreDisplayed("User ID or Password are incorrect. Please try again or contact the NDB helpdesk"));
_logger.Info($": Successfully Verified the message displayed after entering invalid username {userData.Username} and password {userData.Password}");
}
public override void SaveData()
{
IOFileInfo ei = new IOFileInfo();
//CommonFunctions.SetCommonPropertyValues(this, ei);
ei.WorkSheetName = FileName;
DataAccessBase eda = new ExcelDataAccess(ei);
eda.Save();
}
/// <summary>
/// 修改账单
/// </summary>
/// <param name="goods"></param>
/// <param name="errorMessage"></param>
/// <returns></returns>
public bool updateBills(Goods goods, out string errorMessage)
{
string sql = "update [" + getExcelSheetNameById(TableId.BillForExcel) + "] set 商品名称 = " + goods.goodsName + ",商品价格=" + goods.goodsPrice + ",商品类别=" + goods.goodsType + ",商场=" + goods.mall + ",购买时间=" + goods.createDate + ",备注=" + goods.goodsMark + " where id= " + goods.id;
int execCount = ExcelDataAccess.ExecuteCommand(sql, connectionString, out errorMessage);
if (execCount < 1)
{
//errorMessage = "修改失败";
return(false);
}
return(true);
}
/// <summary>
/// 获取id对应的sheet表的最大id（获取表的序列.nextVal）
/// </summary>
/// <param name="tableId"></param>
/// <returns></returns>
private int getExcelSheetMaxId(TableId tableId, out string errMsg)
{
int maxId;
maxId = ExcelDataAccess.getExcelSheetMaxId(connectionString, (int)tableId, out errMsg);
if (maxId < 0)
{
//写入log文件
Log.writeLog(errMsg);
}
return(maxId);
}
//public void Login(String Usern, String pwdn)
//{
// _logger.Trace("Attempting to login");
// PropertiesCollection.driver.Navigate().Refresh();
// username.EnterText(Usern);
// _logger.Info($"username is {Usern}");
// pwd.EnterText(pwdn);
// _logger.Info("password is {0}", pwdn);
// loginButton.Clickme();
//}
public void Login(string sheetname, string testName)
{
_logger.Trace("Attempting to login");
PropertiesCollection.driver.Navigate().Refresh();
var userData = ExcelDataAccess.GetTestData(sheetname, testName);
username.EnterText(userData.Username);
_logger.Info($"username is {userData.Username}");
pwd.EnterText(userData.Password);
_logger.Info("password is {0}", userData.Password);
loginButton.Clickme();
}
public void WithoutEmailAndPhone()
{
var regPage = new RegistrationPage(this.driver);
driver.Navigate().GoToUrl(regPage.URL);
var testUser = ExcelDataAccess.GetTestData("WithoutEmailAndPhone");
regPage.NavigateTo();
regPage.FillRegistrationForm(testUser);
regPage.AssertMessagesForNoEmail("* This field is required");
regPage.AssertPhoneErrorMessage("* This field is required");
}
public override void SaveData()
{
IOFileInfo ei = new IOFileInfo();
// CommonFunctions.SetCommonPropertyValues(this, ei);
ei.WorkSheetName = FileName;
ei.FileFullPath = this.FolderName + "\\" + FileName + ".XLSX";
DataAccessBase eda = new ExcelDataAccess(ei);
eda.Save();
}
public override void ImportData(string WorkSheetName)
{
IOFileInfo ei = new IOFileInfo();
ei.FileFullPath = FileFullPath;
DataAccessBase eda = new ExcelDataAccess(ei);
DataSource = eda.Import(WorkSheetName);
//RemoveSpecialCharactersFromColumns();
//PopulateTableHeader();
//PopulateFirstAndLastRowArray();
}
public void GoogleSearchUsingData2(string testName)
{
var userData = ExcelDataAccess <UserData> .GetTestData(testName, "TestDataSheetPath2");
GoogleHomePage gHome = new GoogleHomePage(driver);
gHome.MaximizeWindow();
gHome.getSearchTextBox().SendKeys(userData.Sarasa);
GoogleResultPage gSearch = gHome.search();
gSearch.getFirstResult().Text.ToLower().Should().Contain(userData.Sarasa.ToLower());
}
public void SignIn(string testName)
{
var userData = ExcelDataAccess.GetTestData(testName);
loginInput.SendKeys(userData.Login);
passwordInput.SendKeys(userData.Password);
//loginInput.SendKeys(login);
//passwordInput.SendKeys(password);
log.WriteMessagesInFile($"Email: {userData.Login}, password: {userData.Password}");
logInBtn.Click();
//SendKeys(loginInput, login);
//SendKeys(passwordInput, password);
}
/// <summary>
/// 修改商品类别
/// </summary>
/// <param name="goodsType"></param>
/// <param name="errorMessage"></param>
/// <returns></returns>
public bool updateGoodsType(GoodsType goodsType, out string errorMessage)
{
errorMessage = "";
string sql = "update [" + getExcelSheetNameById(TableId.GoodsTypeForExcel) + "] set 商品类别 = " + goodsType.goodsTypeName + "where 类别代码 =" + goodsType.goodsTypeCode;
int execCount = ExcelDataAccess.ExecuteCommand(sql, connectionString, out errorMessage);
if (execCount < 1)
{
errorMessage = "修改失败，手动删除";
return(false);
}
return(true);
}
/// <summary>
/// 删除商品类别
/// </summary>
/// <param name="goodsType"></param>
/// <param name="errorMessage"></param>
/// <returns></returns>
public bool deleteGoodsType(GoodsType goodsType, out string errorMessage)
{
errorMessage = "";
string sql = "delete from [" + getExcelSheetNameById(TableId.GoodsTypeForExcel) + "] where 类别代码=" + goodsType.goodsTypeCode;
int execCount = ExcelDataAccess.ExecuteCommand(sql, connectionString, out errorMessage);
if (execCount < 1)
{
//errorMessage += "删除失败，请稍后重试，或手动删除";
return(false);
}
return(true);
}
public void SetUp()
{
// DADOS DO TESTE
TestContext.CurrentContext.Test.Properties.Add("Category", "DEMO_STORE_PANEL");
TestContext.CurrentContext.Test.Properties.Add("ClassName", this.GetType().Name);
TestContext.CurrentContext.Test.Properties.Add("StepCount", 1);
entityData = ExcelDataAccess.GetTestData();
// OBJETOS DO TESTE
WebDriverFactory.InitBrowser(entityData.Browser);
generalMethods = new GeneralMethods();
WebDriverFactory.Driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(60);
}
private void btnImportByExcel_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog dlgDialog = new OpenFileDialog();
dlgDialog.Filter = "All File |*.*;|File Excel |*.xlsx;|File Excel |*.xls;";
dlgDialog.FilterIndex = 1;
dlgDialog.AddExtension = true;
dlgDialog.RestoreDirectory = true;
dlgDialog.InitialDirectory = Application.StartupPath + "\\Template";
if (dlgDialog.ShowDialog() == DialogResult.OK)
{
try
{
string sourcefile = dlgDialog.FileName;
string excelquery = string.Format("Select * from [{0}$]", SHEETNAME);
ExcelDataAccess.SourceFile = sourcefile;
ExcelDataAccess.OpenConnectionExcel();
DataSet ds = ExcelDataAccess.GetDataSet(excelquery);
TinNhanSMS temp;
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row[0].ToString().Length > 3)
{
temp = new TinNhanSMS();
temp.SoDienThoai = row[0].ToString();
temp.TenNhanVien = row[1].ToString();
temp.ThongTinThem = row[2].ToString();
_listData.Add(temp);
}
}
}
ExcelDataAccess.CloseConnectionExcel();
gridMessage.DataSource = _listData;
gridViewMessage.RefreshData();
}
catch (Exception ex)
{
new MessageBoxBA().Show(ex.ToString());
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("btnImportByExcel_Click: ", ex);
}
}
public void RegisterWithBlankFields()
{
RegistrationPage regPage = new RegistrationPage(this.driver);
RegistrationUser user = ExcelDataAccess.GetTestData("withInvalidPicture");
regPage.Navigate();
regPage.Submit.Click();
regPage.AssertLastNamesErrorMessage("* This field is required");
regPage.AssertHobbiesErrorMessage("* This field is required");
regPage.AssertPhoneErrorMessage("* This field is required");
regPage.AssertMessageForMail("* This field is required");
regPage.AssertPasswordErrorMessage("* This field is required");
regPage.AssertConfirmPasswordErrorMessage("* This field is required");
}
public void CreateSurveyTest()
{
// instantiate the dataSheet
var userData = ExcelDataAccess.GetTestData("LoginTest");
// instantiate browser to start
//navigate to target website and output title for debugging
driver.Navigate().GoToUrl(userData.targetURL);
Console.WriteLine(driver.Title);
//verify web title equals expected
Assert.IsTrue(driver.Title.ToLower().Trim().Equals(pFactory.homePage(driver).getTitle()));
pFactory.homePage(driver).clickSignInButton();
// Login to website
pFactory.loginPage(driver).loginAsUser(userData.userName, userData.userPass);
//start survey creation
pFactory.dashboardPage(driver).clickCreateSurveyButton();
pFactory.dashboardSurveyListPage(driver).clickStartFromScratchButton();
pFactory.dashboardSurveyListPage(driver).createSurveyName(userData.surveyName);
pFactory.editSurveyPage(driver).enterSurveyQuestion(userData.getQuestionType(userData.question1), userData.getQuestionTitle(userData.question1), userData.getQuestionChoices(userData.question1));
pFactory.editSurveyPage(driver).enterSurveyQuestion(userData.getQuestionType(userData.question2), userData.getQuestionTitle(userData.question2), userData.getQuestionChoices(userData.question2));
pFactory.editSurveyPage(driver).enterSurveyQuestion(userData.getQuestionType(userData.question3), userData.getQuestionTitle(userData.question3), userData.getQuestionChoices(userData.question3));
pFactory.editSurveyPage(driver).enterSurveyQuestion(userData.getQuestionType(userData.question4), userData.getQuestionTitle(userData.question4), userData.getQuestionChoices(userData.question4));
pFactory.editSurveyPage(driver).enterSurveyQuestion(userData.getQuestionType(userData.question5), userData.getQuestionTitle(userData.question5), userData.getQuestionChoices(userData.question5));
// refresh the page to reduce sync errors
driver.Navigate().Refresh();
//move to final page
pFactory.editSurveyPage(driver).clickNextQuestionButton();
// get web link and output to console
pFactory.collectionsPage(driver).clickWebLinkButton();
pFactory.collectionDetailsPage(driver).waitForElementToBeClickable(pFactory.collectionDetailsPage(driver).webLinkURLLabel, 3);
String weblinkURL = pFactory.collectionDetailsPage(driver).webLinkURLLabel.GetAttribute("value");
Console.Write("Test Success - Web link for survey is: " + weblinkURL);
//Wait on this page for no reason other than to emphasize test is completed
pFactory.collectionDetailsPage(driver).wait(2);
//navigate to my surveys page for deletion
//pFactory.navBar(driver).navigateToMySurveysPage();
//pFactory.mySurveysPage(driver).deleteFirstSurvey();
//close the browser
driver.Quit();
}
public void A2_VerifyLoginWithValidCrdentails()
{
UserData userData = ExcelDataAccess.GetTestData("LoginScreen$", "SAHUserValidCredentails");
LoginPage_.EnterUserName(userData.Username).EnterPassword(userData.Password).ClickLoginButton();
_logger.Info($": Successfully Entered valid username {userData.Username} and password {userData.Password} and clicked on login button");
HomePage_.ClickShopAtHomeTab();
_logger.Info($": Successfully CLicked on Shop at Home Tab on homepage");
Assert.True(HomePage_.VerifyShopAtHomeTabIsClicked());
_logger.Info($": Successfully Verfied that Shop at Home tab is clicked on homepage");
HomePage_.Signout();
_logger.Info($": Successfully CLicked on Signout button n homepage");
}
/*
* public LoginPage(IWebDriver driver) {
* PageFactory.InitElements(driver, this);
* }
*/
public void LoginToApplication(string testName)
{
var userData = ExcelDataAccess.GetTestData(testName);
/*UserName.SendKeys("selenium_test");
* Password.SendKeys("9Esu%YxUmZuP1lBA");
*/
/*
* UserName.SendKeys(userData.Username);
* Password.SendKeys(userData.Password);
* Submit.Click();
*/
UserName.EnterText(userData.Username, "Username");
Password.EnterText(userData.Password, "Passowrd");
Submit.ClickOnIt("Submit button");
}
/*
* public LoginPage(IWebDriver driver)
* {
* this.driver = driver;
* PageFactory.InitElements(driver, this);
* }
*/
public void LoginToApplication(string testName)
{
var userData = ExcelDataAccess.GetTestData(testName);
// UserName.Clear();
// UserName.SendKeys(userData.Username);
UserName.EnterText(userData.Username, "id_username");
// Password.Clear();
// Password.SendKeys(userData.Password);
Password.EnterText(userData.Password, "password");
// Login.Submit();
// Logout.Click();
// LoginAgain.Click();
Login.ClickOnIt("submit");
Logout.ClickOnIt("LOG OUT");
LoginAgain.ClickOnIt("Log in again");
}
public void TestMethod1()
{
test.AssignAuthor("Nancy Tuli");
/*NUnit.Framework.TestContext.Progress.WriteLine("The url is " + ConfigurationManager.AppSettings["url"]);
*/
BrowserMethods.Goto(ConfigurationManager.AppSettings["url"]);
test.Log(LogStatus.Info, "Opened Browser");
BrowserMethods.getDriver.Manage().Window.Maximize();
var homePage = new HomePage(BrowserMethods.getDriver);
homePage.Dismiss.Click();
homePage.MyAccount.Click();
var userData = ExcelDataAccess.GetTestData("LoginTest");
homePage.UserName_txtBox.SendKeys(userData.Username);
homePage.Passwd_txtBox.SendKeys(userData.Password);
homePage.Login_btn.Click();
test.Log(LogStatus.Info, "Entered Credentials");
test.Log(LogStatus.Pass, "Test Case passd");
}
public void LoginToTheApplicationWithCorrectCredentials()
{
test.AssignAuthor("Nancy Tuli");
BrowserMethods.getDriver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(120);
BrowserMethods.Goto(ConfigurationManager.AppSettings["url"]);
test.Log(LogStatus.Info, "Opened Browser");
BrowserMethods.getDriver.Manage().Window.Maximize();
Assert.That(BrowserMethods.Title, Contains.Substring("ToolsQA Demo Site"));
var homePage = new HomePage(BrowserMethods.getDriver);
homePage.clickOnDismissButton();
homePage.clickOnMyAccountTab();
var userData = ExcelDataAccess.GetTestData("LoginTest");
homePage.loginToApplicationWithCredentials(userData.Username, userData.Password);
var accountPage = new MyAccountPage(BrowserMethods.getDriver);
Assert.That(accountPage.getTextFromHelloTxt, Contains.Substring(String.Format("Hello {0}", userData.Username)));
test.Log(LogStatus.Info, "Successfully login to the application");
test.Log(LogStatus.Pass, TestContext.CurrentContext.Test.MethodName + "Test Case passed");
}
private List <String> GetBusinessFlow()
{
ExcelDataAccess businessFlowAccess =
new ExcelDataAccess(_frameworkParameters.RelativePath +
Util.GetFileSeparator() + "Datatables",
testParameters.CurrentScenario);
businessFlowAccess.DatasheetName = "Business_Flow";
int rowNum = businessFlowAccess.GetRowNum(testParameters.CurrentTestcase, 0);
if (rowNum == -1)
{
throw new FrameworkException("The test case \"" + testParameters.CurrentTestcase + "\" is not found in the Business Flow sheet!");
}
String dataValue;
List <String> businessFlowData = new List <String>();
int currentColumnNum = 1;
while (true)
{
dataValue = businessFlowAccess.GetValue(rowNum, currentColumnNum);
if (dataValue.Equals(""))
{
break;
}
businessFlowData.Add(dataValue);
currentColumnNum++;
}
if (businessFlowData.Count() == 0)
{
throw new FrameworkException("No business flow found against the test case \"" + testParameters.CurrentTestcase + "\"");
}
return(businessFlowData);
}
private void InitializeTestIterations()
{
int nTestcaseRows = 1;
int nSubIterations = 1;
switch (testParameters.IterationMode)
{
case IterationOptions.RunAllIterations:
String datatablePath = _frameworkParameters.RelativePath +
Util.GetFileSeparator() + "Datatables";
ExcelDataAccess testDataAccess =
new ExcelDataAccess(datatablePath, testParameters.CurrentScenario);
testDataAccess.DatasheetName = ConfigurationManager.AppSettings["DefaultDataSheet"];
int startRowNum = testDataAccess.GetRowNum(testParameters.CurrentTestcase, 0);
nTestcaseRows = testDataAccess.GetRowCount(testParameters.CurrentTestcase, 0, startRowNum);
nSubIterations = testDataAccess.GetRowCount("1", 1, startRowNum); // Assumption: Every test case will have at least one iteration
int nIterations = nTestcaseRows / nSubIterations;
testParameters.EndIteration = nIterations;
_currentIteration = 1;
break;
case IterationOptions.RunOneIterationOnly:
_currentIteration = 1;
break;
case IterationOptions.RunRangeOfIterations:
if (testParameters.StartIteration > testParameters.EndIteration)
{
throw new FrameworkException("Error", "StartIteration cannot be greater than EndIteration!");
}
_currentIteration = testParameters.StartIteration;
break;
}
}
public override void SaveData(List <FieldNameMapper> mapper, object ExportObjectType)
{
//List<Student> list = this.ExportDataList.ConvertAll(x => x as Student);
//DataBase db = new StudentData();
//DataTable dt = db.GeteExportDatatable(this.ExportDataList);
this.IOFileInfo.FileFullPath = this.FileFullPath;
DataTable dt = this.GetExportDataTable(this.ExportDataList, mapper, ExportObjectType);
this.IOFileInfo.CreateHeader = true;
//if (ConvertFieldsToRows)
//{
// dt = GetConvertedDataTable(dt);
// //this.IOFileInfo.CreateHeader = false;
//}
this.IOFileInfo.OutputDataSource = dt;
this.IOFileInfo.Delimiter = ",";
this.IOFileInfo.WorkSheetName = this.FileNameWithoutExtension;
DataAccessBase eda = new ExcelDataAccess(this.IOFileInfo);
eda.ReportProgress += new EventHandler <DataAccessEventMessenger>(eda_ReportProgress);
eda.Save();
}
