public ActionResult Index()
{
IContractsRepository contractsRepository = new ContractsRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IAnnexContractsRepository annexContractsRepository = new AnnexContractsRepository(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"] : "ContractPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <ContractView> contracts = ContractView.GetContractsView(contractsRepository.GetValid(), annexContractsRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities())
.OrderBy(ordering);
//legalEntities ddl
ViewBag.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("Name ASC").ToList(), "LegalEntityPK", "Name", Request.QueryString["legalEntityFK"]);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
contracts = contracts.Where(c => c.Name.Contains(searchString));
}
if (!String.IsNullOrWhiteSpace(Request.QueryString["legalEntityFK"]))
{
int legalEntityFK = Convert.ToInt32(Request.QueryString["legalEntityFK"]);
contracts = contracts.Where(c => c.LegalEntityFK == legalEntityFK);
}
contracts = contracts.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = contractsRepository.GetValid().Where(c => c.Name.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = contractsRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("Contract?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", contracts.ToList()));
}
}
//[PITAuthorize(Roles = "add, edit, view, delete")]
public ActionResult LegalEntity(int?legalEntityFK, string ShowBasicInfo, string ShowLegalEntityHistory, string ShowLegalEntityLegalRepresentatives, string ShowLegalEntityLegalRepresentativesHistory, string ShowLegalEntityBanks, string ShowLegalEntityBanksHistory, string ShowContracts, string ShowBranches, string ShowBranchesHistory, string ShowLegalEntityOwners, string ShowLegalEntityOwnersHistory)
{
LegalEntityView legalEntityView = new LegalEntityView();
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityFK != null)
{
int legalEntityPK = (int)legalEntityFK;
if (ShowBasicInfo == "on" || ShowBasicInfo == "true")
{
legalEntityView = LegalEntityView.GetLegalEntityReport(db, legalEntityPK);
}
if (ShowLegalEntityLegalRepresentatives == "on" || ShowLegalEntityLegalRepresentatives == "true")
{
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(db);
ILegalEntityLegalRepresentativesRepository legalEntityLegalRepresentativesRepository = new LegalEntityLegalRepresentativesRepository(db);
IQueryable <LegalEntityLegalRepresentativeView> legalEntityLegalRepresentatives = LegalEntityLegalRepresentativeView.GetLegalEntityLegalRepresentativeView(legalEntityLegalRepresentativesRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities(), physicalEntitiesRepository.GetValid());
ViewBag.LegalEntityLegalRepresentatives = legalEntityLegalRepresentatives.Where(c => c.LegalEntityFK == legalEntityPK).ToList();
}
if (ShowLegalEntityBanks == "on" || ShowLegalEntityBanks == "true")
{
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
IBanksRepository banksRepository = new BanksRepository(db);
IQueryable <LegalEntityBankView> legalEntitiesBanks = LegalEntityBankView.GetLegalEntityBankView(legalEntitiesBanksRepository.GetValid(), banksRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities());
ViewBag.LegalEntityBanks = legalEntitiesBanks.Where(c => c.LegalEntityFK == legalEntityPK).ToList();
}
if (ShowContracts == "on" || ShowContracts == "true")
{
IContractsRepository contractsRepository = new ContractsRepository(db);
IAnnexContractsRepository annexContractsRepository = new AnnexContractsRepository(db);
IQueryable <ContractView> contracts = ContractView.GetContractsView(contractsRepository.GetValid(), annexContractsRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities());
ViewBag.Contracts = contracts.Where(c => c.LegalEntityFK == legalEntityPK).ToList();
}
if (ShowBranches == "on" || ShowBranches == "true")
{
ILegalEntityBranchesRepository legalEntityBranchesRepository = new LegalEntityBranchesRepository(db);
IQueryable <LegalEntityBranchView> legalEntityBranches = LegalEntityBranchView.GetLegalEntityBranchView(legalEntityBranchesRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities());
ViewBag.Branches = legalEntityBranches.Where(c => c.LegalEntityFK == legalEntityPK).ToList();
}
// history
if (ShowLegalEntityHistory == "on" || ShowLegalEntityHistory == "true")
{
List <LegalEntityAuditView> legalEntityHistory = LegalEntityAuditView.GetLegalEntityAuditView(db, legalEntityPK);
ViewBag.legalEntityHistory = legalEntityHistory.ToList();
}
if (ShowLegalEntityBanksHistory == "on" || ShowLegalEntityBanksHistory == "true")
{
List <List <LegalEntityBankAuditView> > legalEntityBanksHistory = LegalEntityBankAuditView.GetLegalEntityBanksAuditView(db, legalEntityPK);
List <DateTime> legalEntityBanksDatesHistory = new List <DateTime>();
foreach (List <LegalEntityBankAuditView> legalEntityBank in legalEntityBanksHistory)
{
foreach (LegalEntityBankAuditView legalEntityBankAuditView in legalEntityBank)
{
if (!legalEntityBanksDatesHistory.Contains(legalEntityBankAuditView.ChangeDate.Value))
{
legalEntityBanksDatesHistory.Add(legalEntityBankAuditView.ChangeDate.Value);
}
}
}
ViewBag.legalEntityBanksDatesHistory = legalEntityBanksDatesHistory.OrderBy(c => c.Date).ToList();
ViewBag.legalEntityBanksHistory = legalEntityBanksHistory;
}
if (ShowLegalEntityLegalRepresentativesHistory == "on" || ShowLegalEntityLegalRepresentativesHistory == "true")
{
List <List <LegalEntityLegalRepresentativeAuditView> > legalEntityLegalRepresentativesHistory = LegalEntityLegalRepresentativeAuditView.GetLegalEntityLegalRepresentativesAuditView(db, legalEntityPK);
ViewBag.legalEntityLegalRepresentativesHistory = legalEntityLegalRepresentativesHistory;
}
if (ShowLegalEntityOwnersHistory == "on" || ShowLegalEntityOwnersHistory == "true")
{
List <List <LegalEntityOwnerAuditView> > legalEntityOwnersHistory = LegalEntityOwnerAuditView.GetLegalEntityOwnersAuditView(db, legalEntityPK);
ViewBag.legalEntityOwnersHistory = legalEntityOwnersHistory;
}
if (ShowBranchesHistory == "on" || ShowBranchesHistory == "on")
{
List <List <LegalEntityBranchAuditView> > legalEntityBranchesHistory = LegalEntityBranchAuditView.GetLegalEntityBranchesAuditView(db, legalEntityPK);
ViewBag.legalEntityBranchesHistory = legalEntityBranchesHistory;
}
}
return(View(legalEntityView));
}