public ArchiveBloggViewModel GetAllCategories() { var model = new ArchiveBloggViewModel(); using (BloggContext db = new BloggContext()) { model.BloggCategories = db.BloggCategories.ToList(); } return(model); }
public BloggInfo GetBloggDetails(int id) { var blogg = new BloggInfo(); using (BloggContext db = new BloggContext()) { blogg = db.BloggInfo.FirstOrDefault(r => r.Id == id); } return(blogg); }
public ArchiveBloggViewModel GetBloggDetails(int id) { var model = new ArchiveBloggViewModel(); using (BloggContext db = new BloggContext()) { model.BloggInfo = db.BloggInfo.First(r => r.Id == id); model.BloggCategories = db.BloggCategories.ToList(); } return(model); }
public ArchiveBloggViewModel GetAll() { var model = new ArchiveBloggViewModel(); using (BloggContext db = new BloggContext()) { model.BloggCategory.BloggInfo = db.BloggInfo.OrderByDescending(r => r.Date).ToList(); model.BloggCategories = db.BloggCategories.ToList(); } return(model); }
public ArchiveBloggViewModel BloggsByCategory(ArchiveBloggViewModel model) { var list = new List <BloggInfo>(); using (BloggContext db = new BloggContext()) { model.BloggCategory.BloggInfo = db.BloggInfo.Where(r => r.CategoryId == model.BloggInfo.CategoryId) .OrderByDescending(r => r.Date).ToList() .ToList(); model.BloggCategories = db.BloggCategories.ToList(); } return(model); }
public ArchiveBloggViewModel BloggsBySearchWord(ArchiveBloggViewModel model) { var list = new List <BloggInfo>(); using (BloggContext db = new BloggContext()) { model.BloggCategory.BloggInfo = db.BloggInfo.Where(r => r.Heading.StartsWith(model.BloggInfo.Heading)) .OrderByDescending(r => r.Date).ToList().ToList(); model.BloggCategories = db.BloggCategories.ToList(); } return(model); }
public void CreateNewBlogg(BloggInfo model) { using (BloggContext db = new BloggContext()) { var blogg = new BloggInfo() { CategoryId = model.CategoryId, Date = DateTime.Now, BloggInput = model.BloggInput, Heading = model.Heading }; db.BloggInfo.Add(blogg); db.SaveChanges(); } }