protected void Page_Load(object sender, EventArgs e)
{
string output = "";
string methodName = Request.Form["methodName"];
string lookupField = Request.Form["field"];
string searchTerm = Request.Form["search"];
bool isDistinct = string.IsNullOrEmpty(Request.Form["isDistinct"]) ? false : bool.Parse(Request.Form["isDistinct"]);
switch (methodName)
{
case ("GetParentCodeByChildCode"):
string childLkpField = Request.Form["childLkpField"];
string childLkpCode = Request.Form["childLkpCode"];
string parentLkpField = Request.Form["parentLkpField"];
LookupCodeDa da = new LookupCodeDa();
DataTable dt = da.GetParentLookupCodeByChildCode(parentLkpField, childLkpField, childLkpCode);
// 0 || > 1 results, return empty value (prevent ambiguity)
output = dt.Rows.Count == 1 ? dt.Rows[0][LookupCode.LkpCode].ToString() : "";
break;
default:
if (!string.IsNullOrEmpty(lookupField))
{
DataTable lkpTable = GetLookupCodes(lookupField, isDistinct);
if (lkpTable.Columns.Contains(LookupCode.LkpCode))
{
string[] lkpFields = new string[] { LookupCode.LkpCode, LookupCode.LkpDescription };
output = PageUtil.DataTableToJSArray(lkpTable, lkpFields, false);
}
else
{
string[] lkpFields = new string[] { "DropDownValue", "DropDownText" };
output = PageUtil.DataTableToJSArray(lkpTable, lkpFields, false);
}
}
break;
}
Response.Write(output);
}
