public int InsertInformation(NewsObject newsObj) { SqlConnection con = GetConnection(); con.Open(); SqlCommand cmd = new SqlCommand("Insert_News", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NewsTitle", newsObj.NewsTitle); cmd.Parameters.AddWithValue("@NewsLink", newsObj.NewsLink); cmd.Parameters.AddWithValue("@UserId", newsObj.UserId); cmd.Parameters.AddWithValue("@Status", newsObj.Status); try { return(cmd.ExecuteNonQuery()); } catch { throw; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } }
private async Task <NewsObject> GetValueTest() { string url = "http://www.pja.edu.pl/aktualnosci/projekt-reconcile"; NewsObject news = await NewsGrabber.GetNewsByUrl(url); return(news); }
private void GetNewsCallback(string errorMessage, NewsObject newsObject) { if (!string.IsNullOrEmpty(errorMessage)) { view.Dispatcher.BeginInvoke (() => { ShowLoadingProgress(false); MessageBox.Show(" Couldn't load new news. " + errorMessage); return; }); return; } foreach (var item in newsObject.IncludedNews) { Cached.LoadedNews.News.Add(item); } Cached.LoadedNews.NextId = newsObject.NextId; view.Dispatcher.BeginInvoke (() => { ShowLoadingProgress(false); view.listNews.Source = Cached.LoadedNews.News; }); }
public async System.Threading.Tasks.Task <ActionResult <IEnumerable <SearchNewsModel> > > NewsAsync(string searchInput) { //"https://newsapi.org/v2/everything?q=" + searchInput +"&from=2018-12-10&sortBy=publishedAt&apiKey=" + NewsApiKey string url = "https://newsapi.org/v2/everything?q=" + searchInput + "&from=2018-12-10&sortBy=publishedAt&apiKey=" + NewsApiKey; string jsonString; using (var httpClient = new HttpClient()) { jsonString = await httpClient.GetStringAsync(url); } NewsObject json = JsonConvert.DeserializeObject <NewsObject>(jsonString); List <SearchNewsModel> list = new List <SearchNewsModel>(); foreach (var element in json.articles) { SearchNewsModel news = new SearchNewsModel(); news.Author = element.author; news.Content = element.content; news.Title = element.title; list.Add(news); } return(list); }
public async Task <IActionResult> CreateShowNewsObjectByHttpAsync( [HttpTrigger( AuthorizationLevel.Anonymous, methods: "post", Route = "show/{showId}/news" )] HttpRequestMessage req, ClaimsPrincipal identity, string showId, ILogger log ) { string authorizationStatus = req.Headers.GetValues("AuthorizationStatus").FirstOrDefault(); if (Convert.ToInt32(authorizationStatus).Equals((int)HttpStatusCode.Accepted)) { NewsObject inputObject = JsonConvert.DeserializeObject <NewsObject>(await req.Content.ReadAsStringAsync()); MessageObject <NewsObject> message = new MessageObject <NewsObject>() { Headers = new MessageHeaders() { RequestCorrelationId = Guid.NewGuid().ToString(), RequestCreatedAt = DateTime.Now }, Body = new NewsObject() { CreatedAt = DateTime.Now, Doctype = DocTypes.News, BingId = inputObject.BingId, DatePublished = inputObject.DatePublished, Name = inputObject.Name, Url = inputObject.Url, Partition = showId } }; try { await _showDomain.CreateNewsObject(message, log); } catch (Exception ex) { log.LogInformation($"[Request Correlation ID: {message.Headers.RequestCorrelationId}] :: Creation of News Article {message.Body.Name} failed :: {ex.Message}"); return(new BadRequestObjectResult($"There was an error: {ex.Message}")); } log.LogInformation($"[Request Correlation ID: {message.Headers.RequestCorrelationId}] :: Creation of News Article {message.Body.Name} succeeded"); return(new OkResult()); } else { return(new UnauthorizedResult()); } }
protected void btn_save_Click(object sender, EventArgs e) { NewsObject newsObj = new NewsObject(); newsObj.NewsTitle = tbxNewsTitle.Text; newsObj.NewsLink = tbxNewsLink.Text; newsObj.UserId = Int32.Parse(Session["user_id"].ToString()); if (ddlNewsStatus.SelectedValue == "1") { newsObj.Status = true; } else if (ddlNewsStatus.SelectedValue == "0") { newsObj.Status = false; } try { int result = dal.InsertInformation(newsObj); if (result == 1) { LoadNews(); SuccessPanel.Visible = true; tbxNewsTitle.Text = ""; tbxNewsLink.Text = ""; } else { DangerPanel.Visible = true; tbxNewsTitle.Text = ""; tbxNewsLink.Text = ""; } } catch { throw; } }
protected void btn_update_Click(object sender, EventArgs e) { NewsObject newsObj = new NewsObject(); newsObj.NewsId = int.Parse(Session["News_id"].ToString()); DataTable dt = dal.SelectInformationById(newsObj.NewsId); newsObj.NewsTitle = tbxNewsTitle.Text; newsObj.NewsLink = tbxNewsLink.Text; newsObj.UserId = Int32.Parse(Session["user_id"].ToString()); if (ddlNewsStatus.SelectedValue == "1") { newsObj.Status = true; } else if (ddlNewsStatus.SelectedValue == "0") { newsObj.Status = false; } try { int result = dal.UpdateInformation(newsObj); if (result == 1) { SuccessPanel.Visible = true; } else { DangerPanel.Visible = true; } } catch { throw; } }
public async Task <bool> DeleteNewsAsync(NewsObject _object) { return(await _newsStore.DeleteAsync(_object)); }
public async Task CreateNewsAsync(MessageObject <NewsObject> _message) { NewsObject _object = _message.Body; await _newsStore.CreateAsync(_object); }
public static void MethodToPassObject(NewsObject myNewsObjectInput) { myResultNewsObject = myNewsObjectInput; }