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