public void ThenTheBelowResultShouldBeRetrieved_(Table table)
        {
            DataTable DataToVerify = DataTableUtilities.ConvertTableToDataTable(table);
            DataTable QueryRes     = (DataTable)ScenarioContext.Current["QueryResults"];

            if (!DataTableUtilities.CompareTwoDataTables(QueryRes, DataToVerify))
            {
                ScenarioContext.Current["Comments"]  = ScenarioContext.Current["Comments"] + "Query result is not displayed as per the table from database. \n";
                ScenarioContext.Current["ActResult"] = "Failed";
            }
        }
        public void ThenTheBelowResultSetShouldContain(Table table)
        {
            DataTable DataToVerify = DataTableUtilities.ConvertTableToDataTable(table);
            DataTable QueryRes     = (DataTable)ScenarioContext.Current["QueryResults"];

            foreach (DataRow dr in DataToVerify.Rows)
            {
                if (!dr["DisplayOrder"].ToString().Contains("-1"))
                {
                    ScenarioContext.Current["Comments"]  = ScenarioContext.Current["Comments"] + "Query result is not displayed as per the table from database. \n";
                    ScenarioContext.Current["ActResult"] = "Failed";
                }
            }
        }