public void Delete_Knowledbase_Item_OrgGroupForUserWithoutSO31_WithRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Delete Knowledgebase Item assigned to Org Group where user does not have SO 31 access and with restricted viewing");
String strTestCaseNo = "TC008";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDTitle = testdataSummary_Knowledgebase[3];
string strTDRestrictViewing = testdataSummary_Knowledgebase[7];
string strTDUser = testdataSummary_Knowledgebase[11];
string strTDLogin = testdataSummary_Knowledgebase[20];
/* Identify OrgGroupId for the OrgGroup */
string strSQLtblname = "tblPeopleGroup";
string strtblselectcolumn = "PeopleGroupID";
string strtblcolumn = "PeopleGroupName";
string strwherecondn = strTDUser;
var conn = new ConnectToSQLServer();
string OrgGroupID = conn.Select(strSQLtblname, strtblselectcolumn, strtblcolumn, strwherecondn);
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
Knowledgebase.Delete_Knowledgebase_Item_AssignedtoOrgGroup(strTDTitle, strTDRestrictViewing, OrgGroupID);
try
{
Assert.IsTrue(Knowledgebase.txtKBItem.Displayed);
PropertiesCollection.test.Log(Status.Fail, "Knowledgebase Item could not be deleted");
}
catch
{
PropertiesCollection.test.Log(Status.Pass, "Knowledgebase Item deleted");
}
}
public void Launch_Knowledbase_Item_UserWithoutSO31_WithoutRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Launch Knowledgebase Item assigned to user without SO 31 access and without restricted viewing");
String strTestCaseNo = "TC003";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDLogin = testdataSummary_Knowledgebase[20];
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
System.Threading.Thread.Sleep(15000);
/* Launch Knowledge base item from Knowledge base Grid */
FpSummaryPage Summary = new FpSummaryPage();
string KBGridTitle = Summary.KnowledgebaseGridFirstItem.Text;
Actions action = new Actions(PropertiesCollection.driver);
action.MoveToElement(Summary.KnowledgebaseGridFirstItem).DoubleClick().Perform();
System.Threading.Thread.Sleep(15000);
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
System.Threading.Thread.Sleep(15000);
try
{
Assert.AreEqual(KBGridTitle, Knowledgebase.txtKBItemTitle.Text);
PropertiesCollection.test.Log(Status.Pass, "Launch Knowledgebase Item validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Launch Knowledgebase Item validated and failed");
}
}
public void TestInitialize()
{
PropertiesCollection.driver = new ChromeDriver(ConfigurationManager.AppSettings["ChromeDriverPath"]);
PropertiesCollection.driver.Manage().Window.Maximize();
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails("Login1");
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
Console.WriteLine(strTDUsername);
Console.WriteLine(strTDPassword);
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
}
public void Verify_Knowledbase_Grid_OrgGroupForUserWithSO31_WithoutRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Validate Knowledgebase Item assigned to Org Group where user has SO 31 access and without restricted viewing");
String strTestCaseNo = "TC005";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDLogin = testdataSummary_Knowledgebase[20];
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
FpSummaryPage Summary = new FpSummaryPage();
System.Threading.Thread.Sleep(30000);
try
{
Assert.IsTrue(Summary.LblNoData.Displayed);
PropertiesCollection.test.Log(Status.Pass, "Knowledgebase Item Grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Knowledgebase Item Grid validated and failed");
}
int Never = Summary.RetrieveKnowledgebaseNeverCount();
int Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items validated and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items validated and failed");
}
}
public void MarkAsRead_Knowledbase_Item_OrgGroupForUserWithSO31_WithoutRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Mark As Read Knowledgebase Item assigned to Org Group where user has SO 31 access and without restricted viewing");
String strTestCaseNo = "TC005";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDTitle = testdataSummary_Knowledgebase[3];
string strTDOtherUser = testdataSummary_Knowledgebase[16];
string strTDLogin = testdataSummary_Knowledgebase[20];
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
Console.WriteLine(strTDUsername);
Console.WriteLine(strTDPassword);
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
Knowledgebase.MarkAsRead_Knowledgebase_Item(strTDTitle);
FpSummaryPage Summary = new FpSummaryPage();
String[] Knowledgebasedetails = Summary.RetrieveKnowledgebaseGriddetails(strTDTitle);
String strFPwebItem = Knowledgebasedetails[0];
System.Threading.Thread.Sleep(15000);
/* Validate Item for logged in user */
try
{
Assert.IsNull(strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Data on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Data on grid validated for logged in user and failed");
}
System.Threading.Thread.Sleep(15000);
/* Validate Item for other user */
Summary.BtnPeopleSelector.Click();
System.Threading.Thread.Sleep(5000);
Summary.TxtPeopleSearch.SendKeys(strTDOtherUser);
System.Threading.Thread.Sleep(5000);
Summary.BtnSearch.Click();
System.Threading.Thread.Sleep(5000);
Summary.PersonSelection.Click();
System.Threading.Thread.Sleep(15000);
Summary.BtnApply.Click();
System.Threading.Thread.Sleep(5000);
try
{
Assert.IsNull(strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Data on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Data on grid validated for other user and failed");
}
}
public void Add_Knowledbase_Item_OrgGroupForUserWithSO31_WithoutRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Add Knowledgebase Item assigned to Org Group where user has SO 31 access and without restricted viewing");
String strTestCaseNo = "TC005";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDTitle = testdataSummary_Knowledgebase[3];
string strTDContent = testdataSummary_Knowledgebase[4];
string strTDVersion = testdataSummary_Knowledgebase[5];
string strTDDate = testdataSummary_Knowledgebase[6];
string strTDRestrictViewing = testdataSummary_Knowledgebase[7];
string strTDYourDate = testdataSummary_Knowledgebase[8];
string strTDYourVersion = testdataSummary_Knowledgebase[9];
string strTDStatus = testdataSummary_Knowledgebase[10];
string strTDUser = testdataSummary_Knowledgebase[11];
string strTDOtherUser = testdataSummary_Knowledgebase[16];
string strTDLogin = testdataSummary_Knowledgebase[20];
/* Calculate Days Old */
string strTDDaysOld = GetDaysOldUnreadKnowledgeBaseItem(Convert.ToDateTime(strTDDate)).ToString();
Console.WriteLine(strTDDaysOld);
/* Identify OrgGroupId for the OrgGroup */
string strSQLtblname = "tblPeopleGroup";
string strtblselectcolumn = "PeopleGroupID";
string strtblcolumn = "PeopleGroupName";
string strwherecondn = strTDUser;
var conn = new ConnectToSQLServer();
string OrgGroupID = conn.Select(strSQLtblname, strtblselectcolumn, strtblcolumn, strwherecondn);
/* Identify OrgGroupId for second OrgGroup */
strwherecondn = strTDOtherUser;
conn = new ConnectToSQLServer();
string OrgGroupIDOther = conn.Select(strSQLtblname, strtblselectcolumn, strtblcolumn, strwherecondn);
/* Add Knowledgebase item and assign to user with SO 31 access and without restricted viewing */
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
System.Threading.Thread.Sleep(15000);
Knowledgebase.Add_Knowledgebase_Item_AssigntoOrgGroup(strTDTitle, strTDContent, strTDVersion, strTDDate, strTDRestrictViewing, OrgGroupID, OrgGroupIDOther);
System.Threading.Thread.Sleep(15000);
FpSideMenus SideMenu = new FpSideMenus();
SideMenu.SummaryClick();
System.Threading.Thread.Sleep(15000);
FpSummaryPage Summary = new FpSummaryPage();
String[] Knowledgebasedetails = Summary.RetrieveKnowledgebaseGriddetails(strTDTitle);
String strFPwebItem = Knowledgebasedetails[0];
String strFPwebNowDated = Knowledgebasedetails[1];
String strFPwebYourDate = Knowledgebasedetails[2];
String strFPwebNowVersioned = Knowledgebasedetails[3];
String strFPwebYourVersion = Knowledgebasedetails[4];
String strFPwebDaysOld = Knowledgebasedetails[5];
String strFPwebStatus = Knowledgebasedetails[6];
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
System.Threading.Thread.Sleep(15000);
/* Validate for logged in user */
/* Validate Item column */
try
{
Assert.AreEqual(strTDTitle, strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Item column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Item column on grid validated for logged in user and failed");
}
/* Validate Now Dated column */
try
{
Assert.AreEqual(strTDDate, strFPwebNowDated);
PropertiesCollection.test.Log(Status.Pass, "Now Dated column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Now Dated column on grid validated for logged in user and failed");
}
/* Validate Your Date column */
try
{
Assert.AreEqual(strTDYourDate, strFPwebYourDate);
PropertiesCollection.test.Log(Status.Pass, "Your Date column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Your Date column on grid validated for logged in user and failed");
}
/* Validate Now Versioned column */
try
{
Assert.AreEqual(strTDVersion, strFPwebNowVersioned);
PropertiesCollection.test.Log(Status.Pass, "Now Versioned column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Now Versioned column on grid validated for logged in user and failed");
}
/* Validate Your Version column */
try
{
Assert.AreEqual(strTDYourVersion, strFPwebYourVersion);
PropertiesCollection.test.Log(Status.Pass, "Your Version column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Your Version column on grid validated for logged in user and failed");
}
/* Validate Days Old column */
try
{
Assert.AreEqual(strTDDaysOld, strFPwebDaysOld);
PropertiesCollection.test.Log(Status.Pass, "Days Old column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Days Old column on grid validated for logged in user and failed");
}
/* Validate Status column */
try
{
Assert.AreEqual(strTDStatus, strFPwebStatus);
PropertiesCollection.test.Log(Status.Pass, "Status column on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Status column on grid validated for logged in user and failed");
}
int Never = Summary.RetrieveKnowledgebaseNeverCount();
int Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items validated and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items validated for logged in user and failed");
}
System.Threading.Thread.Sleep(5000);
/* Validation for other user */
Summary.BtnPeopleSelector.Click();
System.Threading.Thread.Sleep(5000);
Summary.TxtPeopleSearch.SendKeys(strTDOtherUser);
System.Threading.Thread.Sleep(5000);
Summary.BtnSearch.Click();
System.Threading.Thread.Sleep(5000);
Summary.PersonSelection.Click();
System.Threading.Thread.Sleep(15000);
Summary.BtnApply.Click();
System.Threading.Thread.Sleep(5000);
/* Validate Item column */
try
{
Assert.AreEqual(strTDTitle, strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Item column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Item column on grid validated for other user and failed");
}
/* Validate Now Dated column */
try
{
Assert.AreEqual(strTDDate, strFPwebNowDated);
PropertiesCollection.test.Log(Status.Pass, "Now Dated column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Now Dated column on grid validated for other user and failed");
}
/* Validate Your Date column */
try
{
Assert.AreEqual(strTDYourDate, strFPwebYourDate);
PropertiesCollection.test.Log(Status.Pass, "Your Date column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Your Date column on grid validated for other user and failed");
}
/* Validate Now Versioned column */
try
{
Assert.AreEqual(strTDVersion, strFPwebNowVersioned);
PropertiesCollection.test.Log(Status.Pass, "Now Versioned column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Now Versioned column on grid validated for other user and failed");
}
/* Validate Your Version column */
try
{
Assert.AreEqual(strTDYourVersion, strFPwebYourVersion);
PropertiesCollection.test.Log(Status.Pass, "Your Version column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Your Version column on grid validated for other user and failed");
}
/* Validate Days Old column */
try
{
Assert.AreEqual(strTDDaysOld, strFPwebDaysOld);
PropertiesCollection.test.Log(Status.Pass, "Days Old column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Days Old column on grid validated for other user and failed");
}
/* Validate Status column */
try
{
Assert.AreEqual(strTDStatus, strFPwebStatus);
PropertiesCollection.test.Log(Status.Pass, "Status column on grid validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Status column on grid validated for other user and failed");
}
Never = Summary.RetrieveKnowledgebaseNeverCount();
Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items validated for other user and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items validated for other user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items validated for other user and failed");
}
}
public void MarkAsRead_Knowledbase_Item_OrgGroupForUserWithoutSO31_WithRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Mark As Read Knowledgebase Item assigned to Org Group where user does not have SO 31 access and with restricted viewing");
String strTestCaseNo = "TC008";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDTitle = testdataSummary_Knowledgebase[3];
string strTDOtherUser = testdataSummary_Knowledgebase[16];
string strTDLogin = testdataSummary_Knowledgebase[20];
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
Console.WriteLine(strTDUsername);
Console.WriteLine(strTDPassword);
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
Knowledgebase.MarkAsRead_Knowledgebase_Item(strTDTitle);
System.Threading.Thread.Sleep(15000);
FpSideMenus SideMenu = new FpSideMenus();
SideMenu.SummaryClick();
System.Threading.Thread.Sleep(15000);
FpSummaryPage Summary = new FpSummaryPage();
String[] Knowledgebasedetails = Summary.RetrieveKnowledgebaseGriddetails(strTDTitle);
String strFPwebItem = Knowledgebasedetails[0];
String strFPwebNowDated = Knowledgebasedetails[1];
String strFPwebYourDate = Knowledgebasedetails[2];
String strFPwebNowVersioned = Knowledgebasedetails[3];
String strFPwebYourVersion = Knowledgebasedetails[4];
String strFPwebDaysOld = Knowledgebasedetails[5];
String strFPwebStatus = Knowledgebasedetails[6];
/* Validate for logged in user */
/* Validate Item */
try
{
Assert.IsNull(strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Data on grid validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Data on grid validated for logged in user and failed");
}
System.Threading.Thread.Sleep(15000);
int Never = Summary.RetrieveKnowledgebaseNeverCount();
int Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items validated for logged in user and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items validated for logged in user and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items validated and for logged in user passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items validated and for logged in user failed");
}
/* Validate for other user */
Summary.BtnPeopleSelector.Click();
System.Threading.Thread.Sleep(5000);
Summary.TxtPeopleSearch.SendKeys(strTDOtherUser);
System.Threading.Thread.Sleep(5000);
Summary.BtnSearch.Click();
System.Threading.Thread.Sleep(5000);
Summary.PersonSelection.Click();
System.Threading.Thread.Sleep(15000);
Summary.BtnApply.Click();
System.Threading.Thread.Sleep(5000);
/* Validate Item */
try
{
Assert.IsNull(strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Data on grid for other user validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Data on grid for other user validated and failed");
}
Never = Summary.RetrieveKnowledgebaseNeverCount();
Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items for other user validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items for other user validated and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items for other user validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items for other user validated and failed");
}
}
public void Delete_Knowledbase_Item_UserWithoutSO31_WithoutRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Delete Knowledgebase Item assigned to user without SO 31 access and without restricted viewing");
String strTestCaseNo = "TC003";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDTitle = testdataSummary_Knowledgebase[3];
string strTDRestrictViewing = testdataSummary_Knowledgebase[7];
string strTDUser = testdataSummary_Knowledgebase[11];
string strTDOtherUser = testdataSummary_Knowledgebase[16];
string strTDLogin = testdataSummary_Knowledgebase[20];
/* Identify PeopleId for the user */
string strSQLtblname = "tblPeople";
string strtblselectcolumn = "PeopleID";
string strtblcolumn = "Surname";
string strwherecondn = strTDUser;
var conn = new ConnectToSQLServer();
string PeopleID = conn.Select(strSQLtblname, strtblselectcolumn, strtblcolumn, strwherecondn);
/* Identify PeopleId for second user */
strwherecondn = strTDOtherUser;
conn = new ConnectToSQLServer();
string PeopleIDOther = conn.Select(strSQLtblname, strtblselectcolumn, strtblcolumn, strwherecondn);
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
Knowledgebase.Delete_Knowledgebase_Item(strTDTitle, strTDRestrictViewing, PeopleID, PeopleIDOther);
System.Threading.Thread.Sleep(5000);
string KBItemXPath = null;
KBItemXPath = "//*/div/span[contains(.,'" + strTDTitle + "')]";
try
{
Assert.IsTrue(Knowledgebase.txtKBItem.Displayed);
PropertiesCollection.test.Log(Status.Fail, "Knowledgebase Item could not be deleted");
}
catch
{
PropertiesCollection.test.Log(Status.Pass, "Knowledgebase Item deleted");
}
}
public void Update_Knowledbase_Item_UserWithoutSO31_WithoutRestriction()
{
PropertiesCollection.test = PropertiesCollection.extent.CreateTest("Update Knowledgebase Item assigned to user without SO 31 access and without restricted viewing");
String strTestCaseNo = "TC003";
String strtblname = "automation_summary_knowledgebase";
String strTestType = "Progression";
/* Get test data from MySQL */
var connection = new ConnectToMySQL_Fetch_TestData();
var testdataSummary_Knowledgebase = connection.Select(strtblname, strTestCaseNo, strTestType);
string strTDTitle = testdataSummary_Knowledgebase[3];
string strTDVersion = testdataSummary_Knowledgebase[5];
string strTDDate = testdataSummary_Knowledgebase[6];
string strTDRestrictViewing = testdataSummary_Knowledgebase[7];
string strTDYourDate = testdataSummary_Knowledgebase[8];
string strTDYourVersion = testdataSummary_Knowledgebase[9];
string strTDStatus = testdataSummary_Knowledgebase[10];
string strTDUser = testdataSummary_Knowledgebase[11];
string strTDUpdatedVersion = testdataSummary_Knowledgebase[12];
string strTDUpdatedContent = testdataSummary_Knowledgebase[13];
string strTDOtherUser = testdataSummary_Knowledgebase[16];
string strTDOtherLogin = testdataSummary_Knowledgebase[17];
string strTDUpdatedStatus = testdataSummary_Knowledgebase[18];
string strTDLogin = testdataSummary_Knowledgebase[20];
ConnectToMySQL_Fetch_TestData MySQLConnect = new ConnectToMySQL_Fetch_TestData();
String[] TestData = new string[3];
TestData = MySQLConnect.GetLoginDetails(strTDLogin);
string strTDUsername = TestData[1];
string strTDPassword = TestData[2];
FpLoginPage loginPage = new FpLoginPage();
loginPage.LoginWithUserCredentials(strTDUsername, strTDPassword);
/* Calculate Days Old */
string strTDDaysOld = GetDaysOldUnreadKnowledgeBaseItem(Convert.ToDateTime(strTDDate)).ToString();
Console.WriteLine(strTDDaysOld);
FpKnowledgeBasePage Knowledgebase = new FpKnowledgeBasePage();
Knowledgebase.Update_Knowledgebase_Item(strTDTitle, strTDUpdatedVersion, strTDUpdatedContent);
System.Threading.Thread.Sleep(15000);
FpSideMenus SideMenu = new FpSideMenus();
SideMenu.SummaryClick();
System.Threading.Thread.Sleep(15000);
FpSummaryPage Summary = new FpSummaryPage();
String[] Knowledgebasedetails = Summary.RetrieveKnowledgebaseGriddetails(strTDTitle);
String strFPwebItem = Knowledgebasedetails[0];
String strFPwebNowDated = Knowledgebasedetails[1];
String strFPwebYourDate = Knowledgebasedetails[2];
String strFPwebNowVersioned = Knowledgebasedetails[3];
String strFPwebYourVersion = Knowledgebasedetails[4];
String strFPwebDaysOld = Knowledgebasedetails[5];
String strFPwebStatus = Knowledgebasedetails[6];
System.Threading.Thread.Sleep(15000);
/* Validate for logged in user */
/* Validate Item column */
try
{
Assert.AreEqual(strTDTitle, strFPwebItem);
PropertiesCollection.test.Log(Status.Pass, "Item column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Item column on grid validated and failed");
}
/* Validate Now Dated column */
try
{
Assert.AreEqual(strTDDate, strFPwebNowDated);
PropertiesCollection.test.Log(Status.Pass, "Now Dated column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Now Dated column on grid validated and failed");
}
/* Validate Your Date column */
try
{
Assert.AreEqual(DateTime.Now.ToString("dd MMM yyyy"), strFPwebYourDate);
PropertiesCollection.test.Log(Status.Pass, "Your Date column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Your Date column on grid validated and failed");
}
/* Validate Now Versioned column */
try
{
Assert.AreEqual(strTDUpdatedVersion, strFPwebNowVersioned);
PropertiesCollection.test.Log(Status.Pass, "Now Versioned column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Now Versioned column on grid validated and failed");
}
/* Validate Your Version column */
try
{
Assert.AreEqual(strTDVersion, strFPwebYourVersion);
PropertiesCollection.test.Log(Status.Pass, "Your Version column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Your Version column on grid validated and failed");
}
/* Validate Days Old column */
try
{
Assert.AreEqual(strTDDaysOld, strFPwebDaysOld);
PropertiesCollection.test.Log(Status.Pass, "Days Old column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Days Old column on grid validated and failed");
}
/* Validate Status column */
try
{
Assert.AreEqual(strTDUpdatedStatus, strFPwebStatus);
PropertiesCollection.test.Log(Status.Pass, "Status column on grid validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Status column on grid validated and failed");
}
int Never = Summary.RetrieveKnowledgebaseNeverCount();
int Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items validated and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items validated and failed");
}
/* Validate for other user */
Summary.BtnPeopleSelector.Click();
System.Threading.Thread.Sleep(5000);
Summary.TxtPeopleSearch.SendKeys(strTDOtherUser);
System.Threading.Thread.Sleep(5000);
Summary.BtnSearch.Click();
System.Threading.Thread.Sleep(5000);
Summary.PersonSelection.Click();
System.Threading.Thread.Sleep(15000);
Summary.BtnApply.Click();
System.Threading.Thread.Sleep(5000);
try
{
Assert.IsTrue(Summary.LblNoData.Displayed);
PropertiesCollection.test.Log(Status.Pass, "Update Knowledgebase Item for other user validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Update Knowledgebase Item for other user validated and failed");
}
Never = Summary.RetrieveKnowledgebaseNeverCount();
Old = Summary.RetrieveKnowledgebaseOldCount();
try
{
Assert.AreEqual(Never, Convert.ToInt32(Summary.CountNever.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Never items for other user validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Never items for other user validated and failed");
}
try
{
Assert.AreEqual(Old, Convert.ToInt32(Summary.CountOld.Text.Substring(0, 1)));
PropertiesCollection.test.Log(Status.Pass, "Count of Old items for other user validated and passed");
}
catch
{
PropertiesCollection.test.Log(Status.Fail, "Count of Old items for other user validated and failed");
}
}