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(); } }
public post WyswietlPostPoID(int id) { using(LinqBlogDataContext dp = new LinqBlogDataContext()) { return dp.posts.Single(p => p.ID == id); } }
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 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 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>(); } }