public void CreateCustomerData(ref ISelenium browser)
{
try
{
var admincommonObj = new AdminSuite.Common();
string user, password = "******";
_testDataFilePath = _currentDirPath.Parent.FullName;
_app = new Application();
//var testDataObj = new TestData();
_app.DisplayAlerts = false;
_workBook = _app.Workbooks.Open(_testDataFilePath + "\\TestData\\TestData.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
_workSheets = _workBook.Worksheets;
var _userSheet = (Microsoft.Office.Interop.Excel.Worksheet)_workSheets.get_Item("Users");
Random rnd = new Random();
int rndNumber;
for (int i = 0; i < 10; i++)
{
rndNumber = rnd.Next(10000);
user = "******" + rndNumber;
admincommonObj.CreateCustomer(browser, user, password);
_userSheet.Cells[i + 2, "B"] = user;
_userSheet.Cells[i +2, "C"] = password;
admincommonObj.PerformManualAdjustment(browser, user, "Test Accounts", "100", "Yes", "Test Accounts", "", "", "", "Today");
_workBook.Save();
}
}
catch (Exception Ex)
{
Framework.BaseTest.CaptureScreenshot(browser, "");
Console.WriteLine(Ex.StackTrace);
Framework.BaseTest.Fail(Ex.Message);
}
finally
{
_workBook.Save();
_workBook.Close();
_workSheet = null;
_workBook = null;
_app.Quit();
}
}
///<summary>
/// This method creates a customer with the same details of a self exclusion customer
/// <example>RegisterCustomer_selfExclusion(portalbrowser, adminbrowser) </example>
public void RegisterCustomer_selfExclusion(ISelenium browser, ISelenium adminBrowser)
{
try
{
string regMsg, gender, xPath;
var admincommonObj = new AdminSuite.Common();
Random rnd = new Random();
int rndNumber = rnd.Next(10000);
//get details of customer in OB
adminBrowser.WindowFocus();
string username = "******" + rndNumber;
admincommonObj.SelectMainFrame(adminBrowser);
string firstname = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'First Name:')]/following-sibling::td");
string lastname = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Last Name:')]/following-sibling::td");
string title = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Title:')]/following-sibling::td");
if (title.ToLower() == "mr")
{
gender = "male";
}
else
{
gender = "female";
}
string dob = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Date of Birth:')]/following-sibling::td");
string[] arr = dob.Split('-');
string DOByear = arr[0];
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string DOBmonth = mfi.GetMonthName(int.Parse(arr[1])).ToString();
string DOBday = arr[2];
string houseno = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Address (1)')]/following-sibling::td");
string postcode = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Postcode:')]/following-sibling::td");
string address1 = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), '(2)')]/following-sibling::td") + adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), '(3)')]/following-sibling::td");
string address2 = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), '(3)')]/following-sibling::td");
string city = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'City:')]/following-sibling::td");
string email = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Email:')]/following-sibling::td");
string teleCode = "+44";
string telnumber = "1234567890";
string mobnumber = "1234512345";
string password = "******";
string confirmPassword = "******";
string securityQuestion = "Favourite Colour";
string securityAnswer = "Blue";
string accountCurrency = "UK Pound Sterling";
string country = "United Kingdom";
browser.WindowFocus();
WaitForLoadingIcon_MobileLobby(browser, FrameGlobals.IconLoadTimeout);
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.registrationTitle), "Registration Page is not displayed");
//Enter data in all the fields
browser.Type(MobileLobbyControls.promocode, "");
browser.Select(MobileLobbyControls.title, title);
browser.Type(MobileLobbyControls.firstname, firstname);
browser.Type(MobileLobbyControls.lastname, lastname);
//gender
if (gender.ToLower().Trim() == "male")
{
browser.Click(MobileLobbyControls.genderMale);
}
else
{
browser.Click(MobileLobbyControls.genderFemale);
}
browser.Select(MobileLobbyControls.DOBday, DOBday);
browser.Select(MobileLobbyControls.DOBmonth, DOBmonth);
browser.Select(MobileLobbyControls.DOByear, DOByear);
browser.Select(MobileLobbyControls.country, country);
browser.Type(MobileLobbyControls.housename, houseno);
browser.Type(MobileLobbyControls.postcode, postcode);
browser.Type(MobileLobbyControls.address1, address1);
browser.Type(MobileLobbyControls.address2, address2);
browser.Type(MobileLobbyControls.city, city);
browser.Type(MobileLobbyControls.email, email);
browser.Type(MobileLobbyControls.telintcode, teleCode);
browser.Type(MobileLobbyControls.telnumber, telnumber);
browser.Type(MobileLobbyControls.mobintcode, teleCode);
browser.Type(MobileLobbyControls.mobnumber, mobnumber);
browser.Select(MobileLobbyControls.accountCurrency, accountCurrency);
browser.Type(MobileLobbyControls.username, username);
browser.Type(MobileLobbyControls.password, password);
browser.Type(MobileLobbyControls.confirmPassword, confirmPassword);
browser.Select(MobileLobbyControls.securityQuestion, securityQuestion);
browser.Type(MobileLobbyControls.securityAnswer, securityAnswer);
MLcommonObj.SelectCheckbox(browser, MobileLobbyControls.contactMe, "on");
MLcommonObj.SelectCheckbox(browser, MobileLobbyControls.aggreement, "on");
Thread.Sleep(1000);
//Validate registration
clickObject_MobileLobby(browser, MobileLobbyControls.registerNow);
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.registrationTitle), "Registration page title was not found in the header after registration");
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.failureRgMsg), "Registration failure message was not displayed");
regMsg = "We are sorry but your country of residence is currently prohibited from using the Ladbrokes service.";
xPath = "//ul[@class='error_align']/li[contains(text()[2], '" + regMsg + "')]";
Assert.IsTrue(browser.IsElementPresent(xPath), "Registration failure message was not displayed to the user");
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.contactMessage), "Customer contact message was not displayed on failing to create a customer from banned country");
Console.WriteLine("Customer was not registered as his details provided matched a self excluded customer");
}
catch (Exception ex)
{
CaptureScreenshot(browser, "EnterRegisterDetails");
Console.WriteLine("Function 'EnterRegisterDetails' - Failed");
Console.WriteLine(ex.Message);
Fail(ex.Message);
}
}
/// <summary>
/// To Update Markt Status
/// </summary>
/// <param name="browser">Selenium browser instance</param>
/// <param name="catName">Category Name</param>
/// <param name="eventClsName">Event ClassName</param>
/// <param name="eventTypeName">Event TypeName</param>
/// <param name="eventSubType">Event SubType</param>
/// <param name="eventName">Event Name</param>
/// <param name="eventStatus">Event Display Status</param>
public void UpdateMarketStatus(ISelenium browser, string catName, string eventClsName, string eventTypeName, string eventSubType, string eventName, string mktName, string marketStatus)
{
string errorMessage = "";
bool eventUpdationStatus = false;
bool finalEventStatus = true;
Framework.Common.Common frameworkcommon = new Framework.Common.Common();
AdminSuite.Common com = new AdminSuite.Common();
Framework.Common.Common Fcommon = new Framework.Common.Common();
TimeSpan ts = new TimeSpan(0, 1, 0);
IWebDriver driver = ((WebDriverBackedSelenium)browser).UnderlyingWebDriver;
//Clicking on Event Link in LHN
LHNavigation(AdminSuite.CommonControls.AdminHomePage.EventNameLink, browser);
//Selecting TopFrame
SelectMainFrame(browser);
System.Threading.Thread.Sleep(10000);
frameworkcommon.WaitUntilElementPresent(browser, AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx, "60");
catName = catName.Replace("|", "").Trim();
if (catName != "")
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx, catName), "Category Name does not present in DropdownList");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx, "label=" + catName);
}
eventClsName = eventClsName.Replace("|", "").Trim();
if (eventClsName != "")
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.classNameLstBx, eventClsName), "EventClass Name does not present");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.classNameLstBx, "label=" + eventClsName);
}
if (eventTypeName != "")
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.eventTypeLstBx, eventTypeName), "EventClass Name does not present");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.eventTypeLstBx, "label=" + eventTypeName);
}
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.dateRangeLstBx, "--"), "Date range dropdown missing");
// Selecting Daterange
browser.Select(AdminSuite.CommonControls.EventDetailsPage.dateRangeLstBx, "label=--");
//Clicking on Seach button
browser.Click(AdminSuite.CommonControls.EventDetailsPage.eventSearchBtn);
_frameworkCommon.WaitUntilAllElementsLoad(browser);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
// Wait for Element to present
if (frameworkcommon.WaitUntilElementPresent(browser, "link=" + eventName + "", "60") == true)
{
browser.Click("link=" + eventName);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
Thread.Sleep(10000);
//Wait Untill the EventDetails Page loads
if (frameworkcommon.WaitUntilElementPresent(browser, AdminSuite.CommonControls.EventDetailsPage.eventDescriptionTextBox, "60") == true)
{
if (frameworkcommon.WaitUntilElementPresent(browser, "link=" + "|" + mktName + "|" + "", "60") == true)
{
//browser.Click("link=" + mktName);
browser.Click("link=" + "|" + mktName + "|");
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
if (marketStatus == "Suspend")
{
browser.Select(AdminSuite.CommonControls.EventDetailsPage.marketStatusListBox, "label=Suspended");
eventUpdationStatus = false;
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
}
else
{
browser.Select(AdminSuite.CommonControls.EventDetailsPage.marketStatusListBox, "label=Active");
}
//Updating the Event
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.ModifyMarketButton))
{
if (eventUpdationStatus == false)
{
browser.Click(AdminSuite.CommonControls.EventDetailsPage.ModifyMarketButton);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
Assert.IsTrue(frameworkcommon.WaitUntilElementPresent(browser, AdminSuite.CommonControls.EventDetailsPage.eventDescriptionTextBox, "120"), "markrt display status Updation is not Successfull");
browser.Click(AdminSuite.CommonControls.EventDetailsPage.updateEventBtn);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
}
}
}
}
}
else
{
finalEventStatus = false;
errorMessage = errorMessage + eventName;
errorMessage = errorMessage + Environment.NewLine;
}
//Finally checking whether all the Events are Suspended or not
if (finalEventStatus == false)
{
Framework.BaseTest.Fail("market display status updation Process is Failed");
}
}
/// <summary>
/// Update Faceted flag
/// </summary>
/// Authour: Revathy
/// Created Date: 28-Mar-2012
public void UpdateFacetedflag(string facet1, string facet2, string Eventclass)
{
var admincommonObj = new AdminSuite.Common();
ISelenium adminBrowser = admincommonObj.LogOnToAdmin();
IWebDriver driver = ((WebDriverBackedSelenium)adminBrowser).UnderlyingWebDriver;
LHNavigation("//div[@id='adminMenuDiv']//a[@class='menu_item' and text()='Event Classes']", adminBrowser);
SelectMainFrame(adminBrowser);
adminBrowser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
driver.FindElement(By.XPath("//a[text()='|Horse Racing|']")).Click();
adminBrowser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
adminBrowser.Click("//a[text()='|" + Eventclass + "|']");
adminBrowser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
if (!adminBrowser.IsChecked(facet1))
adminBrowser.Click(facet1);
if (adminBrowser.IsChecked(facet2))
adminBrowser.Click(facet2);
//click on Modify Event Type button
adminBrowser.Click("//th[@class='buttons']/input[@value='Modify Event Type']");
}
/// <summary>
/// To suspend/ Activate the Events
/// </summary>
/// <param name="browser">Selenium browser instance</param>
/// <param name="catName">Category Name</param>
/// <param name="eventClsName">Event ClassName</param>
/// <param name="eventTypeName">Event TypeName</param>
/// <param name="eventSubType">Event SubType</param>
/// <param name="eventName">Event Name</param>
/// <param name="eventStatus">Event Status</param>
public void UpdateEvents(ISelenium browser, string catName, string eventClsName, string eventTypeName, string eventSubType, string eventName, string eventStatus)
{
string errorMessage = "";
bool eventUpdationStatus = false;
bool finalEventStatus = true;
Framework.Common.Common frameworkcommon = new Framework.Common.Common();
AdminSuite.Common com = new AdminSuite.Common();
Framework.Common.Common Fcommon = new Framework.Common.Common();
TimeSpan ts = new TimeSpan(0, 1, 0);
IWebDriver driver = ((WebDriverBackedSelenium)browser).UnderlyingWebDriver;
//Clicking on Event Link in LHN
LHNavigation(AdminSuite.CommonControls.AdminHomePage.EventNameLink, browser);
//Selecting TopFrame
System.Threading.Thread.Sleep(10000);
SelectMainFrame(browser);
frameworkcommon.WaitUntilElementPresent(browser, AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx, "60");
catName = catName.Replace("|", "").Trim();
if (catName != "")
{
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx))
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx, catName), "Category Name does not present in DropdownList");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.categoryNameLstBx, "label=" + catName);
}
}
eventClsName = eventClsName.Replace("|", "").Trim();
if (eventClsName != "")
{
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.classNameLstBx))
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.classNameLstBx, eventClsName), "EventClass Name does not present");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.classNameLstBx, "label=" + eventClsName);
}
}
if (eventTypeName != "")
{
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.eventTypeLstBx))
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.eventTypeLstBx, eventTypeName), "EventClass Name does not present");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.eventTypeLstBx, "label=" + eventTypeName);
}
}
if (eventSubType != "")
{
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.subEventTypeLstBx))
{
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.subEventTypeLstBx, eventSubType), "EventSubType Name does not present");
browser.Select(AdminSuite.CommonControls.EventDetailsPage.subEventTypeLstBx, "label=" + eventSubType);
}
}
Assert.IsTrue(frameworkcommon.CheckItemPresentInDropDownList(browser, AdminSuite.CommonControls.EventDetailsPage.dateRangeLstBx, "--"), "Date range dropdown missing");
// Selecting Daterange
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.dateRangeLstBx))
{
browser.Select(AdminSuite.CommonControls.EventDetailsPage.dateRangeLstBx, "label=--");
}
//Clicking on Seach button
browser.Click(AdminSuite.CommonControls.EventDetailsPage.eventSearchBtn);
_frameworkCommon.WaitUntilAllElementsLoad(browser);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
//Thread.Sleep(2000);
// Wait for Element to present
if (frameworkcommon.WaitUntilElementPresent(browser, "link=" + eventName + "", "60") == true)
{
browser.Click("link=" + eventName);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
if (eventStatus == "Taginfo" || eventStatus == "Taginfoundo")
{
browser.Click("//a[contains(string(),'Race Winner')]");
Thread.Sleep(10000);
browser.Click("//tr[@class='active']//a[contains(string(),'Horse1')]");
Thread.Sleep(10000);
if (eventStatus == "Taginfoundo")
browser.Select("name=OcFlag", "label=Named runner");
else
browser.Select("name=OcFlag", "label=Unnamed favourite");
browser.Click("//input[@value='Modify Selection']");
}
else
{
//Wait Untill the EventDetails Page loads
if (frameworkcommon.WaitUntilElementPresent(browser, AdminSuite.CommonControls.EventDetailsPage.eventDescriptionTextBox, "60") == true)
{
if (eventStatus == "Suspend")
{
browser.Select(AdminSuite.CommonControls.EventDetailsPage.eventStatusListBox, "label=Suspended");
eventUpdationStatus = false;
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
}
else
{
browser.Select(AdminSuite.CommonControls.EventDetailsPage.eventStatusListBox, "label=Active");
}
//Updating the Event
if (browser.IsElementPresent(AdminSuite.CommonControls.EventDetailsPage.updateEventBtn))
{
if (eventUpdationStatus == false)
{
browser.Click(AdminSuite.CommonControls.EventDetailsPage.updateEventBtn);
browser.WaitForPageToLoad(FrameGlobals.PageLoadTimeOut);
Assert.IsTrue(frameworkcommon.WaitUntilElementPresent(browser, AdminSuite.CommonControls.EventDetailsPage.eventDescriptionTextBox, "120"), "Event Updation is not Successfull");
}
}
}
}
}
else
{
finalEventStatus = false;
errorMessage = errorMessage + eventName;
errorMessage = errorMessage + Environment.NewLine;
}
//Finally checking whether all the Events are Suspended or not
if (finalEventStatus == false)
{
Console.WriteLine("Following Events are not Suspended, Please verify Manually" + Environment.NewLine + errorMessage);
Framework.BaseTest.Fail("Event suspending Process is Failed");
}
}
