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);
        }
예제 #2
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);
        }