public void IsBannedDomain_NoBannedDomain()
        {
            string Test_Result             = string.Empty;
            IsBannedDomainRequest  request = new IsBannedDomainRequest();
            IsBannedDomainResponse response;

            try
            {
                request.domainUrl = DomainUrl[0];
                response          = target.IsBannedDomain(request);
                bool result = response.IsBannedDomainResult;
                Test_Result = _Assert.Execute(
                    () => _Assert.AssertAreEqual(result, Convert.ToBoolean("False"), "domain url are banned doamin", root)
                    );

                if (Test_Result == "")
                {
                    _writer.WriteLog(serviceName, "IsBannedDomain_NoBannedDomain", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Enter No Banned domain Url", SBWSCommon.StatusLevelOptions.PASS.ToString(), "service return the domain url is  not banned domain", root);
                }

                else
                {
                    _writer.WriteLog(serviceName, "IsBannedDomain_NoBannedDomain", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Enter No Banned domain Url", SBWSCommon.StatusLevelOptions.FAIL.ToString(), "|Error:service return the domain url is  banned domain", root);
                }
            }

            catch (FaultException ex)
            {
                _writer.WriteLog(serviceName, "IsBannedDomain_NoBannedDomain", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Enter No Banned domain Url", SBWSCommon.StatusLevelOptions.FAIL.ToString(), Test_Result + "|Error:" + ex.Message, root);
            }
        }
        public void IsBannedDomain_BannedDomain()
        {
            DataSet       DataSFDC        = new DataSet();
            string        Test_Result     = string.Empty;
            List <string> AllBannedDomain = new List <string>();

            int    TotalCount   = 0;
            int    BannedDomain = 0;
            string DomainUrl    = string.Empty;
            string Active;

            IsBannedDomainRequest  request = new IsBannedDomainRequest();
            IsBannedDomainResponse response;

            UnitTesting.DomainWebService.GetAllBannedDomainsRequest cmd = null;

            string QueryBannedDomain = "Select (Select COUNT(*) from dbo.Banned_Domain__c where IsActive__c = 'true') 'TotalCount', count(*) as BannedDomain,Domain_URL__c,IsActive__c from dbo.Banned_Domain__c where IsActive__c='true' group by Domain_URL__c, IsActive__c";

            DataSFDC   = _Common.ExecuteDatabase(_Common.SFDC_ConnectionString, QueryBannedDomain, "Select");
            TotalCount = Convert.ToInt32(DataSFDC.Tables[0].Rows[0]["TotalCount"].ToString());
            for (int i = 0; i < TotalCount; i++)
            {
                BannedDomain = Convert.ToInt32(DataSFDC.Tables[0].Rows[i]["BannedDomain"].ToString());
                DomainUrl    = Convert.ToString(DataSFDC.Tables[0].Rows[i]["Domain_URL__c"].ToString());
                Active       = DataSFDC.Tables[0].Rows[i]["IsActive__c"].ToString();
                AllBannedDomain.Add(DomainUrl);
            }
            try
            {
                for (int i = 0; i < TotalCount; i++)
                {
                    request.domainUrl = AllBannedDomain[i];
                    response          = target.IsBannedDomain(request);
                    bool result = response.IsBannedDomainResult;
                    Test_Result = _Assert.Execute(
                        () => _Assert.AssertAreEqual(result, Convert.ToBoolean("true"), "Banned domain are  not same", root)
                        );

                    if (Test_Result == "")
                    {
                        _writer.WriteLog(serviceName, "IsBannedDomain_BannedDomain", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Enter Banned domain Url", SBWSCommon.StatusLevelOptions.PASS.ToString(), "service return the domain url(" + AllBannedDomain[i] + ") is banned domain", root);
                    }

                    else
                    {
                        _writer.WriteLog(serviceName, "IsBannedDomain_BannedDomain", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Enter Banned domain Url", SBWSCommon.StatusLevelOptions.PARTIAL.ToString(), "service return the domain url(" + AllBannedDomain[i] + ") is  not banned domain and SFDC database UAT2 is not in sync", root);
                    }
                }
            }

            catch (FaultException ex)
            {
                _writer.WriteLog(serviceName, "IsBannedDomain_BannedDomain", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(), "Enter Banned domain Url", SBWSCommon.StatusLevelOptions.FAIL.ToString(), Test_Result + "|Error:" + ex.Message, root);
            }
        }