protected void Page_Load(object sender, EventArgs e)
    {
        string Apikey = "4a5075dbb713f58f60e3acf8f924fa41c9555287";                                   //"e9370cd124274b2dcd0cc7735ad912eb6be52f79";
        string ApiUrl = "http://i.earthinfralanddevelopers.co.in/admin/nlp.ashx?apikey=" + Apikey + "&page=http://news.nationalgeographic.com/2017/04/jungle-dogs-peru-amazon-rare";

        var ApiRequest = (HttpWebRequest)WebRequest.Create(ApiUrl);

        ApiRequest.Method      = "GET";
        ApiRequest.ContentType = "application/xml";
        var    webResponse      = (HttpWebResponse)ApiRequest.GetResponse();
        string KeyWordsAsString = string.Empty;

        using (StreamReader KayReader = new StreamReader(webResponse.GetResponseStream()))
        {
            KeyWordsAsString = KayReader.ReadToEnd();
            KayReader.Close();
        }
        System.Xml.Linq.XDocument KeyWordsAsXml;
        KeyWordsAsXml = System.Xml.Linq.XDocument.Parse(KeyWordsAsString);
        string keyList = string.Empty;

        foreach (XElement Elm in KeyWordsAsXml.Root.Elements())
        {
            if (Elm.Name == "keywords")
            {
                foreach (XElement keys in Elm.Elements())
                {
                    try
                    {
                        keyList += keyList == string.Empty ? keys.Value.ToString() : "," + keys.Value.ToString();
                    }
                    catch
                    {
                        continue;
                    }
                }
            }
        }

        form1.InnerHtml = keyList;
    }
    public DataSet MatchedCampaigns(string pageUrl, string bannerType, string country, string osType, int noOfAds, int maxConversions, string todaysConversions, string matchOrder, string targettingFilter, string LimitConversionsInQuery)
    {
        try
        {
            //bool combinationFlag = CheckCombination(bannerType, country, osType, todaysConversions, maxConversions, matchOrder, targettingFilter, LimitConversionsInQuery);
            //combinationFlag = false;
            //if (combinationFlag == true)
            //{
            #region Get keywords from web page

            #region Setting page Url
            // pageUrl = "http://news.nationalgeographic.com/2017/04/jungle-dogs-peru-amazon-rare";
            // pageUrl = "http://camp.earthinfralanddevelopers.co.in/test/test.html";
            #endregion

            string Apikey = "4a5075dbb713f58f60e3acf8f924fa41c9555287";                                       //"e9370cd124274b2dcd0cc7735ad912eb6be52f79";
            //string ApiUrl = "https://gateway-a.watsonplatform.net/calls/url/URLGetRankedKeywords?apikey=" + Apikey + "&url=" + pageUrl; // ibm api
            string ApiUrl = "http://i.earthinfralanddevelopers.co.in/admin/nlp.ashx?apikey=" + Apikey + "&page=" + pageUrl;

            var ApiRequest = (HttpWebRequest)WebRequest.Create(ApiUrl);
            ApiRequest.Method      = "GET";
            ApiRequest.ContentType = "application/xml";
            var    webResponse      = (HttpWebResponse)ApiRequest.GetResponse();
            string KeyWordsAsString = string.Empty;
            using (StreamReader KayReader = new StreamReader(webResponse.GetResponseStream()))
            {
                KeyWordsAsString = KayReader.ReadToEnd();
                KayReader.Close();
            }
            System.Xml.Linq.XDocument KeyWordsAsXml;
            KeyWordsAsXml = System.Xml.Linq.XDocument.Parse(KeyWordsAsString);
            string keyList = string.Empty;
            foreach (XElement Elm in KeyWordsAsXml.Root.Elements())
            {
                if (Elm.Name == "keywords")
                {
                    foreach (XElement keys in Elm.Elements())
                    {
                        try
                        {
                            keyList += keyList == string.Empty ? keys.Value.ToString() : "," + keys.Value.ToString();
                            //if (keyList == string.Empty)
                            //    keyList = keys.Element("text").Value.ToString();
                            //else
                            //    keyList = keyList + "," + keys.Element("text").Value.ToString();
                        }
                        catch
                        {
                            continue;
                        }
                    }
                }
            }
            DataSet dsReturnCampaigns = GetMatchedCampaigns(keyList, bannerType, country, osType, noOfAds, todaysConversions, matchOrder, targettingFilter, LimitConversionsInQuery);
            #endregion Get keywords from web page
            return(dsReturnCampaigns);

            //}
            //else
            //{
            //    if (noOfAds != 0)
            //    {
            //    #region Get Possible Combinations
            //        string Query = "SELECT top(" + noOfAds + ") [campaign_id],[campaigin_name],[title],[discription],[url],[call_to_action],[action],[device_and_action],[stars],[cost],[sponsers_adv],[country_targeted],[Add_style_formate],[date],[icon_img],[vedio_url] FROM [dbo].[campaigns]  where Add_style_formate='" + bannerType + "' and " + targettingFilter + " and (select status from dbo.campain_details where campain_id=campaigns.campaign_id)='Running' AND " + todaysConversions + " <= " + maxConversions + " ORDER BY NEWID() ";
            //        SqlConnection con = new SqlConnection(strcon);
            //        con.Open();
            //        SqlDataAdapter adp = new SqlDataAdapter(Query, con);
            //        DataSet dsGetData = new System.Data.DataSet();
            //        adp.Fill(dsGetData);
            //        con.Close();
            //    #endregion

            //        if (bannerType == "Banner 1" || bannerType == "Banner 4")
            //        { return null; }
            //        else
            //        {
            //            if (dsGetData.Tables[0].Rows.Count > 0)
            //                return dsGetData;
            //            else
            //                return null;
            //        }
            //    } else
            //    {
            //        return null;
            //    }
            //}
        }
        catch (Exception sqe)
        {
            return(null);
        }
    }