private void BackButton_Click(object sender, EventArgs e) { string searchAll = textBox1.Text; string searchAny = textBox2.Text; string searchExclude = textBox3.Text; string start = dateTimePicker1.Value.ToString("yyyy-MM-dd"); string end = dateTimePicker2.Value.ToString("yyyy-MM-dd"); string lang = comboBox1.Text; decimal maxResult = numericUpDown1.Value; long maxid = -1; long minid = -1; if (re != null && re.Results != null && re.Results.Count > 0) { maxid = re.Results.Max(x => x.NewsId); re = ResultViewMethods.Post(searchAll, searchAny, searchExclude, start, end, maxResult, minid, maxid, lang); if (re.Results.Count == 1) { MessageBox.Show("there isn't new news"); } else { dataGridView1.DataSource = re.Results; } } }
private void SearchButton_Click(object sender, EventArgs e) { if (String.IsNullOrWhiteSpace(textBox1.Text)) { MessageBox.Show(this, "Enter topic please."); return; } else if (numericUpDown1.Value == 0) { MessageBox.Show(this, "Enter MaxResult please."); return; } else if (dateTimePicker1.Value.Date == dateTimePicker2.Value.Date) { MessageBox.Show(this, "Change start time or end time, please."); return; } string searchAll = textBox1.Text; string searchAny = textBox2.Text; string searchExclude = textBox3.Text; string start = dateTimePicker1.Value.ToString("yyyy-MM-dd"); string end = dateTimePicker2.Value.ToString("yyyy-MM-dd"); string lang = comboBox1.Text; decimal maxResult = numericUpDown1.Value; long maxid = -1; long minid = -1; re = ResultViewMethods.Post(searchAll, searchAny, searchExclude, start, end, maxResult, maxid, minid, lang); dataGridView1.DataSource = re.Results; }
public Form1() { re = new ResultView(); InitializeComponent(); }
public void insertByEfx(ResultView resultView) { using (var db = new NewsEntities4()) { foreach (var item in resultView.Results) { db.News.Add(item); } db.SaveChanges(); } }
public bool InsertNews(ResultView resultView) { try { using (SqlConnection con = Connection._Connection) { con.Open(); foreach (var item in resultView.Results) { string saveResult = @"INSERT into News(Country,DomainName,GroupId,ImageUrl,IsPopularWebsite,Lang,NewsId,OnHomePage,PublishDate,RetweetCount,Spot,Title,Topics,Url) VALUES (@Country,@DomainName,@GroupId,@ImageUrl,@IsPopularWebsite,@Lang,@NewsId,@OnHomePage,@PublishDate,@RetweetCount,@Spot,@Title,@Topics,@Url)"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.Parameters.Add("@Country", SqlDbType.NVarChar).Value = item.Country; cmd.Parameters.Add("@DomainName", SqlDbType.NVarChar).Value = item.DomainName; cmd.Parameters.Add("@GroupId", SqlDbType.NVarChar).Value = item.GroupId; cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = item.ImageUrl; cmd.Parameters.Add("@IsPopularWebsite", SqlDbType.Bit).Value = item.IsPopularWebsite; cmd.Parameters.Add("@Lang", SqlDbType.NVarChar).Value = item.Lang; cmd.Parameters.Add("@NewsId", SqlDbType.NVarChar).Value = item.NewsId; cmd.Parameters.Add("@OnHomePage", SqlDbType.Bit).Value = item.OnHomePage; cmd.Parameters.Add("@PublishDate", SqlDbType.VarChar).Value = item.PublishDate; cmd.Parameters.Add("@RetweetCount", SqlDbType.Int).Value = item.RetweetCount; cmd.Parameters.Add("@Spot", SqlDbType.NVarChar).Value = item.Spot; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = item.Title; cmd.Parameters.Add("@Topics", SqlDbType.NVarChar).Value = item.Topics; cmd.Parameters.Add("@Url", SqlDbType.NVarChar).Value = item.Url; cmd.CommandText = saveResult; int rowCount = cmd.ExecuteNonQuery(); } con.Close(); } } catch (SqlException ex) { throw ex; } return(false); }
public static ResultView Post(string searchAll, string searchAny, string searchExclude, string start, string end, decimal maxResult, long MaxId, long MinId, string lang) { try { String url = String.Format("https://api.newsmeter.com/api/news?searchAll={0}&searchAny={1}%&searchExclude={2}%&startDate={3}&endDate={4}&maxResult={5}&maxNewsId={6}&minNewsId={7}&lang={8}", searchAll, searchAny, searchExclude, start, end, maxResult, MaxId, MinId, lang); //string url = "https://api.newsmeter.com/api/news?1=1"; //StringBuilder sb = new StringBuilder(url); //if (!String.IsNullOrWhiteSpace(searchAll)) //{ // sb.Append("&searchAll=" + searchAll); //} //if (MaxId > 0) //{ // sb.Append("&maxNewsId=" + MaxId); //} //url = sb.ToString(); ResultView res = new ResultView(); WebRequest req = WebRequest.Create(url); req.Method = "GET"; req.Headers.Add("token", "445271f4-b117-4e2a-a3a3-7effdd2c475e"); req.ContentType = "application/json; charset=utf-8"; WebResponse resp = req.GetResponse(); Stream stream = resp.GetResponseStream(); StreamReader re = new StreamReader(stream); string json = re.ReadToEnd(); res = Newtonsoft.Json.JsonConvert.DeserializeObject <ResultView>(json); //var dd= Newtonsoft.Json.JsonConvert.SerializeObject(list);//yukardaki işlemin tam tersi return(res); } catch (WebException e) { throw e; } }