I want to pass two parameter(string term,string vouvhertype) in jqgrid autocomplete textbox in edit form .So that data for autocomplete get filtered according to the second parameter.
public JsonResult GetSubAccountForAutocompleteDrCode(string term,string Vtype)
{
if (Vtype == "BP" || Vtype == "CP")
{
string v = Vtype.Remove(1, 1);
FMS_BLL.Account_SubAccountDetails[] matching = string.IsNullOrWhiteSpace(term) ?
Account_SubAccountDetailsHelper.GetSubAccountMasterDetailsForAutoCompleteWithFilter(v).ToArray() :
Account_SubAccountDetailsHelper.GetSubAccountMasterDetailsForAutoCompleteWithFilter(v).Where(p => p.ACCOUNT_NAME != null && p.ACCOUNT_NAME.ToUpper().Trim().StartsWith(term.ToUpper().Trim())).ToArray();
return Json(matching.Select(m => new { id = m.ACCOUNT_CODE, value = m.ACCOUNT_CODE + "-" + m.ACCOUNT_HEAD_CODE + "-" + m.ACCOUNT_NAME + "-" + m.ACCOUNT_DESCRIPTION + "-" + m.ACCOUNT_TYPE, label = m.ACCOUNT_CODE + "-" + m.ACCOUNT_HEAD_CODE + "-" + m.ACCOUNT_NAME + "-" + m.ACCOUNT_DESCRIPTION }), JsonRequestBehavior.AllowGet);
}
else
{
FMS_BLL.Account_SubAccountDetails[] matching = string.IsNullOrWhiteSpace(term) ?
Account_SubAccountDetailsHelper.GetSubAccountMasterDetailsForAutoComplete().ToArray() :
Account_SubAccountDetailsHelper.GetSubAccountMasterDetailsForAutoComplete().Where(p => p.ACCOUNT_NAME != null && p.ACCOUNT_NAME.ToUpper().Trim().StartsWith(term.ToUpper().Trim())).ToArray();
return Json(matching.Select(m => new { id = m.ACCOUNT_CODE, value = m.ACCOUNT_CODE + "-" + m.ACCOUNT_HEAD_CODE + "-" + m.ACCOUNT_NAME + "-" + m.ACCOUNT_DESCRIPTION + "-" + m.ACCOUNT_TYPE, label = m.ACCOUNT_CODE + "-" + m.ACCOUNT_HEAD_CODE + "-" + m.ACCOUNT_NAME + "-" + m.ACCOUNT_DESCRIPTION }), JsonRequestBehavior.AllowGet);
}
}