private ActionResult ErrorResult(OnlineRegModel m, Exception ex, string errorDisplay)
{
var d = new ExtraDatum {
Stamp = Util.Now
};
d.Data = Util.Serialize <OnlineRegModel>(m);
DbUtil.Db.ExtraDatas.InsertOnSubmit(d);
DbUtil.Db.SubmitChanges();
var ex2 = new Exception("{0}, {2}".Fmt(errorDisplay, d.Id, Util.ServerLink("/OnlineReg/RegPeople/") + d.Id), ex);
ErrorSignal.FromCurrentContext().Raise(ex2);
TempData["error"] = errorDisplay;
return(Content("/Error/"));
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
var cols = csv.GetFieldHeaders();
var now = DateTime.Now;
var bh = BatchImportContributions.GetBundleHeader(date, now);
while (csv.ReadNextRecord())
{
string ac = null, oth = null, first = null, last = null, addr = null, name = null, email = null;
var dt = date;
for (var c = 1; c < csv.FieldCount; c++)
{
var col = cols[c].Trim();
switch (col)
{
case "Date Entered":
dt = csv[c].ToDate() ?? date;
break;
case "ProfileID":
ac = csv[c];
break;
case "First Name":
first = csv[c];
break;
case "Last Name":
last = csv[c];
break;
case "Full Name":
name = csv[c];
break;
case "Address":
addr = csv[c];
break;
case "Email Address":
email = csv[c];
break;
case "Designation for "Other"":
oth = csv[c];
break;
}
}
if (ac.ToInt() == 0)
{
ac = email;
}
var eac = Util.Encrypt(ac);
var q = from kc in DbUtil.Db.CardIdentifiers
where kc.Id == eac
select kc.PeopleId;
var pid = q.SingleOrDefault();
string bankac = null;
ExtraDatum ed = null;
if (pid == null)
{
bankac = eac;
string person;
if (last.HasValue())
{
person = $"{last}, {first}; {addr}";
}
else
{
person = $"{name}; {addr}";
}
ed = new ExtraDatum {
Data = person, Stamp = Util.Now
};
}
BundleDetail bd = null;
var defaultfundid = DbUtil.Db.Setting("DefaultFundId", "1").ToInt();
for (var c = 0; c < csv.FieldCount; c++)
{
var col = cols[c].Trim();
if (col != "Amount" && !col.Contains("Comment") && csv[c].StartsWith("$") && csv[c].GetAmount() > 0)
{
var fid = FindFund(col);
bd = CreateContribution(date, fid ?? defaultfundid);
bd.Contribution.ContributionAmount = csv[c].GetAmount();
if (col == "Other")
{
col = oth;
}
if (!fundid.HasValue)
{
bd.Contribution.ContributionDesc = col;
}
if (ac.HasValue())
{
bd.Contribution.BankAccount = bankac;
}
bd.Contribution.PeopleId = pid;
bh.BundleDetails.Add(bd);
if (ed != null)
{
bd.Contribution.ExtraDatum = ed;
}
}
}
}
FinishBundle(bh);
return(bh.BundleHeaderId);
}
public ActionResult CompleteRegistration(OnlineRegModel m)
{
if (m.AskDonation() && !m.donor.HasValue && m.donation > 0)
{
SetHeaders(m);
ModelState.AddModelError("donation",
"Please indicate a donor or clear the donation amount");
return(View("AskDonation", m));
}
if (m.List.Count == 0)
{
return(Content("Can't find any registrants"));
}
RemmoveLastRegistrantIfEmpty(m);
var d = new ExtraDatum {
Stamp = Util.Now
};
d.Data = Util.Serialize <OnlineRegModel>(m);
DbUtil.Db.ExtraDatas.InsertOnSubmit(d);
DbUtil.Db.SubmitChanges();
DbUtil.LogActivity("Online Registration: {0} ({1})".Fmt(m.Header, d.Id));
if (m.PayAmount() == 0 && (m.donation ?? 0) == 0 && !m.Terms.HasValue())
{
return(RedirectToAction("Confirm",
new
{
id = d.Id,
TransactionID = "zero due",
}));
}
var terms = Util.PickFirst(m.Terms, "");
if (terms.HasValue())
{
ViewData["Terms"] = terms;
}
SetHeaders(m);
if (m.PayAmount() == 0 && m.Terms.HasValue())
{
return(View("Terms", new PaymentModel
{
Terms = m.Terms,
_URL = m.URL,
_timeout = INT_timeout,
PostbackURL = Util.ServerLink("/OnlineReg/Confirm/" + d.Id),
}));
}
ViewBag.timeout = INT_timeout;
ViewBag.Url = m.URL;
var om =
DbUtil.Db.OrganizationMembers.SingleOrDefault(
mm => mm.OrganizationId == m.orgid && mm.PeopleId == m.List[0].PeopleId);
m.ParseSettings();
if (om != null && m.settings[m.orgid.Value].AllowReRegister == false)
{
return(Content("You are already registered it appears"));
}
var pf = PaymentForm.CreatePaymentForm(m);
pf.DatumId = d.Id;
pf.FormId = Guid.NewGuid();
if (OnlineRegModel.GetTransactionGateway() == "serviceu")
{
return(View("Payment", pf));
}
return(View("ProcessPayment", pf));
}
public ActionResult ApplyCoupon(PaymentForm pf)
{
OnlineRegModel m = null;
ExtraDatum ed = null;
if (pf.PayBalance == false)
{
ed = DbUtil.Db.ExtraDatas.SingleOrDefault(e => e.Id == pf.DatumId);
m = Util.DeSerialize <OnlineRegModel>(ed.Data);
m.ParseSettings();
}
if (!pf.Coupon.HasValue())
{
return(Json(new { error = "empty coupon" }));
}
string coupon = pf.Coupon.ToUpper().Replace(" ", "");
string admincoupon = DbUtil.Db.Setting("AdminCoupon", "ifj4ijweoij").ToUpper().Replace(" ", "");
if (coupon == admincoupon)
{
return(Json(new { confirm = "/onlinereg/Confirm/{0}?TransactionID=Coupon(Admin)".Fmt(pf.DatumId) }));
}
var c = DbUtil.Db.Coupons.SingleOrDefault(cp => cp.Id == coupon);
if (c == null)
{
return(Json(new { error = "coupon not found" }));
}
if (pf.OrgId.HasValue && c.Organization != null && c.Organization.OrgPickList.HasValue())
{
var a = c.Organization.OrgPickList.SplitStr(",").Select(ss => ss.ToInt()).ToArray();
if (!a.Contains(pf.OrgId.Value))
{
return(Json(new { error = "coupon and org do not match" }));
}
}
else if (pf.OrgId != c.OrgId)
{
return(Json(new { error = "coupon and org do not match" }));
}
if (c.Used.HasValue && c.Id.Length == 12)
{
return(Json(new { error = "coupon already used" }));
}
if (c.Canceled.HasValue)
{
return(Json(new { error = "coupon canceled" }));
}
var ti = pf.CreateTransaction(DbUtil.Db, c.Amount);
if (m != null) // Start this transaction in the chain
{
m.TranId = ti.OriginalId;
ed.Data = Util.Serialize <OnlineRegModel>(m);
}
var tid = "Coupon({0:n2})".Fmt(Util.fmtcoupon(coupon));
if (!pf.PayBalance)
{
ConfirmDuePaidTransaction(ti, tid, sendmail: false);
}
var msg = "<i class='red'>Your coupon for {0:n2} has been applied, your balance is now {1:n2}</i>."
.Fmt(c.Amount, ti.Amtdue);
if (ti.Amt < pf.AmtToPay)
{
msg += "You still must complete this transaction with a payment";
}
if (m != null)
{
m.UseCoupon(ti.TransactionId, ti.Amt ?? 0);
}
else
{
c.UseCoupon(ti.FirstTransactionPeopleId(), ti.Amt ?? 0);
}
DbUtil.Db.SubmitChanges();
if (pf.PayBalance)
{
return(Json(new { confirm = "/onlinereg/ConfirmDuePaid/{0}?TransactionID=Coupon({1})&Amount={2}".Fmt(ti.Id, Util.fmtcoupon(coupon), ti.Amt) }));
}
pf.AmtToPay -= ti.Amt;
if (pf.AmtToPay <= 0)
{
return(Json(new { confirm = "/OnlineReg/Confirm/{0}?TransactionId={1}".Fmt(pf.DatumId, "Coupon") }));
}
return(Json(new { tiamt = pf.AmtToPay, amtdue = ti.Amtdue, amt = pf.AmtToPay.ToString2("N2"), msg }));
}
private string ConfirmTransaction(OnlineRegModel m, string TransactionID, ExtraDatum ed = null)
{
m.ParseSettings();
if (m.List.Count == 0)
{
return("error: unexpected, no registrants found in confirmation");
}
string confirm = "Confirm";
var managingsubs = m.ManagingSubscriptions();
var choosingslots = m.ChoosingSlots();
var t = m.Transaction;
if (t == null && !managingsubs && !choosingslots)
{
var pf = PaymentForm.CreatePaymentForm(m);
if (ed != null)
{
pf.DatumId = ed.Id;
}
t = pf.CreateTransaction(DbUtil.Db);
m.TranId = t.Id;
if (ed != null)
{
ed.Data = Util.Serialize <OnlineRegModel>(m);
DbUtil.Db.SubmitChanges();
}
}
if (t != null)
{
ViewData["message"] = t.Message;
}
if (m.org != null && m.org.RegistrationTypeId == RegistrationTypeCode.CreateAccount)
{
m.List[0].CreateAccount();
ViewData["CreatedAccount"] = true;
confirm = "ConfirmAccount";
}
else if (m.OnlineGiving())
{
var p = m.List[0];
if (p.IsNew)
{
p.AddPerson(null, p.org.EntryPointId ?? 0);
}
var staff = DbUtil.Db.StaffPeopleForOrg(p.org.OrganizationId)[0];
var text = p.setting.Body.Replace("{church}", DbUtil.Db.Setting("NameOfChurch", "church"), ignoreCase: true);
text = text.Replace("{amt}", (t.Amt ?? 0).ToString("N2"));
text = text.Replace("{date}", DateTime.Today.ToShortDateString());
text = text.Replace("{tranid}", t.Id.ToString());
text = text.Replace("{name}", p.person.Name);
text = text.Replace("{account}", "");
text = text.Replace("{email}", p.person.EmailAddress);
text = text.Replace("{phone}", p.person.HomePhone.FmtFone());
text = text.Replace("{contact}", staff.Name);
text = text.Replace("{contactemail}", staff.EmailAddress);
text = text.Replace("{contactphone}", p.org.PhoneNumber.FmtFone());
var re = new Regex(@"(?<b>.*?)<!--ITEM\sROW\sSTART-->(?<row>.*?)\s*<!--ITEM\sROW\sEND-->(?<e>.*)", RegexOptions.Singleline | RegexOptions.IgnorePatternWhitespace);
var match = re.Match(text);
var b = match.Groups["b"].Value;
var row = match.Groups["row"].Value.Replace("{funditem}", "{0}").Replace("{itemamt}", "{1:N2}");
var e = match.Groups["e"].Value;
var sb = new StringBuilder(b);
var desc = "{0}; {1}; {2}".Fmt(
p.person.Name,
p.person.PrimaryAddress,
p.person.PrimaryZip);
foreach (var g in p.FundItemsChosen())
{
if (g.amt > 0)
{
sb.AppendFormat(row, g.desc, g.amt);
p.person.PostUnattendedContribution(DbUtil.Db,
g.amt,
g.fundid,
desc);
}
}
t.Financeonly = true;
if (t.Donate > 0)
{
var fundname = DbUtil.Db.ContributionFunds.Single(ff => ff.FundId == p.setting.DonationFundId).FundName;
sb.AppendFormat(row, fundname, t.Donate);
t.Fund = p.setting.DonationFund();
p.person.PostUnattendedContribution(DbUtil.Db,
t.Donate.Value,
p.setting.DonationFundId,
desc);
}
sb.Append(e);
if (!t.TransactionId.HasValue())
{
t.TransactionId = TransactionID;
if (m.testing == true && !t.TransactionId.Contains("(testing)"))
{
t.TransactionId += "(testing)";
}
}
var contributionemail = (from ex in p.person.PeopleExtras
where ex.Field == "ContributionEmail"
select ex.Data).SingleOrDefault();
if (contributionemail.HasValue())
{
contributionemail = contributionemail.Trim();
}
if (!Util.ValidEmail(contributionemail))
{
contributionemail = p.person.FromEmail;
}
Util.SendMsg(Util.SysFromEmail, Util.Host, Util.TryGetMailAddress(DbUtil.Db.StaffEmailForOrg(p.org.OrganizationId)),
p.setting.Subject, sb.ToString(),
Util.EmailAddressListFromString(contributionemail), 0, p.PeopleId);
DbUtil.Db.Email(contributionemail, DbUtil.Db.StaffPeopleForOrg(p.org.OrganizationId),
"online giving contribution received",
"see contribution records for {0} ({1})".Fmt(p.person.Name, p.PeopleId));
if (p.CreatingAccount == true)
{
p.CreateAccount();
}
}
else if (managingsubs)
{
m.ConfirmManageSubscriptions();
m.URL = null;
ViewData["ManagingSubscriptions"] = true;
ViewData["CreatedAccount"] = m.List[0].CreatingAccount;
confirm = "ConfirmAccount";
}
else if (choosingslots)
{
m.ConfirmPickSlots();
m.URL = null;
ViewData["ManagingVolunteer"] = true;
ViewData["CreatedAccount"] = m.List[0].CreatingAccount;
confirm = "ConfirmAccount";
}
else if (m.OnlinePledge())
{
m.ConfirmManagePledge();
ViewData["ManagingPledge"] = true;
ViewData["CreatedAccount"] = m.List[0].CreatingAccount;
confirm = "ConfirmAccount";
}
else if (m.ManageGiving())
{
m.ConfirmManageGiving();
ViewData["ManagingGiving"] = true;
ViewData["CreatedAccount"] = m.List[0].CreatingAccount;
confirm = "ConfirmAccount";
}
else if (t.TransactionGateway.ToLower() == "serviceu")
{
t.TransactionId = TransactionID;
if (m.testing == true && !t.TransactionId.Contains("(testing)"))
{
t.TransactionId += "(testing)";
}
t.Message = "Transaction Completed";
t.Approved = true;
m.EnrollAndConfirm();
if (m.List.Any(pp => pp.PeopleId == null))
{
if ((bool?)Session["OnlineRegLogin"] == true)
{
FormsAuthentication.SignOut();
Session.Abandon();
}
return("error: no person");
}
m.UseCoupon(t.TransactionId, t.Amt ?? 0);
}
else
{
if (!t.TransactionId.HasValue())
{
t.TransactionId = TransactionID;
if (m.testing == true && !t.TransactionId.Contains("(testing)"))
{
t.TransactionId += "(testing)";
}
}
m.EnrollAndConfirm();
if (m.List.Any(pp => pp.PeopleId == null))
{
if ((bool?)Session["OnlineRegLogin"] == true)
{
FormsAuthentication.SignOut();
Session.Abandon();
}
return("error: no person");
}
m.UseCoupon(t.TransactionId, t.Amt ?? 0);
}
if (m.IsCreateAccount() || m.ManagingSubscriptions())
{
ViewData["email"] = m.List[0].person.EmailAddress;
}
else
{
ViewData["email"] = m.List[0].email;
}
ViewData["orgname"] = m.org != null ? m.org.OrganizationName
: m.masterorgid.HasValue ? m.masterorg.OrganizationName
: m.div.Name;
if ((bool?)Session["OnlineRegLogin"] == true)
{
FormsAuthentication.SignOut();
Session.Abandon();
}
return(confirm);
}
