Пример #1
0
 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);
 }
Пример #2
0
        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);
        }
Пример #3
0
        /// <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());
        }