public string[] GetItems(string query, int ClientId) { /*string query = ""; query = Context.Request.Form["query"].ToString();*/ Clients client = new Clients(); client.LoadByPrimaryKey(ClientId); int clientTypeID = 0 ; if(client.RowCount > 0) clientTypeID= client.ClientTypeID; Items items = new Items(); List<string> listString = new List<string>(); if (clientTypeID != 0) { items.SearchItemsAjax(query, clientTypeID); if (items.RowCount > 0) { for (int i = 0; i < items.RowCount; i++) { listString.Add(items.ItemID + "##" + items.Name + "##" + items.GetColumn("Price").ToString()); //ItemsJSON += "{'Name': '" + items.ItemCode + " - " + items.Name + "' , 'ItemID': '" + items.ItemID + "'}"; items.MoveNext(); } } } else { items.SearchItems(query); if (items.RowCount > 0) { for (int i = 0; i < items.RowCount; i++) { listString.Add(items.ItemID + "##" + items.Name); //ItemsJSON += "{'Name': '" + items.ItemCode + " - " + items.Name + "' , 'ItemID': '" + items.ItemID + "'}"; items.MoveNext(); } } } string[] str = listString.ToArray(); //Context.Response.Output.Write(ItemsJSON); //Context.Response.End(); return str; }
public string GetItems(string term) { string ItemsJSON = ""; Items items = new Items(); items.SearchItems(term); if (items.RowCount > 0) { ItemsJSON = "["; for (int i = 0; i < items.RowCount; i++) { ItemsJSON += "'" + items.Name + "'"; //ItemsJSON += "{'Name': '" + items.ItemCode + " - " + items.Name + "' , 'ItemID': '" + items.ItemID + "'}"; if (items.MoveNext()) ItemsJSON += ","; } ItemsJSON += "]"; } Context.Response.Output.Write(ItemsJSON); Context.Response.End(); return string.Empty; }