protected async override void OnNavigatedTo(NavigationEventArgs e)
{
newsitem = e.Parameter as Newsitem;
titel.Text = newsitem.Titel;
beschrijving.Text = newsitem.Inhoud;
datum.Text = newsitem.Datum;
tijd.Text = newsitem.Uur;
List <Opleiding> opleidingen = await Api.GetAsync <List <Opleiding> >();
List <Campus> campussen = await Api.GetAsync <List <Campus> >();
foreach (Opleiding o in opleidingen)
{
if (o == newsitem.Opleiding)
{
opleiding.Text = o.Naam;
}
}
foreach (Campus c in campussen)
{
if (c == newsitem.Campus)
{
campus.Text = c.Naam;
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
newsitem = e.Parameter as Newsitem;
titel.Text = newsitem.Titel;
beschrijving.Text = newsitem.Inhoud;
Datum.Date = DateTime.Parse(newsitem.Datum);
Tijd.Time = TimeSpan.Parse(newsitem.Uur);
}
public async Task <IHttpActionResult> GetNewsitem(int id)
{
Newsitem newsitem = await db.Newsitems.FindAsync(id);
if (newsitem == null)
{
return(NotFound());
}
return(Ok(newsitem));
}
public async Task <IHttpActionResult> DeleteNewsitem(int id)
{
Newsitem newsitem = await db.Newsitems.FindAsync(id);
if (newsitem == null)
{
return(NotFound());
}
db.Newsitems.Remove(newsitem);
await db.SaveChangesAsync();
return(Ok(newsitem));
}
private async void Save_Click(object sender, RoutedEventArgs e)
{
Newsitem newsitem = new Newsitem();
newsitem.Datum = Datum.Date.ToString().Split(' ')[0];
newsitem.Inhoud = beschrijving.Text;
newsitem.Titel = titel.Text;
newsitem.Uur = Tijd.Time.ToString();
var campus = CampussenComboBox.SelectedValue as Campus;
var opleiding = OpleidingenComboBox.SelectedValue as Opleiding;
newsitem.Campus = campus is NullCampus ? null : campus;
newsitem.Opleiding = opleiding is NullOpleiding ? null : opleiding;
await Api.PostAsync <Newsitem>(newsitem);
Frame.GoBack();
}
public async Task <IHttpActionResult> PutNewsitem(int id, Newsitem newsitem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != newsitem.NewsitemId)
{
return(BadRequest());
}
db.Entry(newsitem).State = EntityState.Modified;
if (newsitem.Campus != null)
{
db.Entry(newsitem.Campus).State = EntityState.Unchanged;
}
if (newsitem.Opleiding != null)
{
db.Entry(newsitem.Opleiding).State = EntityState.Unchanged;
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NewsitemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> PostNewsitem(Newsitem newsitem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Newsitems.Add(newsitem);
if (newsitem.Campus != null)
{
db.Entry(newsitem.Campus).State = EntityState.Unchanged;
}
if (newsitem.Opleiding != null)
{
db.Entry(newsitem.Opleiding).State = EntityState.Unchanged;
}
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = newsitem.NewsitemId }, newsitem));
}
protected void Page_Load(object sender, EventArgs e)
{
Metotlar methods = new Metotlar();
veritabani vt = new veritabani();
#region The code-piece inserting the news to the database
string sqlQuery;
try
{
string rssUrl = "http://www.trthaber.com/sondakika.rss";
XmlDocument xmlVerisi = new XmlDocument();
for (int i = 0; i < 3; i++)
{
xmlVerisi.Load(rssUrl);
}
Newsitem News = new Newsitem();
for (int i = 0; i < 3; i++)
{
News.Title = xmlVerisi.SelectNodes("rss/channel/item/title")[i].InnerText;
News.Description = xmlVerisi.SelectNodes("rss/channel/item/description")[i].InnerText;
News.ImageURL = xmlVerisi.SelectNodes("rss/channel/item/imageUrl")[i].InnerText;
News.Link = xmlVerisi.SelectNodes("rss/channel/item/link")[i].InnerText;
News.Title = methods.TirnaklariKaldir(News.Title);
News.Description = methods.TirnaklariKaldir(News.Description);
News.Description = methods.BoslukKaldır(News.Description);
if (i == 0 && News.Title != null && News.Link != null && News.Description != null && News.ImageURL != null)
{
vt.Connection();
sqlQuery = "select * from haberler";
int count = vt.Command(sqlQuery);
if (count == -1)
{
vt.Connection();
vt.Command("DELETE FROM haberler");
for (int k = 0; k < 3; k++)
{
File.Delete(Server.MapPath("~/img/YeniHaber" + k.ToString() + ".jpg"));
}
}
}
WebClient webClient = new WebClient();
News.FotoYol = "/img/YeniHaber" + i.ToString() + ".jpg";
webClient.DownloadFile(News.ImageURL, Server.MapPath("~" + News.FotoYol));
sqlQuery = "INSERT INTO haberler (haber_baslik, haber_detay, haber_foto_link, haber_link, haber_foto_yol) VALUES('" + News.Title + "','" + News.Description + "','" + News.ImageURL + "','" + News.Link + "','" + News.FotoYol + "')";
vt.Connection();
vt.Command(sqlQuery);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
#endregion
#region The code-piece showing the news on the page
vt.Connection();
SqlDataReader dr = vt.GetDataReader("SELECT * FROM haberler");
int j = 0;
while (dr.Read())
{
if (j == 0)
{
NewsTitle1.Text = dr["haber_baslik"].ToString();
NewsDescription1.Text = dr["haber_detay"].ToString();
NewsImage1.ImageUrl = dr["haber_foto_yol"].ToString();
NewsLink1.NavigateUrl = dr["haber_link"].ToString();
}
else if (j == 1)
{
NewsTitle2.Text = dr["haber_baslik"].ToString();
NewsDescription2.Text = dr["haber_detay"].ToString();
NewsImage2.ImageUrl = dr["haber_foto_yol"].ToString();
NewsLink2.NavigateUrl = dr["haber_link"].ToString();
}
else
{
NewsTitle3.Text = dr["haber_baslik"].ToString();
NewsDescription3.Text = dr["haber_detay"].ToString();
NewsImage3.ImageUrl = dr["haber_foto_yol"].ToString();
NewsLink3.NavigateUrl = dr["haber_link"].ToString();
}
j++;
}
dr.Close();
#endregion
}
private void NewsItem_click(object sender, ItemClickEventArgs e)
{
Newsitem n = e.ClickedItem as Newsitem;
Frame.Navigate(typeof(NewsfeedDetail), n);
}
private void NewsItem_click(object sender, ItemClickEventArgs e)
{
Newsitem newsitem = e.ClickedItem as Newsitem;
Frame.Navigate(typeof(NewsitemBeheerUpdate), newsitem);
}
