internal void AddDayTimeDetails(int dataRow)
{
StartDateDropDown.SendKeys(GlobalDefinitions.ExcelLib.ReadData(dataRow, "Startdate") + Keys.Enter);
EndDateDropDown.SendKeys(GlobalDefinitions.ExcelLib.ReadData(dataRow, "Enddate") + Keys.Enter);
DayMon.Click();
StartTimeDropDown.SendKeys(GlobalDefinitions.ExcelLib.ReadData(dataRow, "Starttime") + Keys.Enter);
EndTimeDropDown.SendKeys(GlobalDefinitions.ExcelLib.ReadData(dataRow, "Endtime") + Keys.Enter);
SkillTradeExchange.Click();
SkillExchange.SendKeys(GlobalDefinitions.ExcelLib.ReadData(dataRow, "Skill-Exchange") + Keys.Enter);
}
public void SkillExchange()
{
SkillTradeExchange.Click();
var skill = ExcelLibHelper.ReadData(rownum, "Skill");
Skill_Exchange.SendKeys(skill);
Skill_Exchange.SendKeys(Keys.Enter);
var skill1 = ExcelLibHelper.ReadData(rownum, "Skill1");
Skill_Exchange.SendKeys(skill1);
Skill_Exchange.SendKeys(Keys.Enter);
}
/// <summary>
/// Saves the service record details given in the excel sheet data for given number of records <paramref name="RecordNo"/> and
/// returns data if record successfully saved
/// </summary>
/// <returns>
/// If the record exists in the table
/// </returns>
/// <param name="RecordNo">The number of records to be saved as int Value </param>
internal string SaveNew(int RecordNo)
{
//Populate the Excel Sheet
GlobalDefinitions.ExcelLib.PopulateInCollection(Base.ExcelPath, "ServiceListing");
Thread.Sleep(1000);
//Record Row No Starts with 2 in the DataSet
RecordNo += 2;
//Enter Title
string TitleInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "Title");
Title.SendKeys(TitleInput);
//Enter Description
string DescriptionInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "Description");
Description.SendKeys(DescriptionInput);
//Select Category
string CategoryInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "Category");
if (!("" == CategoryInput || null == CategoryInput))
{
ValidateCategory(CategoryInput);
var selectCategory = new SelectElement(Category);
selectCategory.SelectByText(CategoryInput);
Thread.Sleep(1000);
}
//Select SubCategory
string SubCategoryInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "SubCategory");
if (!("" == SubCategoryInput || null == SubCategoryInput))
{
ValidateSubCategory(SubCategoryInput);
var selectSubCatElement = new SelectElement(SubCategory);
selectSubCatElement.SelectByText(SubCategoryInput);
Thread.Sleep(500);
}
//Add tags
//Multiple Tag values are supported using ',' seperater under the Tags column
var TagsInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "Tags");
string[] Inputs = TagsInput.Split(',');
foreach (var tag in Inputs)
{
Tags.SendKeys(tag);
Tags.SendKeys(Keys.Enter);
Thread.Sleep(200);
}
//Select Service Type
var ServiceTypeInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "ServiceType");
if (!("" == ServiceTypeInput || null == ServiceTypeInput))
{
ValidateServiceType(ServiceTypeInput);
if (ServiceTypeInput == "Hourly basis service")
{
ServiceTypeHourlyBased.Click();
}
else
{
ServiceTypeOneOff.Click();
}
Thread.Sleep(500);
}
//Select Location Type
var LocationTypeInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "LocationType");
if (!("" == LocationTypeInput || null == LocationTypeInput))
{
ValidateLocationType(LocationTypeInput);
if (LocationTypeInput == "On-site")
{
LocationTypeOnSite.Click();
}
else
{
LocationTypeOnline.Click();
}
Thread.Sleep(500);
}
//Enter available days
var StartDateInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "StartDate");
var StartMonthInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "StartMonth");
var StartYearInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "StartYear");
var EndDateInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "EndDate");
var EndMonthInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "EndMonth");
var EndYearInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "EndYear");
var AvailDaysInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "AvailableDays");
var StartTimeInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "StartTime");
var EndTimeInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "EndTime");
if (StartDateInput != "")
{
StartDate.SendKeys(StartMonthInput);
Thread.Sleep(200);
StartDate.SendKeys(StartDateInput);
Thread.Sleep(200);
StartDate.SendKeys(StartYearInput);
Thread.Sleep(500);
}
if (EndDateInput != "")
{
EndDate.SendKeys(EndMonthInput);
Thread.Sleep(200);
EndDate.SendKeys(EndDateInput);
Thread.Sleep(200);
EndDate.SendKeys(EndYearInput);
Thread.Sleep(500);
}
string[] Days = AvailDaysInput.Split(',');
foreach (var AvailDay in Days)
{
switch (AvailDay)
{
case "Sun":
SunCheckBox.Click();
SunStartTime.SendKeys(StartTimeInput);
SunEndTime.SendKeys(EndTimeInput);
break;
case "Mon":
MonCheckBox.Click();
MonStartTime.SendKeys(StartTimeInput);
MonEndTime.SendKeys(EndTimeInput);
break;
case "Tue":
TueCheckBox.Click();
TueStartTime.SendKeys(StartTimeInput);
TueEndTime.SendKeys(EndTimeInput);
break;
case "Wed":
WedCheckBox.Click();
WedStartTime.SendKeys(StartTimeInput);
WedEndTime.SendKeys(EndTimeInput);
break;
case "Thur":
ThursCheckBox.Click();
ThursStartTime.SendKeys(StartTimeInput);
ThursEndTime.SendKeys(EndTimeInput);
break;
case "Fri":
FriCheckBox.Click();
FriStartTime.SendKeys(StartTimeInput);
FriEndTime.SendKeys(EndTimeInput);
break;
case "Sat":
SatCheckBox.Click();
SatStartTime.SendKeys(StartTimeInput);
SatEndTime.SendKeys(EndTimeInput);
break;
}
Thread.Sleep(300);
}
//Select Skill Trade
var SkillTradeInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "SkillTrade");
if (!("" == SkillTradeInput || null == SkillTradeInput))
{
ValidateSkillTradeOption(SkillTradeInput);
if (SkillTradeInput == "Skill-exchange")
{
SkillTradeExchange.Click();
Thread.Sleep(500);
//Add Skill Exchange Tags
//Multiple Tag values are supported using ',' seperater under the Skill Exchange Tags column
var SkillExTagsInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "SkillExchangeTags");
if (SkillExTagsInput != "")
{
string[] SkillExTags = SkillExTagsInput.Split(',');
foreach (var skill in SkillExTags)
{
SkillExchangeTags.SendKeys(skill);
SkillExchangeTags.SendKeys(Keys.Enter);
Thread.Sleep(300);
}
}
}
else
{
SkillTradeCredit.Click();
Thread.Sleep(500);
//Add Skill Trade Credit Amount
var SkillCreditAmountInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "SkillTradeCredit");
Thread.Sleep(500);
if (SkillCreditAmountInput != "")
{
ChargeAmount.SendKeys(SkillCreditAmountInput);
Thread.Sleep(500);
}
}
}
//Add Work Samples
var WorkSampleInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "WorkSamples");
if (WorkSampleInput != "")
{
WorkSampleUpload.Click();
AutoItX3 autoItX3 = new AutoItX3();
autoItX3.WinActivate("File Upload");
Thread.Sleep(200);
autoItX3.Send(@WorkSampleInput);
Thread.Sleep(500);
autoItX3.Send("{ENTER}");
Thread.Sleep(1000);
}
//Select Active Status
var ActiveInput = GlobalDefinitions.ExcelLib.ReadData(RecordNo, "Active");
if (!("" == ActiveInput || null == ActiveInput))
{
ValidateActiveOption(ActiveInput);
if (ActiveInput == "Active")
{
IsActive.Click();
}
else
{
IsHidden.Click();
}
Thread.Sleep(500);
}
//Save Service Details
Save.Click();
Thread.Sleep(2000);
//Check the saved record in the listings
ManageListing manageListing = new ManageListing();
bool IsExist = manageListing.ValidateRecordInTable(CategoryInput, TitleInput);
return(IsExist.ToString());
}