/// <summary> /// Get Journal Entry Details by AccountingDocumentId List. /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <JournalEntryDetailUnitDto> > GetJournalDetailsByDocumentId( GetTransactionList input) { var query = from journals in _journalEntryDocumentDetailUnitRepository.GetAll() join job in _jobUnitRepository.GetAll() on journals.JobId equals job.Id into job from jobs in job.DefaultIfEmpty() join line in _accountUnitRepository.GetAll() on journals.AccountId equals line.Id into line from lines in line.DefaultIfEmpty() join subAccount1 in _subAccountUnitRepository.GetAll() on journals.SubAccountId1 equals subAccount1.Id into subAccount1 from subAccounts1 in subAccount1.DefaultIfEmpty() join subAccount2 in _subAccountUnitRepository.GetAll() on journals.SubAccountId2 equals subAccount2.Id into subAccount2 from subAccounts2 in subAccount2.DefaultIfEmpty() join subAccount3 in _subAccountUnitRepository.GetAll() on journals.SubAccountId3 equals subAccount3.Id into subAccount3 from subAccounts3 in subAccount3.DefaultIfEmpty() join vendor in _vendorUnitRepository.GetAll() on journals.VendorId equals vendor.Id into vendor from vendors in vendor.DefaultIfEmpty() join taxCredit in _taxCreditUnitRepository.GetAll() on journals.TaxRebateId equals taxCredit.Id into taxCredit from taxCredits in taxCredit.DefaultIfEmpty() select new { JournalDetails = journals, jobs.JobNumber, lines.AccountNumber, SubAccountNumber1 = subAccounts1.SubAccountNumber, SubAccountNumber2 = subAccounts2.SubAccountNumber, SubAccountNumber3 = subAccounts3.SubAccountNumber, vendorLastName = vendors.LastName, taxCreditNumber = taxCredits.Number }; query = query.Where(p => p.JournalDetails.AccountingDocumentId.Value == input.AccountingDocumentId); var results = await query .AsNoTracking() .ToListAsync(); var mapResult = results.Select(item => { var dto = item.JournalDetails.MapTo <JournalEntryDetailUnitDto>(); dto.AccountingItemId = item.JournalDetails.Id; dto.JobNumber = item.JobNumber; dto.AccountNumber = item.AccountNumber; dto.SubAccountNumber1 = item.SubAccountNumber1; dto.SubAccountNumber2 = item.SubAccountNumber2; dto.SubAccountNumber3 = item.SubAccountNumber3; dto.VendorName = item.vendorLastName; dto.TaxRebateNumber = item.taxCreditNumber; return(dto); }).ToList(); return(new PagedResultOutput <JournalEntryDetailUnitDto>(mapResult.Count, mapResult)); }
/// <summary> /// /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <PurchaseOrderHistoryUnitDto> > GetPurchaseOrderHistoryByAccountingDocumentId(GetTransactionList input) { var query = from pODetail in _purchaseOrderHistoryRepository.GetAll() join user in _userUnitRepository.GetAll() on pODetail.CreatorUserId equals user.Id into users from userunits in users.DefaultIfEmpty() join job in _jobUnitRepository.GetAll() on pODetail.JobId equals job.Id into jobunit from jobs in jobunit.DefaultIfEmpty() join line in _accountUnitRepository.GetAll() on pODetail.AccountId equals line.Id into account from lines in account.DefaultIfEmpty() join subAccount1 in _subAccountUnitRepository.GetAll() on pODetail.SubAccountId1 equals subAccount1.Id into subAccount1 from subAccounts1 in subAccount1.DefaultIfEmpty() join subAccount2 in _subAccountUnitRepository.GetAll() on pODetail.SubAccountId2 equals subAccount2.Id into subAccount2 from subAccounts2 in subAccount2.DefaultIfEmpty() join vendor in _vendorUnitRepository.GetAll() on pODetail.VendorId equals vendor.Id into vendor from vendors in vendor.DefaultIfEmpty() join taxCredit in _taxCreditUnitRepository.GetAll() on pODetail.TaxRebateId equals taxCredit.Id into taxCredit from taxCredits in taxCredit.DefaultIfEmpty() select new { POHDetails = pODetail, jobs.JobNumber, lines.AccountNumber, subAccount1 = subAccounts1.Description, taxCreditNumber = taxCredits.Number, VendorName = vendors.LastName, CreatedUser = userunits.Name }; query = query.Where(p => p.POHDetails.AccountingDocumentId.Value == input.AccountingDocumentId); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("POHDetails.CreationTime DESC", input.Sorting)) .PageBy(input) .ToListAsync(); return(new PagedResultOutput <PurchaseOrderHistoryUnitDto>(results.Count, results.Select(item => { var dto = item.POHDetails.MapTo <PurchaseOrderHistoryUnitDto>(); dto.SubAccountNumber1 = item.subAccount1; dto.JobNumber = item.JobNumber; dto.AccountNumber = item.AccountNumber; dto.TaxRebateNumber = item.taxCreditNumber; dto.TypeOf1099T4 = item.POHDetails.TypeOf1099T4Id != null ? item.POHDetails.TypeOf1099T4Id.ToDisplayName() : ""; dto.VendorName = item.VendorName; dto.AccountingItemId = item.POHDetails.Id; dto.ModificationType = item.POHDetails.ModificationTypeId != null ? item.POHDetails.ModificationTypeId.ToDisplayName() : ""; dto.SourceType = item.POHDetails.SourceTypeId != null ? item.POHDetails.SourceTypeId.ToDisplayName() : ""; dto.CreatedUser = item.CreatedUser; return dto; }).ToList())); }
/// <summary> /// /// </summary> /// <param name="input"></param> /// <returns></returns> public Task <PagedResultOutput <CreditCardEntryDocumentUnitDto> > GetCreditCardDetailsByDocumentId(GetTransactionList input) { return(null); }
public async Task <PagedResultOutput <InvoiceEntryDocumentDetailUnitDto> > GetAPHeaderTransactionDetailUnitsByAccountingDocumentId(GetTransactionList input) { var query = from invoices in _invoiceEntryDocumentDetailUnitRepository.GetAll() join job in _jobUnitRepository.GetAll() on invoices.JobId equals job.Id into jobunit from jobs in jobunit.DefaultIfEmpty() join line in _accountUnitRepository.GetAll() on invoices.AccountId equals line.Id into account from lines in account.DefaultIfEmpty() join subAccount1 in _subAccountUnitRepository.GetAll() on invoices.SubAccountId1 equals subAccount1.Id into subAccountunit1 from subAccounts1 in subAccountunit1.DefaultIfEmpty() join subAccount2 in _subAccountUnitRepository.GetAll() on invoices.SubAccountId2 equals subAccount2.Id into subAccountunit2 from subAccounts2 in subAccountunit2.DefaultIfEmpty() join subAccount3 in _subAccountUnitRepository.GetAll() on invoices.SubAccountId3 equals subAccount3.Id into subAccountunit3 from subAccounts3 in subAccountunit2.DefaultIfEmpty() join taxCredit in _taxCreditUnitRepository.GetAll() on invoices.TaxRebateId equals taxCredit.Id into taxCreditunit from taxCredits in taxCreditunit.DefaultIfEmpty() select new { InvoiceDetails = invoices, JobNumber = jobs.JobNumber, accountDesc = lines.AccountNumber, subAccount1 = subAccounts1.Description, subAccount2 = subAccounts2.Description, subAccount3 = subAccounts3.Description, taxCredit = taxCredits.Number }; query = query.Where(p => p.InvoiceDetails.AccountingDocumentId.Value == input.AccountingDocumentId); var results = await query.AsNoTracking().ToListAsync(); return(new PagedResultOutput <InvoiceEntryDocumentDetailUnitDto>(results.Count, results.Select(item => { var dto = item.InvoiceDetails.MapTo <InvoiceEntryDocumentDetailUnitDto>(); dto.AccountNumber = item.accountDesc; dto.JobNumber = item.JobNumber; dto.SubAccountNumber1 = item.subAccount1; dto.SubAccountNumber2 = item.subAccount2; dto.SubAccountNumber3 = item.subAccount3; dto.TaxRebateNumber = item.taxCredit; dto.AccountingItemId = item.InvoiceDetails.Id; dto.TypeOf1099T4 = item.InvoiceDetails.TypeOf1099T4Id != null ? item.InvoiceDetails.TypeOf1099T4Id.ToDisplayName() : ""; dto.ActualAmount = item.InvoiceDetails.Amount.Value;// this is to maintainning the actual Amount on calculation return dto; }).ToList())); }
public async Task <PagedResultOutput <PayrollEntryDocumentDetailUnitDto> > GetPayrollEntryDocumentDetailsByAccountingDocumentId(GetTransactionList input) { var query = from payrolls in _payrollEntryDocumentDetailUnitRepository.GetAll() join job in _jobUnitRepository.GetAll() on payrolls.JobId equals job.Id into jobunit from jobs in jobunit.DefaultIfEmpty() join line in _accountUnitRepository.GetAll() on payrolls.AccountId equals line.Id into account from lines in account.DefaultIfEmpty() join subAccount1 in _subAccountUnitRepository.GetAll() on payrolls.SubAccountId1 equals subAccount1.Id into subAccountunit1 from subAccounts1 in subAccountunit1.DefaultIfEmpty() join subAccount2 in _subAccountUnitRepository.GetAll() on payrolls.SubAccountId2 equals subAccount2.Id into subAccountunit2 from subAccounts2 in subAccountunit2.DefaultIfEmpty() join taxCredit in _taxCreditUnitRepository.GetAll() on payrolls.TaxRebateId equals taxCredit.Id into taxCreditunit from taxCredits in taxCreditunit.DefaultIfEmpty() select new { PayrollDetails = payrolls, JobDesc = jobs.JobNumber, accountDesc = lines.AccountNumber, subAccount1 = subAccounts1.Description, subAccount2 = subAccounts2.Description, taxCredit = taxCredits.Number }; query = query.Where(p => p.PayrollDetails.AccountingDocumentId.Value == input.AccountingDocumentId); var results = await query.AsNoTracking().ToListAsync(); return(new PagedResultOutput <PayrollEntryDocumentDetailUnitDto>(results.Count, results.Select(item => { var dto = item.PayrollDetails.MapTo <PayrollEntryDocumentDetailUnitDto>(); dto.AccountNumber = item.accountDesc; dto.SubAccountNumber1 = item.subAccount1; dto.JobLocation = item.subAccount2; dto.TaxRebateNumber = item.taxCredit; dto.AccountingDocumentId = item.PayrollDetails.Id; return dto; }).ToList())); }
private static void RunMethod(string methodName) { // These are default transaction keys. // You can create your own keys in seconds by signing up for a sandbox account here: https://developer.authorize.net/sandbox/ string apiLoginId = "5KP3u95bQpv"; string transactionKey = "4Ktq966gC55GAX7S"; string transactionAmount; string transactionId = string.Empty; switch (methodName) { case "ValidateCustomerPaymentProfile": ValidateCustomerPaymentProfile.Run(apiLoginId, transactionKey); break; case "UpdateCustomerShippingAddress": UpdateCustomerShippingAddress.Run(apiLoginId, transactionKey); break; case "UpdateCustomerProfile": UpdateCustomerProfile.Run(apiLoginId, transactionKey); break; case "UpdateCustomerPaymentProfile": UpdateCustomerPaymentProfile.Run(apiLoginId, transactionKey); break; case "GetCustomerShippingAddress": GetCustomerShippingAddress.Run(apiLoginId, transactionKey); break; case "GetCustomerProfileIds": GetCustomerProfileIds.Run(apiLoginId, transactionKey); break; case "GetCustomerProfile": GetCustomerProfile.Run(apiLoginId, transactionKey); break; case "GetCustomerPaymentProfile": GetCustomerPaymentProfile.Run(apiLoginId, transactionKey); break; case "DeleteCustomerShippingAddress": DeleteCustomerShippingAddress.Run(apiLoginId, transactionKey); break; case "DeleteCustomerProfile": DeleteCustomerProfile.Run(apiLoginId, transactionKey); break; case "DeleteCustomerPaymentProfile": DeleteCustomerPaymentProfile.Run(apiLoginId, transactionKey); break; case "CreateCustomerShippingAddress": CreateCustomerShippingAddress.Run(apiLoginId, transactionKey); break; case "CreateCustomerProfileFromTransaction": CreateCustomerProfileFromTransaction.Run(apiLoginId, transactionKey); break; case "GetTransactionDetails": GetTransactionDetails.Run(apiLoginId, transactionKey); break; case "GetTransactionList": GetTransactionList.Run(apiLoginId, transactionKey); break; //case "CreateAnApplePayTransaction": // CreateAnApplePayTransaction.Run(apiLoginId, transactionKey); // break; case "DecryptVisaCheckoutData": DecryptVisaCheckoutData.Run(apiLoginId, transactionKey); break; case "CreateVisaCheckoutTransaction": CreateVisaCheckoutTransaction.Run(apiLoginId, transactionKey); break; case "ChargeCreditCard": ChargeCreditCard.Run(apiLoginId, transactionKey); break; case "CaptureOnly": CaptureOnly.Run(apiLoginId, transactionKey); break; case "CapturePreviouslyAuthorizedAmount": Console.WriteLine("Enter An Transaction Amount"); transactionAmount = Console.ReadLine(); Console.WriteLine("Enter An Transaction ID"); transactionId = Console.ReadLine(); CapturePreviouslyAuthorizedAmount.Run(apiLoginId, transactionKey, Convert.ToDecimal(transactionAmount), transactionId); break; case "CaptureFundsAuthorizedThroughAnotherChannel": CaptureFundsAuthorizedThroughAnotherChannel.Run(apiLoginId, transactionKey); break; case "AuthorizeCreditCard": AuthorizeCreditCard.Run(apiLoginId, transactionKey); break; case "Refund": Console.WriteLine("Enter An Transaction Amount"); transactionAmount = Console.ReadLine(); Console.WriteLine("Enter An Transaction ID"); transactionId = Console.ReadLine(); RefundTransaction.Run(apiLoginId, transactionKey, Convert.ToDecimal(transactionAmount), transactionId); break; case "Void": Console.WriteLine("Enter An Transaction ID"); transactionId = Console.ReadLine(); VoidTransaction.Run(apiLoginId, transactionKey, transactionId); break; case "DebitBankAccount": DebitBankAccount.Run(apiLoginId, transactionKey); break; case "CreditBankAccount": Console.WriteLine("Enter An Transaction ID"); transactionId = Console.ReadLine(); CreditBankAccount.Run(apiLoginId, transactionKey, transactionId); break; case "ChargeCustomerProfile": ChargeCustomerProfile.Run(apiLoginId, transactionKey); break; case "ChargeTokenizedCard": ChargeTokenizedCreditCard.Run(apiLoginId, transactionKey); break; case "PayPalVoid": PayPalVoid.Run(apiLoginId, transactionKey, transactionId); break; case "PayPalAuthorizeCapture": PayPalAuthorizeCapture.Run(apiLoginId, transactionKey); break; case "PayPalAuthorizeCaptureContinue": PayPalAuthorizeCaptureContinue.Run(apiLoginId, transactionKey, transactionId); break; case "PayPalAuthorizeOnly": PayPalAuthorizeOnly.Run(apiLoginId, transactionKey); break; case "PayPalAuthorizeOnlyContinue": PayPalAuthorizeCaptureContinue.Run(apiLoginId, transactionKey, transactionId); break; case "PayPalCredit": PayPalCredit.Run(apiLoginId, transactionKey, transactionId); break; case "PayPalGetDetails": PayPalGetDetails.Run(apiLoginId, transactionKey, transactionId); break; case "PayPalPriorAuthorizationCapture": PayPalPriorAuthorizationCapture.Run(apiLoginId, transactionKey, transactionId); break; case "CancelSubscription": CancelSubscription.Run(apiLoginId, transactionKey); break; case "CreateSubscription": CreateSubscription.Run(apiLoginId, transactionKey); break; case "GetSubscriptionList": GetListSubscriptions.Run(apiLoginId, transactionKey); break; case "GetSubscriptionStatus": GetSubscriptionStatus.Run(apiLoginId, transactionKey); break; case "UpdateSubscription": UpdateSubscription.Run(apiLoginId, transactionKey); break; case "CreateCustomerProfile": CreateCustomerProfile.Run(apiLoginId, transactionKey); break; case "CreateCustomerPaymentProfile": CreateCustomerPaymentProfile.Run(apiLoginId, transactionKey); break; case "GetUnsettledTransactionList": GetUnsettledTransactionList.Run(apiLoginId, transactionKey); break; case "GetBatchStatistics": GetBatchStatistics.Run(apiLoginId, transactionKey); break; case "GetSettledBatchList": GetSettledBatchList.Run(apiLoginId, transactionKey); break; default: ShowUsage(); break; } }
/// <summary> /// /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <ArInvoiceEntryDetailUnitDto> > GetArInvoiceByAccountingDocumentId(GetTransactionList input) { var query = from invoices in _arInvoiceEntryDocumentDetailUnitRepository.GetAll() join job in _jobUnitRepository.GetAll() on invoices.JobId equals job.Id into jobunit from jobs in jobunit.DefaultIfEmpty() join line in _accountUnitRepository.GetAll() on invoices.AccountId equals line.Id into account from lines in account.DefaultIfEmpty() join subAccount1 in _subAccountUnitRepository.GetAll() on invoices.SubAccountId1 equals subAccount1.Id into subAccount1 from subAccounts1 in subAccount1.DefaultIfEmpty() join subAccount4 in _subAccountUnitRepository.GetAll() on invoices.SubAccountId4 equals subAccount4.Id into subAccountunit4 from subAccounts4 in subAccountunit4.DefaultIfEmpty() select new { InvoiceDetails = invoices, JobNumber = jobs.JobNumber, accountNumber = lines.AccountNumber, subAccount1 = subAccounts1.Description, subAccount4 = subAccounts4.Description }; query = query.Where(p => p.InvoiceDetails.AccountingDocumentId.Value == input.AccountingDocumentId); var results = await query.AsNoTracking().ToListAsync(); return(new PagedResultOutput <ArInvoiceEntryDetailUnitDto>(results.Count, results.Select(item => { var dto = item.InvoiceDetails.MapTo <ArInvoiceEntryDetailUnitDto>(); dto.SubAccountNumber1 = item.subAccount1; dto.SubAccountNumber4 = item.subAccount4; dto.JobNumber = item.JobNumber; dto.AccountNumber = item.accountNumber; dto.AccountingDocumentId = item.InvoiceDetails.Id; return dto; }).ToList())); }