public ActionResult Index()
{
IAnnexContractsRepository annexContractsRepository = new AnnexContractsRepository(db);
IContractsRepository contractsRepository = new ContractsRepository(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"] : "AnnexContractPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <AnnexContractView> annexContracts = AnnexContractView.GetAnnexContractView(annexContractsRepository.GetValid(), contractsRepository.GetValid())
.OrderBy(ordering);
//contracts ddl
ViewBag.Contracts = new SelectList(contractsRepository.GetValid().OrderBy("Name ASC").ToList(), "ContractPK", "Name", Request.QueryString["contractFK"]);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
annexContracts = annexContracts.Where(c => c.Name.Contains(searchString) || c.Number.Contains(searchString));
}
if (!String.IsNullOrWhiteSpace(Request.QueryString["contractFK"]))
{
int contractFK = Convert.ToInt32(Request.QueryString["contractFK"]);
annexContracts = annexContracts.Where(c => c.ContractFK == contractFK);
}
annexContracts = annexContracts.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = annexContractsRepository.GetValid().Where(c => c.Name.Contains(searchString) || c.Number.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = annexContractsRepository.GetValid().Count();
}
ViewData["numberOfRecords"] = annexContractsRepository.GetValid().Count();
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("AnnexContract?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", annexContracts.ToList()));
}
}
public ActionResult Delete(int?annexContractPK)
{
IAnnexContractsRepository annexContractsRepository = new AnnexContractsRepository(db);
if (annexContractPK != null)
{
AnnexContract annexContract = annexContractsRepository.GetAnnexContractByPK((int)annexContractPK);
annexContract.Deleted = true;
annexContractsRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("DELETE", annexContract.AnnexContractPK);
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public ActionResult Edit(int?annexContractPK)
{
if (annexContractPK != null)
{
IAnnexContractsRepository annexContractsRepository = new AnnexContractsRepository(db);
AnnexContract annexContract = annexContractsRepository.GetAnnexContractByPK((int)annexContractPK);
AnnexContractView annexContractView = new AnnexContractView();
annexContractView.ConvertFrom(annexContract, annexContractView);
annexContractView.BindDDLs(annexContractView, db);
return(View(annexContractView));
}
else
{
return(RedirectToAction("Index", "AnnexContract"));
}
}
public ActionResult Edit(AnnexContractView annexContractView)
{
if (ModelState.IsValid)
{
IAnnexContractsRepository annexContractsRepository = new AnnexContractsRepository(db);
AnnexContract annexContract = annexContractsRepository.GetAnnexContractByPK((int)annexContractView.AnnexContractPK);
annexContractView.ConvertTo(annexContractView, annexContract);
annexContractsRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", annexContract.AnnexContractPK);
return(RedirectToAction("Index", "AnnexContract"));
}
else
{
annexContractView.BindDDLs(annexContractView, db);
return(View(annexContractView));
}
}
//[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));
}
