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