public void May4to7()
{
var arg = SampleDir.Lease197();
var sut = new ColxnSummaryReport(4.May(2018), 6.May(2018), arg);
sut.Count.Should().Be(3);
sut.DateRangeText.Should().Be("May 4, 2018 to May 6, 2018");
sut.SectionTotals.Should().HaveCount(4);
sut.SectionTotals.ContainsKey(DRY).Should().BeTrue();
sut.SectionTotals.ContainsKey(FRZ).Should().BeTrue();
sut.SectionTotals.ContainsKey(WET).Should().BeTrue();
sut.SectionTotals.ContainsKey(OFC).Should().BeTrue();
sut.SectionTotals[DRY].Rent.Should().Be(12721 + 9992);
sut.SectionTotals[FRZ].Rent.Should().Be(0 + 0);
sut.SectionTotals[WET].Rent.Should().Be(18199 + 5889);
sut.SectionTotals[OFC].Rent.Should().Be(0 + 0);
sut.SectionTotals[DRY].Rights.Should().Be(750 + 0);
sut.SectionTotals[FRZ].Rights.Should().Be(0 + 0);
sut.SectionTotals[WET].Rights.Should().Be(2508 + 5929);
sut.SectionTotals[OFC].Rights.Should().Be(3000 + 0);
sut.GLAccounts[CR].Should().Be("CR");
sut.GLAccounts[PRK].Should().Be("Parking");
sut.OtherTotals.Count.Should().Be(2);
sut.OtherTotals[CR].Should().Be(465 + 666);
sut.OtherTotals[PRK].Should().Be(549);
sut.TotalCollections.Should().Be(68666);
sut.TotalDeposits.Should().Be(68666);
}
public async Task ReviewMay8()
{
var args = SampleDir.Lease197();
var sut = new MainWindowVM(8.May(2018), args, false);
await sut.RefreshCmd.RunAsync();
sut.CashierColxns.Should().HaveCount(1);
sut.CashierColxns.TotalSum.Should().Be(5_000);
sut.OtherColxns.Should().HaveCount(1);
sut.OtherColxns.TotalSum.Should().Be(519);
sut.BankDeposits.Should().HaveCount(3);
sut.BankDeposits.TotalSum.Should().Be(23_298);
sut.SectionTabs[0].IntendedColxns.Should().HaveCount(38);
sut.SectionTabs[0].IntendedColxns.TotalSum.Should().Be(7_466);
sut.SectionTabs[0].AmbulantColxns.Should().HaveCount(0);
sut.SectionTabs[0].AmbulantColxns.TotalSum.Should().Be(0);
sut.SectionTabs[0].Uncollecteds.Should().HaveCount(7);
sut.SectionTabs[0].NoOperations.Should().HaveCount(3);
sut.SectionTabs[0].SectionTotal.Should().Be(7_466);
sut.SectionTabs[1].IntendedColxns.Should().HaveCount(67);
sut.SectionTabs[1].IntendedColxns.TotalSum.Should().Be(9_560);
sut.SectionTabs[1].AmbulantColxns.Should().HaveCount(6);
sut.SectionTabs[1].AmbulantColxns.TotalSum.Should().Be(585);
sut.SectionTabs[1].Uncollecteds.Should().HaveCount(0);
sut.SectionTabs[1].NoOperations.Should().HaveCount(9);
sut.SectionTabs[1].SectionTotal.Should().Be(10_145);
sut.PostAndClose.TotalCollections.Should().Be(23_130);
sut.PostAndClose.TotalDeposits.Should().Be(23_298);
sut.PostAndClose.IsBalanced.Should().BeFalse();
}
public async Task ReviewMay12()
{
var args = SampleDir.Lease197();
var sut = new MainWindowVM(12.May(2018), args, false);
await sut.RefreshCmd.RunAsync();
sut.CashierColxns.Should().HaveCount(0);
sut.CashierColxns.TotalSum.Should().Be(0);
sut.OtherColxns.Should().HaveCount(1);
sut.OtherColxns.TotalSum.Should().Be(416);
sut.BankDeposits.Should().HaveCount(2);
sut.BankDeposits.TotalSum.Should().Be(15_831);
sut.SectionTabs[0].IntendedColxns.Should().HaveCount(31);
sut.SectionTabs[0].IntendedColxns.TotalSum.Should().Be(6_890);
sut.SectionTabs[0].AmbulantColxns.Should().HaveCount(0);
sut.SectionTabs[0].AmbulantColxns.TotalSum.Should().Be(0);
sut.SectionTabs[0].Uncollecteds.Should().HaveCount(4);
sut.SectionTabs[0].NoOperations.Should().HaveCount(13);
sut.SectionTabs[0].SectionTotal.Should().Be(6_890);
sut.SectionTabs[0].Collector.Name.Should().Be("Jomar Pasaludos");
sut.SectionTabs[1].IntendedColxns.Should().HaveCount(63);
sut.SectionTabs[1].IntendedColxns.TotalSum.Should().Be(7_785);
sut.SectionTabs[1].AmbulantColxns.Should().HaveCount(4);
sut.SectionTabs[1].AmbulantColxns.TotalSum.Should().Be(530);
sut.SectionTabs[1].Uncollecteds.Should().HaveCount(2);
sut.SectionTabs[1].NoOperations.Should().HaveCount(11);
sut.SectionTabs[1].SectionTotal.Should().Be(8_315);
sut.SectionTabs[1].Collector.Name.Should().Be("Jomar Pasaludos");
sut.PostAndClose.TotalCollections.Should().Be(15_621);
sut.PostAndClose.TotalDeposits.Should().Be(15_831);
sut.PostAndClose.IsBalanced.Should().BeFalse();
}
public void May4()
{
var arg = SampleDir.Lease197();
var sut = new DailyColxnsReport(4.May(2018), arg);
sut.Should().HaveCount(4);
//sut.ContainsKey(DRY).Should().BeTrue();
//sut.ContainsKey(FRZ).Should().BeTrue();
//sut.ContainsKey(WET).Should().BeTrue();
//sut.ContainsKey(OFC).Should().BeTrue();
var dry = sut.Single(_ => _.Section.Id == DRY);
var frz = sut.Single(_ => _.Section.Id == FRZ);
var wet = sut.Single(_ => _.Section.Id == WET);
var ofc = sut.Single(_ => _.Section.Id == OFC);
dry.Rent.Should().Be(5821);
frz.Rent.Should().Be(0);
wet.Rent.Should().Be(10164);
ofc.Rent.Should().Be(0);
sut.TotalRent.Should().Be(15985);
dry.Rights.Should().Be(750);
frz.Rights.Should().Be(0);
wet.Rights.Should().Be(1679);
ofc.Rights.Should().Be(0);
sut.TotalRights.Should().Be(2429);
dry.Electric.Should().Be(831);
frz.Electric.Should().Be(0);
wet.Electric.Should().Be(965);
ofc.Electric.Should().Be(0);
sut.TotalElectric.Should().Be(1796);
dry.Water.Should().Be(0);
frz.Water.Should().Be(0);
wet.Water.Should().Be(0);
ofc.Water.Should().Be(0);
sut.TotalWater.Should().Be(0);
dry.Ambulant.Should().Be(0);
frz.Ambulant.Should().Be(168);
wet.Ambulant.Should().Be(355);
ofc.Ambulant.Should().Be(0);
sut.TotalAmbulant.Should().Be(523);
dry.Total.Should().Be(7_402);
frz.Total.Should().Be(168);
wet.Total.Should().Be(13_163);
ofc.Total.Should().Be(0);
sut.SectionsTotal.Should().Be(20_733);
sut.Others.Count.Should().Be(1);
sut.Others[CR].Should().Be(465);
sut.CollectionsSum.Should().Be(21_198);
sut.DepositsSum.Should().Be(21_198);
}
public void FindbyIDIncludesSectionobject()
{
var arg = SampleDir.Lease197();
var sut = arg.MarketState.ActiveLeases;
var rec = sut.Find(10, true);
rec.Stall.Section.Should().NotBeNull();
rec.Stall.Section.Name.Should().Be("WET");
}
public void GetAllIncludesSectionobject()
{
var arg = SampleDir.Lease197();
var sut = arg.MarketState.ActiveLeases;
var all = sut.GetAll();
foreach (var rec in all)
{
rec.Stall.Section.Should().NotBeNull();
rec.Stall.Section.Name.Should().NotBeEmpty();
}
}
public void ColxnSummaryToExcel()
{
var arg = SampleDir.Lease197();
var bgn = 3.May(2018);
var end = 12.May(2018);
//if (!PopUpInput.TryGetDateRange("Dates covered by Collection Summary Report", out (DateTime Start, DateTime End) rng, bgn, end)) return;
//var rep = new ColxnSummaryReport(rng.Start, rng.End, arg);
var rep = new ColxnSummaryReport(bgn, end, arg);
rep.ToExcel();
}
public async Task TestMethod00001()
{
var arg = SampleDir.Lease197();
arg.Collections.ExecutionTimeOf(_ => _.UnclosedDate())
.Should().BeLessThan(500.Milliseconds());
var dte = arg.Collections.UnclosedDate();
var sut = new MainWindowVM(dte, arg, false);
await sut.RefreshCmd.RunAsync();
sut.SectionTabs.Should().HaveCount(2);
}
public void May4()
{
var arg = SampleDir.Lease197();
var db = arg.Collections.For(4.May(2018));
var mkt = arg.MarketState;
var sut = new StallsInventoryReport(db, mkt);
sut.Count.Should().Be(3);
var dry = sut.Single(_ => _.Section.Id == DRY);
var frz = sut.Single(_ => _.Section.Id == FRZ);
var wet = sut.Single(_ => _.Section.Id == WET);
var total = sut.SummaryRows?.FirstOrDefault();
dry.TotalCount.Should().Be(68);
dry.TotalRent.Should().Be(11767);
dry.Occupieds.Count.Should().Be(50);
dry.OccupiedRent.Should().Be(8651);
dry.OccupiedRate.Should().BeApproximately(0.74M, 0.01M);
dry.Vacants.Count.Should().Be(18);
dry.VacantRent.Should().Be(3116);
dry.VacantRate.Should().BeApproximately(0.26M, 0.01M);
frz.TotalCount.Should().Be(8);
frz.TotalRent.Should().Be(0);
frz.Occupieds.Count.Should().Be(0);
frz.OccupiedRent.Should().Be(0);
frz.OccupiedRate.Should().BeApproximately(0, 0.01M);
frz.Vacants.Count.Should().Be(8);
frz.VacantRent.Should().Be(0);
frz.VacantRate.Should().BeApproximately(1, 0.01M);
wet.TotalCount.Should().Be(102);
wet.TotalRent.Should().Be(8520);
wet.Occupieds.Count.Should().Be(83);
wet.OccupiedRent.Should().Be(6960);
wet.OccupiedRate.Should().BeApproximately(0.81M, 0.01M);
wet.Vacants.Count.Should().Be(19);
wet.VacantRent.Should().Be(1560);
wet.VacantRate.Should().BeApproximately(0.19M, 0.01M);
total.Should().NotBeNull();
total.TotalCount.Should().Be(68 + 8 + 102);
total.TotalRent.Should().Be(11767 + 0 + 8520);
total.Occupieds.Count.Should().Be(50 + 0 + 83);
total.OccupiedRent.Should().Be(8651 + 0 + 6960);
total.OccupiedRate.Should().BeApproximately(0.747M, 0.01M);
total.Vacants.Count.Should().Be(18 + 8 + 19);
total.VacantRent.Should().Be(3116 + 0 + 1560);
total.VacantRate.Should().BeApproximately(0.26M, 0.01M);
}
public void ReadsAdjustments()
{
var arg = SampleDir.Lease197();
var lse = arg.MarketState.ActiveLeases.Find(197, true);
var sut = new SampleComposer(arg.Collections);
sut._billCode = BillCode.Rent;
var adj = sut.ReadAdjustments(lse, 4.May(2018));
adj.Single().AmountOffset.Should().Be(-656);
sut._billCode = BillCode.Rights;
adj = sut.ReadAdjustments(lse, 4.May(2018));
adj.Single().AmountOffset.Should().Be(-10_000);
}
public void ReadsPayments()
{
var arg = SampleDir.Lease197();
var lse = arg.MarketState.ActiveLeases.Find(197, true);
var sut = new SampleComposer(arg.Collections);
sut._billCode = BillCode.Rent;
var pay = sut.ReadPayments(lse, 9.May(2018));
pay.Single().Amount.Should().Be(160);
sut._billCode = BillCode.Electric;
pay = sut.ReadPayments(lse, 11.May(2018));
pay.Single().Amount.Should().Be(33);
pay.Single().Collector.Name.Should().Be("Jomar Pasaludos");
}
public void LastPostedDate()
{
var arg = SampleDir.Lease197();
arg.Collections.LastPostedDate().Should().Be(12.May(2018));
}
public void UnclosedDate()
{
var arg = SampleDir.Lease197();
arg.Collections.UnclosedDate().Should().Be(13.May(2018));
}
