Jquery Table Sorter, Pagination and Search with Starts with query

table sorter with column search starts with query

https://www.idrive.com/idrive/sh/sh?k=n4q9l4x5p3

santosh



http://mottie.github.io/tablesorter/docs/index.html#Widget-options

How to make current menu tab as Active

<li>

<a href="@Url.Content("~/Admin/Admin/Index")"  class="@((ViewData["Menu"] == "MenuName") ? "active" : "inactive")" >MENU</a>

</li>

Controller

 public ActionResult Index()

        {

            ViewData["Menu"] = " MenuName ";

            return View();

        }

Decimal value upto 0,2,4 decimals points

For Zero decimal value:

@String.Format("{0:C0}", item.Amount)

For 2 decimal value:

@String.Format("{0:C2}", item.Amount)

For 4 decimal value:

@String.Format("{0:C4}", item.Amount)

Check all checkboxes

<input id="chkall" type="checkbox" title="Select/Clear All" onchange="getselect(this)"/>

for (int i = 0; i < Model.lst.Count; i++)

{

@Html.CheckBoxFor(m => m.lst[i].Aid, new { @class="chk", id="chk" })

}

<script type="text/javascript">

   

    function getselect() {

        if (document.getElementById('chkall').checked) {

            $('.chk').prop('checked', true);

        }

        else {

         

            $('.chk').prop('checked', false);

           

        }    

    }

        

</script>

Dropdown Selected Value and Text

@Html.DropDownListFor(model => model.Country, new SelectList(((System.Collections.IEnumerable)ViewData["CList"]), "cid", "cname"), "--Select--", new { @Class = "txtbox", onchange = "CountryChange()", id = "ddlcountry" })

function CountryChange() {
        var dropdownSelect= document.getElementById("ddlcountry");
        var selectedValue = dropdownSelect.options[dropdownSelect.selectedIndex].value;
        var selectedText = dropdownSelect.options[dropdownSelect.selectedIndex].text;    
    }

Script for Text Box allows only numeric values

 <input type="text" id="txtNumber"  onKeyPress="return isNumber(event)"/>

 <script type="text/javascript">
 function isNumber(evt) {
 evt = (evt) ? evt : window.event;
 var charCode = (evt.which) ? evt.which : evt.keyCode;
 if (charCode > 31 && (charCode < 46 || charCode > 57))
 return false;
 return true;
 }
 </script>

LDAP view

SELECT     displayName, mail, telephoneNumber, physicalDeliveryOfficeName, title, department, RIGHT(LEFT(manager, CHARINDEX(',', manager) - 1), LEN(RIGHT(manager,
                      CHARINDEX(',', manager) - 1)) - 3) AS Expr1, CN, SAMAccountName, accountExpires, manager
FROM         OPENQUERY(ADSI,
                      'SELECT mail, displayName,givenname,distinguishedName, SAMAccountName, CN, physicalDeliveryOfficeName,department,title,telephoneNumber,manager,userAccountControl, accountExpires,maxPwdAge
FROM ''LDAP://domain''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')
                       AS derivedtbl_1
WHERE     (userAccountControl = 512) OR
                      (userAccountControl = 66048)