public void ATC4407_CRMAlertsValidationforClient()
        {
            #region Start Up Excel
            MyBook = MyApp.Workbooks.Open(DatasourceDir + @"\Clients.xlsx", 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            MySheet = (Excel.Worksheet)MyBook.Sheets[Properties.Settings.Default.ENVIRONMENT.ToString()];
            MyRange = MySheet.UsedRange;

            //Get specific row for the data
            int testDataRows = MyRange.Rows.Count;
            int MyRow = 0;
            for (int i = 2; i <= testDataRows; i++)
            {
                if (MyRange.Cells[i, 1].Value.ToString() == "ClientTestData")
                {
                    MyRow = i;
                    break;
                }
            }
            #endregion

            string clientName = (MyRange.Cells[MyRow, ClientsSchema.GetColumnIndex("CLIENT_NAME")].Value.ToString());

            //Login in as role
            User user = this.environment.GetUser(SecurityRole.GeneralStaff);
            new LoginDialog().Login(user.Id, user.Password);

            HomePage homePage = new HomePage(driver);
            homePage.HoverCRMRibbonTab();
            homePage.ClickClientServicesRibbonButton();
            homePage.HoverClientServicesRibbonTab();
            homePage.ClickClientsRibbonButton();

            ClientsSearchPage clientsSearchPage = new ClientsSearchPage(driver);
            string testName = clientName;
            clientsSearchPage.SetClientSearchText(testName);
            Table table = new Table(clientsSearchPage.GetSearchResultTable());
            table.ClickCellValue("Full Name", testName, "Full Name");

            ClientPage clientPage = new ClientPage(driver);
            clientPage.ClickPageTitle();
            string BaseWindow = driver.CurrentWindowHandle;

            clientPage.ClickAddAlertElement();

            //Enter Alert details
            driver = UICommon.SwitchToNewBrowserWithTitle(driver, BaseWindow, "Alert");
            AlertPage alertPage = new AlertPage(driver);
            Assert.IsTrue(alertPage.GetAlertTypeText("Other"));

            alertPage.SetOtherAlertText("Other Alert Test Value");
            alertPage.SetDesctiptionText("Description Text Test Value");

            alertPage.ClickSaveIMG();
            StringAssert.Contains(alertPage.GetAlertNumber(), testName);

            Assert.IsTrue(alertPage.GetAlertTypeText("Receivership/Management"));

            //Assert that Other Alert is locked
            string controlMode = alertPage.GetOtherAlertControlMode();
            StringAssert.Equals(controlMode, "locked");
            alertPage.SetStartDateValue(DateTime.Now.ToString("dd/MM/yyyy"));
            alertPage.SetEndDateValue(DateTime.Now.ToString("dd/MM/yyyy"));
            alertPage.ClickSaveIMG();
            //Assert.IsTrue(alertPage.GetNoErrorMessageState());
            StringAssert.Contains(alertPage.GetAlertState(), "Active");

            alertPage.SetEndDateValue(DateTime.Now.AddDays(1).ToString("dd/MM/yyyy"));
            alertPage.ClickSaveIMG();
            //Assert.IsTrue(alertPage.GetNoErrorMessageState());

            alertPage.SetEndDateValue(DateTime.Now.AddDays(-1).ToString("dd/MM/yyyy"));
            alertPage.ClickSaveIMG();
            StringAssert.Contains(alertPage.GetStartDateErrorText(), "Start date must be earlier than or the same as end date");
            alertPage.ClickPageTitle();
            //alertPage.ClickStartDate();
            alertPage.SetStartDateValue(DateTime.Now.AddDays(-1).ToString("dd/MM/yyyy"));
            alertPage.ClickSaveIMG();
            //Assert.IsTrue(alertPage.GetNoErrorMessageState());

            alertPage.ClickDeactivateIMG();
            StringAssert.Contains(alertPage.GetAlertState(), "Inactive");
            driver.Close();
            driver.SwitchTo().Window(BaseWindow);

            #region Shut down Excel
            MyBook.Save();
            MyBook.Close();
            MyApp.Quit();
            #endregion
        }