public HttpResponseMessage GetPrice(string price)
        {
            if (price == "0-1999")
            {
                var res = entities.sp_GetPdtByPrice(0, 1999);
                return(Request.CreateResponse(HttpStatusCode.OK, res));
            }
            else if (price == "2000-9999")
            {
                var res = entities.sp_GetPdtByPrice(2000, 9999);
                return(Request.CreateResponse(HttpStatusCode.OK, res));
            }

            else if (price == "10000-80000")
            {
                var res = entities.sp_GetPdtByPrice(10000, 80000);
                return(Request.CreateResponse(HttpStatusCode.OK, res));
            }

            else
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Product price out of range"));
            }
        }