aSelect

<script>
    function initializePlugins($context) {
        $context.find('select.aSelect').each(function () {
            $(this).aSelect(); // if aSelect is already initialized, aSelect ignores this.
        });
    }

    $(document).ready(function () {
        initializePlugins($(document));
    });

    // Run after every jQuery AJAX request completes
    $(document).ajaxComplete(function () {
        initializePlugins($(document));
    });
</script>
                

public class DropdownDTO
{
    public string chDropdownId { get; set; }
    public string nvcSqlQuery { get; set; }
    public bool bitImplementPagination { get; set; }
    public string vcValColumn { get; set; }
    public string vcTextColumn { get; set; }
    public string vcSkippedColumns { get; set; }
    public string vcSkippedSearchColumns { get; set; }
    public Dictionary ColumnMappings { get; set; }
}
                

using DotNetMvc.DTOs;

namespace DotNetMvc.Repository
{
    public class DropdownRepository
    {
        public List GetAllDropdown()
        {
            return new List()
            {
                new DropdownDTO
                {
                    chDropdownId = "Order",
                    nvcSqlQuery = "SELECT [idOrderId], vcOrderNo , decPrice, vcCustomerName as vcCustomer FROM Order WHERE {{filters}} AND bitActive = 1 ORDER BY vcCompanyName",
                    bitImplementPagination = true,
                    vcValColumn = "idOrderId",
                    vcTextColumn = "vcOrderNo",
                    vcSkippedColumns = "idOrderId",
                    ColumnMappings = new Dictionary()
                    {
                        ["vcCustomer"] = "vcCustomerName"
                    }
                }
            };
        }
    }
}
                

builder.Services.AddSingleton();
                

using DotNetMvc.DTOs;
using DotNetMvc.Repository;
using Microsoft.AspNetCore.Mvc;
namespace DotNetMvc.Controllers;

public class CommonController(DropdownRepository dropDownRepo) : Controller
{
    public async Task Dropdown(string id, string search, string start, string length, string valColumn, string selectedValue, bool onlyFetchSelectedRow, bool initialLoad, List headers, Dictionary dependsOn)
    {
        // Logic to handle dropdown data fetching using dropDownRepo
        List listAllDropdowns = dropDownRepo.GetAllDropdown();
        DropdownDTO dropdown = listAllDropdowns.First(x => x.chDropdownId == id);

        List> data = null; // TODO: Implement your logic. I am leaving this intentionally.. your should know how you should fetch your data.
        Dictionary selectedRow = null;

        if (onlyFetchSelectedRow)
        {
            if (string.IsNullOrEmpty(selectedValue))
            {
                throw new InvalidOperationException("Select value cannot be empty");
            }


            string sql = dropdown.nvcSqlQuery.Replace("{{filters}}", $"({dropdown.vcValColumn} = @valColumn)"); // this is okay as we in the backend control what is the dropdown.vcValColumn...

            var parameters = new Dictionary
            {
                { "@valColumn", selectedValue },
            };
            foreach (var kv in dependsOn)
            {
                parameters[kv.Key] = kv.Value;
            }
            selectedRow = null; // TODO: Implement your logic. I am leaving this intentionally.. your should know how you should fetch your data. This should be return if onlyFetchSelectedRow is true. This maybe a Db repo Call
        }
        else
        {
            data = null; // TODO: Implement your logic. I am leaving this intentionally.. your should know how you should fetch your data.  This maybe a Db repo Call
        }
        return Json(new { data, selectedRow, dropdown.vcValColumn, dropdown.vcTextColumn, dropdown.bitImplementPagination, dropdown.vcSkippedColumns });
    }
}