public void DoWork() { Db = DbUtil.Create(Host); Db.CommandTimeout = 1200; var noaddressok = Db.Setting("RequireAddressOnStatement", "true") == "false"; showCheckNo = Db.Setting("RequireCheckNoOnStatement", "false").ToLower() == "true"; showNotes = Db.Setting("RequireNotesOnStatement", "false").ToLower() == "true"; const bool UseMinAmt = true; var qc = APIContribution.contributors(Db, fd, td, 0, 0, 0, noaddressok, UseMinAmt, StartsWith, Sort, tagid: TagId, excludeelectronic: ExcludeElectronic); var runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.Count = qc.Count(); Db.SubmitChanges(); if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FromDate = fd, ToDate = td, typ = 3, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; using (var stream = new FileStream(OutputFile, FileMode.Create)) c.Run(stream, Db, qc); LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) c.Run(stream, Db, qc, set); runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } else { var c = new ContributionStatements { FromDate = fd, ToDate = td, typ = 3 }; using (var stream = new FileStream(OutputFile, FileMode.Create)) c.Run(stream, Db, qc); LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) c.Run(stream, Db, qc, set); runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } }
public override void ExecuteResult(ControllerContext context) { var response = context.HttpContext.Response; response.ContentType = "application/pdf"; var filename = $"Statement-{ToDate:d}".SlugifyString("-", false); response.AddHeader("content-disposition", $"filename={filename}.pdf"); var cs = ContributionStatements.GetStatementSpecification(CurrentDatabase, statementType ?? "all"); if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FamilyId = FamilyId, FromDate = FromDate, PeopleId = PeopleId, SpouseId = SpouseId, ToDate = ToDate, typ = typ, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; IEnumerable <ContributorInfo> q = null; switch (typ) { case 1: q = APIContribution.Contributors(CurrentDatabase, FromDate, ToDate, PeopleId, SpouseId, 0, cs.Funds, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 2: FamilyId = CurrentDatabase.People.Single(p => p.PeopleId == PeopleId).FamilyId; q = APIContribution.Contributors(CurrentDatabase, FromDate, ToDate, 0, 0, FamilyId, cs.Funds, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 3: q = APIContribution.Contributors(CurrentDatabase, FromDate, ToDate, 0, 0, 0, cs.Funds, noaddressok, useMinAmt, singleStatement: singleStatement); break; } c.Run(response.OutputStream, CurrentDatabase, q, cs); } else { var c = new ContributionStatements { FamilyId = FamilyId, FromDate = FromDate, PeopleId = PeopleId, SpouseId = SpouseId, ToDate = ToDate, typ = typ }; IEnumerable <ContributorInfo> q = null; switch (typ) { case 1: q = APIContribution.Contributors(CurrentDatabase, FromDate, ToDate, PeopleId, SpouseId, 0, cs.Funds, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 2: FamilyId = CurrentDatabase.People.Single(p => p.PeopleId == PeopleId).FamilyId; q = APIContribution.Contributors(CurrentDatabase, FromDate, ToDate, 0, 0, FamilyId, cs.Funds, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 3: q = APIContribution.Contributors(CurrentDatabase, FromDate, ToDate, 0, 0, 0, cs.Funds, noaddressok, useMinAmt, singleStatement: singleStatement); break; } c.Run(response.OutputStream, CurrentDatabase, q, cs); } }
public override void ExecuteResult(ControllerContext context) { var Response = context.HttpContext.Response; Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "filename=foo.pdf"); if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FamilyId = FamilyId, FromDate = FromDate, PeopleId = PeopleId, SpouseId = SpouseId, ToDate = ToDate, typ = typ, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; IEnumerable <ContributorInfo> q = null; switch (typ) { case 1: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, PeopleId, SpouseId, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 2: FamilyId = DbUtil.Db.People.Single(p => p.PeopleId == PeopleId).FamilyId; q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, FamilyId, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 3: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; } c.Run(Response.OutputStream, DbUtil.Db, q); } else { var c = new ContributionStatements { FamilyId = FamilyId, FromDate = FromDate, PeopleId = PeopleId, SpouseId = SpouseId, ToDate = ToDate, typ = typ }; IEnumerable <ContributorInfo> q = null; switch (typ) { case 1: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, PeopleId, SpouseId, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 2: FamilyId = DbUtil.Db.People.Single(p => p.PeopleId == PeopleId).FamilyId; q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, FamilyId, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 3: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; } c.Run(Response.OutputStream, DbUtil.Db, q); } }
public void DoWork() { Db = new CMSDataContext(Util.GetConnectionString(Host)); Db.Host = Host; Db.CommandTimeout = 1200; var noaddressok = Db.Setting("RequireAddressOnStatement", "true") == "false"; showCheckNo = Db.Setting("RequireCheckNoOnStatement", "false").ToLower() == "true"; showNotes = Db.Setting("RequireNotesOnStatement", "false").ToLower() == "true"; var qc = APIContribution.contributors(Db, fd, td, 0, 0, 0, noaddressok, useMinAmt: true, startswith: StartsWith, sort: Sort); var runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.Count = qc.Count(); Db.SubmitChanges(); if (PDF) { if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FromDate = fd, ToDate = td, typ = 3, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; using (var stream = new FileStream(OutputFile, FileMode.Create)) c.Run(stream, Db, qc); LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) c.Run(stream, Db, qc, set); runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } else { var c = new ContributionStatements { FromDate = fd, ToDate = td, typ = 3 }; using (var stream = new FileStream(OutputFile, FileMode.Create)) c.Run(stream, Db, qc); LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) c.Run(stream, Db, qc, set); runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } } else { textStream = new StreamWriter(OutputFile); foreach (var c in qc) { pageStatement = 1; writeHeader(c); writeContributions(c); string hdrGift = " Date Fund Name Description of Gift-in-Kind Given as of {0:d}\n\n".Fmt(td); rWrite(hdrGift); writeSummary(c); runningtotals.Processed += 1; Db.SubmitChanges(); } textStream.Close(); runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } }
public void DoWork(ContributionStatements.StatementSpecification cs) { Db = DbUtil.Create(Host); DbUtil.Db.CommandTimeout = 1200; var noaddressok = !DbUtil.Db.Setting("RequireAddressOnStatement", true); showCheckNo = DbUtil.Db.Setting("RequireCheckNoOnStatement"); showNotes = DbUtil.Db.Setting("RequireNotesOnStatement"); const bool UseMinAmt = true; var qc = APIContribution.Contributors(DbUtil.Db, fd, td, 0, 0, 0, cs.Funds, noaddressok, UseMinAmt, StartsWith, Sort, tagid: TagId, excludeelectronic: ExcludeElectronic); var runningtotals = DbUtil.Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.Count = qc.Count(); DbUtil.Db.SubmitChanges(); if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FromDate = fd, ToDate = td, typ = 3, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; using (var stream = new FileStream(OutputFile, FileMode.Create)) { c.Run(stream, Db, qc, cs); } LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) { using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) { c.Run(stream, Db, qc, cs, set); } } runningtotals = DbUtil.Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; DbUtil.Db.SubmitChanges(); } else { var c = new ContributionStatements { FromDate = fd, ToDate = td, typ = 3 }; using (var stream = new FileStream(OutputFile, FileMode.Create)) { c.Run(stream, Db, qc, cs); } LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) { using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) { c.Run(stream, Db, qc, cs, set); } } runningtotals = DbUtil.Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; DbUtil.Db.SubmitChanges(); } }
public override void ExecuteResult(ControllerContext context) { var Response = context.HttpContext.Response; Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "filename=foo.pdf"); if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FamilyId = FamilyId, FromDate = FromDate, PeopleId = PeopleId, SpouseId = SpouseId, ToDate = ToDate, typ = typ, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; IEnumerable<ContributorInfo> q = null; switch (typ) { case 1: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, PeopleId, SpouseId, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 2: FamilyId = DbUtil.Db.People.Single(p => p.PeopleId == PeopleId).FamilyId; q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, FamilyId, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 3: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; } c.Run(Response.OutputStream, DbUtil.Db, q); } else { var c = new ContributionStatements { FamilyId = FamilyId, FromDate = FromDate, PeopleId = PeopleId, SpouseId = SpouseId, ToDate = ToDate, typ = typ }; IEnumerable<ContributorInfo> q = null; switch (typ) { case 1: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, PeopleId, SpouseId, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 2: FamilyId = DbUtil.Db.People.Single(p => p.PeopleId == PeopleId).FamilyId; q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, FamilyId, noaddressok, useMinAmt, singleStatement: singleStatement); break; case 3: q = APIContribution.contributors(DbUtil.Db, FromDate, ToDate, 0, 0, 0, noaddressok, useMinAmt, singleStatement: singleStatement); break; } c.Run(Response.OutputStream, DbUtil.Db, q); } }
public void DoWork() { Db = new CMSDataContext(Util.GetConnectionString(Host)); Db.Host = Host; Db.CommandTimeout = 1200; var noaddressok = Db.Setting("RequireAddressOnStatement", "true") == "false"; showCheckNo = Db.Setting("RequireCheckNoOnStatement", "false").ToLower() == "true"; showNotes = Db.Setting("RequireNotesOnStatement", "false").ToLower() == "true"; var qc = APIContribution.contributors(Db, fd, td, 0, 0, 0, noaddressok, useMinAmt: true, startswith: StartsWith, sort: Sort, tagid: TagId); var runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.Count = qc.Count(); Db.SubmitChanges(); if (PDF) { if (showCheckNo || showNotes) { var c = new ContributionStatementsExtra { FromDate = fd, ToDate = td, typ = 3, ShowCheckNo = showCheckNo, ShowNotes = showNotes }; using (var stream = new FileStream(OutputFile, FileMode.Create)) c.Run(stream, Db, qc); LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) { using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) c.Run(stream, Db, qc, set); } runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } else { var c = new ContributionStatements { FromDate = fd, ToDate = td, typ = 3 }; using (var stream = new FileStream(OutputFile, FileMode.Create)) c.Run(stream, Db, qc); LastSet = c.LastSet(); var sets = c.Sets(); foreach (var set in sets) { using (var stream = new FileStream(Output(OutputFile, set), FileMode.Create)) c.Run(stream, Db, qc, set); } runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.LastSet = LastSet; runningtotals.Sets = string.Join(",", sets); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } } else { textStream = new StreamWriter(OutputFile); foreach (var c in qc) { pageStatement = 1; writeHeader(c); writeContributions(c); string hdrGift = " Date Fund Name Description of Gift-in-Kind Given as of {0:d}\n\n".Fmt(td); rWrite(hdrGift); writeSummary(c); runningtotals.Processed += 1; Db.SubmitChanges(); } textStream.Close(); runningtotals = Db.ContributionsRuns.OrderByDescending(mm => mm.Id).First(); runningtotals.Completed = DateTime.Now; Db.SubmitChanges(); } }