public HttpResponseMessage Getsale() { List <sp_getPendingSaleData_Result> results = entities.sp_getPendingSaleData().ToList(); if (results.Count == 0) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No pending sale Data")); } return(Request.CreateResponse <IEnumerable <sp_getPendingSaleData_Result> >(HttpStatusCode.OK, results)); }