public ActionResult Index()
{
IRisksRepository risksRepository = new RisksRepository(db);
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "RiskPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <Risk> risks = risksRepository.GetValid()
.OrderBy(ordering);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
risks = risks.Where(c => c.Name.Contains(searchString));
}
risks = risks.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = risksRepository.GetValid().Where(c => c.Name.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = risksRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("Risk?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", risks.ToList()));
}
}
public ActionResult Index()
{
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IRisksRepository risksRepository = new RisksRepository(db);
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "AssessmentPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <AssessmentsView> assessments = AssessmentsView.GetHomeView(assessmentsRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities(), risksRepository.GetValid())
.OrderBy(ordering);
//legalEntities ddl
ViewBag.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("Name ASC").ToList(), "LegalEntityPK", "Name", Request.QueryString["legalEntityFK"]);
if (!String.IsNullOrWhiteSpace(Request.QueryString["LegalEntityFK"]))
{
int legalEntityFK = Convert.ToInt32(Request.QueryString["LegalEntityFK"]);
assessments = assessments.Where(a => a.LegalEntityFK == legalEntityFK);
}
int assessmentCount = 0;
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
assessments = assessments.Where(c => c.AssessmentComment.Contains(searchString) || c.AssessmentDate.ToString().Contains(searchString) || c.LegalEntityName.Contains(searchString));
assessmentCount = assessments.Count();
}
assessments = assessments.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = assessmentCount;
}
else
{
ViewData["numberOfRecords"] = assessmentsRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("Assessment?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", assessments.ToList()));
}
}
