コード例 #1
0
        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));
        }