public HttpResponseMessage Post(tblBid bid)
{
DbContextTransaction transaction = entities.Database.BeginTransaction();
try
{
entities.sp_approveBid(bid.bId, bid.CropId);
entities.SaveChanges();
tblCropForSale crop = entities.tblCropForSales.Where(c => c.CropId == bid.CropId).FirstOrDefault();
tblFarmer farmer = entities.tblFarmers.Where(f => f.fId == crop.FarmerId).FirstOrDefault();
EmailModel mail = new EmailModel();
mail.to = farmer.fEmailId;
mail.subject = "Crop Sold ";
mail.body = "Your crop sold id" + bid.CropId + "\t of type\t" + crop.CropType + "is sold for amount " +
bid.BidAmount + "Rs/-;\n money will be credited after crop is shipped";
HttpClient http = new HttpClient();
http.BaseAddress = new Uri("http://localhost:61674/api/Email");
var consumewebApi = http.PostAsJsonAsync <EmailModel>("email", mail);
//Sending confirmation to bidder
EmailModel bidderMail = new EmailModel();
tblBidder bidder = entities.tblBidders.Where(b => bid.BidderId == b.bId).FirstOrDefault();
bidderMail.to = bidder.bEmailId;
bidderMail.subject = "Congrats..! Your Bid Cinfirmed";
bidderMail.body = "your bid is confirmed for crop id" + bid.CropId + "with Amount Of" + bid.BidAmount + "<button>MakePaymet</button>";
var consumewebApi2 = http.PostAsJsonAsync <EmailModel>("email", bidderMail);
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Something went Wrong Try to bid again"));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Post(tblBid bid)
{
DbContextTransaction transaction = entities.Database.BeginTransaction();
try
{
entities.sp_approveBid(bid.bId, bid.CropId);
entities.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Something went Wrong Try to bid again"));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
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));
}
