private void Populate()
{
if (dopopulate)
{
dopopulate = false;
if (!OrgId.HasValue || !PeopleId.HasValue)
{
return;
}
}
var i = (from mm in DbUtil.Db.OrganizationMembers
where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId
select new
{
mm,
mm.Person.Name,
mm.Organization.OrganizationName,
mm.Organization,
mm.OrgMemMemTags,
mm.Organization.IsMissionTrip,
ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == PeopleId && tt.OrganizationId == OrgId)
}).SingleOrDefault();
if (i == null)
{
throw new Exception($"missing OrgMember at oid={OrgId}, pid={PeopleId}");
}
om = i.mm;
TransactionSummary = i.ts;
this.CopyPropertiesFrom(om);
Name = i.Name;
IsMissionTrip = i.IsMissionTrip ?? false;
AmtFee = i.ts?.IndPaid + i.ts?.IndDue;
AmtDonation = i.ts?.IndAmt - AmtFee;
AmtPaid = om.AmountPaidTransactions(DbUtil.Db);
AmtDue = om.AmountDueTransactions(DbUtil.Db);
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.OrgMemMemTags.ToList();
Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0);
}
private void Populate()
{
if (dopopulate)
{
dopopulate = false;
if (!OrgId.HasValue || !PeopleId.HasValue)
return;
}
var i = (from mm in DbUtil.Db.OrganizationMembers
where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId
select new
{
mm,
mm.Person.Name,
mm.Organization.OrganizationName,
mm.Organization,
mm.OrgMemMemTags,
mm.Organization.IsMissionTrip,
ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == PeopleId && tt.OrganizationId == OrgId)
}).SingleOrDefault();
if (i == null)
throw new Exception($"missing OrgMember at oid={OrgId}, pid={PeopleId}");
OrgMember = i.mm;
TransactionSummary = i.ts;
this.CopyPropertiesFrom(OrgMember);
Name = i.Name;
IsMissionTrip = i.IsMissionTrip ?? false;
AmtFee = i.ts?.IndPaid + i.ts?.IndDue;
AmtDonation = i.ts?.IndAmt - AmtFee;
AmtCoupon = i.ts?.TotCoupon;
AmtPaid = OrgMember.AmountPaidTransactions(DbUtil.Db);
AmtDue = OrgMember.AmountDueTransactions(DbUtil.Db);
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.OrgMemMemTags.ToList();
Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0);
}
public TransactionSummary TransactionSummary(CMSDataContext db)
{
if (transactionSummaryLoaded)
return transactionSummary;
transactionSummary = db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == TranId && tt.PeopleId == PeopleId);
transactionSummaryLoaded = true;
return transactionSummary;
}
private void Populate()
{
if (dopopulate)
{
dopopulate = false;
if (!OrgId.HasValue || !PeopleId.HasValue)
return;
}
var i = (from et in DbUtil.Db.EnrollmentTransactions
where et.OrganizationId == OrgId && et.PeopleId == PeopleId
where et.TransactionTypeId == 5
orderby et.TransactionDate descending
select new
{
et,
et.Person.Name,
et.Organization.OrganizationName,
et.Organization,
et.SmallGroups,
ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(
ts => ts.RegId == et.TranId && ts.PeopleId == PeopleId && ts.OrganizationId == OrgId)
}
).FirstOrDefault();
if (i == null)
throw new Exception($"missing PrevOrgMember at oid={OrgId}, pid={PeopleId}");
PrevMember = i.et;
TransactionSummary = i.ts;
this.CopyPropertiesFrom(PrevMember);
Name = i.Name;
AmtFee = i.ts?.IndPaid + i.ts?.IndDue;
AmtDonation = i.ts?.IndAmt - AmtFee;
AmtCoupon = i.ts?.TotCoupon;
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.SmallGroups.SplitStr("\n").ToList();
Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0);
}
public TransactionSummary TransactionSummary()
{
if(transactionSummary == null)
transactionSummary = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == Transaction.OriginalId && tt.PeopleId == List[0].PeopleId);
return transactionSummary;
}
