public HttpResponseMessage Post(tblCropForSale sale) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_approvesale(sale.CropId, sale.CropType, sale.CropName); entities.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Not able to approve the user")); } return(Request.CreateResponse(HttpStatusCode.OK)); }