public ActionResult GetComments(int id)
{
var repo = new Repository();
var comments = (from s in repo.GetComments()
select s);
//var comments = (from c in db.tblComments
// .Where(d => d.tblTipsId == id) // supervisor = 2 , coordinator = 5
// select c);
return PartialView("GetComments", comments);
}
public ViewResult Index(string sortOrder, string currentFilter, string searchString, int? page)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.TitleSortParm = String.IsNullOrEmpty(sortOrder) ? "title_desc" : "";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var repo = new Repository();
var tips = (from s in repo.GetTips()
select s);
//var tips = (from s in db.tblTips
// .Where(d => d.@group == 2) // supervisor = 2 , coordinator = 5
// select s);
//Show the query
//ViewBag.itemType = tips;
if (!String.IsNullOrEmpty(searchString))
{
tips = tips.Where(s => s.title.Contains(searchString)
|| s.body.Contains(searchString));
}
switch (sortOrder)
{
case "title_desc":
tips = tips.OrderByDescending(s => s.title);
break;
case "Date":
tips = tips.OrderBy(s => s.created);
break;
case "date_desc":
tips = tips.OrderByDescending(s => s.created);
break;
default: // Name ascending
tips = tips.OrderBy(s => s.updated);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
var x = tips.Count();
ViewBag.TotalCount = x.ToString();
//ViewBag.TotalItemCount = y.ToString();
return View(tips.ToPagedList(pageNumber, pageSize));
//return View(tips.ToPagedList(1, pageSize));
}
