Bug: [FIX] Fix the functionality to show both the disabled and enabled connectors while List Merchant Connector Account



### Feature Description

Fix the functionality to show both the disabled and enabled connectors while List Merchant Connector Account

### Possible Implementation

Fix the functionality to show both the disabled and enabled connectors while List Merchant Connector Account

### Have you spent some time checking if this feature request 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!
diff --git a/crates/diesel_models/src/query/merchant_connector_account.rs b/crates/diesel_models/src/query/merchant_connector_account.rs
index cc73bd7a532..bd24d12ec22 100644
--- a/crates/diesel_models/src/query/merchant_connector_account.rs
+++ b/crates/diesel_models/src/query/merchant_connector_account.rs
@@ -124,9 +124,7 @@ impl MerchantConnectorAccount {
         if get_disabled {
             generics::generic_filter::<<Self as HasTable>::Table, _, _, _>(
                 conn,
-                dsl::merchant_id
-                    .eq(merchant_id.to_owned())
-                    .and(dsl::disabled.eq(true)),
+                dsl::merchant_id.eq(merchant_id.to_owned()),
                 None,
                 None,
                 Some(dsl::created_at.asc()),
diff --git a/crates/router/src/core/payment_methods/cards.rs b/crates/router/src/core/payment_methods/cards.rs
index 5a12334c385..9fe8d899ea3 100644
--- a/crates/router/src/core/payment_methods/cards.rs
+++ b/crates/router/src/core/payment_methods/cards.rs
@@ -3700,7 +3700,12 @@ pub async fn get_mca_status(
             .change_context(errors::ApiErrorResponse::MerchantConnectorAccountNotFound {
                 id: merchant_id.to_string(),
             })?;
+
         let mut mca_ids = HashSet::new();
+        let mcas = mcas
+            .into_iter()
+            .filter(|mca| mca.disabled == Some(true))
+            .collect::<Vec<_>>();
 
         for mca in mcas {
             mca_ids.insert(mca.merchant_connector_id);

## Type of Change
<!-- Put an `x` in the boxes that apply -->

- [ ] Bugfix
- [ ] New feature
- [ ] Enhancement
- [ ] Refactoring
- [ ] Dependency updates
- [ ] Documentation
- [ ] CI/CD

## Description
revert the filter for getting the mcas which are disabled, and explicitly get the Mca that are disabled


### 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 the paths where you can find config files:
1. `config`
2. `crates/router/src/configs`
3. `loadtest/config`
-->


## Motivation and Context
<!--
Why is this change required? What problem does it solve?
If it fixes an open issue, please link to the issue here.

If you don't have an issue, we'd recommend starting with one first so the PR
can focus on the implementation (unless it is an obvious bug or documentation fix
that will have little conversation).
-->


## How did you test it?
 
 - All the MCA's either disabled/enabled will show in the LIST MCAs
 ```
 Response
 [
    {
        "connector_type": "fiz_operations",
        "connector_name": "cybersource",
        "connector_label": "cybersource_US_default_2",
        "merchant_connector_id": "mca_JfI8xFhxTnL5q2bFhpUW",
        "profile_id": "pro_NMDohQHyrqzAkUjBjDmB",
      
        "payment_methods_enabled": [
            {
                "payment_method": "card",
                "payment_method_types": [
                    {
                        "payment_method_type": "credit",
                        "payment_experience": null,
                        "card_networks": [
                            "Visa",
                            "Mastercard"
                        ],
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    },
                    {
                        "payment_method_type": "debit",
                        "payment_experience": null,
                        "card_networks": [
                            "Visa",
                            "Mastercard"
                        ],
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    }
                ]
            },
            {
                "payment_method": "bank_debit",
                "payment_method_types": [
                    {
                        "payment_method_type": "ach",
                        "payment_experience": null,
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 0,
                        "maximum_amount": 10000,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    }
                ]
            },
            {
                "payment_method": "wallet",
                "payment_method_types": [
                    {
                        "payment_method_type": "google_pay",
                        "payment_experience": "invoke_sdk_client",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    },
                    {
                        "payment_method_type": "apple_pay",
                        "payment_experience": "invoke_sdk_client",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    },
                    {
                        "payment_method_type": "paypal",
                        "payment_experience": "redirect_to_url",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    }
                ]
            }
        ],
        "connector_webhook_details": {
            "merchant_secret": "samraat",
            "additional_secret": null
        },
        "metadata": {
            "google_pay": {
                "merchant_info": {
                    "merchant_id": "vbewlji",
                    "merchant_name": "bluesnap"
                },
                "allowed_payment_methods": [
                    {
                        "type": "CARD",
                        "parameters": {
                            "allowed_auth_methods": [
                                "PAN_ONLY",
                                "CRYPTOGRAM_3DS"
                            ],
                            "allowed_card_networks": [
                                "AMEX",
                                "DISCOVER",
                                "INTERAC",
                                "JCB",
                                "MASTERCARD",
                                "VISA"
                            ]
                        },
                        "tokenization_specification": {
                            "type": "PAYMENT_GATEWAY",
                            "parameters": {
                                "gateway": "bluesnap",
                                "gateway_merchant_id": "1087905"
                            }
                        }
                    }
                ]
            },
            "terminal_id": "10000001",
            "account_name": "transaction_processing"
        },
        "test_mode": true,
        "disabled": true,
        "frm_configs": null,
        "business_country": "US",
        "business_label": "default",
        "business_sub_label": null,
        "applepay_verified_domains": null,
        "pm_auth_config": null,
        "status": "active"
    },
    {
        "connector_type": "fiz_operations",
        "connector_name": "stripe",
        "connector_label": "stripe_US_default7",
        "merchant_connector_id": "mca_mETGK4Fi1JQG7ggXzUnd",
        "profile_id": "pro_NMDohQHyrqzAkUjBjDmB",
     
        "payment_methods_enabled": [
            {
                "payment_method": "card",
                "payment_method_types": [
                    {
                        "payment_method_type": "credit",
                        "payment_experience": null,
                        "card_networks": [
                            "Visa"
                        ],
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 200000,
                        "recurring_enabled": false,
                        "installment_payment_enabled": false
                    },
                    {
                        "payment_method_type": "debit",
                        "payment_experience": null,
                        "card_networks": [
                            "JCB"
                        ],
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 200000,
                        "recurring_enabled": false,
                        "installment_payment_enabled": false
                    }
                ]
            },
            {
                "payment_method": "wallet",
                "payment_method_types": [
                    {
                        "payment_method_type": "google_pay",
                        "payment_experience": "invoke_sdk_client",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 50000,
                        "recurring_enabled": false,
                        "installment_payment_enabled": false
                    },
                    {
                        "payment_method_type": "apple_pay",
                        "payment_experience": "invoke_sdk_client",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 600,
                        "maximum_amount": 800,
                        "recurring_enabled": false,
                        "installment_payment_enabled": false
                    }
                ]
            },
            {
                "payment_method": "pay_later",
                "payment_method_types": [
                    {
                        "payment_method_type": "affirm",
                        "payment_experience": "redirect_to_url",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 50000,
                        "recurring_enabled": false,
                        "installment_payment_enabled": false
                    }
                ]
            }
        ],
        "connector_webhook_details": null,
        "metadata": {
            "city": "NY",
            "unit": "245"
        },
        "test_mode": false,
        "disabled": false,
        "frm_configs": null,
        "business_country": null,
        "business_label": null,
        "business_sub_label": null,
        "applepay_verified_domains": null,
        "pm_auth_config": null,
        "status": "active"
    },
    {
        "connector_type": "fiz_operations",
        "connector_name": "cybersource",
        "connector_label": "cybersource_US_default_default",
        "merchant_connector_id": "mca_Ec6WKYkD3tP5m4HwSmxd",
        "profile_id": "pro_NMDohQHyrqzAkUjBjDmB",
ment_methods_enabled": [
            {
                "payment_method": "card",
                "payment_method_types": [
                    {
                        "payment_method_type": "credit",
                        "payment_experience": null,
                        "card_networks": [
                            "Visa",
                            "Mastercard",
                            "DinersClub",
                            "Discover"
                        ],
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": -1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    },
                    {
                        "payment_method_type": "debit",
                        "payment_experience": null,
                        "card_networks": [
                            "Visa",
                            "Mastercard",
                            "DinersClub",
                            "Discover"
                        ],
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": -1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    }
                ]
            },
            {
                "payment_method": "wallet",
                "payment_method_types": [
                    {
                        "payment_method_type": "google_pay",
                        "payment_experience": "redirect_to_url",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    },
                    {
                        "payment_method_type": "apple_pay",
                        "payment_experience": "invoke_sdk_client",
                        "card_networks": null,
                        "accepted_currencies": null,
                        "accepted_countries": null,
                        "minimum_amount": 1,
                        "maximum_amount": 68607706,
                        "recurring_enabled": true,
                        "installment_payment_enabled": true
                    }
                ]
            }
        ],
        "connector_webhook_details": {
            "merchant_secret": "MyWebhookSecret",
            "additional_secret": null
        },
      
                },
                "payment_request_data": {
                    "label": "applepay",
                    "supported_networks": [
                        "visa",
                        "masterCard",
                        "amex",
                        "discover"
                    ],
                    "merchant_capabilities": [
                        "supports3DS"
                    ]
                }
            }
        },
        "test_mode": false,
        "disabled": false,
        "frm_configs": null,
        "business_country": "US",
        "business_label": "default",
        "business_sub_label": null,
        "applepay_verified_domains": null,
        "pm_auth_config": null,
        "status": "active"
    }
]
```


## Checklist
<!-- Put an `x` in the boxes that apply -->

- [ ] I formatted the code `cargo +nightly fmt --all`
- [ ] I addressed lints thrown by `cargo clippy`
- [ ] I reviewed the submitted code
- [ ] I added unit tests for my changes where possible
