public void ExportDonorTotals_Should_Bring_Pledges(int campusid, bool?pledges, bool?nontaxdeductible, int?online, bool includeUnclosed, int?tagid, string fundids)
{
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.ExcelDonorTotals(exportStartDt, exportEndDt, campusid, pledges, nontaxdeductible, online, includeUnclosed, tagid, fundids);
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());
amountpledged.ShouldBe(1000.00);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
foreach (var b in bundleList)
{
MockContributions.DeleteAllFromBundle(db, b);
}
}
}
}
public void ExcelDonorTotals_Should_Not_Bring_Reversed_or_Returned_contributions(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(db);
int?online = null;
DateTime exportStartDt = Util.Now.AddDays(-180);
DateTime exportEndDt = Util.Now.AddDays(180);
DataTable tableResult = _exportPeople.ExcelDonorTotals(exportStartDt, exportEndDt, campusid, pledges, nontaxdeductible, online, includeUnclosed, tagid, fundids, false);
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 tableResultTotals = tableResult.AsEnumerable().Sum(row => row.Field <decimal>("Amount"));
var totalContributions = dbContributionsQry.Sum(x => x.ContributionAmount) ?? 0;
try
{
totalContributions.ToDouble().ShouldBe(tableResultTotals.ToDouble());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
foreach (var b in bundleList)
{
MockContributions.DeleteAllFromBundle(db, b);
}
}
}
}
