private static void SummarizePayment(Transaction ti, OrganizationMember om, StringBuilder sb)
{
if ((ti.Amt ?? 0) == 0 || om == null)
return;
var ts = om.TransactionSummary(DbUtil.Db);
if (ts != null)
sb.AppendFormat(@"
<tr><td colspan='2'>
<table cellpadding=4>
<tr>
<td>Registrant Fee</td>
<td>Amount Paid</td>
<td>Amount Due</td>
</tr>
<tr>
<td align='right'>{0}</td>
<td align='right'>{1}</td>
<td align='right'>{2}</td>
</tr>
</table>
</td></tr>
", ts.IndAmt.ToString2("c"),
om.TotalPaid(DbUtil.Db).ToString("c"),
om.AmountDue(DbUtil.Db).ToString("c"));
}
public static OrganizationMember AddOrgMember(CMSDataContext db, int organizationId, int peopleId, int memberTypeId, DateTime enrollmentDate, string name)
{
var om = new OrganizationMember
{
OrganizationId = organizationId,
PeopleId = peopleId,
MemberTypeId = memberTypeId,
EnrollmentDate = enrollmentDate,
CreatedDate = Util.Now,
SkipInsertTriggerProcessing = true
};
var et = new EnrollmentTransaction
{
OrganizationId = om.OrganizationId,
PeopleId = om.PeopleId,
MemberTypeId = om.MemberTypeId,
OrganizationName = name,
TransactionDate = enrollmentDate,
EnrollmentDate = enrollmentDate,
TransactionTypeId = 1,
// join
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
AttendancePercentage = om.AttendPct,
SkipInsertTriggerProcessing = true
};
db.OrganizationMembers.InsertOnSubmit(om);
db.EnrollmentTransactions.InsertOnSubmit(et);
db.SubmitChanges();
return om;
}
private void Populate()
{
var q = from mm in DbUtil.Db.OrganizationMembers
let ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == mm.PeopleId)
where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId
select new
{
mm.Person.Name,
mm.Organization.OrganizationName,
om = mm,
mt = mm.Organization.IsMissionTrip ?? false,
ts
};
var i = q.SingleOrDefault();
if (i == null)
return;
Name = i.Name;
OrgName = i.OrganizationName;
om = i.om;
isMissionTrip = i.mt;
TransactionSummary = i.ts;
Due = isMissionTrip
? MissionTripFundingModel.TotalDue(peopleId, orgId)
: i.ts != null ? i.ts.TotDue ?? 0 : 0;
}
public SummaryInfo(CMSDataContext db, OrganizationMember om)
{
this.om = om;
First = om.Person.PreferredName;
Last = om.Person.LastName;
Orgname = om.Organization.OrganizationName;
setting = new Settings(om.Organization.RegSetting, db, om.Organization.OrganizationId)
{
org = om.Organization
};
}
private void LogRegistrationOnOrgMember(Transaction transaction, OrganizationMember om, string paylink)
{
var reg = person.GetRecReg();
var sb = new StringBuilder();
sb.AppendFormat("{0:g} ----------------\n", DateTime.Now);
if (om.AmountPaid > 0)
{
var others = GetOthersInTransaction(transaction);
sb.AppendFormat("{0:c} ({1} id) transaction amount\n", transaction.Amt, transaction.Id);
sb.AppendFormat("{0:c} applied to this registrant\n", AmountToPay());
sb.AppendFormat("{0:c} total due all registrants\n", transaction.Amtdue);
if (others.HasValue())
sb.AppendFormat("Others: {0}\n", others);
}
om.AddToMemberDataBelowComments(sb.ToString());
var sbreg = new StringBuilder();
sbreg.Append($"{org.OrganizationName}\n");
sbreg.AppendFormat("{0:g} ----------------\n", DateTime.Now);
if (om.AmountPaid > 0)
{
sbreg.AppendFormat("{0:c} ({1} id) transaction amount\n", transaction.Amt, transaction.Id);
sbreg.AppendFormat("{0:c} applied to this registrant\n", AmountToPay());
sbreg.AppendFormat("{0:c} total due all registrants\n", transaction.Amtdue);
}
if (paylink.HasValue())
{
sbreg.AppendLine(paylink);
om.PayLink = paylink;
}
if (request.HasValue())
{
sbreg.AppendFormat("Request: {0}\n", request);
om.Request = request.Truncate(140);
}
sbreg.AppendFormat("{0}\n", EmailAddress);
reg.AddToComments(sbreg.ToString());
}
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);
}
private void attach_OrganizationMembers(OrganizationMember entity)
{
this.SendPropertyChanging();
entity.Person = this;
}
private string PrepareSummaryText2(OrganizationMember om)
{
const string razorTemplate = @"@model CmsData.API.APIOrganization.SummaryInfo
<table>
<tr><td>Org:</td><td>@Model.Orgname</td></tr>
<tr><td>First:</td><td>@Model.First</td></tr>
<tr><td>Last:</td><td>@Model.Last</td></tr>
@foreach(var ask in Model.List())
{
foreach(var row in ask.List())
{
<tr><td>@row.Label</td><td>@row.Description</td></tr>
}
}
</table>
";
return Razor.Parse(razorTemplate, new SummaryInfo(Db, om));
}
public void UpdateModel()
{
om = DbUtil.Db.OrganizationMembers.Single(mm => mm.OrganizationId == OrgId && mm.PeopleId == PeopleId);
this.CopyPropertiesTo(om);
DbUtil.Db.SubmitChanges();
Populate();
}
private void SaveAgeGroupChoice(OrganizationMember om)
{
if (setting.TargetExtraValues)
{
foreach (var ag in setting.AgeGroups)
person.RemoveExtraValue(DbUtil.Db, ag.SmallGroup);
if (setting.AgeGroups.Count > 0)
person.AddEditExtraValue(AgeGroup(), "true");
}
else
{
foreach (var ag in setting.AgeGroups)
om.RemoveFromGroup(DbUtil.Db, ag.SmallGroup);
if (setting.AgeGroups.Count > 0)
om.AddToGroup(DbUtil.Db, AgeGroup());
}
}
public static OrganizationMember InsertOrgMembers(CMSDataContext db, int organizationId, int peopleId, int memberTypeId, DateTime enrollmentDate, DateTime? inactiveDate, bool pending, string name, bool skipTriggerProcessing = false)
{
db.SubmitChanges();
var ntries = 2;
while (true)
{
try
{
var m = db.OrganizationMembers.SingleOrDefault(m2 => m2.PeopleId == peopleId && m2.OrganizationId == organizationId);
if (m != null)
{
m.Pending = pending;
m.MemberTypeId = memberTypeId;
db.SubmitChanges();
return m;
}
var om = new OrganizationMember
{
OrganizationId = organizationId,
PeopleId = peopleId,
MemberTypeId = memberTypeId,
EnrollmentDate = enrollmentDate,
InactiveDate = inactiveDate,
CreatedDate = Util.Now,
Pending = pending,
SkipInsertTriggerProcessing = skipTriggerProcessing
};
var et = new EnrollmentTransaction
{
OrganizationId = om.OrganizationId,
PeopleId = om.PeopleId,
MemberTypeId = om.MemberTypeId,
OrganizationName = name,
TransactionDate = enrollmentDate,
EnrollmentDate = enrollmentDate,
TransactionTypeId = 1,
// join
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
Pending = pending,
AttendancePercentage = om.AttendPct,
SkipInsertTriggerProcessing = skipTriggerProcessing
};
db.OrganizationMembers.InsertOnSubmit(om);
db.EnrollmentTransactions.InsertOnSubmit(et);
db.SubmitChanges();
return om;
}
catch (SqlException ex)
{
if (ex.Number == 1205)
if (--ntries > 0)
{
System.Threading.Thread.Sleep(500);
continue;
}
throw;
}
}
}
private void detach_OrganizationMembers(OrganizationMember entity)
{
this.SendPropertyChanging();
entity.MemberType = null;
}
private void SummarizeAnswers(StringBuilder sb, OrganizationMember om)
{
if (Parent.SupportMissionTrip)
return;
var rr = person.RecRegs.Single();
foreach (var ask in setting.AskItems)
{
switch (ask.Type)
{
case "AskTickets":
sb.AppendFormat("<tr><td>Tickets:</td><td>{0}</td></tr>\n", om.Tickets);
break;
case "AskSize":
sb.AppendFormat("<tr><td>Shirt:</td><td>{0}</td></tr>\n", om.ShirtSize);
break;
case "AskEmContact":
sb.AppendFormat("<tr><td>Emerg Contact:</td><td>{0}</td></tr>\n", rr.Emcontact);
sb.AppendFormat("<tr><td>Emerg Phone:</td><td>{0}</td></tr>\n", rr.Emphone);
break;
case "AskDoctor":
sb.AppendFormat("<tr><td>Physician Name:</td><td>{0}</td></tr>\n", rr.Doctor);
sb.AppendFormat("<tr><td>Physician Phone:</td><td>{0}</td></tr>\n", rr.Docphone);
break;
case "AskInsurance":
sb.AppendFormat("<tr><td>Insurance Carrier:</td><td>{0}</td></tr>\n", rr.Insurance);
sb.AppendFormat("<tr><td>Insurance Policy:</td><td>{0}</td></tr>\n", rr.Policy);
break;
case "AskRequest":
sb.AppendFormat("<tr><td>{1}:</td><td>{0}</td></tr>\n", om.Request, ((AskRequest) ask).Label);
break;
case "AskHeader":
sb.AppendFormat("<tr><td colspan='2'><h4>{0}</h4></td></tr>\n", ((AskHeader) ask).Label);
break;
case "AskInstruction":
break;
case "AskAllergies":
sb.AppendFormat("<tr><td>Medical:</td><td>{0}</td></tr>\n", rr.MedicalDescription);
break;
case "AskTylenolEtc":
sb.AppendFormat("<tr><td>Tylenol?: {0},", tylenol == true ? "Yes" : tylenol == false ? "No" : "");
sb.AppendFormat(" Advil?: {0},", advil == true ? "Yes" : advil == false ? "No" : "");
sb.AppendFormat(" Robitussin?: {0},", robitussin == true ? "Yes" : robitussin == false ? "No" : "");
sb.AppendFormat(" Maalox?: {0}</td></tr>\n", maalox == true ? "Yes" : maalox == false ? "No" : "");
break;
case "AskChurch":
sb.AppendFormat("<tr><td>Member:</td><td>{0}</td></tr>\n", rr.Member);
sb.AppendFormat("<tr><td>OtherChurch:</td><td>{0}</td></tr>\n", rr.ActiveInAnotherChurch);
break;
case "AskParents":
sb.AppendFormat("<tr><td>Mother's name:</td><td>{0}</td></tr>\n", rr.Mname);
sb.AppendFormat("<tr><td>Father's name:</td><td>{0}</td></tr>\n", rr.Fname);
break;
case "AskCoaching":
sb.AppendFormat("<tr><td>Coaching:</td><td>{0}</td></tr>\n", rr.Coaching);
break;
case "AskSMS":
sb.AppendFormat("<tr><td>Receive Texts:</td><td>{0}</td></tr>\n", person.ReceiveSMS);
break;
case "AskDropdown":
SummarizeDropdownChoice(sb, ask);
break;
case "AskMenu":
SummarizeMenuChoices(sb, ask);
break;
case "AskCheckboxes":
SummarizeCheckboxChoices(sb, ask);
break;
case "AskYesNoQuestions":
SummarizeYesNoChoices(sb, ask);
break;
case "AskExtraQuestions":
SummarizeExtraAnswers(sb, ask);
break;
case "AskText":
SummarieTextAnswers(sb, ask);
break;
case "AskGradeOptions":
SummarizeGradeOption(sb, ask);
break;
}
}
if (setting.AgeGroups.Count > 0)
sb.AppendFormat("<tr><td>AgeGroup:</td><td>{0}</td></tr>\n", AgeGroup());
}
public string SmallGroupChanged(int sgtagid, bool ck)
{
if (OrgMember == null)
OrgMember = DbUtil.Db.OrganizationMembers.Single(mm => mm.OrganizationId == OrgId && mm.PeopleId == PeopleId);
if (OrgMember == null)
return "error";
if (ck)
{
var name = (from mt in DbUtil.Db.MemberTags
where mt.Id == sgtagid
where mt.OrgId == OrgId
select mt.Name).Single();
OrgMember.OrgMemMemTags.Add(new OrgMemMemTag { MemberTagId = sgtagid });
DbUtil.LogActivity("OrgMem AddSubGroup " + name, OrgId, PeopleId);
}
else
{
var i = (from mt in OrgMember.OrgMemMemTags
where mt.MemberTagId == sgtagid
select new
{
mt,
name = mt.MemberTag.Name
}).SingleOrDefault();
if (i == null)
return "not found";
DbUtil.Db.OrgMemMemTags.DeleteOnSubmit(i.mt);
DbUtil.LogActivity("OrgMem RemoveSubGroup " + i.name, OrgId, PeopleId);
}
DbUtil.Db.SubmitChanges();
return "ok";
}
public void UpdateModel()
{
if (OrgMember == null)
OrgMember = DbUtil.Db.OrganizationMembers.Single(mm => mm.OrganizationId == OrgId && mm.PeopleId == PeopleId);
var changes = this.CopyPropertiesTo(OrgMember);
DbUtil.Db.SubmitChanges();
foreach (var g in changes)
DbUtil.LogActivity($"OrgMem {GroupName} change {g.Field}", OrgId, PeopleId);
Populate();
}
public void Drop()
{
if (OrgMember == null)
OrgMember = DbUtil.Db.OrganizationMembers.Single(mm => mm.OrganizationId == OrgId && mm.PeopleId == PeopleId);
if (DropDate.HasValue)
OrgMember.Drop(DbUtil.Db, DropDate.Value);
else
OrgMember.Drop(DbUtil.Db);
DbUtil.Db.SubmitChanges();
DbUtil.LogActivity("OrgMem Drop", OrgId, PeopleId);
if (RemoveFromEnrollmentHistory)
{
DbUtil.DbDispose();
DbUtil.Db = DbUtil.Create(Util.Host);
var q = DbUtil.Db.EnrollmentTransactions.Where(tt => tt.OrganizationId == OrgId && tt.PeopleId == PeopleId);
DbUtil.Db.EnrollmentTransactions.DeleteAllOnSubmit(q);
DbUtil.Db.SubmitChanges();
DbUtil.LogActivity("OrgMem RemoveEnrollmentHistory", OrgId, PeopleId);
}
}
private void attach_OrganizationMembers(OrganizationMember entity)
{
this.SendPropertyChanging();
entity.MemberType = this;
}
public void MoveToOrg(int pid, int fromOrg, int toOrg, bool?moveregdata = true, int toMemberTypeId = -1)
{
db.LogActivity($"PythonModel.MoveToOrg({pid},{fromOrg},{toOrg})");
using (var db2 = NewDataContext())
OrganizationMember.MoveToOrg(db2, pid, fromOrg, toOrg, moveregdata, toMemberTypeId);
}
private void Populate()
{
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.RegSetting,
mm.Organization,
mm.OrgMemMemTags,
mm.Organization.IsMissionTrip
}).SingleOrDefault();
if (i == null)
throw new Exception("missing OrgMember at oid={0}, pid={0}".Fmt(OrgId, PeopleId));
om = i.mm;
this.CopyPropertiesFrom(om);
Name = i.Name;
AmountPaidTransactions = om.TotalPaid(DbUtil.Db);
OrgName = i.OrganizationName;
Organization = i.Organization;
OrgMemMemTags = i.OrgMemMemTags.ToList();
IsMissionTrip = i.IsMissionTrip ?? false;
Setting = new Settings(i.RegSetting, DbUtil.Db, OrgId.Value);
}
public static OrganizationMember InsertOrgMembers(CMSDataContext Db,
int OrganizationId,
int PeopleId,
int MemberTypeId,
DateTime EnrollmentDate,
DateTime? InactiveDate, bool pending
)
{
Db.SubmitChanges();
int ntries = 2;
while (true)
{
try
{
var m = Db.OrganizationMembers.SingleOrDefault(m2 => m2.PeopleId == PeopleId && m2.OrganizationId == OrganizationId);
if (m != null)
{
m.MemberTypeId = MemberTypeId;
Db.SubmitChanges();
return m;
}
var org = Db.Organizations.SingleOrDefault(oo => oo.OrganizationId == OrganizationId);
if (org == null)
return null;
var name = org.OrganizationName;
var om = new OrganizationMember
{
OrganizationId = OrganizationId,
PeopleId = PeopleId,
MemberTypeId = MemberTypeId,
EnrollmentDate = EnrollmentDate,
InactiveDate = InactiveDate,
CreatedDate = Util.Now,
Pending = pending,
};
var et = new EnrollmentTransaction
{
OrganizationId = om.OrganizationId,
PeopleId = om.PeopleId,
MemberTypeId = om.MemberTypeId,
OrganizationName = name,
TransactionDate = EnrollmentDate,
EnrollmentDate = EnrollmentDate,
TransactionTypeId = 1,
// join
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
Pending = pending,
AttendancePercentage = om.AttendPct
};
Db.OrganizationMembers.InsertOnSubmit(om);
Db.EnrollmentTransactions.InsertOnSubmit(et);
Db.SubmitChanges();
return om;
}
catch (SqlException ex)
{
if (ex.Number == 1205)
if (--ntries > 0)
{
System.Threading.Thread.Sleep(500);
continue;
}
throw;
}
}
}
public void JoinOrg(int orgId, Person p)
{
OrganizationMember.InsertOrgMembers(db, orgId, p.PeopleId, 220, DateTime.Now, null, false);
}
public AskItem(Ask ask, OrganizationMember om)
{
this.ask = ask;
this.om = om;
}
private void SaveGradeChoice(OrganizationMember om)
{
if (setting.TargetExtraValues)
person.Grade = gradeoption.ToInt();
else
{
om.Grade = gradeoption.ToInt();
person.UpdateValue("Grade", gradeoption.ToInt());
Log("GradeUpdate " + person.Grade);
}
}
public static OrganizationMember InsertOrgMembers(CMSDataContext db, int organizationId, int peopleId, int memberTypeId, DateTime enrollmentDate, DateTime?inactiveDate, bool pending, string name, bool skipTriggerProcessing = false)
{
db.SubmitChanges();
var ntries = 2;
while (true)
{
try
{
var m = db.OrganizationMembers.SingleOrDefault(m2 => m2.PeopleId == peopleId && m2.OrganizationId == organizationId);
if (m != null)
{
m.Pending = pending;
if (m.MemberTypeId == MemberTypeCode.Member || m.MemberTypeId == 0 || m.MemberTypeId == MemberTypeCode.Prospect)
{
m.MemberTypeId = memberTypeId;
}
db.SubmitChanges();
return(m);
}
var om = new OrganizationMember
{
OrganizationId = organizationId,
PeopleId = peopleId,
MemberTypeId = memberTypeId,
EnrollmentDate = enrollmentDate,
InactiveDate = inactiveDate,
CreatedDate = Util.Now,
Pending = pending,
SkipInsertTriggerProcessing = skipTriggerProcessing
};
var et = new EnrollmentTransaction
{
OrganizationId = om.OrganizationId,
PeopleId = om.PeopleId,
MemberTypeId = om.MemberTypeId,
OrganizationName = name,
TransactionDate = enrollmentDate,
EnrollmentDate = enrollmentDate,
TransactionTypeId = 1,
// join
CreatedBy = db.UserId1,
CreatedDate = Util.Now,
Pending = pending,
AttendancePercentage = om.AttendPct,
SkipInsertTriggerProcessing = skipTriggerProcessing
};
db.OrganizationMembers.InsertOnSubmit(om);
db.EnrollmentTransactions.InsertOnSubmit(et);
db.SubmitChanges();
return(om);
}
catch (SqlException ex)
{
if (ex.Number == 1205)
{
if (--ntries > 0)
{
System.Threading.Thread.Sleep(500);
continue;
}
}
throw;
}
}
}
private void SaveMenuChoices(OrganizationMember om, Ask ask)
{
foreach (var i in MenuItem[ask.UniqueId])
om.AddToGroup(DbUtil.Db, i.Key, i.Value);
{
var menulabel = ((AskMenu) ask).Label;
foreach (var i in ((AskMenu) ask).MenuItemsChosen(MenuItem[ask.UniqueId]))
{
om.AddToMemberDataBelowComments(menulabel);
var desc = i.amt > 0
? $"{i.number} {i.desc} (at {i.amt:N2})"
: $"{i.number} {i.desc}";
om.AddToMemberDataBelowComments(desc);
menulabel = string.Empty;
}
}
}
public SummaryInfo(CMSDataContext db, OrganizationMember om)
{
this.om = om;
First = om.Person.PreferredName;
Last = om.Person.LastName;
Orgname = om.Organization.OrganizationName;
setting = new Settings(om.Organization.RegSetting, db, om.Organization.OrganizationId) { org = om.Organization };
}
private void SaveYesNoChoices(OrganizationMember om, Ask ask)
{
if (setting.TargetExtraValues == false)
{
foreach (var yn in ((AskYesNoQuestions) ask).list)
{
om.RemoveFromGroup(DbUtil.Db, "Yes:" + yn.SmallGroup);
om.RemoveFromGroup(DbUtil.Db, "No:" + yn.SmallGroup);
}
foreach (var g in YesNoQuestion)
om.AddToGroup(DbUtil.Db, (g.Value == true ? "Yes:" : "No:") + g.Key);
}
else
foreach (var g in YesNoQuestion)
person.AddEditExtraValue(g.Key, g.Value == true ? "Yes" : "No");
}
private void DoLinkGroupsFromOrgs(OrganizationMember om)
{
if (setting.LinkGroupsFromOrgs.Count > 0)
{
var q = from omt in DbUtil.Db.OrgMemMemTags
where setting.LinkGroupsFromOrgs.Contains(omt.OrgId)
where omt.PeopleId == om.PeopleId
select omt.MemberTag.Name;
foreach (var name in q)
om.AddToGroup(DbUtil.Db, name);
}
if (om.Organization.IsMissionTrip == true)
om.AddToGroup(DbUtil.Db, "Goer");
}
private OrganizationMember RecordAllFamilyAttends(OrganizationMember om)
{
om.AddToGroup(DbUtil.Db, "Attended");
om.AddToGroup(DbUtil.Db, "Registered");
foreach (var fm in FamilyAttend)
{
if (fm.PeopleId == -1)
continue;
Person pp = null;
OrganizationMember omm = null;
if (!fm.PeopleId.HasValue && fm.Attend)
{
if (!fm.Name.HasValue())
continue;
string first, last;
Util.NameSplit(fm.Name, out first, out last);
if (!first.HasValue())
{
first = last;
last = LastName;
}
var uperson = DbUtil.Db.LoadPersonById(PeopleId ?? 0);
var p = new OnlineRegPersonModel()
{
FirstName = first,
LastName = last,
DateOfBirth = fm.Birthday,
EmailAddress = fm.Email,
gender = fm.GenderId,
married = fm.MaritalId
};
p.AddPerson(uperson, org.EntryPointId ?? 0);
pp = p.person;
omm = OrganizationMember.InsertOrgMembers(DbUtil.Db, org.OrganizationId, pp.PeopleId,
MemberTypeCode.Member, DateTime.Now, null, false);
}
else
{
pp = DbUtil.Db.LoadPersonById(fm.PeopleId ?? 0);
if (fm.Attend)
omm = OrganizationMember.InsertOrgMembers(DbUtil.Db, org.OrganizationId, pp.PeopleId,
MemberTypeCode.Member, DateTime.Now, null, false);
else
{
omm = OrganizationMember.Load(DbUtil.Db, pp.PeopleId, org.OrganizationId);
omm?.RemoveFromGroup(DbUtil.Db, "Attended");
}
}
if (omm == null)
continue;
if (fm.Attend)
omm.AddToGroup(DbUtil.Db, "Attended");
if (!fm.PeopleId.HasValue)
omm.AddToGroup(DbUtil.Db, "Added");
}
return om;
}
private void SaveAnswers(OrganizationMember om)
{
om.OnlineRegData = Util.Serialize(this); // saves all answers
var reg = person.SetRecReg();
foreach (var ask in setting.AskItems)
switch (ask.Type)
{
case "AskSize":
om.ShirtSize = shirtsize;
reg.ShirtSize = shirtsize;
break;
case "AskChurch":
reg.ActiveInAnotherChurch = otherchurch;
reg.Member = memberus;
break;
case "AskAllergies":
reg.MedAllergy = medical.HasValue();
reg.MedicalDescription = medical;
break;
case "AskParents":
reg.Mname = mname;
reg.Fname = fname;
break;
case "AskEmContact":
reg.Emcontact = emcontact;
reg.Emphone = emphone;
break;
case "AskTylenolEtc":
reg.Tylenol = tylenol;
reg.Advil = advil;
reg.Robitussin = robitussin;
reg.Maalox = maalox;
break;
case "AskDoctor":
reg.Docphone = docphone;
reg.Doctor = doctor;
break;
case "AskCoaching":
reg.Coaching = coaching;
break;
case "AskSMS":
SaveSMSChoice();
break;
case "AskInsurance":
reg.Insurance = insurance;
reg.Policy = policy;
break;
case "AskTickets":
om.Tickets = ntickets;
break;
case "AskYesNoQuestions":
SaveYesNoChoices(om, ask);
break;
case "AskCheckboxes":
SaveCheckboxChoices(om, ask);
break;
case "AskExtraQuestions":
foreach (var g in ExtraQuestion[ask.UniqueId])
if (g.Value.HasValue())
if (setting.TargetExtraValues)
person.AddEditExtraData(g.Key, g.Value);
break;
case "AskText":
foreach (var g in Text[ask.UniqueId])
if (g.Value.HasValue())
if (setting.TargetExtraValues)
person.AddEditExtraData(g.Key, g.Value);
break;
case "AskMenu":
SaveMenuChoices(om, ask);
break;
case "AskDropdown":
SaveDropdownChoice(om, ask);
break;
case "AskGradeOptions":
SaveGradeChoice(om);
break;
}
}
private void detach_OrganizationMembers(OrganizationMember entity)
{
this.SendPropertyChanging();
entity.RegistrationDatum = null;
}
private void SaveDropdownChoice(OrganizationMember om, Ask ask)
{
if (setting.TargetExtraValues)
{
foreach (var op in ((AskDropdown) ask).list)
person.RemoveExtraValue(DbUtil.Db, op.SmallGroup);
person.AddEditExtraValue(((AskDropdown) ask).SmallGroupChoice(option).SmallGroup, "true");
}
else
{
foreach (var op in ((AskDropdown) ask).list)
op.RemoveFromSmallGroup(DbUtil.Db, om);
((AskDropdown) ask).SmallGroupChoice(option).AddToSmallGroup(DbUtil.Db, om, PythonModel);
}
}
public void AddToSmallGroup(CMSDataContext Db, OrganizationMember om, PythonModel pe)
{
if (om == null)
return;
if (pe != null)
pe.instance.AddToSmallGroup(SmallGroup, om);
om.AddToGroup(Db, SmallGroup);
if (MeetingTime.HasValue)
Attend.MarkRegistered(Db, om.OrganizationId, om.PeopleId, MeetingTime.Value, 1);
}
private void SaveCheckboxChoices(OrganizationMember om, Ask ask)
{
if (setting.TargetExtraValues)
{
foreach (var ck in ((AskCheckboxes) ask).list)
person.RemoveExtraValue(DbUtil.Db, ck.SmallGroup);
foreach (var g in ((AskCheckboxes) ask).CheckboxItemsChosen(Checkbox))
person.AddEditExtraBool(g.SmallGroup, true);
}
else
{
foreach (var ck in ((AskCheckboxes) ask).list)
ck.RemoveFromSmallGroup(DbUtil.Db, om);
foreach (var i in ((AskCheckboxes) ask).CheckboxItemsChosen(Checkbox))
i.AddToSmallGroup(DbUtil.Db, om, PythonModel);
}
}
public void RemoveFromSmallGroup(CMSDataContext Db, OrganizationMember om)
{
om.RemoveFromGroup(Db, SmallGroup);
}
private static OrganizationMember AddSender(OrganizationMember om)
{
if (!om.IsInGroup("Goer"))
om.MemberTypeId = MemberTypeCode.InActive;
om.AddToGroup(DbUtil.Db, "Sender");
return om;
}
private void detach_OrganizationMembers(OrganizationMember entity)
{
this.SendPropertyChanging();
entity.Transaction = null;
}
public void MoveToOrg(object pid, object fromOrg, object toOrg, bool?moveregdata = true, int toMemberTypeId = -1)
{
db.LogActivity($"PythonModel.MoveToOrg({pid},{fromOrg},{toOrg})");
using (var db2 = NewDataContext())
OrganizationMember.MoveToOrg(db2, CMSImageDataContext.Create(db2.Host), pid.ToInt(), fromOrg.ToInt(), toOrg.ToInt(), moveregdata, toMemberTypeId);
}
public static OrganizationMember InsertOrgMembers
(CMSDataContext Db,
int OrganizationId,
int PeopleId,
int MemberTypeId,
DateTime EnrollmentDate,
DateTime?InactiveDate, bool pending
)
{
Db.SubmitChanges();
int ntries = 2;
while (true)
{
try
{
var m = Db.OrganizationMembers.SingleOrDefault(m2 => m2.PeopleId == PeopleId && m2.OrganizationId == OrganizationId);
if (m != null)
{
return(m);
}
var org = Db.Organizations.SingleOrDefault(oo => oo.OrganizationId == OrganizationId);
if (org == null)
{
return(null);
}
var name = org.OrganizationName;
var om = new OrganizationMember
{
OrganizationId = OrganizationId,
PeopleId = PeopleId,
MemberTypeId = MemberTypeId,
EnrollmentDate = EnrollmentDate,
InactiveDate = InactiveDate,
CreatedDate = Util.Now,
Pending = pending,
};
var et = new EnrollmentTransaction
{
OrganizationId = om.OrganizationId,
PeopleId = om.PeopleId,
MemberTypeId = om.MemberTypeId,
OrganizationName = name,
TransactionDate = EnrollmentDate,
EnrollmentDate = EnrollmentDate,
TransactionTypeId = 1,
// join
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
Pending = pending,
AttendancePercentage = om.AttendPct
};
Db.OrganizationMembers.InsertOnSubmit(om);
Db.EnrollmentTransactions.InsertOnSubmit(et);
Db.SubmitChanges();
return(om);
}
catch (SqlException ex)
{
if (ex.Number == 1205)
{
if (--ntries > 0)
{
System.Threading.Thread.Sleep(500);
continue;
}
}
throw;
}
}
}
