public List <tblpostswithreply> Get(string searchpostby, string searchstring)
{
using (ivimessageboardEntities entities = new ivimessageboardEntities())
{
List <tblpostswithreply> searchposts = new List <tblpostswithreply>();
try
{
var allposts = (from item in entities.tblposts
join category in entities.tblcategories on item.postcategoryid equals category.CategoriesId into cats
from category in cats.DefaultIfEmpty()
orderby item.postdate descending
select new tblpostswithreply
{
idposts = item.idposts,
postdate = item.postdate,
postauthor = item.postauthor,
postcategory = category.CategoryName,
posttitle = item.posttitle,
postdescription = item.postdescription,
postreplies = item.postreplies
}).ToList();
if (searchpostby.ToLower() == "title")
{
searchposts = (from item in allposts.AsEnumerable()
where item.posttitle.ToLower().Contains(searchstring.ToLower())
select item).OrderByDescending(x => x.postdate).ToList();
}
else if (searchpostby.ToLower() == "author")
{
searchposts = (from item in allposts.AsEnumerable()
where item.postauthor.ToLower().Contains(searchstring.ToLower())
select item).OrderByDescending(x => x.postdate).ToList();
}
else if (searchpostby.ToLower() == "category")
{
searchposts = (from item in allposts.AsEnumerable()
where item.postcategory.ToLower().Contains(searchstring.ToLower())
select item).OrderByDescending(x => x.postdate).ToList();
}
else if (searchpostby.ToLower() == "description")
{
searchposts = (from item in allposts.AsEnumerable()
where item.postdescription.ToLower().Contains(searchstring.ToLower())
select item).OrderByDescending(x => x.postdate).ToList();
}
else if (searchpostby.ToLower() == "allposts")
{
searchposts = allposts;
}
return(searchposts);
}
catch (Exception ex)
{
//dbupdates.TapErrortoDB(entities, ex.ToString(), "PostsController", "GetAllPosts");
return(null);
}
}
}
public IEnumerable <tblcategory> GetAllCategories()
{
using (ivimessageboardEntities entities = new ivimessageboardEntities())
{
return(entities.tblcategories.ToList());
}
}
public IEnumerable <tblpostswithreply> GetAllPosts()
{
using (ivimessageboardEntities entities = new ivimessageboardEntities())
{
try
{
var allposts = from item in entities.tblposts
join category in entities.tblcategories on item.postcategoryid equals category.CategoriesId into cats
from category in cats.DefaultIfEmpty()
orderby item.postdate descending
select new tblpostswithreply
{
idposts = item.idposts,
postdate = item.postdate,
postauthor = item.postauthor,
postcategory = category.CategoryName,
posttitle = item.posttitle,
postdescription = item.postdescription,
postreplies = item.postreplies
};
return(allposts.ToList());
}
catch (Exception ex)
{
dbupdates.TapErrortoDB(entities, ex.ToString(), "PostsController", "GetAllPosts");
return(null);
}
}
}
public List <tblpostswithreply> Get(int postid)
{
using (ivimessageboardEntities entities = new ivimessageboardEntities())
{
try
{
var searchpostswithreplies = from item in entities.tblposts
join reply in entities.tblpostreplies on item.idposts equals reply.idreplyparent
join category in entities.tblcategories on item.postcategoryid equals category.CategoriesId into cats
from category in cats.DefaultIfEmpty()
where item.idposts == postid
select new tblpostswithreply
{
idposts = item.idposts,
posttitle = item.posttitle,
postcategory = category.CategoryName,
postdescription = item.postdescription,
postauthor = item.postauthor,
postdate = item.postdate,
postreplydescription = reply.postreplydescription,
postreplyauthor = reply.postreplyauthor,
postreplydate = reply.postreplydate
};
var listpostswithreplies = searchpostswithreplies.ToList();
if (listpostswithreplies.Count == 0)
{
var searchposts = from item in entities.tblposts
join category in entities.tblcategories on item.postcategoryid equals category.CategoriesId into cats
from category in cats.DefaultIfEmpty()
where item.idposts == postid
select new tblpostswithreply
{
idposts = item.idposts,
posttitle = item.posttitle,
postcategory = category.CategoryName,
postdescription = item.postdescription,
postauthor = item.postauthor,
postdate = item.postdate,
};
return(searchposts.ToList());
}
else
{
return(listpostswithreplies);
}
}
catch (Exception ex)
{
//dbupdates.TapErrortoDB(entities, ex.ToString(), "PostsController", "GetAllPosts");
return(null);
}
}
}
