public static List <LegalEntityLegalRepresentativeAuditView> GetLegalEntityLegalRepresentativeAuditView(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 == "LegalEntityLegalRepresentatives")
where am.RelatedEntityPK == relatedEntityPK
select new {
AuditingMasterPK = am.AuditingMasterPK,
RelatedEntityPK = am.RelatedEntityPK,
SessionToken = am.SessionToken
}).ToList();
List <LegalEntityLegalRepresentativeAuditView> legalEntityLegalRepresentativeAuditViewList = new List <LegalEntityLegalRepresentativeAuditView>();
foreach (var item in sessionTokens)
{
var record = auditingDetailsRepository.GetAuditingDetailByAuditingMasterPK(item.AuditingMasterPK).ToList();
LegalEntityLegalRepresentativeAuditView legalEntityLegalRepresentativeAuditView = new LegalEntityLegalRepresentativeAuditView();
legalEntityLegalRepresentativeAuditView.LegalEntityFK = record.checkInteger("LegalEntityFK");
legalEntityLegalRepresentativeAuditView.LegalRepresentativeFK = record.checkInteger("LegalRepresentativeFK");
legalEntityLegalRepresentativeAuditView.WayOfRepresentationFK = record.checkInteger("WayOfRepresentationFK");
legalEntityLegalRepresentativeAuditView.ChangeDate = record.checkDate("ChangeDate");
legalEntityLegalRepresentativeAuditView.Deleted = record.checkBoolean("Deleted");
legalEntityLegalRepresentativeAuditViewList.Add(legalEntityLegalRepresentativeAuditView);
}
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(context);
IQueryable <PhysicalEntity> physicalEntityTable = physicalEntitiesRepository.GetValid();
IWaysOfRepresentationRepository WaysOfRepresentationRepository = new WaysOfRepresentationRepository(context);
IQueryable <WayOfRepresentation> wayOfRepresentationTable = WaysOfRepresentationRepository.GetValid();
List <LegalEntityLegalRepresentativeAuditView> legalEntityLegalRepresentative =
(from t in legalEntityLegalRepresentativeAuditViewList
from t1 in physicalEntityTable.Where(tbl => tbl.PhysicalEntityPK == t.LegalRepresentativeFK).DefaultIfEmpty()
from t2 in wayOfRepresentationTable.Where(tbl => tbl.WayOfRepresentationPK == t.WayOfRepresentationFK).DefaultIfEmpty()
where t.ChangeDate != null
select new LegalEntityLegalRepresentativeAuditView
{
LegalEntityLegalRepresentativePK = t.LegalEntityLegalRepresentativePK,
LegalRepresentativeName = t1 != null && t1.Firstname != null && t1.Lastname != null ? t1.Firstname + " " + t1.Lastname : null,
WayOfRepresentationName = t2 != null && t2.Name != null ? t2.Name : null,
ChangeDate = t.ChangeDate != null ? t.ChangeDate : null,
Deleted = t.Deleted != null ? t.Deleted : null,
}).OrderBy(c => c.ChangeDate).ToList();
return(legalEntityLegalRepresentative);
}
public static List <List <LegalEntityLegalRepresentativeAuditView> > GetLegalEntityLegalRepresentativesAuditView(ObjectContext context, int legalEntityFK)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(context);
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(context);
ILegalEntityLegalRepresentativesRepository legalEntityLegalRepresentativesRepository = new LegalEntityLegalRepresentativesRepository(context);
// get all legalEntity branches
List <LegalEntityLegalRepresentativeView> legalEntityLegalRepresentatives = LegalEntityLegalRepresentativeView.GetLegalEntityLegalRepresentativeView(legalEntityLegalRepresentativesRepository.GetAll(), legalEntitiesRepository.GetValid(), physicalEntitiesRepository.GetValid())
.Where(c => c.LegalEntityFK == legalEntityFK)
.ToList();
List <List <LegalEntityLegalRepresentativeAuditView> > legalEntityLegalRepresentativesListList = new List <List <LegalEntityLegalRepresentativeAuditView> >();
foreach (LegalEntityLegalRepresentativeView legalEntityLegalRepresentative in legalEntityLegalRepresentatives)
{
legalEntityLegalRepresentativesListList.Add(LegalEntityLegalRepresentativeAuditView.GetLegalEntityLegalRepresentativeAuditView(context, legalEntityLegalRepresentative.LegalEntityLegalRepresentativePK));
}
return(legalEntityLegalRepresentativesListList);
}