ASP.NET

19-Dec-13 0:55

Hello,

I am trying to execute the following query string url:
api/item?name=storm&name=prest,
but I cannot get the code to work.

I am using the split function to request same records at the same time.

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)
        {
            **data = data.Where(c => c.Name.Split("&").Contains(query.name));**

        }
        if (query.id!= null)
        {
            data = data.Where(c => c.ID== query.id);
        }

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

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

Any help would be very much appreciated.

Richard Deeming19-Dec-13 2:05

19-Dec-13 2:05

Your code is taking the name from the database, splitting it on the ampersand character, and looking to see if any of the parts contain the string "storm,prest". So, for example, this would match a record where the name was "A&B&storm,prest&C".

I suspect you want to split the name from the query, and see if it contains the name from the database.

data = data.Where(c => query.name.Split(',').Contains(c.Name));

This would return records where the name is equal to either "storm" or "prest".

If you want to return records where the name contains any of the values passed in the querystring then it gets a little more complicated.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

miss78619-Dec-13 2:12

19-Dec-13 2:12

Thank you so much for your response richard and thank you for clarifying the problem. Yes, that is correct, I would like the query string to return where name is either equal to 'storm' or 'prest'.

is their any example or functionality i can look at to build this method.

I really appreciate your help and time.
Many thanks.

Richard Deeming19-Dec-13 2:18

19-Dec-13 2:18

The code I posted in my previous answer should do what you want, assuming the name parameter comes through as I think it will. If not, you'll need to add a breakpoint to your method and inspect the value of the query.name property to see how it's being read.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

miss78620-Dec-13 4:59

20-Dec-13 4:59

Thank you so much for response. I amended my code according to your suggestion, but sadly I could not get the code to work. I was getting "does not recognize the method 'System.String[] Split(Char[]" error and I changed the following line of code from:

var data = db.database_BWICs.AsQueryable();

to:

public class ItemController : ApiController
    {
        private cdwEntities db = new cdwEntities();

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

            if (query.name != null)
            {
                //data = data.Where(c => c.Name == query.name);
                data = data.Where(c => query.name.Split('&').Contains(c.Name));
                
                //data = data.Where(c => c.Name.Split('&').Contains(query.name));
            }
            if (query.id!= null)
            {
                data = data.Where(c => c.ID== query.id);
            }
            
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

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

After, changing the above line, I was able to resolve the above error. But I still cannot request two records of name in the URL: api/item?name=storm&name=prest
It only shows the result for the first name record in the url(storm). Is there a way to execute this functionality using any any other built-in function or some kind of pseudo code.

Thank you so much for your help and time.

Richard Deeming20-Dec-13 5:22

20-Dec-13 5:22

What's the value of the query.name property?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

miss78620-Dec-13 5:47

20-Dec-13 5:47

Thank you for response back. the value of the "query.name" is string.I submitted query class code for further reference.

namespace API_Dec.Controllers
{
    public class Query
    {

        public string name { get; set; }
        public string id{ get; set; }
        public string deal_type { get; set; }
        public string price_type { get; set; }
        public Nullable<DateTime> startDate { get; set; }
        public Nullable<DateTime> endDate{ get; set; }
    }
}

Many Thanks

Richard Deeming20-Dec-13 8:17

20-Dec-13 8:17

Yes, but what's the value in the name property when you submit your query? Does it contain "storm,prest", or something else?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

miss78620-Dec-13 10:06

20-Dec-13 10:06

I apologize for the confusion.

I am passing both 'storm' and 'prest' in the query string. So, my values contain 'storm' and 'storm'. when I pass 'name=storm', i get back 4 records but when i pass 'name=storm&name=prest', i get same 4 storm records and the query does not read the second name value.

many thanks for your time and help

miss78623-Dec-13 3:50

23-Dec-13 3:50

Hi Richard.
Thank you so much for your time and help. I am writing to inform, I manage to get the 'split' function to pass multiple records for the parameter name. I am little stuck on getting the 'split name' to work other parameter query. When I run a call = api/data?name=storm,prest&price_type=talk, I get 'no data' message on the client-end. Is there a way to filter the following above query string?

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


            if (query.name!= null)
            {
                 data = data.Where(c => query.name.Split(',').Contains(c.Name));
            }
            if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }
            
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

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

I really appreciate your support and time. Many thanks.

Richard Deeming6-Jan-14 8:35

6-Jan-14 8:35

So if you call api/data?name=storm&price_type=talk, you get 4 records?

And if you call api/data?name=storm,storm&price_type=talk, do you still get the same records?

What is the value of query.name when you call api/data?name=storm,prest&price_type=talk?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

miss7867-Jan-14 5:50

7-Jan-14 5:50

Hi Richard. Thank you so much for your help and apology for the late response.
Hope you had a nice Christmas holiday and happy new year.

I manage to get the code partially working by adding 'toList' with split function. So the code works for the following url = 'api/item/name=storm,prest'. However, I cannot get the code to execute two parameters together such as 'api/item?name=storm,prest&id=123', it throws a no data found error.

I am assuming there is an issue with using contain, if so, is there another function i could use. Any help would be very much appreciated.
Thank you so much for your time and help.

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

Richard Deeming7-Jan-14 8:03