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 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);
}