public ActionResult Add(LegalEntityBankView legalEntityBankView)
{
if (ModelState.IsValid)
{
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
LegalEntityBank legalEntityBank = new LegalEntityBank();
legalEntityBankView.ConvertTo(legalEntityBankView, legalEntityBank);
legalEntitiesBanksRepository.Add(legalEntityBank);
legalEntitiesBanksRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("INSERT", legalEntityBank.LegalEntityBankPK);
if (TempData["legalEntityFK"] != null)
{
return(RedirectToAction("Index", "LegalEntity"));
}
else
{
return(RedirectToAction("Index", "LegalEntityBank"));
}
}
else
{
legalEntityBankView.BindDLLs(legalEntityBankView, db);
return(View(legalEntityBankView));
}
}
public ActionResult Index()
{
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
IBanksRepository banksRepository = new BanksRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntityBankView legalEntityBankView = new LegalEntityBankView();
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"] : "LegalEntityBankPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <LegalEntityBankView> legalEntitiesBanks = LegalEntityBankView.GetLegalEntityBankView(legalEntitiesBanksRepository.GetValid(), banksRepository.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();
legalEntitiesBanks = legalEntitiesBanks.Where(c => c.LegalEntityName.Contains(searchString) || c.BankName.Contains(searchString));
}
if (!String.IsNullOrWhiteSpace(Request.QueryString["legalEntityFK"]))
{
int legalEntityFK = Convert.ToInt32(Request.QueryString["legalEntityFK"]);
legalEntitiesBanks = legalEntitiesBanks.Where(c => c.LegalEntityFK == legalEntityFK);
}
legalEntitiesBanks = legalEntitiesBanks.Page(page, pageSize);
ViewData["numberOfRecords"] = legalEntitiesBanksRepository.GetValid().Count();
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("LegalEntityBank?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", legalEntitiesBanks.ToList()));
}
}
public ActionResult Add(int?legalEntityFK)
{
LegalEntityBankView legalEntityBankView = new LegalEntityBankView();
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityFK != null)
{
TempData["legalEntityFK"] = legalEntityFK;
legalEntityBankView.LegalEntityFK = (int)legalEntityFK;
legalEntityBankView.LegalEntityName = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityFK).Name;
}
legalEntityBankView.BindDLLs(legalEntityBankView, db);
return(View(legalEntityBankView));
}
public ActionResult Edit(int?legalEntityBankPK)
{
if (legalEntityBankPK != null)
{
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
LegalEntityBank legalEntityBank = legalEntitiesBanksRepository.GetLegalEntityBankByPK((int)legalEntityBankPK);
LegalEntityBankView legalEntityBankView = new LegalEntityBankView();
legalEntityBankView.ConvertFrom(legalEntityBank, legalEntityBankView, db);
legalEntityBankView.BindDLLs(legalEntityBankView, db);
return(View(legalEntityBankView));
}
else
{
return(RedirectToAction("Index", "LegalEntityBank"));
}
}
public static List <List <LegalEntityBankAuditView> > GetLegalEntityBanksAuditView(ObjectContext context, int legalEntityFK)
{
IBanksRepository banksRepository = new BanksRepository(context);
ILegalEntitiesRepository LegalEntitiesRepository = new LegalEntitiesRepository(context);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(context);
// get all legalEntity bank records
List <LegalEntityBankView> legalEntitiesBanks = LegalEntityBankView.GetLegalEntityBankView(legalEntitiesBanksRepository.GetAll(), banksRepository.GetValid(), LegalEntitiesRepository.GetValidLegalEntities())
.Where(c => c.LegalEntityFK == legalEntityFK)
.ToList();
List <List <LegalEntityBankAuditView> > LegalEntityBanksListList = new List <List <LegalEntityBankAuditView> >();
foreach (LegalEntityBankView legalEntityBank in legalEntitiesBanks)
{
LegalEntityBanksListList.Add(LegalEntityBankAuditView.GetLegalEntityBankAuditView(context, legalEntityBank.LegalEntityBankPK));
}
return(LegalEntityBanksListList);
}
public ActionResult Edit(LegalEntityBankView legalEntityBankView)
{
if (ModelState.IsValid)
{
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
LegalEntityBank legalEntityBank = legalEntitiesBanksRepository.GetLegalEntityBankByPK((int)legalEntityBankView.LegalEntityBankPK);
legalEntityBankView.ConvertTo(legalEntityBankView, legalEntityBank);
legalEntitiesBanksRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", legalEntityBank.LegalEntityBankPK);
return(RedirectToAction("Index", "LegalEntityBank"));
}
else
{
legalEntityBankView.BindDLLs(legalEntityBankView, db);
return(View(legalEntityBankView));
}
}
//[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));
}
