public HttpResponseMessage Post(int fid, tblBid bid) { //entities.tblBids.Add(bid); DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_newBid(bid.CropId, bid.BidderId, bid.BidAmount, bid.DateOfBid); entities.SaveChanges(); int bidID = entities.tblBids.Max(x => x.bId); entities.sp_InsertintoBidCrops(bidID, fid, bid.CropId, bid.BidderId); entities.SaveChanges(); transaction.Commit(); }catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Could not insert data ")); } return(Request.CreateResponse(HttpStatusCode.Created)); }