Example #1
0
        public async Task <PaymentHistoryDTO> GetPaymentHistoryById(long id)
        {
            Payment payment = await _iPaymentRepository.GetPayment(id);

            PaymentHistoryDTO paymentHistoryDTO = _iPaymentHistoryDTO.MapToPaymentHistoryDTO(payment);

            return(paymentHistoryDTO);
        }
Example #2
0
        protected void btnAddPaymentHistory_Click(object sender, EventArgs e)
        {
            MyFileItAppServiceClient obj        = new MyFileItAppServiceClient();
            MyFileItResult           result     = new MyFileItResult();
            PaymentHistoryDTO        objPayment = new PaymentHistoryDTO();

            objPayment.PRIMARYAPPUSERID    = 2;
            objPayment.DATEPURCHASED       = DateTime.UtcNow;
            objPayment.QUANTITY            = 1;
            objPayment.ITEM                = "ShareKey";
            objPayment.AMOUNT              = Convert.ToDecimal("3.99");;
            objPayment.LAST4CC             = "1111";
            objPayment.PROMOCODE           = "";
            objPayment.AUTHORIZATIONNUMBER = "0000";
            //objPayment.NAME = "Test Name";

            result = obj.AddPaymentHistory(appGlobal.username, appGlobal.password, objPayment);
        }
Example #3
0
        //hàm lay lich su giao dich cua khach hang
        public List <PaymentHistoryDTO> GetInfoPaymentFromAccID(string Accid)
        {
            //danh sach thong tin giao dich
            List <PaymentHistoryDTO> list = new List <PaymentHistoryDTO>();


            try
            {
                //cau lenh query lay thong tin giao dich
                string sql = "select c.BillID, a.ProductName, b.NgayDat, c.Size, c.Amount, c.TotalPrice "
                             + "from Product a, Payment b, PaymentInfo c where b.AccID = @id and c.BillID = b.BillID and a.ProductID = c.ProductID";

                SqlParameter id = new SqlParameter("@id", System.Data.SqlDbType.NVarChar);
                id.Value = Accid;

                SqlDataReader reader = ReadDataPars(sql, new[] { id });


                while (reader.Read())
                {
                    //truyen thong tin giao dich vao danh sach
                    PaymentHistoryDTO a = new PaymentHistoryDTO();
                    a.BillID      = reader.GetString(0);
                    a.ProductName = reader.GetString(1);
                    a.NgayDat     = reader.GetDateTime(2);
                    a.Size        = reader.GetString(3);
                    a.Amount      = reader.GetInt32(4);
                    a.TotalPrice  = reader.GetSqlMoney(5).ToString();
                    list.Add(a);
                }
                reader.Close();
            }catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                closeConnection();
            }

            return(list);
        }