public async Task SelectBooking(Booking booking) { SelectedBooking = booking; if (SelectedBooking.PaymentAccount == null) { if (booking.AssignedPilot != null) { if (booking.PaymentType == PaymentType.Vipps) { booking.PaymentAccountId = booking.AssignedPilot.VippsPaymentAccountId; } else if (booking.PaymentType == PaymentType.IZettle) { booking.PaymentAccountId = booking.AssignedPilot.IZettlePaymentAccountId; } booking.PaymentAccount = PaymentAccounts.FirstOrDefault(a => a.Id == booking.PaymentAccountId); } } using (var scope = ScopeFactory.CreateScope()) { var db = scope.ServiceProvider.GetService <TandemBookingContext>(); FilteredPaymentAccounts = PaymentAccounts .Where(p => p.PaymentType == booking.PaymentType) .ToList(); FilteredPayments = db.Payments .Where(p => p.PaymentAccountId == SelectedBooking.PaymentAccountId) .Where(p => p.UnreconciledAmount > 0) .AsEnumerable() .OrderBy(p => Math.Abs((p.PaymentDate - (booking.CompletedDate ?? booking.BookingDate)).TotalSeconds)) .ToList(); } }
protected override bool SaveSuccessful() { try { using (new CDS.Client.Desktop.Essential.UTL.WaitCursor()) { this.OnSaveRecord(); if (!IsValid) { return(false); } foreach (BulkPaymentEntry mainLine in BulkPaymentEntries) { Int64 trackingNumber = -1; // Make a new header entry DB.GLX_Header header = BL.GLX.GLX_Header.New; header.TrackId = -1; header.PeriodId = mainLine.PeriodId.Value; header.ReferencePeriodId = mainLine.PeriodId.Value; header.Date = mainLine.Date.Value; header.PostedDate = BL.ApplicationDataContext.Instance.ServerDateTime.Date; header.Reference = mainLine.Reference; header.Description = mainLine.Description; header.StatusId = 52; if (mainLine.Amount >= 0) { // header.Description = "CREDITOR PAYMENT RECEIVED"; header.JournalTypeId = (byte)BL.GLX.GLX_JournalType.Payment; } else { // header.Description = "CREDITOR PAYMENT REVERSAL"; header.JournalTypeId = (byte)BL.GLX.GLX_JournalType.Reversal; } //Double check if this has a use if (!trackingNumber.Equals(-1)) { header.TrackId = trackingNumber; } //Loop through INV or C/N or BBF (Agings) foreach (var agingAmount in mainLine.BulkPaymentItems.Where(n => n.Checked.Equals(true)).GroupBy(g => g.AgingId).Select(l => new { AgingId = l.Key, Balance = l.Sum(i => i.Balance) })) { //DEBTOR LINE DB.GLX_Line linecreditor = BL.GLX.GLX_Line.New; //TODO: ACCOUNT NOT LOADING ON subLine linecreditor.EntityId = mainLine.AccountId.Value; linecreditor.AgingId = agingAmount.AgingId; linecreditor.Amount = -agingAmount.Balance; header.GLX_Line.Add(linecreditor); } //BANK LINE DB.GLX_Line linebank = BL.GLX.GLX_Line.New; linebank.EntityId = Convert.ToInt64(ddlAccount.EditValue); linebank.AgingId = 1; linebank.Amount = mainLine.Amount; header.GLX_Line.Add(linebank); //SETTLEMENT DISCOUNT TAX LINE DB.GLX_Line linesettlementtax = BL.GLX.GLX_Line.New; DB.GLX_Tax taxType = DataContext.EntityAccountingContext .GLX_Tax.FirstOrDefault(n => n.Id == PaymentAccounts .Where(nn => nn.AccountId.Equals(((DB.GLX_Account)ddlSettlementAccount.GetSelectedDataRow()).Id)) .Select(nn => nn.TaxId).FirstOrDefault()); if (taxType != null && taxType.Percentage != 0) { linesettlementtax.Amount = mainLine.Settlement * (1 - taxType.Percentage); } else { linesettlementtax.Amount = mainLine.Settlement; } header.GLX_Line.Add(linesettlementtax); //SETTLEMENT DISCOUNT LINE DB.GLX_Line linesettlement = BL.GLX.GLX_Line.New; linesettlement.EntityId = Convert.ToInt64(ddlSettlementAccount.EditValue); linesettlement.AgingId = 1; linesettlement.Amount = mainLine.Settlement - linesettlementtax.Amount; header.GLX_Line.Add(linesettlement); //Change the subLines's tracking number to the new tracking number foreach (var subLine in mainLine.BulkPaymentItems.Where(n => n.Checked.Equals(true))) { BL.GLX.GLX_Header.UpdateTrackNumber(subLine.HeaderId, trackingNumber, DataContext); } } return(true); } } catch (Exception ex) { HasErrors = true; if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } return(false); } }