public HttpResponseMessage GetBoth(string price, string cname)
 {
     if (cname == "TOYS" && price == "0-1999")
     {
         var res = entities.sp_GetPdtByPriceCategory(0, 1999, "TOYS");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "TOYS" && price == "2000-9999")
     {
         var res = entities.sp_GetPdtByPriceCategory(2000, 9999, "TOYS");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "TOYS" && price == "10000-80000")
     {
         var res = entities.sp_GetPdtByPriceCategory(10000, 80000, "TOYS");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Electronics" && price == "10000-80000")
     {
         var res = entities.sp_GetPdtByPriceCategory(10000, 80000, "Electronics");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Electronics" && price == "0-1999")
     {
         var res = entities.sp_GetPdtByPriceCategory(0, 1999, "Electronics");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Electronics" && price == "2000-9999")
     {
         var res = entities.sp_GetPdtByPriceCategory(2000, 9999, "Electronics");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Clothings" && price == "0-1999")
     {
         var res = entities.sp_GetPdtByPriceCategory(0, 1999, "Clothings");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Clothings" && price == "2000-9999")
     {
         var res = entities.sp_GetPdtByPriceCategory(2000, 9999, "Clothings");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Clothings" && price == "10000-80000")
     {
         var res = entities.sp_GetPdtByPriceCategory(10000, 80000, "Clothings");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Books" && price == "0-1999")
     {
         var res = entities.sp_GetPdtByPriceCategory(0, 1999, "Books");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Books" && price == "2000-9999")
     {
         var res = entities.sp_GetPdtByPriceCategory(2000, 9999, "Books");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Books" && price == "10000-80000")
     {
         var res = entities.sp_GetPdtByPriceCategory(10000, 80000, "Books");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Mobiles" && price == "0-1999")
     {
         var res = entities.sp_GetPdtByPriceCategory(0, 1999, "Mobiles");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Mobiles" && price == "2000-9999")
     {
         var res = entities.sp_GetPdtByPriceCategory(2000, 9999, "Mobiles");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else if (cname == "Mobiles" && price == "10000-80000")
     {
         var res = entities.sp_GetPdtByPriceCategory(10000, 80000, "Mobiles");
         return(Request.CreateResponse(HttpStatusCode.OK, res));
     }
     else
     {
         return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Product Not found"));
     }
 }