private static void RebuildSoaFor(LeaseDTO lse, DateTime minDate, ITenantDBsDir dir) { var repo = dir.Balances.GetRepo(lse); DeleteRowsEarlierThan(minDate, repo); repo.RecomputeFrom(minDate); }
private static void ZeroOutRentBalances(ITenantDBsDir dir) { //var adjs = (dir.Collections.For (terminationDate) // ?? dir.Collections.CreateFor(terminationDate)) // .BalanceAdjs; var inactvs = dir.MarketState.InactiveLeases.GetAll(); foreach (var lse in inactvs) { var bill = dir.Balances.GetRepo(lse.Id)?.Latest(); var endBal = bill?.For(BillCode.Rent)?.ClosingBalance ?? 0; if (endBal == 0) { continue; } var adjs = dir.Collections.For(bill.GetBillDate()) .BalanceAdjs; adjs.Insert(new BalanceAdjustmentDTO { DocumentRef = "[system-auto]", Reason = "Market Renovation", LeaseId = lse.Id, BillCode = BillCode.Rent, AmountOffset = endBal * -1, }); } }
public SectionColxnsRow(SectionDTO sec, DateTime date, ITenantDBsDir dir) { Section = sec; ColxnDate = date; var db = dir.Collections.For(date); Collector = GetSectionCollector(sec, db); var colxns = GetLeaseColxns(sec, date, db, dir); Rent = colxns.Sum(_ => _.Rent ?? 0); Rights = colxns.Sum(_ => _.Rights ?? 0); Electric = colxns.Sum(_ => _.Electric ?? 0); Water = colxns.Sum(_ => _.Water ?? 0); Ambulant = colxns.Sum(_ => _.Ambulant ?? 0); Details.SetItems(colxns); Details.SetSummary(new LeaseColxnRow() { Rent = Rent, Rights = Rights, Electric = Electric, Water = Water, Ambulant = Ambulant, }); }
public MainWindowVM(DateTime unclosedDate, ITenantDBsDir tenantDBsDir, bool clickRefresh = true) : base(tenantDBsDir) { Date = unclosedDate; CanReview = AppArgs.CanPostAndClose(false); CanEncode = AppArgs.CanEncodeCollections(false); if (!IsPrivilegedUser()) { return; } ColxnsDB = CheckIfDbExists(Date); if (ColxnsDB == null) { return; } SectionTabs = new TabsListVM(this); CashierColxns = new CashierColxnsVM(this); OtherColxns = new OtherColxnsVM(this); BankDeposits = new BankDepositsVM(this); ApprovalAwaiter = new ApprovalRequesterVM(this); PostAndClose = new PostAndCloseVM(this); NextDayOpener = new NextDayOpenerVM(this); if (clickRefresh) { ClickRefresh(); } SetCaption(""); }
public static List <Action> GetActions(ICollectionsDB colxnsDB, ITenantDBsDir dir, string postedBy) { var jobs = new List <Action>(); jobs.Add(() => colxnsDB.MarkAsPosted(postedBy)); return(jobs); }
private static string GetInactivesDir(ITenantDBsDir dir) { var mktDir = Path.GetDirectoryName(dir.MarketState.DatabasePath); var dirPath = Path.Combine(mktDir, DIR_NAME); Directory.CreateDirectory(dirPath); return(dirPath); }
public CollectionsLocalDir(ITenantDBsDir tenantDBsDir) { _dir = tenantDBsDir; _mkt = _dir.MarketState; //_mkt = marketStateDB; _foldrPath = FindCollectionsDir(_mkt.DatabasePath); _mkt.Collections = this; }
public PrintPreviewWindowVM(ChequeVoucherDTO dto, ITenantDBsDir dir) //: base(dto, dir) { AppArgs = dir; CurrentItem = dto; AllocationTotals.SetItems(GetAllocationsSummary(dto)); ReviewerName = Default.ReviewerName; ApproverName = Default.ApproverName; }
public BalancesLocalDir(ITenantDBsDir tenantDBsDir) { _dir = tenantDBsDir; _mkt = _dir.MarketState; //_mkt = marketStateDB; _foldrPath = FindBalancesDir(_mkt.DatabasePath); _mkt.Balances = this; }
public static void Show(LeaseDTO lse, ITenantDBsDir args) { if (lse == null || args == null) { return; } new SoaViewerVM(lse, args).Show <SoaViewerWindow>(); }
public DailyTxnConverterBase2(PeriodRowVM periodRowVM) { _row = periodRowVM; _rntDir = _row.MainWindow.AppArgs; _rntCache = _row.MainWindow.RntCache; _byfCache = _row.MainWindow.ByfCache; _client = _row.MainWindow.ByfServer.Client; }
public static void DecommissionOldStalls (ITenantDBsDir dir, int oldSectionsMaxId, DateTime terminationDate) { dir.Credentials.HumanName = "AdHoc Admin"; TerminateOldLeases(dir, oldSectionsMaxId, terminationDate); ZeroOutRentBalances(dir); MarkOldStallsAsNonOperational(dir, oldSectionsMaxId); MarkNewStallsAsOperational(dir, oldSectionsMaxId); }
private BalanceAdjustmentDTO FindRntDTO(BalanceAdjConverter1 conv, ITenantDBsDir dir, out DateTime date) { date = conv._adjDates[Id]; var colxns = dir.Collections.For(date); _repo = colxns?.BalanceAdjs; return(_repo?.Find(Id, false)); //return _repo?.GetAll().SingleOrDefault(_ => _.Id == Id); }
private static string GetInactiveRequestsPath(ITenantDBsDir dir) { var dbPath = Path.Combine(GetInactivesDir(dir), REQUESTS_FILE); //if (!File.Exists(dbPath)) // throw Missing.File(dbPath, "Inactive Requests DB file"); return(dbPath); }
private void FillMainList(ITenantDBsDir dir) { this.Clear(); foreach (var date in StartDate.EachDayUpTo(EndDate)) { this.Add(new DailyColxnsReport(date, dir)); } }
public void RefillFrom(ITenantDBsDir dir) { var mkt = dir.MarketState; _lsesById = mkt.GetAllLeases().ToDictionary(_ => _.Id); _bankAcctsById = mkt.BankAccounts.GetAll().ToDictionary(_ => _.Id); _colctrsById = mkt.Collectors.GetAll().ToDictionary(_ => _.Id); _glAcctsById = mkt.GLAccounts.GetAll().ToDictionary(_ => _.Id); }
public AdHocJobCmdsVM(MainWindowVM mainWindowVM) { _main = mainWindowVM; _dir = _main.AppArgs; AdHocJobCmd1 = R2Command.Relay(_ => RunAdHoc(1), _ => _dir.CanRunAdHocTask(false), "Run Ad Hoc Command 1"); AdHocJobCmd2 = R2Command.Relay(_ => RunAdHoc(2), _ => _dir.CanRunAdHocTask(false), "Run Ad Hoc Command 2"); AdHocJobCmd3 = R2Command.Relay(_ => RunAdHoc(3), _ => _dir.CanRunAdHocTask(false), "Run Ad Hoc Command 3"); }
public AllActiveLeasesVM(MainWindowVM main, ITenantDBsDir dir) : base(main, dir) { AddStallToTenantCmd = LeaseCRUD1VM.GetAddStallToTenantCmd(this); EditThisLeaseCmd = LeaseCRUD1VM.GetEditThisLeaseCmd(this); EditTenantInfoCmd = LeaseCRUD1VM.GetEditTenantInfoCmd(this); TerminateThisLeaseCmd = LeaseCRUD1VM.GetTerminateThisLeaseCmd(this); AdhocLeaseJobCmd1 = AdhocLeaseJobs.CreateLeaseJobCmd(1, this); AdhocLeaseJobCmd2 = AdhocLeaseJobs.CreateLeaseJobCmd(2, this); AdhocLeaseJobCmd3 = AdhocLeaseJobs.CreateLeaseJobCmd(3, this); }
public static Action FixBDO1ImportBug(ITenantDBsDir dir, out string jobDesc) { jobDesc = "Fix BDO-1 Import Bug"; return(() => { ProcessRequests(dir.Vouchers.PreparedCheques); ProcessRequests(dir.Vouchers.ActiveRequests); ProcessRequests(dir.Vouchers.InactiveRequests); }); }
public MainWindowVM(ITenantDBsDir tenantDBsDir) : base(tenantDBsDir) { DailyTxns = new DailyTransactionsVM(this); Enlist("Leases", () => new LeaseConverter1(this)); Enlist("Stalls", () => new StallConverter1(this)); Enlist("Sections", () => new SectionConverter1(this)); Enlist("Collectors", () => new CollectorConverter1(this)); Enlist("Bank Accts", () => new BankAccountConverter1(this)); Enlist("GL Accts", () => new GLAccountConverter1(this)); }
public AllInactiveLeasesVM(MainWindowVM main, ITenantDBsDir dir) : base(main, dir) { AddStallToTenantCmd = LeaseCRUD1VM.GetAddStallToTenantCmd(this); RenewInactiveLeaseCmd = LeaseCRUD1VM.GetRenewInactiveLeaseCmd(this); UndoTerminationCmd = R2Command.Relay(UndoTermination, _ => AppArgs.CanUndoLeaseTermination(false), "Undo Lease Termination"); RebuildSoaCmd = R2Command.Async(RebuildSoA, _ => AppArgs.CanRunAdHocTask(false), "Rebuild Statement of Account"); }
public static Action SetYearsBack_1(ITenantDBsDir dir, out string jobDesc, out bool canRun) { canRun = dir.CanRunAdHocTask(false); jobDesc = "Set YearsBackCount to [1]"; return(() => { dir.MarketState.YearsBackCount = 1; }); }
public AdHocJobCmdsVM(MainWindowVM mainWindowVM) { _main = mainWindowVM; _dir = _main.AppArgs; AdHocJobCmd1 = R2Command.Relay(_ => RunAdHoc(1), null, "Run Ad Hoc Command 1"); AdHocJobCmd2 = R2Command.Relay(_ => RunAdHoc(2), null, "Run Ad Hoc Command 2"); AdHocJobCmd3 = R2Command.Relay(_ => RunAdHoc(3), null, "Run Ad Hoc Command 3"); AdHocJobCmd4 = R2Command.Relay(_ => RunAdHoc(4), null, "Run Ad Hoc Command 4"); AdHocJobCmd5 = R2Command.Relay(_ => RunAdHoc(5), null, "Run Ad Hoc Command 5"); }
public MainToolbarVM(MainWindowVM mainWindowVM) { _main = mainWindowVM; _args = _main.AppArgs; WithOverduesReportCmd = WithOverduesReport.CreateLauncherCmd(_args); PrintCurrentListCmd = R2Command.Relay(PrintCurrentList, null, "Print Current List"); ExportListToExcelCmd = R2Command.Relay(ExportListToExcel, null, "Export List to Excel"); //RunAdHocTask1Cmd = R2Command.Relay(_ => RunAdHocTask(1), _ => _args.CanRunAdHocTask(false), "Run Ad Hoc Script 1"); //RunAdHocTask2Cmd = R2Command.Relay(_ => RunAdHocTask(2), _ => _args.CanRunAdHocTask(false), "Run Ad Hoc Script 2"); //RunAdHocTask3Cmd = R2Command.Relay(_ => RunAdHocTask(3), _ => _args.CanRunAdHocTask(false), "Run Ad Hoc Script 3"); }
private void FillSectionTotals(ITenantDBsDir dir) { SectionTotals.Clear(); foreach (var sec in dir.MarketState.Sections.GetAll()) { SectionTotals.Add(sec.Id, GetCollectionAmounts(sec.Id)); } SectionTotals.Add(0, GetCollectionAmounts(0)); }
public static CVsByDateCell GetCheckVouchers(this ITenantDBsDir dir, DateTime date) { var db = dir.Vouchers; return(new CVsByDateCell { ActiveRequests = GetActiveRequests(db, date), InactiveRequests = GetInactiveRequests(db, date), PreparedCheques = GetPreparedCheques(db, date), }); }
private static void ExecuteRateIncrease(LeaseDTO origLse, ITenantDBsDir dir) { var mkt = dir.MarketState; var lastDte = 28.Feb(2019); var reason = "2019 Rate Increase"; var inactv = mkt.DeactivateLease(origLse, reason, lastDte); var newActv = CreateNewActive(inactv, lastDte); mkt.ActiveLeases.Insert(newActv); inactv.ForwardBalancesTo(newActv, dir); }
public static void All_AR_Others(ITenantDBsDir dir) { dir.AddIfNone("A/R Others - Fortune Balagtas", GLAcctType.Asset); dir.AddIfNone("A/R Others - Fortune Marilao", GLAcctType.Asset); dir.AddIfNone("A/R Others - Fortune Norzagaray", GLAcctType.Asset); dir.AddIfNone("A/R Others - Fortune Meycauayan", GLAcctType.Asset); dir.AddIfNone("A/R Others - Fortune Bignay", GLAcctType.Asset); dir.AddIfNone("A/R Others - BK Balagtas", GLAcctType.Asset); dir.AddIfNone("A/R Others - BK Meycauayan", GLAcctType.Asset); dir.AddIfNone("A/R Others - BK Bignay", GLAcctType.Asset); }
public static void Launch(ITenantDBsDir dir) { var now = DateTime.Now.Date; var bgn = new DateTime(now.Year, now.Month - 1, 1); var end = bgn.AddMonths(1).AddDays(-1); if (!PopUpInput.TryGetDateRange("Clearing Dates of Checks", out (DateTime Start, DateTime End)rng, bgn, end)) { return; } }
public static List <Action> GetActions(ICollectionsDB colxnsDB, ITenantDBsDir dir) { var jobs = new List <Action>(); var balancd = colxnsDB.Date.AddDays(-1); EnqueueBalanceUpdates(jobs, balancd, dir); jobs.Add(() => dir.AddDepositsToPassbook(balancd, true)); jobs.Add(() => colxnsDB.MarkAsOpened()); jobs.Add(() => TerminateExpiredLeases(dir)); return(jobs); }