Issue:
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!

Pull request description:
## 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


Testing:
 - 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"
    }
]
```

Patch:
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);