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;
}
