public static IEnumerable<ChequesTransactionModel> GetForeignChequesByCurrency(int currencyId, PaymentType paymentType, DateTime today) { var tomm = today.AddDays(1); var query = from chq in Context.Cheques join pymnt in Context.Payments.Where(entity => entity.PaymentTypeId == paymentType.Id) on chq.PaymentId equals pymnt.Id join assoc in Context.PaymentCurrencyAssocs on pymnt.Id equals assoc.PaymentId where pymnt.EntryDate >= today && pymnt.EntryDate < tomm && assoc.CurrencyId == currencyId select pymnt; List<ChequesTransactionModel> chequesDisbursedList = new List<ChequesTransactionModel>(); foreach (var item in query) { chequesDisbursedList.Add(new ChequesTransactionModel(item)); } return chequesDisbursedList; }
public static IEnumerable<ChequesTransactionModel> GetPhilippineCheques(PaymentType paymentType, DateTime today) { var philCurrency = Currency.GetCurrencyBySymbol("PHP").Id; var tomm = today.AddDays(1); var query = from chq in Context.Cheques join pymnt in Context.Payments.Where(entity => entity.PaymentTypeId == paymentType.Id) on chq.PaymentId equals pymnt.Id where pymnt.EntryDate >= today && pymnt.EntryDate < tomm select pymnt; var foreign = from chq in Context.Cheques join pymnt in Context.Payments.Where(entity => entity.PaymentTypeId == paymentType.Id) on chq.PaymentId equals pymnt.Id join assoc in Context.PaymentCurrencyAssocs on pymnt.Id equals assoc.PaymentId where pymnt.EntryDate >= today && pymnt.EntryDate < tomm && assoc.CurrencyId != philCurrency select pymnt; var cancelledpostdatedcheques = from chq in Context.Cheques join pymnt in Context.Payments.Where(entity => entity.PaymentTypeId == paymentType.Id) on chq.PaymentId equals pymnt.Id join chqassoc in Context.ChequeApplicationAssocs on chq.Id equals chqassoc.ChequeId join las in Context.LoanApplicationStatus on chqassoc.ApplicationId equals las.ApplicationId where las.IsActive == true && (las.LoanApplicationStatusType.Id == LoanApplicationStatusType.RejectedType.Id || las.LoanApplicationStatusType.Id == LoanApplicationStatusType.CancelledType.Id) select pymnt; List<ChequesTransactionModel> chequesDisbursedList = new List<ChequesTransactionModel>(); var result = query.Except(foreign); result = result.Except(cancelledpostdatedcheques); foreach (var item in result) { chequesDisbursedList.Add(new ChequesTransactionModel(item)); } return chequesDisbursedList; }
public static IEnumerable<ChequesTransactionModel> GetAllCheques(PaymentType paymentType, DateTime today) { var tomm = today.AddDays(1); var query = from chq in Context.Cheques join pymnt in Context.Payments.Where(entity => entity.PaymentTypeId == paymentType.Id) on chq.PaymentId equals pymnt.Id where pymnt.EntryDate >= today && pymnt.EntryDate < tomm select pymnt; List<ChequesTransactionModel> chequesDisbursedList = new List<ChequesTransactionModel>(); foreach (var item in query) { chequesDisbursedList.Add(new ChequesTransactionModel(item)); } return chequesDisbursedList; }
public static Payment CreatePayment(DateTime entryDate, DateTime transactionDate, int processedToPartyRoleId, int processedByPartyRoleId, decimal totalAmount, PaymentType paymentType, PaymentMethodType paymentMethodType, SpecificPaymentType specificPaymentType, string paymentReferenceNumber) { Payment newPayment = new Payment(); newPayment.EntryDate = entryDate; newPayment.TransactionDate = transactionDate; newPayment.ProcessedToPartyRoleId = processedToPartyRoleId; newPayment.ProcessedByPartyRoleId = processedByPartyRoleId;//partytroleID of teller newPayment.TotalAmount = totalAmount; newPayment.PaymentTypeId = paymentType.Id; newPayment.PaymentMethodTypeId = paymentMethodType.Id; newPayment.SpecificPaymentTypeId = specificPaymentType.Id; newPayment.PaymentReferenceNumber = paymentReferenceNumber; return newPayment; }
public static IEnumerable<PaymentBreakdown> GetBreakdown(int parentPaymentId, PaymentType paymenttype) { var Payments = from p in Context.Payments where p.ParentPaymentId == parentPaymentId && p.PaymentTypeId == paymenttype.Id select p; if (Payments.Count() == 0) { var parentPayment = from p in Context.Payments where p.Id == parentPaymentId select new PaymentBreakdown { PaymentMethod = p.PaymentMethodType.Name, TotalAmount = p.TotalAmount, CheckNumber = "N/A", Payment = p }; return parentPayment; } else { var cashBreakdown = from p in Payments where p.PaymentMethodTypeId == PaymentMethodType.CashType.Id select new PaymentBreakdown { PaymentMethod = p.PaymentMethodType.Name, TotalAmount = p.TotalAmount, CheckNumber = "N/A", Payment = p }; var atmBreakdown = from p in Payments where p.PaymentMethodTypeId == PaymentMethodType.ATMType.Id select new PaymentBreakdown { PaymentMethod = p.PaymentMethodType.Name, TotalAmount = p.TotalAmount, CheckNumber = p.PaymentReferenceNumber, Payment = p }; var checkBreakDown = from p in Payments where (p.PaymentMethodTypeId == PaymentMethodType.PayCheckType.Id || p.PaymentMethodTypeId == PaymentMethodType.PersonalCheckType.Id) select new PaymentBreakdown { PaymentMethod = p.PaymentMethodType.Name, TotalAmount = p.TotalAmount, CheckNumber = p.PaymentReferenceNumber, Payment = p }; var breakdown = cashBreakdown.Concat(atmBreakdown).Concat(checkBreakDown); return breakdown; } }
public static Payment RetrieveAssociatedPayment(int receiptId, PaymentType type) { var payments = from rpa in Context.ReceiptPaymentAssocs join p in Context.Payments on rpa.PaymentId equals p.Id where p.PaymentTypeId == type.Id && rpa.ReceiptId == receiptId select p; return payments.First(); }
public static List<Receipt> RetrieveAssociatedReceipts(Payment payment, PaymentType type) { var receipts = from rpa in Context.ReceiptPaymentAssocs join p in Context.Payments on rpa.PaymentId equals p.Id where p.PaymentTypeId == type.Id && rpa.PaymentId == payment.Id select rpa.Receipt; return receipts.ToList(); }