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); } }