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