public IEnumerable <post> WyswietlPosty()
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
return((from p in dp.posts where p.status == 1 && p.data_dodania.Month == DateTime.Now.Month orderby p.ID descending select p).ToList <post>());
}
}
public post WyswietlPostPoID(int id)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
return(dp.posts.Single(p => p.ID == id));
}
}
public List <post> WyswietlTytul(string slowo)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var PostyT = from p in dp.posts where p.tytul == slowo select p;
return(PostyT.ToList <post>());
}
}
public List <post> WyswietlPoTagach(string slowo)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var PostyPoSlowie = from p in dp.posts where p.tagi.keywords == slowo select p;
return(PostyPoSlowie.ToList <post>());
}
}
public List <post> WyswietlPoDacie(int id)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var PostyPoDacie = from p in dp.posts where p.data_dodania.Month == id select p;
return(PostyPoDacie.ToList <post>());
}
}
public void EdytujPost(post new_post)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var e = dp.posts.Single(x => x.ID == new_post.ID);
e.tytul = new_post.tytul;
e.tresc = new_post.tresc;
e.status = new_post.status;
e.data_modyfikacji = DateTime.Now;
dp.SubmitChanges();
}
}
public post EdytujPost(int id)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
try
{
return(dp.posts.Single(p => p.ID == id));
}
catch
{
return(null);
}
}
}
public void DodajPost(Klasa new_post)
{
using (LinqBlogDataContext dp = new LinqBlogDataContext())
{
var p = new post();
p.tytul = new_post.tytul;
p.tresc = new_post.tresc;
p.status = new_post.status;
p.data_dodania = DateTime.Now;
dp.posts.InsertOnSubmit(p);
dp.SubmitChanges();
var t = new tagi();
t.id_posta = p.ID;
t.keywords = new_post.keywords;
t.description = new_post.description;
dp.tagis.InsertOnSubmit(t);
dp.SubmitChanges();
}
}