public JsonResult GetComtrolddl(string strCriteria)
{
ListSelectList_ listItems = new ListSelectList_();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
string strresult = "";
try
{
listItems = ObjRun.GetPlaning(strCriteria);
}
catch (Exception e)
{
strresult = e.Message;
}
var jsonResult = Json(new { data = new MultiSelectList(listItems._ListSelectList, "Value", "Text"), dataResult = listItems.strResult });
return(jsonResult);
}
public ListSelectList_ GetPlaning(string strCriteria)
{
ListSelectList_ resultList = new ListSelectList_();
mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration);
List <SelectListItem> listItems = new List <SelectListItem>();
dt = new DataTable();
strSQL = "";
string strItemText = "";
string strItemVal = "";
try
{
if (strCriteria == "ItemCateg")
{
strCriteria = "ItemCateg,ItemCategName ";
strItemText = "ItemCategName";
strItemVal = "ItemCateg";
}
else if (strCriteria == "ItemCode")
{
strCriteria = "ItemCode,ItemName ";
strItemText = "ItemName";
strItemVal = "ItemCode";
}
else if (strCriteria == "OperatorID")
{
strCriteria = "OperatorID,OperatorName ";
strItemText = "OperatorName";
strItemVal = "OperatorID";
}
else
{
strItemText = strCriteria;
strItemVal = strCriteria;
}
strSQL = "select ";
strSQL += " " + strCriteria + " ";
strSQL += " from vewExamResults ";
strSQL += " group by " + strCriteria + " ";
strSQL += " order by " + strCriteria + " ";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count != 0)
{
listItems.Add(new SelectListItem()
{
Text = "- ALL -",
Value = "",
});
foreach (DataRow row in dt.Rows)
{
string strTxt = (strItemVal == strItemText ? row[strItemText].ToString().Trim() : row[strItemVal].ToString().Trim() + " : " + row[strItemText].ToString().Trim());
listItems.Add(new SelectListItem()
{
Text = strTxt,
Value = row[strItemVal].ToString().Trim(),
});
}
resultList._ListSelectList = listItems;
resultList.strResult = "OK";
}
else
{
resultList.strResult = "Data " + strCriteria + " not found";
}
}
catch (Exception e)
{
resultList.strResult = e.Message;
}
return(resultList);
}
