public void BindDLLs(LegalEntityBankView LegalEntityBankView, ObjectContext db)
{
//bank ddl
IBanksRepository banksRepository = new BanksRepository(db);
LegalEntityBankView.Banks = new SelectList(banksRepository.GetValid().OrderBy("Name ASC").ToList(), "BankPK", "Name");
}
public void AddBankAndBankAccounts()
{
var bankRep = new BanksRepository(_dbConn);
var bankAccRep = new BankAccountsRepository(_dbConn);
bankRep.AddNewBank(UserId, CompanyId);
bankAccRep.AddNewBankAccount(UserId);
}
public void DeleteBankAndBankAccounts(string email)
{
var bankRep = new BanksRepository(_dbConn);
var closingFile = new ClosingFilesRepository(_dbConn);
var bankAccRep = new BankAccountsRepository(_dbConn);
closingFile.DeleteClosingFiles(email, _configuration.GetSection("ClosingFileNumber").Value);
bankAccRep.DeleteNewBankAccount(UserId);
bankRep.DeleteNewBank(UserId);
}
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 static List <LegalEntityBankAuditView> GetLegalEntityBankAuditView(ObjectContext context, int relatedEntityPK)
{
IAuditingDetailsRepository auditingDetailsRepository = new AuditingDetailsRepository(context);
IAuditingMasterRepository auditingMasterRepository = new AuditingMasterRepository(context);
var sessionTokens = (from am in auditingMasterRepository.GetAll().Where(c => c.TableName == "LegalEntityBanks")
where am.RelatedEntityPK == relatedEntityPK
select new {
AuditingMasterPK = am.AuditingMasterPK,
RelatedEntityPK = am.RelatedEntityPK,
SessionToken = am.SessionToken
}).ToList();
List <LegalEntityBankAuditView> legalEntityBankAuditViewList = new List <LegalEntityBankAuditView>();
foreach (var item in sessionTokens)
{
var record = auditingDetailsRepository.GetAuditingDetailByAuditingMasterPK(item.AuditingMasterPK).ToList();
LegalEntityBankAuditView legalEntityBankAuditView = new LegalEntityBankAuditView();
legalEntityBankAuditView.BankFK = record.checkInteger("BankFK");
legalEntityBankAuditView.Iban = record.checkString("Iban");
legalEntityBankAuditView.ChangeDate = record.checkDate("ChangeDate");
legalEntityBankAuditView.Deleted = record.checkBoolean("Deleted");
legalEntityBankAuditViewList.Add(legalEntityBankAuditView);
}
IBanksRepository banksRepository = new BanksRepository(context);
IQueryable <Bank> banksTable = banksRepository.GetValid();
List <LegalEntityBankAuditView> legalEntityBanks =
(from t in legalEntityBankAuditViewList
from t1 in banksTable.Where(tbl => tbl.BankPK == t.BankFK).DefaultIfEmpty()
where t.ChangeDate != null
select new LegalEntityBankAuditView
{
LegalEntityBankPK = t.LegalEntityBankPK,
BankFK = t.BankFK,
BankIban = t.Iban,
BankName = t1 != null && t1.Name != null ? t1.Name : null,
ChangeDate = t.ChangeDate != null ? t.ChangeDate : null,
Deleted = t.Deleted != null ? t.Deleted : null,
}).OrderBy(c => c.ChangeDate).ToList();
return(legalEntityBanks);
}
public static IQueryable <LegalEntity> GetLegalEntitiesByBank(this IQueryable <LegalEntity> legalEntities, ObjectContext context, int?bankPK)
{
IBanksRepository banksRepository = new BanksRepository(context);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(context);
var banks = banksRepository.GetValid();
var legalEntitiesBanks = legalEntitiesBanksRepository.GetValid();
var legalEntitiesByBank = (from mn in legalEntitiesBanks
from b in banks.Where(b => b.BankPK == mn.BankFK).DefaultIfEmpty()
from c in legalEntities.Where(c => c.LegalEntityPK == mn.LegalEntityFK).DefaultIfEmpty()
where b.BankPK == bankPK
select c);
return(legalEntitiesByBank);
}
public ActionResult Edit(int?bankPK)
{
if (bankPK != null)
{
IBanksRepository banksRepository = new BanksRepository(db);
Bank bank = banksRepository.GetBankByPK((int)bankPK);
BankView bankView = new BankView();
bankView.ConvertFrom(bank, bankView);
return(View(bankView));
}
else
{
return(RedirectToAction("Index", "Bank"));
}
}
public ActionResult Delete(int?bankPK)
{
IBanksRepository banksRepository = new BanksRepository(db);
if (bankPK != null)
{
Bank bank = banksRepository.GetBankByPK((int)bankPK);
bank.Deleted = true;
banksRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("DELETE", bank.BankPK);
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public ActionResult Index()
{
IBanksRepository banksRepository = new BanksRepository(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"] : "BankPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <Bank> banks = banksRepository.GetValid()
.OrderBy(ordering);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
banks = banks.Where(c => c.Name.Contains(searchString) || c.AccountNumber.Contains(searchString) || c.Swift.Contains(searchString) || c.Oib.Contains(searchString) || c.Iban.Contains(searchString));
}
banks = banks.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = banksRepository.GetValid().Where(c => c.Name.Contains(searchString) || c.AccountNumber.Contains(searchString) || c.Swift.Contains(searchString) || c.Oib.Contains(searchString) || c.Iban.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = banksRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("Bank?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", banks.ToList()));
}
}
public ActionResult Edit(BankView bankModel)
{
if (ModelState.IsValid)
{
IBanksRepository banksRepository = new BanksRepository(db);
Bank bank = banksRepository.GetBankByPK((int)bankModel.BankPK);
bankModel.ConvertTo(bankModel, bank);
banksRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", bank.BankPK);
return(RedirectToAction("Index", "Bank"));
}
else
{
return(View(bankModel));
}
}
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 Add(BankView bankView)
{
if (ModelState.IsValid)
{
IBanksRepository banksRepository = new BanksRepository(db);
Bank bank = new Bank();
bankView.ConvertTo(bankView, bank);
banksRepository.Add(bank);
banksRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("INSERT", bank.BankPK);
return(RedirectToAction("Index", "Bank"));
}
else
{
return(View(bankView));
}
}
public BanksController()
{
IKernel kernel = new StandardKernel(new BankingModule());
this.Repository = kernel.Get <BanksRepository>();
}
public static IQueryable <LegalEntity> GetLegalEntitiesReport(ObjectContext db, string ordering, string Name, string OIB, string MB, string MBS, int?BankPK, int?TaxPK, int?FormPK, int?ActivityPK, int?numberOfEmployeesFrom, int?numberOfEmployeesTo)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IBanksRepository banksRepository = new BanksRepository(db);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
var banks = banksRepository.GetValid();
var legalEntitiesBanks = legalEntitiesBanksRepository.GetValid();
var allLegalEntities = legalEntitiesRepository.GetValid();
// Applying filters
IQueryable <LegalEntity> legalEntitiesFiltered = allLegalEntities; // default list
// Banks
if (BankPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByBank(db, BankPK);
}
// Tax payers
if (TaxPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByTax(TaxPK);
}
// Forms
if (FormPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByForm(FormPK);
}
// ACtivities
if (ActivityPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByActivity(ActivityPK);
}
// Name filter
if (!String.IsNullOrWhiteSpace(Name))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByName(Name);
}
// OIB filter
if (!String.IsNullOrWhiteSpace(OIB))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByOIB(OIB);
}
// MB filter
if (!String.IsNullOrWhiteSpace(MB))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMB(MB);
}
// MBS filter
if (!String.IsNullOrWhiteSpace(MBS))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMBS(MBS);
}
// numberOfEmployees
if (numberOfEmployeesFrom != null || numberOfEmployeesTo != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByEmployeesRange(numberOfEmployeesFrom, numberOfEmployeesTo);
}
return(legalEntitiesFiltered);
}
public static IQueryable <LegalEntityView> GetLegalEntitiesReport(ObjectContext db, string Name, string OIB, string MB, string MBS, int?BankPK, int?TaxPK, int?FormPK, int?ActivityPK, int?SubstationPK, int?CommercialCourtPK, int?numberOfEmployeesFrom, int?numberOfEmployeesTo, int?fundamentalCapitalFrom, int?fundamentalCapitalTo, bool?TouristOffice, bool?MonumentAnnuity)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IQueryable <LegalEntity> legalEntityTable = legalEntitiesRepository.GetValidLegalEntities();
IBanksRepository banksRepository = new BanksRepository(db);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
var banksTable = banksRepository.GetValid();
var legalEntitiesBanksTable = legalEntitiesBanksRepository.GetValid();
IQueryable <LegalEntity> legalEntitiesFiltered = legalEntitiesRepository.GetValid();
if (legalEntitiesFiltered.Count() > 0)
{
if (!string.IsNullOrWhiteSpace(Name))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByName(Name);
}
if (!string.IsNullOrWhiteSpace(OIB))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByOIB(OIB);
}
if (!string.IsNullOrWhiteSpace(MB))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMB(MB);
}
if (!string.IsNullOrWhiteSpace(MBS))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMBS(MBS);
}
if (numberOfEmployeesFrom != null || numberOfEmployeesTo != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByEmployeesRange(numberOfEmployeesFrom, numberOfEmployeesTo);
}
if (fundamentalCapitalFrom != null || fundamentalCapitalTo != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByFundamentalCapitalRange(fundamentalCapitalFrom, fundamentalCapitalTo);
}
if (BankPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByBank(db, BankPK);
}
if (TaxPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByTax(TaxPK);
}
if (SubstationPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesBySubstation(SubstationPK);
}
if (CommercialCourtPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByCommercialCourt(CommercialCourtPK);
}
if (FormPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByForm(FormPK);
}
if (ActivityPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByActivity(ActivityPK);
}
if (TouristOffice != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByTouristOffice(TouristOffice);
}
if (MonumentAnnuity != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMonumentAnnuity(MonumentAnnuity);
}
}
IQueryable <LegalEntityView> legalEntityViewList = (from t1 in legalEntitiesFiltered
from t2 in legalEntitiesBanksTable.Where(b => b.LegalEntityFK == t1.LegalEntityPK).DefaultIfEmpty()
from t3 in banksTable.Where(b => b.BankPK == t2.BankFK).DefaultIfEmpty()
select new LegalEntityView
{
LegalEntityPK = t1.LegalEntityPK,
Name = t1.Name,
ShortName = t1.ShortName != null ? t1.ShortName : "",
OIB = t1.OIB != null ? t1.OIB : "",
MB = t1.MB != null ? t1.MB : "",
MBS = t1.MBS != null ? t1.MBS : "",
FormName = t1.Form.Name != null ? t1.Form.Name : ""
}).Distinct().AsQueryable <LegalEntityView>();
return(legalEntityViewList);
}
public BanksService(BanksRepository repo)
{
_repo = repo;
}
public ActionResult LegalEntities(string Name, string OIB, string MB, string MBS, int?BankPK, int?TaxPK, int?FormPK, int?ActivityPK, int?SubstationPK, int?CommercialCourtPK, int?NumberOfEmployeesFrom, int?NumberOfEmployeesTo, int?FundamentalCapitalFrom, int?FundamentalCapitalTo, string TouristOffice, string MonumentAnnuity)
{
string sortOrder = !string.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !string.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "LegalEntityPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IBanksRepository banksRepository = new BanksRepository(db);
ITaxesRepository taxesRepository = new TaxesRepository(db);
IFormsRepository formsRepository = new FormsRepository(db);
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
ISubstationsRepository substationsRepository = new SubstationsRepository(db);
ICommercialCourtsRepository commercialCourtsRepository = new CommercialCourtsRepository(db);
// Binding DDL for report search
ViewBag.Banks = new SelectList(banksRepository.GetValid().OrderBy("Name ASC").ToList(), "BankPK", "Name", BankPK);
ViewBag.Taxes = new SelectList(taxesRepository.GetValid().OrderBy("Name ASC").ToList(), "TaxPK", "Name", TaxPK);
ViewBag.Forms = new SelectList(formsRepository.GetValid().OrderBy("Name ASC").ToList(), "FormPK", "Name", FormPK);
ViewBag.Activities = new SelectList(activitiesRepository.GetValid().OrderBy("Name ASC").ToList(), "ActivityPK", "Name", ActivityPK);
ViewBag.Substations = new SelectList(substationsRepository.GetValid().OrderBy("Name ASC").ToList(), "SubstationPK", "Name", SubstationPK);
ViewBag.CommercialCourts = new SelectList(commercialCourtsRepository.GetValid().OrderBy("Name ASC").ToList(), "CommercialCourtPK", "Name", CommercialCourtPK);
if (BankPK != null)
{
ViewBag.Bank = banksRepository.GetBankByPK((int)BankPK).Name;
}
if (TaxPK != null)
{
ViewBag.Tax = taxesRepository.GetTaxByPK((int)TaxPK).Name;
}
if (SubstationPK != null)
{
ViewBag.Substation = substationsRepository.GetSubstationByPK((int)SubstationPK).Name;
}
if (CommercialCourtPK != null)
{
ViewBag.CommercialCourt = commercialCourtsRepository.GetCommercialCourtByPK((int)CommercialCourtPK).Name;
}
if (FormPK != null)
{
ViewBag.Form = formsRepository.GetFormByPK((int)FormPK).Name;
}
if (ActivityPK != null)
{
ViewBag.Activity = activitiesRepository.GetActivityByPK((int)ActivityPK).Name;
}
bool?TouristOfficeFlag = null;
bool?MonumentAnnuityFlag = null;
if (TouristOffice == "on")
{
TouristOfficeFlag = true;
}
if (MonumentAnnuity == "on")
{
MonumentAnnuityFlag = true;
}
// Applying filters
IQueryable <LegalEntityView> legalEntities = LegalEntityView.GetLegalEntitiesReport(db, Name, OIB, MB, MBS, BankPK, TaxPK, FormPK, ActivityPK, SubstationPK, CommercialCourtPK, NumberOfEmployeesFrom, NumberOfEmployeesTo, FundamentalCapitalFrom, FundamentalCapitalTo, TouristOfficeFlag, MonumentAnnuityFlag)
.OrderBy(ordering);
// Excluding temporary deleted items from view
legalEntitiesPKsToExclude = new List <int>();
// Empty session on first request
if (Request.QueryString.Count == 0)
{
Session["legalEntitiesPKsToExclude"] = null;
}
if (Session["legalEntitiesPKsToExclude"] != null)
{
legalEntitiesPKsToExclude = (List <int>)Session["legalEntitiesPKsToExclude"];
legalEntities = legalEntities.Where(c => !legalEntitiesPKsToExclude.Contains(c.LegalEntityPK));
}
return(View("LegalEntities", legalEntities.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));
}
public ActionResult Index()
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IContractsRepository contractsRepository = new ContractsRepository(db);
ILegalEntityBranchesRepository legalEntityBranchesRepository = new LegalEntityBranchesRepository(db);
IBanksRepository banksRepository = new BanksRepository(db);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
ILegalEntityLegalRepresentativesRepository legalEntityLegalRepresentativesRepository = new LegalEntityLegalRepresentativesRepository(db);
ILegalEntityOwnersRepository legalEntityOwnersRepository = new LegalEntityOwnersRepository(db);
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(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"] : "LegalEntityPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <LegalEntityView> legalEntities = LegalEntityView.GetLegalEntityView(legalEntitiesRepository.GetValid(),
legalEntityBranchesRepository.GetValid(),
contractsRepository.GetValid(),
banksRepository.GetValid(),
legalEntitiesBanksRepository.GetValid(),
legalEntityLegalRepresentativesRepository.GetValid(),
legalEntityOwnersRepository.GetValid(),
assessmentsRepository.GetValid())
.OrderBy(ordering);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"];
legalEntities = legalEntities.Where(c => c.Name.Contains(searchString));
}
if (!String.IsNullOrWhiteSpace(Request.QueryString["company"]) && Request.QueryString["company"].Contains("true"))
{
legalEntities = legalEntities.Where(c => c.Company == true);
}
if (String.IsNullOrWhiteSpace(Request.QueryString["active"]))
{
legalEntities = legalEntities.Where(c => c.Active == true);
}
else
{
var active = Request.QueryString["active"].Contains("true");
legalEntities = legalEntities.Where(c => c.Active == active);
}
ViewData["numberOfRecords"] = legalEntities.Count();
legalEntities = legalEntities.Page(page, pageSize);
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("LegalEntity?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", legalEntities.ToList()));
}
}
