public List <CreditCardRowViewModel> GetCreditCards(int id) { var creditCards = _creditCardRepository.GetAllQueryable() .Where(x => x.CustomerId == id && x.Deleted == false).ToList(); creditCards.ForEach(credit => credit.Last4DigitsHash = Decrypt(credit.Last4DigitsHash)); var creditCardRowViewModels = _mapper.Map <List <CreditCard>, List <CreditCardRowViewModel> >(creditCards); return(creditCardRowViewModels); }
public List <TransactionDataTable> GetTransactions(string username, int page, int pageSize) { var transactionAllRecord = (from PM in _paymentRepository.GetAllQueryable() join CDC in _creditCardRepository.GetAllQueryable() on PM.CreditCartId equals CDC.Id join Cus in _customerRepository.GetAllQueryable() on CDC.CustomerId equals Cus.Id where Cus.Username == username select new TransactionDataTable() { Amount = PM.Amount, Description = PM.Description, CreatedAtUTC = PM.CreatedAtUTC, Type = "Payment" } ).Union( from RP in _refundRepository.GetAllQueryable() join PM in _paymentRepository.GetAllQueryable() on RP.PaymentId equals PM.Id join CDC in _creditCardRepository.GetAllQueryable() on PM.CreditCartId equals CDC.Id join Cus in _customerRepository.GetAllQueryable() on CDC.CustomerId equals Cus.Id where Cus.Username == username select new TransactionDataTable() { Amount = RP.Amount, Description = RP.Description, CreatedAtUTC = RP.CreatedAtUTC, Type = "Refund" } ) .Union( from PO in _payoutRepository.GetAllQueryable() //join PM in _paymentRepository.GetAllQueryable() on PO.PaymentId equals PM.Id //join CDC in _creditCardRepository.GetAllQueryable() on PM.CreditCartId equals CDC.Id //join Cus in _customerRepository.GetAllQueryable() on CDC.CustomerId equals Cus.Id where PO.Ticket.Seller.Username == username select new TransactionDataTable() { Amount = PO.Amount, Description = PO.Description, CreatedAtUTC = PO.CreatedAtUTC, Type = "Payout" } ).OrderByDescending(x => x.CreatedAtUTC).Skip((page - 1) * pageSize).Take(pageSize).ToList(); ////var listRefund = //// (from RP in _refundRepository.GetAllQueryable() //// join PM in _paymentRepository.GetAllQueryable() on RP.PaymentId equals PM.Id //// join CDC in _creditCardRepository.GetAllQueryable() on PM.CreditCartId equals CDC.Id //// join Cus in _customerRepository.GetAllQueryable() on CDC.CustomerId equals Cus.Id //// where Cus.Username == username //// select new TransactionDataTable() //// { //// Amount = RP.Amount, //// Description = RP.Description, //// CreatedAtUTC = RP.CreatedAtUTC //// } //// ); ////var listPayout = //// (from PO in _payoutRepository.GetAllQueryable() //// join PM in _paymentRepository.GetAllQueryable() on PO.PaymentId equals PM.Id //// join CDC in _creditCardRepository.GetAllQueryable() on PM.CreditCartId equals CDC.Id //// join Cus in _customerRepository.GetAllQueryable() on CDC.CustomerId equals Cus.Id //// where Cus.Username == username //// select new TransactionDataTable() //// { //// Amount = PO.Amount, //// Description = PO.Description, //// CreatedAtUTC = PO.CreatedAtUTC //// } //// ); //////add 3 list thành 1 list ////List<TransactionDataTable> transactionAllRecord = null; ////foreach(var item in listPayment) ////{ //// var paymentItem = _mapper.Map<PaymentTransactionViewModel, TransactionDataTable>(item); //// transactionAllRecord.Add(paymentItem); ////} ////foreach (var item in listPayout) ////{ //// var payoutItem = _mapper.Map<PayoutTransactionViewModel, TransactionDataTable>(item); //// transactionAllRecord.Add(payoutItem); ////} ////foreach (var item in listRefund) ////{ //// var refundItem = _mapper.Map<RefundTransactionViewModel, TransactionDataTable>(item); //// transactionAllRecord.Add(refundItem); ////} return(transactionAllRecord); }