private void button6_Click(object sender, EventArgs e) { string key = ""; keyword keyword = new keyword(); if (textBox4.Text == null) { MessageBox.Show("Please Empty values not allowed"); return; } key = textBox4.Text; keyword.keywords = key; if (fbEntities.keywords.Any(c => c.keywords.Trim().ToLower() == key.ToLower().Trim())) { MessageBox.Show("This Keyword already exist !"); return; } fbEntities.keywords.Add(keyword); if (fbEntities.SaveChanges() == 1) { MessageBox.Show("Added Sucessfully "); } }
//Add Criteria private void button7_Click(object sender, EventArgs e) { fbEntities = new FBNewsDbEntities(); criteria criteria = new criteria(); criteria.criterianame = textBox6.Text; fbEntities.criterias.Add(criteria); fbEntities.SaveChanges(); getcriterias(); }
private void deletecriteria() { int criteriaId = int.Parse(listView1.SelectedItems[0].SubItems[0].Text); fbEntities = new FBNewsDbEntities(); var dcriteria = fbEntities.criterias.Where(c => c.id == criteriaId).SingleOrDefault(); var dkeywords = fbEntities.keywords.Where(c => c.cirteriaId == criteriaId).ToList(); var dpages = fbEntities.pages.Where(c => c.criteriaId == criteriaId).ToList(); foreach (keyword keyword in dkeywords) { if (keyword != null) { fbEntities.keywords.Remove(keyword); fbEntities.SaveChanges(); } } foreach (page page in dpages) { if (page != null) { fbEntities.pages.Remove(page); fbEntities.SaveChanges(); } } if (dcriteria != null) { fbEntities.criterias.Remove(dcriteria); fbEntities.SaveChanges(); } getcriterias(); clearlist(); }
//Add Keyword private void button6_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count == 0) { MessageBox.Show("Please choose criteria"); return; } string key = ""; int criteriaId = int.Parse(listView1.SelectedItems[0].SubItems[0].Text); keyword keyword = new keyword(); if (textBox4.Text == null) { MessageBox.Show("Please Empty values not allowed"); return; } key = textBox4.Text; keyword.keywords = key; keyword.cirteriaId = criteriaId; if (fbEntities.keywords.Any(c => c.keywords.Trim().ToLower() == key.ToLower().Trim())) { MessageBox.Show("This Keyword already exist !"); return; } fbEntities.keywords.Add(keyword); if (fbEntities.SaveChanges() == 1) { MessageBox.Show("Added Sucessfully "); } }
private void button4_Click(object sender, EventArgs e) { int postcount = 0; fbEntities = new FBNewsDbEntities(); label6.Text = "Loading"; // Url = Url + token; pages = fbEntities.pages.ToList(); keywords = fbEntities.keywords.Select(c => c.keywords).ToArray(); foreach (page page in pages) { path = "https://graph.facebook.com/" + page.pagefbid + "/posts?limit=100&access_token=" + token; var clientRepsonse = ""; try { using (var client = new WebClient()) { clientRepsonse = client.DownloadString(path); } int count = 0; dynamic deserialize_post = JsonConvert.DeserializeObject(clientRepsonse); if (deserialize_post.data != null) { // check if posts exist var listresponse = deserialize_post.data; DateTime lastCheckDate = listresponse[0].created_time; for (int i = 0; i < listresponse.Count; i++) { count = listresponse.Count; string message = listresponse[i].message; DateTime createdate = listresponse[i].created_time; string id = listresponse[i].id; if (!string.IsNullOrEmpty(message)) { foreach (string keyword in keywords) { if (message.ToLower().Contains(keyword.ToLower()) && !(fbEntities.FBNews.Any(c => c.post_id == id))) { FBNew fb = new FBNew(); fb.created_at = createdate; fb.message = message; fb.pagename = page.pagename; fb.post_id = id; fbEntities.FBNews.Add(fb); fbEntities.SaveChanges(); postcount++; } } } } page.lastcheckdate = lastCheckDate; fbEntities.SaveChanges(); } // MessageBox.Show(count + ""); // Do further processing. } catch (Exception ex) { MessageBox.Show(ex.Message + ""); } } MessageBox.Show("Done ! We Found " + postcount + " new posts"); label6.Text = ""; }
//Search private void button4_Click(object sender, EventArgs e) { int postcount = 0; fbEntities = new FBNewsDbEntities(); label6.Text = "Loading"; var criterias = fbEntities.criterias.ToList(); //Task f = Task.Factory.StartNew(() => //{ foreach (criteria criteria in criterias) { pages = fbEntities.pages.Where(c => c.criteriaId == criteria.id).ToList(); keywords = fbEntities.keywords.Where(c => c.cirteriaId == criteria.id).Select(c => c.keywords).ToArray(); if (pages.Count == 0 || keywords.Length == 0) { continue; } foreach (page page in pages) { path = "https://graph.facebook.com/" + page.pagefbid + "/posts?limit=100&access_token=" + token; var clientRepsonse = ""; try { using (var client = new WebClient()) { clientRepsonse = client.DownloadString(path); } int count = 0; dynamic deserialize_post = JsonConvert.DeserializeObject(clientRepsonse); if (deserialize_post.data != null) { // check if posts exist var listresponse = deserialize_post.data; DateTime lastCheckDate = listresponse[0].created_time; for (int i = 0; i < listresponse.Count; i++) { count = listresponse.Count; string message = listresponse[i].message; DateTime createdate = listresponse[i].created_time; string id = listresponse[i].id; if (!string.IsNullOrEmpty(message)) { foreach (string keyword in keywords) { string[] splitkeyword = keyword.Split(','); if (splitkeyword.Length == 1) { if (message.ToLower().Contains(keyword.ToLower()) && !(fbEntities.FBNews.Any(c => c.post_id == id))) { string[] url = id.Split('_'); FBNew fb = new FBNew(); fb.created_at = createdate; fb.message = message; fb.pagename = page.pagename; fb.post_id = id; fb.location = page.location; fb.category = page.category; fb.keyword = keyword; fb.url = page.pageurl + url[1]; fbEntities.FBNews.Add(fb); fbEntities.SaveChanges(); postcount++; } } else if (splitkeyword.Length > 1) { for (int k = 0; k < splitkeyword.Length; k++) { if (splitkeyword[k].ToLower().Trim().Contains("بدون")) { if (message.ToLower().Contains(splitkeyword[k].ToLower()) && message.ToLower().Contains(splitkeyword[k - 1].ToLower()) && !(fbEntities.FBNews.Any(c => c.post_id == id))) { string[] url = id.Split('_'); FBNew fb = new FBNew(); fb.created_at = createdate; fb.message = message; fb.pagename = page.pagename; fb.post_id = id; fb.location = page.location; fb.category = page.category; fb.keyword = keyword; fb.url = page.pageurl + url[1]; fbEntities.FBNews.Add(fb); fbEntities.SaveChanges(); postcount++; } } else if (message.ToLower().Contains(splitkeyword[k].ToLower()) && !(fbEntities.FBNews.Any(c => c.post_id == id))) { string[] url = id.Split('_'); FBNew fb = new FBNew(); fb.created_at = createdate; fb.message = message; fb.pagename = page.pagename; fb.post_id = id; fb.location = page.location; fb.category = page.category; fb.keyword = splitkeyword[k]; fb.url = page.pageurl + url[1]; fbEntities.FBNews.Add(fb); fbEntities.SaveChanges(); postcount++; } } } } } } page.lastcheckdate = lastCheckDate; fbEntities.SaveChanges(); } // MessageBox.Show(count + ""); // Do further processing. } catch (Exception ex) { MessageBox.Show(ex.Message + ""); } } } //}); MessageBox.Show("Done ! We Found " + postcount + " new posts"); label6.Text = ""; }