public void ExportDonorFundTotals_Should_Bring_Pledges(int fundid, int campusid, bool?nontaxdeductible,
bool includeUnclosed, int?tagid, string fundids, int?online)
{
using (var db = CMSDataContext.Create(Util.Host))
{
var bundleList = CreateTestContributionSet(db, Util.Now.Date);
var _exportPeople = new ExportPeople(db);
DateTime exportStartDt = Util.Now.AddDays(-180);
DateTime exportEndDt = Util.Now.AddDays(180);
DataTable tableResult = _exportPeople.ExcelDonorFundTotals(exportStartDt, exportEndDt, fundid, campusid, true, nontaxdeductible, includeUnclosed, tagid, fundids, (int)online);
try
{
var q = from c in tableResult.Select() where c.ItemArray[3].ToInt() > 0 select c;
if (q.IsNotNull())
{
var amountpledged = Double.Parse(q.Select(x => x.ItemArray[3]).SingleOrDefault().ToString());
//The pledged amount correspond to the pledge amount created in CreateTestContributionSet()
amountpledged.ShouldBe(1000.00);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
foreach (var b in bundleList)
{
MockContributions.DeleteAllFromBundle(db, b);
}
}
}
}
public void ExcelDonorFundTotals_Should_Not_Bring_Reversed_or_Returned_contributions(int fundid, int campusid, bool pledges, bool?nontaxdeductible, bool includeUnclosed, int?tagid, string fundids)
{
using (var db = CMSDataContext.Create(Util.Host))
{
var bundleList = CreateTestContributionSet(db, Util.Now.Date);
var _exportPeople = new ExportPeople();
DateTime exportStartDt = new DateTime(Util.Now.Date.Year, 1, 1);
DateTime exportEndDt = new DateTime(Util.Now.Date.Year, 12, 31);
DataTable tableResult = _exportPeople.ExcelDonorFundTotals(exportStartDt, exportEndDt, fundid, campusid, pledges, nontaxdeductible, includeUnclosed, tagid, fundids);
var dbContributionsQry = db.Contributions
.Where(x => !ContributionTypeCode.ReturnedReversedTypes.Contains(x.ContributionTypeId) && !ContributionTypeCode.Pledge.Equals(x.ContributionTypeId))
.Where(x => ContributionStatusCode.Recorded.Equals(x.ContributionStatusId))
.Where(x => x.ContributionDate >= exportStartDt && x.ContributionDate < exportEndDt)
.Select(x => x);
dbContributionsQry = nontaxdeductible.HasValue
? (nontaxdeductible is true)
? dbContributionsQry = dbContributionsQry.Where(x => ContributionTypeCode.NonTaxDed.Equals(x.ContributionTypeId)).Select(x => x)
: dbContributionsQry = dbContributionsQry.Where(x => !ContributionTypeCode.NonTaxDed.Equals(x.ContributionTypeId)).Select(x => x)
: dbContributionsQry;
if (includeUnclosed is false)
{
dbContributionsQry = from c in dbContributionsQry
join bd in db.BundleDetails on c.ContributionId equals bd.ContributionId
join bh in db.BundleHeaders on bd.BundleHeaderId equals bh.BundleHeaderId
where bh.BundleStatusId == 0
select c;
}
var rc = tableResult.AsEnumerable().Where(row => ContributionTypeCode.ReturnedReversedTypes.Contains(row.Field <int>("ContributionTypeId")));
var tableResultTotals = tableResult.AsEnumerable().Sum(row => row.Field <decimal>("Amount"));
var totalContributions = dbContributionsQry.Sum(x => x.ContributionAmount) ?? 0;
totalContributions.ToDouble().ShouldBe(tableResultTotals.ToDouble());
rc.Count().ShouldBeLessThan(1);
foreach (var b in bundleList)
{
MockContributions.DeleteAllFromBundle(db, b);
}
}
}
public void ExcelDonorFundTotals_Should_Not_Bring_Reversed_or_Returned_contributions(int fundid, int?campusid, bool pledges, bool?nontaxdeductible, bool includeUnclosed, int?tagid, string fundids, int online)
{
using (var db = CMSDataContext.Create(Util.Host))
{
var bundleList = CreateTestContributionSet(db, Util.Now.Date);
var _exportPeople = new ExportPeople(db);
DateTime exportStartDt = Util.Now.AddDays(-180);
DateTime exportEndDt = Util.Now.AddDays(180);
DataTable tableResult = _exportPeople.ExcelDonorFundTotals(exportStartDt, exportEndDt, fundid, (int)campusid, pledges, nontaxdeductible, includeUnclosed, tagid, fundids, online);
var nontax = nontaxdeductible is null ? "Both" : nontaxdeductible == true ? "NonTaxDed" : "";
IQueryable <Contribution> contributions;
if (!nontax.HasValue())
{
nontax = "TaxDed";
}
contributions = db.Contributions;
if (!includeUnclosed)
{
contributions = from c in contributions
where c.BundleDetails.Any(dd => dd.BundleHeader.BundleStatusId == BundleStatusCode.Closed)
select c;
}
switch (nontax)
{
case "TaxDed":
contributions = pledges
?
(from c in contributions
where !ContributionTypeCode.NonTaxDed.Equals(c.ContributionTypeId)
select c)
:
(from c in contributions
where !ContributionTypeCode.NonTaxDed.Equals(c.ContributionTypeId)
where !ContributionTypeCode.Pledge.Equals(c.ContributionTypeId)
select c);
break;
case "NonTaxDed":
contributions = pledges
?
(from c in contributions
where ContributionTypeCode.NonTaxDed.Equals(c.ContributionTypeId)
select c).Concat(from c in contributions where c.ContributionTypeId == ContributionTypeCode.Pledge select c)
:
(from c in contributions
where ContributionTypeCode.NonTaxDed.Equals(c.ContributionTypeId)
where !ContributionTypeCode.Pledge.Equals(c.ContributionTypeId)
select c);
break;
case "Both":
contributions = pledges
?
(from c in contributions
select c)
:
(from c in contributions
where !ContributionTypeCode.Pledge.Equals(c.ContributionTypeId)
select c);
break;
case "Pledge":
contributions = from c in contributions
where c.ContributionTypeId == ContributionTypeCode.Pledge
select c;
break;
}
if (exportStartDt.ToDate().HasValue)
{
contributions = from c in contributions
where c.ContributionDate >= exportStartDt
select c;
}
if (exportEndDt.ToDate().HasValue)
{
contributions = from c in contributions
where c.ContributionDate < exportEndDt.ToDate().Value.AddDays(1)
select c;
}
if (online == 1)
{
contributions = from c in contributions
where c.BundleDetails.Any(dd => dd.BundleHeader.BundleHeaderTypeId == BundleTypeCode.Online)
select c;
}
else if (online == 0)
{
contributions = from c in contributions
where c.BundleDetails.All(dd => dd.BundleHeader.BundleHeaderTypeId != BundleTypeCode.Online)
select c;
}
if ((campusid ?? 0) != 0)
{
contributions = from c in contributions
where (c.CampusId ?? c.Person.CampusId) == campusid
select c;
}
if (fundids.HasValue())
{
if (fundids != null)
{
contributions = from c in contributions
where fundids.Contains(c.FundId.ToString())
select c;
}
}
var tableResultTotals = tableResult.AsEnumerable().Sum(row => row.Field <decimal>("Amount"));
var totalContributions = contributions.Sum(x => x.ContributionAmount) ?? 0;
totalContributions.ToDouble().ShouldBe(tableResultTotals.ToDouble());
foreach (var b in bundleList)
{
MockContributions.DeleteAllFromBundle(db, b);
}
}
}
