Issue: [BUG] payment_method_type for cards is null

### Bug Description

payment_method_type is a sub category of payment_method for defining the the payment_method's type. This is useful for PMs like banks and wallets to differentiate between SEPA / BACS / ACH banks or APay / GPay wallets, and helpful in similar way for other PMs.

This field is sent in the request when the consumer is requesting for initiating a payment.

However, the consumer might not be aware of what's the type of the card (credit vs debit), that's why this field is optional for cards.

This field is expected to be populated for cards for known card BINs.

### Expected Behavior

This field should be populated for known card BINs.

### Actual Behavior

This field is empty for cards if payment_method_type was not specified in the request.

### Steps To Reproduce

Make a card payment without passing `payment_method_type`

### Have you spent some time checking if this bug has been raised before?

- [X] I checked and didn't find a similar issue

### Have you read the Contributing Guidelines?

- [X] I have read the [Contributing Guidelines](https://github.com/juspay/hyperswitch/blob/main/docs/CONTRIBUTING.md)

### Are you willing to submit a PR?

Yes, I am willing to submit a PR!

Resolution: <think>
PR Context:
- Title: fix(payments): populate payment_method_type in payment_attempt for cards
- Merged: 2024-11-13T10:04:00Z
- Files changed: 3 files
- Commits: 7 commits

Implementation approach:
## Type of Change
<!-- Put an `x` in the boxes that apply -->

- [x] Bugfix
- [ ] New feature
- [ ] Enhancement
- [ ] Refactoring
- [ ] Dependency updates
- [ ] Documentation
- [ ] CI/CD

## Description
Described in #6512 

### Additional Changes

- [ ] This PR modifies the API contract
- [ ] This PR modifies the database schema
- [ ] This PR modifies application configuration/environment variables

<!--
Provide links to the files with corresponding changes.

Following are
</think>

To implement this, you'll need to modify:


**Detailed Implementation:**


**Commit 1:** fix(payments): populate payment_method_type in payment_attempt for cards (#6519)
Files to modify:


**crates/router/src/core/payments/operations/payment_confirm.rs**
  Modify existing code

**crates/router/src/core/payments/operations/payment_create.rs**
  Modify existing code

**crates/router/src/core/payments/transformers.rs**
  Add:
    - function: private::foreign_from
    - impl: impl ForeignFrom<(Self, Option<&api_models::payments::AdditionalPaymentData>)> for Option<enums::PaymentMethodType>