// GET: Companies
public ActionResult Index(string sortColumn, string sortOrder, string nextpage, string currentFilter, string searchString, int?page)
{
ViewBag.CurrentSort = sortColumn;
ViewBag.SortOrder = sortOrder;
if (nextpage == null)
{
sortOrder = sortOrder == "asc" ? "desc" : "asc";
}
//ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
//ViewBag.AddressSortParm = String.IsNullOrEmpty(sortOrder) ? "address_desc" : "";
//ViewBag.ContactPSortParm = String.IsNullOrEmpty(sortOrder) ? "contactp_desc" : "";
//ViewBag.ContactNSortParm = String.IsNullOrEmpty(sortOrder) ? "contactn_desc" : "";
//ViewBag.ActiveSortParm = String.IsNullOrEmpty(sortOrder) ? "active_desc" : "";
//ViewBag.PrefixSortParm = String.IsNullOrEmpty(sortOrder) ? "prefix_desc" : "";
//Paging
//if (searchString != null)
//{
// page = 1;
//}
//else
//{
// searchString = currentFilter;
//}
ViewBag.CurrentFilter = searchString;
IQueryable <Company> companies = companyRepo.List();
//Search
if (!String.IsNullOrEmpty(searchString))
{
companies = companies.Where(s => s.Name.Contains(searchString) ||
s.Address.Contains(searchString) ||
s.ContactPerson.ToString().Contains(searchString) ||
s.ContactNo.Contains(searchString));
}
////Sorting the table for companies
//switch (sortOrder)
//{
// case "name_desc":
// companies = companies.OrderByDescending(c => c.Name);
// break;
// case "address_desc":
// companies = companies.OrderByDescending(c => c.Address);
// break;
// case "contactp_desc":
// companies = companies.OrderByDescending(c => c.ContactPerson);
// break;
// case "contactn_desc":
// companies = companies.OrderByDescending(c => c.ContactNo);
// break;
// case "active_desc":
// companies = companies.OrderByDescending(c => c.Active);
// break;
// case "prefix_desc":
// companies = companies.OrderByDescending(c => c.Prefix);
// break;
// default:
// companies = companies.OrderBy(c => c.Name);
// break;
//}
if (String.IsNullOrEmpty(sortColumn))
{
companies = companies.OrderByDescending(c => c.Id);
}
else
{
companies = companies.OrderBy(sortColumn + " " + sortOrder);
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return(View(companies.ToPagedList(pageNumber, pageSize)));
//return View(db.Companies.ToList());
}
public PartialViewResult MenuList()
{
List <Company> lstCompany = companyRepo.List().ToList();
return(PartialView(lstCompany));
}