/// <summary> /// Updates the TransactionPayment /// </summary> /// <param name="TransactionPayment">The TransactionPayment</param> public void UpdateTransactionPayment(TransactionPayment transactionPayment) { if (transactionPayment == null) throw new ArgumentNullException("transactionPayment"); Transaction transaction = new Transaction(); transaction = _context.Transactions.Where(w => w.ID == transactionPayment.TransactionPaymentId).SingleOrDefault(); if (transaction != null) { transaction.ID = transactionPayment.TransactionPaymentId; transaction.Type = transactionPayment.TransactionPaymentType; transaction.Amount = transactionPayment.TransactionPaymentTotal; transaction.Status = transactionPayment.TransactionPaymentStatusId; transaction.MemberId = transactionPayment.MemberId; transaction.MemberIP = transactionPayment.MemberIP; transaction.MemberEmail = transactionPayment.MemberEmail; transaction.PaymentMenthodID = transactionPayment.PaymentMethodId; transaction.ModifyDate = DateTime.Now; _context.SaveChanges(); } }
/// <summary> /// Inserts an TransactionPayment /// </summary> /// <param name="TransactionPayment">TransactionPayment</param> public void InsertTransactionPayment(TransactionPayment transactionPayment) { if (transactionPayment == null) throw new ArgumentNullException("transactionPayment"); Transaction transaction = new Transaction(); transaction.Type = transactionPayment.TransactionPaymentType; transaction.Amount = transactionPayment.TransactionPaymentTotal; transaction.Status = transactionPayment.TransactionPaymentStatusId; transaction.MemberId = transactionPayment.MemberId; transaction.MemberIP = transactionPayment.MemberIP; transaction.MemberEmail = transactionPayment.MemberEmail; transaction.ResponeTranId = transactionPayment.TransactionIDRespone; transaction.PaymentMenthodID = transactionPayment.PaymentMethodId; transaction.AddedDate = DateTime.Now; transaction.ModifyDate = DateTime.Now; _context.AddToTransactions(transaction); _context.SaveChanges(); }
/// <summary> /// Deprecated Method for adding a new object to the Transactions EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToTransactions(Transaction transaction) { base.AddObject("Transactions", transaction); }
/// <summary> /// Gets last TransactionPayment by userID /// </summary> /// <param name="UserId">The UserId identifier</param> /// <returns>TransactionPayment</returns> public TransactionPayment GetTransactionPaymentByUserId(long UserId) { TransactionPayment transactionPayment = new TransactionPayment(); Transaction transaction=new Transaction(); using (var dba = new BetEXDataContainer()) { byte type = (byte)1; var listTransaction = dba.Transactions.Where(w => w.MemberId == UserId && w.Type == type).OrderByDescending(z=>z.Amount).ToList(); if (listTransaction != null) { transaction = listTransaction[0]; } } if (transaction != null) { transactionPayment.TransactionPaymentId = transaction.ID; transactionPayment.TransactionPaymentType = transaction.Type; transactionPayment.MemberId = transaction.MemberId; transactionPayment.MemberIP = transaction.MemberIP; transactionPayment.TransactionIDRespone = transaction.ResponeTranId!=null?transaction.ResponeTranId.Value:0; transactionPayment.TransactionPaymentTotal = transaction.Amount; transactionPayment.TransactionPaymentStatusId = transaction.Status; transactionPayment.PaymentMethodId = transaction.PaymentMenthodID; transactionPayment.MemberEmail = transaction.MemberEmail; } return transactionPayment; }
/// <summary> /// Create a new Transaction object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="type">Initial value of the Type property.</param> /// <param name="amount">Initial value of the Amount property.</param> /// <param name="status">Initial value of the Status property.</param> /// <param name="memberId">Initial value of the MemberId property.</param> /// <param name="paymentMenthodID">Initial value of the PaymentMenthodID property.</param> public static Transaction CreateTransaction(global::System.Int64 id, global::System.Byte type, global::System.Decimal amount, global::System.Int32 status, global::System.Int64 memberId, global::System.Int64 paymentMenthodID) { Transaction transaction = new Transaction(); transaction.ID = id; transaction.Type = type; transaction.Amount = amount; transaction.Status = status; transaction.MemberId = memberId; transaction.PaymentMenthodID = paymentMenthodID; return transaction; }