ASP.NET

public class ItemController : ApiController
    {
        private cdwEntities db = new cdwEntities();
 
        public HttpResponseMessage Get([FromUri] Query query)
        {
            var data = db.database_ICs.AsQueryable();
 
            if (query.name != null)
            {
		 var ids = query.name.Split(',').ToList();
                 data = data.Where(c => ids.Contains(c.Name));
            }
            if (query.id!= null)
            {
                 var ids = query.id.Split(',').ToList();
                data = data.Where(c => ids.Contains(c.ID));
            }
            
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }
 
            return Request.CreateResponse(HttpStatusCode.OK, data);
        }
    }

if (query.id1!= null || query.id2!= null)
            {
                data = data.Where(c => c.ID1.Contains(query.id1) || c.ID2.Contains(query.id2));
            }

public HttpResponseMessage Get([FromUri] Query query)
        {
            var data = db.database_ICs.AsQueryable();

            if (!String.IsNullOrEmpty(query.name))
            {
                var ids = query.name.Split(',').ToList();                
                //data = data.Where(c => c.Name == query.name);
                data = data.Where(c => ids.Any(i => (c.Name!= null && c.Name.Contains(i))));
            }

            if (!String.IsNullOrEmpty(query.id1))
            {
                var ids = query.id1.Split(',').ToList();
                
                data = data.Where(c => ids.Any(i => (c.ID1!= null && c.ID1.Contains(i))));
                data = data.Where(c => c.Name == query.name);
            }

            if (!String.IsNullOrEmpty(query.id2))
            {
                var ids = query.id2.Split(',').ToList();

                //data = data.Where(c => ids.Any(i => (c.ID2!= null && c.ID2.Contains(i))));
                data = data.Where(c => c.ID2 == query.id2);
            }

            if (query.deal_type != null)
            {
                data = data.Where(c => c.Type == query.deal_type);
            }
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

            return Request.CreateResponse(HttpStatusCode.OK, data);
        }


public class Query
    {

        public string name { get; set; }
        public string id1{ get; set; }
        public string id2{ get; set; }
        public string deal_type { get; set; }
        
    }</pre>

Name	id1	id2	deal_type
prest	789		ms
prest	345		ms
storm		456	bs
storm			bs
ariel	123		rs
ariel		223	rs


Thank you so much your time and help. Many thanks.

var data = db.database_ICs.AsQueryable();
var filteredData = new List<IQueryable<database_IC>>();

if (!string.IsNullOrEmpty(query.name))
{
    var ids = query.name.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.Name != null && c.Name.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id1))
{
    var ids = query.id1.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID1 != null && c.ID1.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id2))
{
    var ids = query.id2.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID2 != null && c.ID1.Contains(i)));
    }
}

if (query.deal_type != null)
{
    filteredData.Add(data.Where(c => c.Type == query.deal_type));
}

// If no filters passed, return all data.
// Otherwise, combine the individual filters using the Union method
// to return all records which match at least one filter.
if (filteredData.Count != 0)
{
    data = filteredData.Aggregate(Queryable.Union);
}

if (!data.Any())
{
    var message = string.Format("No data was found");
    return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
}

return Request.CreateResponse(HttpStatusCode.OK, data);

var data = db.database_ICs.AsQueryable();

// If a deal_type is specified, only return records for that deal type:
if (query.deal_type != null)
{
    data = data.Where(c => c.Type == query.deal_type);
}

// If any other filters are specified, return records which match any of them:
var filteredData = new List<IQueryable<database_IC>>();

if (!string.IsNullOrEmpty(query.name))
{
    var ids = query.name.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.Name != null && c.Name.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id1))
{
    var ids = query.id1.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID1 != null && c.ID1.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id2))
{
    var ids = query.id2.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID2 != null && c.ID1.Contains(i)));
    }
}

// If no filters passed, return all data.
// Otherwise, combine the individual filters using the Union method
// to return all records which match at least one filter.
if (filteredData.Count != 0)
{
    data = filteredData.Aggregate(Queryable.Union);
}

if (!data.Any())
{
    var message = string.Format("No data was found");
    return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
}

return Request.CreateResponse(HttpStatusCode.OK, data);

Ya Rasoolallah wrote:

C#

string query = "select * from tbl_users where username like @username";
SqlCommand cm = new SqlCommand(query,cn);
cm.Parameters.AddWithValue("@username","N%"+prefixT  ext+"%");

cm.Parameters.AddWithValue("@username","N%"+prefixText+"%");

while (dr.Read())

  [WebMethod]
    public static string[] City(string prefixText, int count, string contextKey)
    {


        DataTable dt = new DataTable();

        dt = Bal_BindingData._city(prefixText);
//_city is dataTable type function with the string type parameter.just add the String Contextkey in your GetCompletionList method.

        string[] movies = new string[dt.Rows.Count];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            movies[i] = dt.Rows[i]["City"].ToString();

        }


        return movies;
    }