public void GetCounties()
{
try
{
//Fill dataset with CDS return values.
DataSet Data = new DataSet();
string Test_Result = String.Empty;
bool is_active = false;
string Query = "select * from mfweb.tbl_CountryLookup where IsActive=1";
Data = _Common.ExecuteDatabase(_Common.CDS_ConnectionString, Query, "Select");
//Call WebService method
List <Country> actual = target.GetCountries();
//for (int i = 0; i < actual.Count; i++)
//{
if (!string.IsNullOrEmpty(Data.Tables[0].Rows[0]["CventCountryCode"].ToString()))
{
cventCountryCode = Convert.ToString(Data.Tables[0].Rows[0]["CventCountryCode"]);
}
else
{
cventCountryCode = null;
}
if (!string.IsNullOrEmpty(Data.Tables[0].Rows[0]["IsActive"].ToString()))
{
is_active = Convert.ToBoolean(Data.Tables[0].Rows[0]["IsActive"]);
}
else
{
is_active = false;
}
Test_Result = _Assert.Execute(
() => _Assert.AssertIsNotNull(actual, "Reasponse is not null", root),
() => _Assert.AssertAreEqual(string.IsNullOrEmpty(actual[0].CventCountryCode) ? null : actual[0].CventCountryCode, cventCountryCode, "CventCountryCode dint match", root),
() => _Assert.AssertAreEqual(actual[0].IsActive, is_active, "IsActive dint match", root),
() => _Assert.AssertAreEqual(actual.Count, Data.Tables[0].Rows.Count, "IsActive dint match", root)
);
if (Test_Result == "")
{
_writer.WriteLog(serviceName, "GetCounties", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Verify the correctness of GetCounties data", SBWSCommon.StatusLevelOptions.PASS.ToString(), Test_Result + "| CventCountryCode:" + actual[0].CventCountryCode + "|Total countries Count:" + actual.Count, root);
}
else
{
_writer.WriteLog(serviceName, "GetCounties", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Verify the correctness of GetCounties data", SBWSCommon.StatusLevelOptions.FAIL.ToString(), Test_Result + "| CventCountryCode:" + actual[0].CventCountryCode + "|Total countries Count:" + actual.Count, root);
////throw new Exception(Test_Result);
}
//}
}
catch (Exception)
{
//throw;
}
}
