| static private AddContributionDetail ( System.DateTime date, int fundid, string amount, int peopleid ) : CmsData.BundleDetail | ||
| date | System.DateTime | |
| fundid | int | |
| amount | string | |
| peopleid | int | |
| return | CmsData.BundleDetail | |
private static int?BatchProcess(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var now = DateTime.Now;
var list = new List <DepositRecord>();
bh = BatchImportContributions.GetBundleHeader(date, now);
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
var Amount = csv["Amount"];
var Date = csv["Processing Date"].ToDate() ?? DateTime.Today;
var Account = csv["Account"];
var Routing = csv["RT"];
var CheckNo = csv["Check"];
var bd = BatchImportContributions.AddContributionDetail(Date, fid, Amount, CheckNo, Routing, Account);
bd.Contribution.PostingDate = now;
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId ?? 0);
}
private static int?BatchProcessAbundantLife(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var prevbatch = "";
while (csv.ReadNextRecord())
{
var batch = csv[5];
if (bh == null || batch != prevbatch)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
prevbatch = batch;
continue; // the first row of a batch is a total row
}
var amount = csv[3];
var routing = csv[8];
var account = csv[9];
var checkno = csv[10];
var bd = BatchImportContributions.AddContributionDetail(date, fid, amount, checkno, routing, account);
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId);
}
private static int?BatchProcessVanco2(CsvReader csv, DateTime date, int?fundid)
{
var fundList = (from f in DbUtil.Db.ContributionFunds
orderby f.FundId
select f.FundId).ToList();
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid != null && fundList.Contains(fundid ?? 0) ? fundid ?? 0 : firstfund;
while (csv.ReadNextRecord())
{
var routing = "0";
var checkno = "0";
var account = csv[0];
var amount = csv[7];
var fundText = csv[11];
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var f = DbUtil.Db.FetchOrCreateFund(fundText);
var bd = BatchImportContributions.AddContributionDetail(date, f.FundId, amount, checkno, routing, account);
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcessHollyCreek(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
// 0 Amount, 1 Account, 2 Serial, 3 RoutingNumber, 4 TransmissionDate, 5 DepositTotal"))
while (csv.ReadNextRecord())
{
var amount = csv[0];
var account = csv[1];
var checkno = csv[2];
var routing = csv[3];
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, fund, amount, checkno, routing, account);
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcessFbcFayetteville(CsvReader csv, DateTime date, int?fundid)
{
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
while (csv.ReadNextRecord())
{
if (csv[6].StartsWith("Total Checks"))
{
continue;
}
var routing = csv[4];
var account = csv[5];
var checkno = csv[6];
var amount = csv[7];
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, fund, amount, checkno, routing, account);
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcessEnon(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
var dt = csv[1].ToDate();
var amount = csv[6];
if (!amount.HasValue() || !dt.HasValue)
{
continue;
}
var account = csv[4];
var checkno = csv[5];
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(dt.Value, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, fid, amount, checkno, "", account);
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcessFirstState(CsvReader csv, DateTime date, int?fundid)
{
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var list = new List <DepositRecord>();
/*
* Deposit Item
* Sequence #
* Item Date
* Item Status
* Customer Name
* Routing / Account #
* Check #
* Amount
* Deposit As
* Amount Source
* Image Quality Pass
* Scanned Count
*/
while (csv.ReadNextRecord())
{
var a = csv[5].Split('/');
list.Add(new DepositRecord()
{
Date = csv[2].ToDate(),
Routing = a[0].Trim(),
Account = a[1].Trim(),
Amount = csv[7],
CheckNo = csv[6],
Row = csv[1].ToInt(),
Valid = csv[3].Trim() == "Deposited"
});
}
DateTime?prevbatch = null;
foreach (var r in list.Where(rr => rr.Valid).OrderBy(rr => rr.Row))
{
if (r.Date != prevbatch)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(r.Date ?? date, DateTime.Now, BundleTypeCode.Online);
bh.DepositDate = r.Date;
prevbatch = r.Date;
}
BundleDetail bd;
bd = BatchImportContributions.AddContributionDetail(r.Date ?? date, fundid ?? firstfund, r.Amount, r.CheckNo, r.Routing, r.Account);
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bundleHeader = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var details = new List <BundleDetail>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
if (csv[0].EndsWith("ENDTRNS"))
{
continue;
}
var amount = csv[6];
var dt = csv[3].ToDate();
if (!amount.HasValue())
{
continue;
}
var fund = csv[4];
int ffid = !fund.HasValue() ? fid : DbUtil.Db.FetchOrCreateFund(fund).FundId;
var name = csv[5];
var address = csv[12];
var city = csv[13];
var st = csv[14];
var zip = csv[15];
if (bundleHeader == null)
{
bundleHeader = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(dt ?? date, ffid, amount, null, "", $"{name};{address}");
details.Add(bd);
bd.Contribution.ContributionDesc = $"{name};{address},{city},{st},{zip}";
}
details.Reverse();
if (bundleHeader != null)
{
foreach (var bd in details)
{
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
return(null);
}
private static int?BatchProcess(CsvReader csv, DateTime date, int?fundid)
{
var prevdt = DateTime.MinValue;
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var rows = new List <Row>();
var n = 0;
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
n += 1;
if (!csv[4].HasValue())
{
continue;
}
var row = new Row
{
N = n,
Dt = csv[1].ToDate() ?? date,
Amount = csv[4],
Pid = csv[2].ToInt(),
Fund = csv[5].ToInt2() ?? fid
};
rows.Add(row);
}
var q = from row in rows
orderby row.Dt, row.N
select row;
foreach (var row in q)
{
if (bh == null || row.Dt != prevdt)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(row.Dt, DateTime.Now);
prevdt = row.Dt;
}
var bd = BatchImportContributions.AddContributionDetail(row.Dt, row.Fund, row.Amount, row.Pid);
bh.BundleDetails.Add(bd);
bd.Contribution.PostingDate = date;
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId ?? 1);
}
private static int?BatchProcessKindred(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
var list = new List <DepositRecord>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
if (csv[14] == "Completed")
{
var desc = csv[13].HasValue()
? $"keyword={csv[13]}; {csv[2]}; {csv[3]}, {csv[4]}, {csv[5]} {csv[6]}; {csv[8]}"
: $"{csv[2]}; {csv[3]}, {csv[4]}, {csv[5]} {csv[6]}; {csv[8]}";
list.Add(new DepositRecord()
{
Date = csv[1].ToDate(),
Account = csv[7],
Amount = csv[9],
CheckNo = csv[12],
Description = desc,
});
}
}
var q = from r in list
select r;
foreach (var r in q)
{
var dt = DateTime.Parse("1/1/1980");
if (r.Date.HasValue)
{
dt = r.Date.Value;
}
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(dt.Date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(dt, fund, r.Amount, r.CheckNo, "", r.Account);
bd.Contribution.ContributionDesc = r.Description;
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcessText2Give(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
var list = new List <DepositRecord>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
if (csv[28].Equal("collected"))
{
var dt = Regex.Match(csv[24] ?? "", @"(\d{1,2}/\d{1,2}/\d{4} \d+:\d+:\d+ [A-P]M)").Value.ToDate();
var desc = $"{csv[8]}, {csv[9]}, {csv[10]}, {csv[16]}, {csv[17]}";
list.Add(new DepositRecord()
{
Date = dt,
Account = csv[18],
Amount = csv[2],
CheckNo = csv[0],
Description = desc,
});
}
}
var q = from r in list
select r;
foreach (var r in q)
{
var dt = DateTime.Parse("1/1/1980");
if (r.Date.HasValue)
{
dt = r.Date.Value;
}
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(dt.Date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(dt, fund, r.Amount, r.CheckNo, "", r.Account);
bd.Contribution.ContributionDesc = r.Description;
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcess(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var now = DateTime.Now;
var list = new List <Record>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
if (csv[0] != "Deposit") // Type
{
continue;
}
var rec = new Record
{
CheckNo = csv[2], //Num
Identifer = csv[3], //Name
Dt = csv[4].ToDate(), //Memo
Fund = csv[6], //Split
Amount = csv[7], //Amount
};
list.Add(rec);
}
foreach (var rec in list)
{
if (!rec.Dt.HasValue)
{
continue;
}
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, now);
}
var f = DbUtil.Db.FetchOrCreateFund(rec.Fund);
var bd = BatchImportContributions.AddContributionDetail(rec.Dt.Value, f.FundId, rec.Amount, rec.CheckNo, "", rec.Identifer);
bd.Contribution.PostingDate = now;
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId ?? 0);
}
private static int?BatchProcessFcchudson(CsvReader csv, DateTime date, int?fundid)
{
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
var list = new List <DepositRecord>();
while (csv.ReadNextRecord())
{
list.Add(new DepositRecord()
{
Batch = csv[0],
Routing = csv[1],
Account = csv[2],
Amount = csv[3],
CheckNo = csv[4],
Type = csv[5],
});
}
var q = from r in list
where r.Type == "Check"
select r;
var prevbatch = "";
foreach (var r in q)
{
if (r.Batch != prevbatch)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(r.Batch.ToDate().Value, DateTime.Now);
prevbatch = r.Batch;
}
var bd = BatchImportContributions.AddContributionDetail(date, fund, r.Amount, r.CheckNo, r.Routing, r.Account);
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcessMetropolitan(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
var list = new List <DepositRecord>();
while (csv.ReadNextRecord())
{
list.Add(new DepositRecord()
{
Type = csv[13],
Batch = csv[0],
Routing = csv[17],
Account = csv[16],
CheckNo = csv[15],
Amount = csv[14],
});
}
var q = from r in list
where r.Type.Equal("debit")
orderby r.Batch
select r;
var prevbatch = "";
foreach (var r in q)
{
if (r.Batch != prevbatch)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
prevbatch = r.Batch;
}
var bd = BatchImportContributions.AddContributionDetail(date, fund, r.Amount, r.CheckNo, r.Routing, r.Account);
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bundleHeader = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var details = new List <BundleDetail>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
var amount = csv["give_amount"];
var dt = csv["date"].ToDate();
if (!amount.HasValue())
{
continue;
}
var fund = csv["fund"];
var ffid = DbUtil.Db.ContributionFunds.FirstOrDefault(f => f.FundName == fund && f.FundStatusId == 1)?.FundId ?? fid;
var pid = GetPersonByEmail(csv["email"]);
var desc = $"{csv["first_name"]} {csv["last_name"]};{csv["email"]}";
if (bundleHeader == null)
{
bundleHeader = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(dt ?? date, ffid, amount, null, "", desc);
details.Add(bd);
bd.Contribution.PeopleId = pid;
bd.Contribution.ContributionDesc = desc;
}
details.Reverse();
if (bundleHeader != null)
{
foreach (var bd in details)
{
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
return(null);
}
private void AddSortedContributions()
{
foreach (var record in _details.OrderByDescending(x => x.Name).ToList())
{
var detail = BatchImportContributions.AddContributionDetail(_batchDate, _fundId, record.Amount,
record.IndividualIdNumber,
record.RoutingNumber,
record.AccountNumber);
if (!detail.Contribution.PeopleId.HasValue)
{
detail.Contribution.ContributionDesc = record.Name;
}
_bundleHeader.BundleDetails.Add(detail);
}
}
private static int?BatchProcessVanco(CsvReader csv, DateTime date, int?fundid)
{
var fundList = (from f in DbUtil.Db.ContributionFunds
orderby f.FundId
select f.FundId).ToList();
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid != null && fundList.Contains(fundid ?? 0) ? fundid ?? 0 : firstfund;
while (csv.ReadNextRecord())
{
var routing = "0";
var checkno = "0";
var account = csv[0];
var amount = csv[1];
var fundText = csv[3];
var fundNum = 0;
int.TryParse(fundText, out fundNum);
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
BundleDetail bd;
if (fundList.Contains(fundNum))
{
bd = BatchImportContributions.AddContributionDetail(date, fundNum, amount, checkno, routing, account);
}
else
{
bd = BatchImportContributions.AddContributionDetail(date, fund, amount, checkno, routing, account);
bd.Contribution.ContributionDesc = $"Used default fund (fund requested: {fundText})";
}
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bundleHeader = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var details = new List <BundleDetail>();
while (csv.Read())
{
var amount = csv[0];
var dt = csv[2].ToDate();
if (!amount.HasValue())
{
continue;
}
var fund = csv[4];
int ffid = !fund.HasValue() ? fid : DbUtil.Db.FetchOrCreateFund(fund).FundId;
var name = csv[5];
var email = csv[6];
var address = csv[7];
var phone = csv[8];
if (bundleHeader == null)
{
bundleHeader = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(dt ?? date, ffid, amount, null, "", email);
details.Add(bd);
bd.Contribution.ContributionDesc = $"{name};{address};{phone}";
}
details.Reverse();
if (bundleHeader != null)
{
foreach (var bd in details)
{
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
return(null);
}
private static int?BatchProcessJackHenry(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
var list = new List <DepositRecord>();
var r = 2;
while (csv.ReadNextRecord())
{
var peopleid = csv[6].ToInt();
list.Add(new DepositRecord()
{
PeopleId = peopleid,
Amount = csv[9],
CheckNo = csv[10],
Row = r++,
Valid = DbUtil.Db.People.Any(pp => pp.PeopleId == peopleid),
});
}
if (list.Any(vv => vv.Valid == false))
{
throw new Exception("The following rows had peopleids that were not found<br>\n" +
string.Join(",", (list.Where(vv => vv.Valid == false).Select(vv => vv.Row)).ToArray()));
}
foreach (var i in list)
{
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, fund, i.Amount, i.CheckNo, i.Routing, i.PeopleId);
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?BatchProcess(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var now = DateTime.Now;
var list = new List <Record>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
var rec = new Record
{
ItemType = csv["ItemTypeName"],
Amount = csv["Amount"],
Dt = csv["CapturedDate"].ToDate(),
Account = csv["Account"],
Routing = csv["RoutingNumber"],
CheckNo = csv["TranCode"],
};
if (rec.ItemType == "CK")
{
list.Add(rec);
}
}
bh = BatchImportContributions.GetBundleHeader(date, now);
foreach (var rec in list)
{
if (!rec.HasAmount || !rec.Dt.HasValue)
{
continue;
}
var bd = BatchImportContributions.AddContributionDetail(rec.Dt.Value, fid, rec.Amount, rec.CheckNo, rec.Routing, rec.Account);
bd.Contribution.PostingDate = now;
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId ?? 0);
}
private static int?BatchProcessTeaysValley(CsvReader csv, DateTime date, int?fundid)
{
var fundList = (from f in DbUtil.Db.ContributionFunds
orderby f.FundId
select f.FundId).ToList();
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
while (csv.ReadNextRecord())
{
var dt = csv[0].ToDate();
var amount = csv[2];
if (!amount.HasValue() || !dt.HasValue)
{
continue;
}
var fid = csv[1].ToInt2() ?? fund;
var account = csv[3];
var checkno = csv[4];
if (!fundList.Contains(fid))
{
fid = firstfund;
}
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(dt.Value, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, fid, amount, checkno, "", account);
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var list = new List <DepositRecord>();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
list.Add(new DepositRecord()
{
Batch = csv[0],
Account = csv[4],
CheckNo = csv[5],
Amount = csv[7],
});
}
var q = from r in list
select r;
var prevbatch = "";
foreach (var r in q)
{
if (r.Batch != prevbatch)
{
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(r.Batch.ToDate() ?? date, DateTime.Now);
}
prevbatch = r.Batch;
}
var bd = BatchImportContributions.AddContributionDetail(date, fid, r.Amount, r.CheckNo, r.Routing, r.Account);
bh.BundleDetails.Add(bd);
}
if (bh == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
public static int?BatchProcessSilverdale(CsvReader csv, DateTime date, int?fundid)
{
var cols = csv.GetFieldHeaders();
BundleHeader bh = null;
var firstfund = BatchImportContributions.FirstFundId();
var fund = fundid ?? firstfund;
while (csv.ReadNextRecord())
{
var excludecol = csv[12] == "Virtual Credit Item";
var routing = csv[18];
var account = csv[19];
var amount = csv[20];
var checkno = csv[24];
if (!checkno.HasValue() && account.Count(c => c == ' ') == 1)
{
var a = account.Split(' ');
account = a[1];
checkno = a[0];
}
if (excludecol)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
continue;
}
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, fund, amount, checkno, routing, account);
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh.BundleHeaderId);
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bundleHeader = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
var batchDate = csv["Date"].ToDate();
var amount = csv["Amount"];
//var paymentMethod = csv["Payment Method"];
var method = csv["Method"];
//var payerName = csv["Payer Name"];
var email = csv["Email address"];
var phone = csv["Mobile Number"];
var fundText = "";
if (csv.Context.HeaderRecord.Contains("Giving Type Label"))
{
fundText = csv["Giving Type Label"];
}
ContributionFund f = null;
if (fundText.HasValue())
{
f = DbUtil.Db.FetchOrCreateFund(fundText);
}
if (bundleHeader == null)
{
bundleHeader = BatchImportContributions.GetBundleHeader(batchDate ?? DateTime.Today, DateTime.Now);
}
var bd = BatchImportContributions.AddContributionDetail(date, f?.FundId ?? fid, amount, method, null, $"{email}|{phone}");
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
private static int?Import(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bundleHeader = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var details = new List <BundleDetail>();
while (csv.ReadNextRecord())
{
var batchDate = csv[0].ToDate();
var amount = csv[14];
var type = csv[13];
if (!amount.HasValue() || !batchDate.HasValue || type == "Credit")
{
continue;
}
var routingNumber = csv[17];
var accountNumber = csv[16];
var checkNumber = csv[15];
if (bundleHeader == null)
{
bundleHeader = BatchImportContributions.GetBundleHeader(batchDate.Value, DateTime.Now);
}
details.Add(BatchImportContributions.AddContributionDetail(date, fid, amount, checkNumber, routingNumber, accountNumber));
}
details.Reverse();
foreach (var bd in details)
{
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
private static int?BatchProcessFbcFayetteville(CsvReader csv, DateTime date, int?fundid)
{
var cols = csv.GetFieldHeaders();
BundleHeader bundleHeader = null;
var firstfund = BatchImportContributions.FirstFundId(); //TODO: use default fund id based on DBSetting w/ default to 1 if not set
var fund = fundid ?? firstfund;
while (csv.ReadNextRecord())
{
var isHeaderRow = csv[0].StartsWith("Date");
if (isHeaderRow)
{
continue;
}
var contributionDate = csv[0].Trim();
var memberNumber = csv[1].Trim();
var memberName = csv[2].Trim();
var amount = csv[3].Trim();
var checkNumber = csv[4].Trim();
if (bundleHeader == null)
{
bundleHeader = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
}
var bundleDetails = BatchImportContributions.AddContributionDetail(date, fund, amount, checkNumber, "", int.Parse(memberNumber));
bundleHeader.BundleDetails.Add(bundleDetails);
}
if (bundleHeader == null)
{
return(null);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
private static int?BatchProcess(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var now = DateTime.Now;
csv.Read();
csv.ReadHeader();
csv.Read(); // skip first row which is the total row
while (csv.Read())
{
var amount = csv[0];
var routing = csv[1];
var checkno = csv[2];
var account = csv[3];
var dt = csv[4].ToDate();
if (!amount.HasValue() || !dt.HasValue)
{
continue;
}
if (bh == null)
{
bh = BatchImportContributions.GetBundleHeader(date, now);
}
var bd = BatchImportContributions.AddContributionDetail(dt.Value, fid, amount, checkno, routing, account);
bd.Contribution.PostingDate = now;
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId ?? 0);
}
private static int?Import(CsvReader csv, int?fundid, DateTime date)
{
csv.Configuration.HasHeaderRecord = false;
csv.Configuration.Delimiter = "\t";
var bundleHeader = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
var fid = fundid ?? BatchImportContributions.FirstFundId();
var list = new List <DepositRecord>();
var n = 0;
// this is a peculiar file, no headers and all rows are included twice.
while (csv.Read())
{
if (csv[3] == "C") // C is the marker beginning each section
{
continue; // skip over C records
}
var r = new DepositRecord()
{
Row = n++, Valid = true
};
r.Account = csv[5];
r.Amount = (csv[7].ToDecimal() / 100).ToString();
r.CheckNo = csv[8];
r.Routing = csv[9];
list.Add(r);
}
for (var i = 0; i < n / 2; i++)
{
var r = list[i];
var bd = BatchImportContributions.AddContributionDetail(date, fid, r.Amount, r.CheckNo, r.Routing, r.Account);
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
private static int?BatchProcess(CsvReader csv, DateTime date, int?fundid)
{
BundleHeader bh = null;
var fid = fundid ?? BatchImportContributions.FirstFundId();
var now = DateTime.Now;
var list = new List <Record>();
// for parsing account and checkno
var regex = new Regex(Patterns, RegexOptions.IgnorePatternWhitespace | RegexOptions.Multiline);
csv.Read();
csv.ReadHeader();
csv.Read(); // read header;
var newBundle = true;
while (csv.Read())
{
if (csv[4] == "Bank On Us")
{
csv.Read(); // read the next row past the header row
newBundle = true;
}
var rec = new Record
{
Dt = csv[1].PadLeft(8, '0').ToDate(),
Amount = csv[5],
Routing = csv[3],
AccCk = csv[4],
NewBundle = newBundle,
};
// Parse out account and checkno
var m = regex.Match(rec.AccCk);
if (!m.Success)
{
throw new Exception($@"account **""{rec.AccCk}""**, does not match known patterns, contact support with this information.
No Contributions have been imported from this batch.");
}
rec.Account = m.Groups["ac"].Value;
rec.CheckNo = m.Groups["ck"].Value;
list.Add(rec);
newBundle = false;
}
foreach (var rec in list)
{
if (!rec.HasAmount || !rec.Dt.HasValue)
{
continue;
}
if (rec.NewBundle)
{
if (bh != null)
{
BatchImportContributions.FinishBundle(bh);
}
bh = BatchImportContributions.GetBundleHeader(date, now);
}
if (bh == null)
{
throw new Exception($@"Unexpected error: header row not found, aborting");
}
var bd = BatchImportContributions.AddContributionDetail(rec.Dt.Value, fid, rec.Amount, rec.CheckNo, rec.Routing, rec.Account);
bd.Contribution.PostingDate = now;
bh.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bh);
return(bh?.BundleHeaderId ?? 0);
}
private static int?Import(CsvReader csv, DateTime date)
{
var bundleHeader = BatchImportContributions.GetBundleHeader(date, DateTime.Now);
var list = new List <DepositRecord>();
var n = 0;
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
var r = new DepositRecord()
{
Row = ++n, Valid = true
};
r.Date = csv["Date"].ToDate();
r.PeopleId = csv["PeopleId"].ToInt();
r.CheckNo = csv["Check#"];
var typ = csv["Type"];
r.FundId = csv["Fund"].ToInt2();
r.Amount = csv["Amount"];
r.Description = csv["Notes"];
if (!r.Date.HasValue)
{
r.AddError("Missing Date");
}
if (!r.FundId.HasValue)
{
r.AddError("Missing Fund");
}
if (r.PeopleId == 0)
{
r.AddError("Missing PeopleId");
}
if (0 == DbUtil.Db.Connection.ExecuteScalar <int>(
"SELECT IIF(EXISTS(SELECT NULL FROM dbo.People WHERE PeopleId = @pid), 1, 0)", new { pid = r.PeopleId }))
{
r.AddError("Cannot Find Person");
}
if (0 == DbUtil.Db.Connection.ExecuteScalar <int>(
"SELECT IIF(EXISTS(SELECT NULL FROM dbo.ContributionFund WHERE FundId = @fid), 1, 0)", new { fid = r.FundId }))
{
r.AddError("Cannot Find Fund");
}
switch (typ)
{
case "PL":
r.TypeId = ContributionTypeCode.Pledge;
break;
case "NT":
r.TypeId = ContributionTypeCode.NonTaxDed;
break;
case "GK":
r.TypeId = ContributionTypeCode.GiftInKind;
break;
case "SK":
r.TypeId = ContributionTypeCode.Stock;
break;
case "CN":
r.TypeId = ContributionTypeCode.CheckCash;
break;
default:
r.AddError("missing/unknown type");
break;
}
list.Add(r);
}
if (list.Any(vv => vv.Valid == false))
{
throw new Exception("The following errors were found<br>\n" +
string.Join("<br>\n", list.Where(vv => vv.Valid == false).Select(vv => vv.RowError()).ToArray()));
}
foreach (var r in list)
{
if (!r.Date.HasValue || !r.FundId.HasValue)
{
continue;
}
var bd = BatchImportContributions.AddContributionDetail(r.Date.Value, r.FundId.Value, r.Amount, r.PeopleId);
var c = bd.Contribution;
c.ContributionDesc = r.Description;
c.CheckNo = r.CheckNo;
bundleHeader.BundleDetails.Add(bd);
}
BatchImportContributions.FinishBundle(bundleHeader);
return(bundleHeader.BundleHeaderId);
}
