public void fillAddress()
{
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(10);
Addressline1.Clear();
Addressline1.SendKeys(ExcelOperation.GetData[9]);
SuburbText.Clear();
AddressLine2.Clear();
AddressLine2.SendKeys(ExcelOperation.GetData[10]);
SuburbText.SendKeys(ExcelOperation.GetData[11]);
State.Click();
PostCode.Clear();
PostCode.SendKeys(ExcelOperation.GetData[12]);
PostalAddressLine1.Clear();
PostalAddressLine1.SendKeys(ExcelOperation.GetData[13]);
PostalAddressLine2.Clear();
PostalAddressLine2.SendKeys(ExcelOperation.GetData[14]);
PostalSuburbText.Clear();
PostalSuburbText.SendKeys(ExcelOperation.GetData[15]);
PostalStateCombo.Click();
PostalPostCode.Clear();
PostalPostCode.SendKeys(ExcelOperation.GetData[16]);
GenericHelper.AllScreenShot(driver);
Nextbutton.Click();
}
public void AddPropertyDetails()
{
obj.ClickAddNewProperty();
// Populating the data from Excel
ExcelLib.PopulateInCollection(Base.ExcelPath, "PropertyDetails");
PropertyName.SendKeys(ExcelLib.ReadData(2, "PropertyName"));
SearchAddress.SendKeys(ExcelLib.ReadData(2, "SearchAddress"));
Description.SendKeys(ExcelLib.ReadData(2, "Description"));
Number.SendKeys(ExcelLib.ReadData(2, "Number"));
Street.SendKeys(ExcelLib.ReadData(2, "Street"));
Suburb.SendKeys(ExcelLib.ReadData(2, "Suburb"));
City.SendKeys(ExcelLib.ReadData(2, "City"));
PostCode.SendKeys(ExcelLib.ReadData(2, "PostCode"));
Region.SendKeys(ExcelLib.ReadData(2, "Region"));
YearBuilt.SendKeys(ExcelLib.ReadData(2, "YearBuilt"));
TargetRent.SendKeys(ExcelLib.ReadData(2, "TargetRent"));
LandArea.SendKeys(ExcelLib.ReadData(2, "LandArea"));
FloorArea.SendKeys(ExcelLib.ReadData(2, "FloorArea"));
BedRooms.SendKeys(ExcelLib.ReadData(2, "Bedrooms"));
BathRooms.SendKeys(ExcelLib.ReadData(2, "Bathrooms"));
CarPark.SendKeys(ExcelLib.ReadData(2, "Carparks"));
owneroccupied = ExcelLib.ReadData(2, "Owner Occupied");
if (owneroccupied == "Yes")
{
OwnerOccupied.Click();
}
Next.Click();
AddFinanceDetails();
}
public void FillNessesaryAccountInformation(RegistrationUser user)
{
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.SelectByText(user.State);
PostCode.SendKeys(user.PostCode);
MobilePhone.SendKeys(user.MobilePhone);
TryClearFiledBeforeType(Alias, user.Alias);
}
public void EnterUserDetail()
{
SignInBtn.Click();
EmailAddress.SendKeys("*****@*****.**");
BasePage.driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(10);
CreateAcccontBtn.Click();
// AC 4.1 create user account
Gender.Click();
FirstName.SendKeys("Nadeem");
LastName.SendKeys("Digital");
Password.SendKeys("123qwe");
SelectElement DropDay = new SelectElement(Day);
DropDay.SelectByValue("10");
SelectElement DropMonth = new SelectElement(Month);
DropMonth.SelectByValue("9");
SelectElement DropYear = new SelectElement(Year);
DropYear.SelectByValue("2020");
CheckedSpecialOffer.Click();
AddressFirstName.SendKeys("Nadeem");
AddressLastName.SendKeys("Digital");
Company.SendKeys("Test Digital Company");
Address1.SendKeys("Leeds Town");
Address2.SendKeys("LS1");
City.SendKeys("Leeds");
SelectElement DropDown = new SelectElement(State);
DropDown.SelectByText("Florida");
PostCode.SendKeys("00012");
AdditionalInfo.SendKeys("This is first programme of testig");
MobileNo.SendKeys("123456789");
AddressFutureRef.SendKeys("NB_Test");
ClickRegisterUser.Click();
//AC 4.4 verify account namme
Assert.AreEqual("Nadeem Digital", VerifyUser.Text);
Console.WriteLine(VerifyUser.Text + " Displayed");
Bpage.Imp_wait();
//AC 4.3 verify user taken to MY ACCOUNT page
Assert.IsTrue(Pageheading.Displayed);
Console.WriteLine(Pageheading.Text + " Displayed");
SignOut.Click();
}
public void FillFormWithoutState(FormModel user)
{
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
PostCode.SendKeys(user.PostCode);
PhoneNumber.SendKeys(user.PhoneNumber);
Driver.ScrollTo(RegisterButton);
RegisterButton.Click();
}
public void FillForm(PracticeFormModel user)
{
Email.SendKeys(user.Email);
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Phone.SendKeys(user.Phone);
Password.SendKeys(user.Password);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
PostCode.SendKeys(user.PostCode);
ScrollTo(Submit).Click();
}
//Method for filling the personal details form
public void FillPersonalDetails(PersonalDetails details)
{
Address.Clear();
Address.SendKeys(details.Address);
PostCode.Clear();
PostCode.SendKeys(details.PostCode);
City.Clear();
City.SendKeys(details.City);
Name.Clear();
Name.SendKeys(details.Name);
PhoneNumber.Clear();
PhoneNumber.SendKeys(details.PhoneNumber);
Email.Clear();
Email.SendKeys(details.Email);
}
public void FillForm(RegistrationUser user)
{
RadioButtons[0].Click();
CustomerFirstName.SendKeys(user.FirstName);
CustomerLastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Days.SelectByValue(user.Date);
Months.SelectByValue(user.Month);
Years.SelectByValue(user.Year);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.SelectByText(user.State);
PostCode.SendKeys(user.PostCode);
Phone.SendKeys(user.Phone);
RegisterButton.Click();
}
public void FillForm(FormModel user)
{
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
PostCode.SendKeys(user.PostCode);
PhoneNumber.SendKeys(user.PhoneNumber);
SelectElement selectElementFromDropDownList = new SelectElement(State);
selectElementFromDropDownList.SelectByText("Alabama");
Driver.ScrollTo(RegisterButton);
RegisterButton.Click();
}
public void EnterInvalidDetail()
{
SignInBtn.Click();
EmailAddress.SendKeys("*****@*****.**");
BasePage.driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(10);
CreateAcccontBtn.Click();
Gender.Click();
// first name and last name not entered to get the error
FirstName.SendKeys("");
LastName.SendKeys("");
Password.SendKeys("123qwe");
SelectElement DropDay = new SelectElement(Day);
DropDay.SelectByValue("10");
SelectElement DropMonth = new SelectElement(Month);
DropMonth.SelectByValue("9");
SelectElement DropYear = new SelectElement(Year);
DropYear.SelectByValue("2020");
CheckedSpecialOffer.Click();
AddressFirstName.SendKeys("Nadeem");
AddressLastName.SendKeys("Digital");
Company.SendKeys("Test Digital Company");
Address1.SendKeys("Leeds Town");
Address2.SendKeys("LS1");
City.SendKeys("Leeds");
SelectElement DropDown = new SelectElement(State);
DropDown.SelectByText("Florida");
PostCode.SendKeys("00012");
AdditionalInfo.SendKeys("This is first programme of testig");
MobileNo.SendKeys("123456789");
AddressFutureRef.SendKeys("NB_Test");
ClickRegisterUser.Click();
//AC 4.2 verify the error message
Assert.IsTrue(CreatAnAccoutError.Displayed);
Console.WriteLine(CreatAnAccoutError.Text + " Displayed");
}
public void FillForm(User user)
{
RadioButtons[0].Click();
CustomerFirstName.SendKeys(user.FirstName);
CustomerLastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Days.SelectByValue(user.Day);
Months.SelectByValue(user.Month);
Years.SelectByValue(user.Year);
FirstName.SendKeys(user.AddressFirstName);
LastName.SendKeys(user.AddressLastName);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.SelectByText(user.State);
PostCode.SendKeys(user.Postalcode);
Phone.SendKeys(user.MobilePhone);
Alias.SendKeys(user.Alias);
}
public void FillForm(PracticeFormModel user)
{
Title.Click();
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
FirstAddressField.SendKeys(user.FirstAddressField);
City.SendKeys(user.City);
SelectElement State = new SelectElement(Driver.
FindElement(By.XPath("/html/body/div/div[2]/div/div[3]/div/div/form/div[2]/p[7]/div/select")));
State.SelectByText("California");
PostCode.SendKeys(user.PostCode);
MobilePhone.SendKeys(user.MobilePhone);
Driver.ScrollTo(RegisterButton);
RegisterButton.Click();
}
public void EnterPersonalDetails()
{
Title.Click();
FN.SendKeys(ConfigurationManager.AppSettings["Firstname"]);
SN.SendKeys(ConfigurationManager.AppSettings["Surname"]);
DOB.SendKeys(ConfigurationManager.AppSettings["DOB"]);
TN.SendKeys(ConfigurationManager.AppSettings["Telephonenumber"]);
Emp.Click();
ResiStatus.Click();
GrossAnnualIncome.SendKeys(ConfigurationManager.AppSettings["GAI"]);
HouseNo.SendKeys(ConfigurationManager.AppSettings["House"]);
PostCode.SendKeys(ConfigurationManager.AppSettings["PCode"]);
MoveinYear.SendKeys(ConfigurationManager.AppSettings["Year"]);
FindMyAddress.Click();
System.Threading.Thread.Sleep(1000);
//SelectAddress.Click();
//System.Threading.Thread.Sleep(1000);
Next.Click();
}
public void FillFormEmail(UserProperty user)
{
Radiobuttons[0].Click();
CustomerFirstName.SendKeys(user.FirstName);
CustomerLastName.SendKeys(user.LastName);
passwordField.SendKeys(user.Password);
Days.SelectByValue(user.Day);
Months.SelectByValue(user.Month);
Years.SelectByValue(user.Year);
FirstName.SendKeys(user.AdressFirstName);
LastName.SendKeys(user.AddressLastName);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.SelectByText(user.State);
PostCode.SendKeys(user.Postalcode);
Phone.SendKeys(user.Phone);
Alias.SendKeys(user.Alias);
Email.Clear();
RegisterButton.Click();
}
public void FillForm(PracticeFormModel user)
{
Gender(user.Gender).Click();
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Day.SendKeys(user.Day);
Month.SelectByValue(user.Month);
Year.SendKeys(user.Year);
CompanyName.SendKeys(user.CompanyName);
Address.SendKeys(user.Address);
City.SendKeys(user.Address);
State.SelectByValue(user.State);
PostCode.SendKeys(user.PostCode);
Phone.SendKeys(user.Phone);
PhoneMobile.SendKeys(user.PhoneMobile);
Alias.SendKeys(user.Alias);
Submit.Click();
}
public void FillForm(UserRegistration user)
{
RadioButtons[1].Click();
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Day.SelectByValue(user.Day);
Month.SelectByValue(user.Month);
Year.SelectByValue(user.Year);
FirstNameForAddress.Clear();
FirstNameForAddress.SendKeys(user.FirstNameForAddress);
LastNameForAddress.Clear();
LastNameForAddress.SendKeys(user.LastNameForAddress);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.SelectByText(user.State);
PostCode.SendKeys(user.PostCode);
MobilePhone.SendKeys(user.MobilePhone);
Alias.SendKeys(user.Alias);
RegisterButton.Click();
}
public void FillForm(RegistrationUser user)
{
Driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(5);
RadioButtons[1].Click();
CustomerFirstName.SendKeys(user.FirstName);
CustomerLastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Days.SelectByValue(user.Date);
Months.SelectByValue(user.Month);
Years.SelectByValue(user.Year);
RealFirstName.SendKeys(user.RealFirstName);
RealLastName.SendKeys(user.RealLastName);
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.SelectByText(user.State);
PostCode.SendKeys(user.PostCode);
Phone.SendKeys(user.Phone);
Alias.Type(user.Alias);
RegisterButton.Click();
}
public void PropertyDetails()
{
//Enter the Property Name
PropertyName.SendKeys(ExcelLib.ReadData(2, "PropertyName"));
Thread.Sleep(500);
//Click on Property Type drop down menu
PropertyType.Click();
//Clicking Short-Term Rental on the Property Type drop down menu
PropertyTypeChoice.Click();
Thread.Sleep(500);
//Enter Street Number
StreetNumber.SendKeys(ExcelLib.ReadData(2, "Number"));
Driver.wait(1000);
//Enter Street Name
StreetName.SendKeys(ExcelLib.ReadData(2, "Street"));
Driver.wait(1000);
//Enter City Name
CityName.SendKeys(ExcelLib.ReadData(2, "City"));
Driver.wait(1000);
//Enter PostCode
PostCode.SendKeys(ExcelLib.ReadData(2, "PostCode"));
Driver.wait(1000);
//Enter Region Name
Region.SendKeys(ExcelLib.ReadData(2, "Region"));
Driver.wait(1000);
//Enter Description
Description.SendKeys(ExcelLib.ReadData(2, "Description"));
Driver.wait(3000);
//Enter TargetRent
TargetRent.SendKeys(ExcelLib.ReadData(2, "TargetRent"));
Driver.wait(2000);
//Enter Bedroms
Bedrooms.SendKeys(ExcelLib.ReadData(2, "Bedrooms"));
Driver.wait(2000);
//Enter Bathrooms
Bathrooms.SendKeys(ExcelLib.ReadData(2, "Bathrooms"));
Driver.wait(2000);
//Enter Carparks
Carparks.SendKeys(ExcelLib.ReadData(2, "Carparks"));
Driver.wait(3000);
//Enter Year Built
YearBuilt.SendKeys(ExcelLib.ReadData(2, "YearBuilt"));
Driver.wait(2000);
//Upload a file thru AutoIT
Driver.wait(1000);
AutoItX3 autoIT = new AutoItX3();
FileUpload.Click();
autoIT.WinActivate("Open");
Thread.Sleep(1000);
autoIT.Send(@"C:\Users\VictorFelix\source\repos\automationOnboardingSample-master\Keys_Onboarding\TestReports\Screenshots\home.jpg");
Thread.Sleep(1000);
autoIT.Send("{Enter}");
Driver.wait(2000);
//Clicking on Next button
Next.Click();
Driver.wait(3000);
}
internal void AddNewSalesOrder()
{
ExcelLib.PopulateInCollection(InventoryTest.ExcelPath, "SalesOrderPage");
//Navigate through Add Sales Order
SalesMenu.Click();
Thread.Sleep(1000);
OrdersMenu.Click();
Thread.Sleep(1000);
AddSalesOrder.Click();
Thread.Sleep(3000);
//Add New Sales Order
CustCode.Click();
CustCode.SendKeys(ExcelLib.ReadData(2, "CustCode"));
Thread.Sleep(2000);
CustCodSelect.Click();
Thread.Sleep(3000);
CustRef.SendKeys(ExcelLib.ReadData(2, "CustRef"));
Thread.Sleep(1000);
Discount.Clear();
Thread.Sleep(1000);
Discount.SendKeys(ExcelLib.ReadData(2, "Discount"));
Thread.Sleep(1000);
Tax.SendKeys(ExcelLib.ReadData(2, "TaxRate"));
Thread.Sleep(2000);
//var TaxRate = CommonMethods.driver.FindElement(By.Id("SaleTaxes"));
//var selectTaxRate = new SelectElement(TaxRate);
//Thread.Sleep(3000);
//selectTaxRate.SelectByText(ExcelLib.ReadData(2, "TaxRate"));
//Warehouse.SendKeys(ExcelLib.ReadData(2,"Warehouse"));
//Thread.Sleep(1000);
var warehouse = CommonMethods.driver.FindElement(By.Id("WarehouseList"));
var selectWarehouse = new SelectElement(warehouse);
Thread.Sleep(1000);
selectWarehouse.SelectByText(ExcelLib.ReadData(2, "Warehouse"));
//DeliveryMethod.SendKeys(ExcelLib.ReadData(2,"DeliveryMethod"));
//Thread.Sleep(1000);
var deliverymethod = CommonMethods.driver.FindElement(By.Id("DeliveryMethodList"));
var selectDM = new SelectElement(deliverymethod);
Thread.Sleep(1000);
selectDM.SelectByText(ExcelLib.ReadData(2, "DeliveryMethod"));
DeliveryName.SendKeys(ExcelLib.ReadData(2, "DeliveryName"));
Thread.Sleep(1000);
DeliveryAdd.SendKeys(ExcelLib.ReadData(2, "StreetAddress"));
Thread.Sleep(1000);
DeliverySub.SendKeys(ExcelLib.ReadData(2, "Suburb"));
Thread.Sleep(1000);
DeliveryCity.SendKeys(ExcelLib.ReadData(2, "City"));
Thread.Sleep(1000);
Region.SendKeys(ExcelLib.ReadData(2, "Region"));
Thread.Sleep(1000);
PostCode.SendKeys(ExcelLib.ReadData(2, "PostCode"));
Thread.Sleep(1000);
DeliveryCountry.SendKeys(ExcelLib.ReadData(2, "Country"));
Thread.Sleep(1000);
SalesPerson.SendKeys(ExcelLib.ReadData(2, "SalesPerson"));
Thread.Sleep(2000);
//var sp = CommonMethods.driver.FindElement(By.Id("SalesPersonSelection"));
//var selectsp = new SelectElement(sp);
//Thread.Sleep(1000);
//selectsp.SelectByText(ExcelLib.ReadData(2, "SalesPerson"));
//SalesGrp.SendKeys(ExcelLib.ReadData(2, "SalesOrderGrp"));
//Thread.Sleep(1000);
var salesgroup = CommonMethods.driver.FindElement(By.Id("SalesGroupList"));
var selectsalesgrp = new SelectElement(salesgroup);
Thread.Sleep(1000);
selectsalesgrp.SelectByText(ExcelLib.ReadData(2, "SalesOrderGrp"));
OrderDate.SendKeys(ExcelLib.ReadData(2, "OrderDate"));
Thread.Sleep(1000);
OrderDateSelect.Click();
Thread.Sleep(1000);
RequiredDate.SendKeys(ExcelLib.ReadData(2, "ReqDate"));
Thread.Sleep(1000);
RequiredDateSelect.Click();
//InvoiceLayout.SendKeys(ExcelLib.ReadData(2, "SalesOrderTemp"));
//Thread.Sleep(1000);
var SalesorderTemp = CommonMethods.driver.FindElement(By.Id("InvoiceLayoutId"));
var selectSalesorderTemp = new SelectElement(SalesorderTemp);
Thread.Sleep(1000);
selectSalesorderTemp.SelectByText(ExcelLib.ReadData(2, "SalesOrderTemp"));
//PackingSliplayout.SendKeys(ExcelLib.ReadData(2, "PackingSlipTemp"));
//Thread.Sleep(1000);
var PackingTemp = CommonMethods.driver.FindElement(By.Id("InvoiceLayoutId"));
var selectPackingTemp = new SelectElement(PackingTemp);
Thread.Sleep(1000);
selectPackingTemp.SelectByText(ExcelLib.ReadData(2, "PackingSlipTemp"));
ProductLineAdd.SendKeys(ExcelLib.ReadData(2, "ProductLine"));
Thread.Sleep(1000);
Qty.SendKeys(ExcelLib.ReadData(2, "Qty"));
Thread.Sleep(1000);
Price.SendKeys(ExcelLib.ReadData(2, "LinePrice"));
Thread.Sleep(1000);
DeliverySub.SendKeys(ExcelLib.ReadData(2, "LineDiscount"));
Thread.Sleep(1000);
//Add sales order line to Order
AddOrderLineBtn.Click();
Thread.Sleep(1000);
//Save Sales Order
SaveSalesOrderBtn.Click();
Thread.Sleep(1000);
ViewSalesOrder.Click();
Thread.Sleep(1000);
//to filter data either can give cutomernumber or order number
OrderNoFilter.SendKeys(SalesOrderNoDisplay.Text);
Thread.Sleep(1000);
OrderNoFilter.SendKeys(Keys.Enter);
//filter byCust num
CustFilter.SendKeys(ExcelLib.ReadData(2, "CustCode"));
Thread.Sleep(1000);
CustFilter.SendKeys(Keys.Enter);
IList SalesOrderList = CommonMethods.driver.FindElements(By.XPath(".//*[@id='SalesOrderList_tccell0_"));
int SalesOrderListCount = SalesOrderList.Count;
//.//*[@id='SalesOrderList_tccell1_1']/a
//.//*[@id='SalesOrderList_tccell2_1']/a
//Verify added Sales Order
try
{
for (int i = 0; i <= SalesOrderListCount; i++)
{
//Check whether the Salesorder is equal with grid table data
if (SalesOrderNoDisplay.Text == CommonMethods.driver.FindElement(By.XPath(".//*[@id='SalesOrderList_tccell[" + i + "]_1']/a ")).Text)
{
//Check whether the Salesorder is equal to actual
if (ExcelLib.ReadData(2, "CustCode") == CommonMethods.driver.FindElement(By.XPath(".//*[@id='SalesOrderList_tccell[" + i + "]_4']/a")).Text)
{
SaveScreenShotClass.SaveScreenshot(CommonMethods.driver, "Found Added Sales Order");
Thread.Sleep(2000);
}
}
else
{
SaveScreenShotClass.SaveScreenshot(CommonMethods.driver, "Sales Order not found");
Thread.Sleep(2000);
}
}
}
catch (Exception e)
{
Console.WriteLine("Can not find added Product,Test failed" + e.Message);
}
}
public void Address()
{
House.SendKeys(ConfigurationManager.AppSettings["House"]);
PostCode.SendKeys(ConfigurationManager.AppSettings["PCode"]);
}
public void EnterDetails(Table table)
{
foreach (var row in table.Rows)
{
switch (row[0].ToLower())
{
case "approved":
var approved = Convert.ToBoolean(row[1]);
if ((Approved.Selected && !approved) || (!Approved.Selected && approved))
{
Approved.Click();
}
break;
case "emailverified":
var emailVerified = Convert.ToBoolean(row[1]);
if ((EmailVerified.Selected && !emailVerified) || (!EmailVerified.Selected && emailVerified))
{
EmailVerified.Click();
}
break;
case "enabled":
var enabled = Convert.ToBoolean(row[1]);
if ((Enabled.Selected && !enabled) || (!Enabled.Selected && enabled))
{
Enabled.Click();
}
break;
case "firstname":
FirstName.Clear();
FirstName.SendKeys(row[1]);
break;
case "lastname":
LastName.Clear();
LastName.SendKeys(row[1]);
break;
case "postcode":
PostCode.Clear();
PostCode.SendKeys(row[1]);
break;
case "skypename":
SkypeName.Clear();
SkypeName.SendKeys(row[1]);
break;
case "hometelephonenumber":
TelNoHome.Clear();
TelNoHome.SendKeys(row[1]);
break;
case "mobiletelephonenumber":
TelNoMobile.Clear();
TelNoMobile.SendKeys(row[1]);
break;
case "worktelephonenumber":
TelNoWork.Clear();
TelNoWork.SendKeys(row[1]);
break;
case "title":
Title.Clear();
Title.SendKeys(row[1]);
break;
case "town":
Town.Clear();
Town.SendKeys(row[1]);
break;
default:
throw new Exception(string.Format("Field {0} not defined", row[0]));
}
}
}