public PartialViewResult _GetPartialViewPosts(PostFilterModel filter)
{
var postList = _postM.GetPostsByFilterModel(filter);
ViewBag.Filter = filter;
return(PartialView(postList));
}
public ActionResult Blog(string category_name, string search_key, string tag, string writer)
{
PostFilterModel filter = new PostFilterModel();
filter.CategoryName = category_name;
filter.SearchKey = search_key;
filter.TagName = tag;
filter.Writer = writer;
ViewBag.Filter = filter;
return(View());
}
public JsonResult GetInternships(PostFilterModel model)
{
try
{
int count = 0;
var result = CorporateBusiness.GetInternships(model, ref count);
var pages = CommonBusiness.GetPages(count);
var response = new ApiRespnoseWrapper {
status = ApiRespnoseStatus.Success, results = new ArrayList()
{
result, pages
}
};
return(new JsonResult {
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
catch (Exception ex)
{
return(CommonBusiness.GetErrorResponse(ex.Message));
}
}
public List <PostModel> GetPostsByFilterModel(PostFilterModel filter)
{
filter.CategoryName = GenerateUriFormat(filter.CategoryName);
List <PostModel> postList = new List <PostModel>();
postList = _postModelRepo.GetByCustomQuery(@"select TOP 20
u.FirstName + ' ' + u.LastName as [Writer],
c.Name as [Category],
us.*
from UserPosts us
inner join Categories c on c.ID = us.CategoryID
inner join Users u on u.ID = us.UserID
where us.IsPublish = 1 and us.IsActive = 1 and
(@CategoryName is null or c.Uri = @CategoryName)
and
(@Writer is null or u.Uri = @Writer)
and
(@SearchKey is null or us.Title like '%'+ @SearchKey +'%')
and
(@TagName is null or us.Tags like '%' +@TagName+ '%')" , filter).ToList();
return(postList);
}
