// GET: Communities/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Community community2 = db.Communities.Find(id);
if (community2 == null)
{
return(HttpNotFound());
}
CommunityTaskView result = new CommunityTaskView();
result.singleCommunity = community2;
result.communityTask = db.CommunityTasks.Where(i => i.CommunityId == id).ToList();
return(View(result));
//return View(community);
}
// GET: Communities
public ActionResult Index(int?id, string sortOrder, string currentFilter, string searchString, int?page)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.LocationSortParm = sortOrder == "Location" ? "location_desc" : "Location";
ViewBag.OfficerNameSortParm = sortOrder == "OfficerName" ? "officerName_desc" : "OfficerName";
ViewBag.EmailSortParm = sortOrder == "Email" ? "email_desc" : "Email";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var communities = db.Communities.Include(c => c.Location);
if (!String.IsNullOrEmpty(searchString))
{
communities = communities.Where(c => c.Name.ToUpper().Contains(searchString.ToUpper()) || c.Location.Name.ToUpper().Contains(searchString.ToUpper()) || c.OfficerName.ToUpper().Contains(searchString.ToUpper()) || c.Email.ToUpper().Contains(searchString.ToUpper()));
}
switch (sortOrder)
{
case "name_desc":
communities = communities.OrderByDescending(c => c.Name);
break;
case "Location":
communities = communities.OrderBy(c => c.Location.Name);
break;
case "location_desc":
communities = communities.OrderByDescending(c => c.Location.Name);
break;
case "OfficerName":
communities = communities.OrderBy(c => c.OfficerName);
break;
case "officerName_desc":
communities = communities.OrderByDescending(c => c.OfficerName);
break;
case "Email":
communities = communities.OrderBy(c => c.Email);
break;
case "email_desc":
communities = communities.OrderByDescending(c => c.Email);
break;
default:
communities = communities.OrderBy(c => c.Name);
break;
}
int pageSize = 3;
int pageNumber = (page ?? 1);
CommunityTaskView result = new CommunityTaskView();
result.communityTask = db.CommunityTasks.ToList();
if (id != null)
{
result.community = communities.Where(i => i.LocationId == id).ToList();
}
else
{
result.community = communities.ToList();
}
result.pagedCommunity = communities.ToPagedList(pageNumber, pageSize);
return(View(result));
//return View(communities.ToList());
}