public IHttpActionResult PuttblCropRequest(int id, tblCropRequest tblCropRequest)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblCropRequest.RequestId)
{
return(BadRequest());
}
db.Entry(tblCropRequest).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblCropRequestExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpResponseMessage WayTwo()
{
string imageName = "";
string Qty = "";
var httpRequest = HttpContext.Current.Request;
//Upload Image
var postedFile = httpRequest.Files["Image"];
//Create custom filename
imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-");
imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName);
var filePath = HttpContext.Current.Server.MapPath("~/Image/" + imageName);
postedFile.SaveAs(filePath);
//Save to DB
using (dbProjectEntities1 db = new dbProjectEntities1())
{
tblCropRequest cpr = new tblCropRequest();
cpr.SoilPhCertificate = imageName;
cpr.CropType = httpRequest["CropType"];
cpr.CropName = httpRequest["CropName"];
cpr.FertilizerType = httpRequest["FertilizerType"];
Qty = (httpRequest["Quantity"]);
//Quantity = 25
cpr.Quantity = Convert.ToInt32(Qty);
cpr.Farmerid = Convert.ToInt32(httpRequest["FarmerID"]);
cpr.CropApproved = false;
db.tblCropRequests.Add(cpr);
db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.Created));
}
public void Listing([FromBody] tblCropRequest cropRequest)
{
cropRequest.SoilPhCertificate = cropRequest.SoilPhCertificate.Replace("/", "-");
cropRequest.Farmerid = 100;
cropRequest.CropApproved = false;
db.tblCropRequests.Add(cropRequest);
db.SaveChanges();
}
public IHttpActionResult GettblCropRequest(int id)
{
tblCropRequest tblCropRequest = db.tblCropRequests.Find(id);
if (tblCropRequest == null)
{
return(NotFound());
}
return(Ok(tblCropRequest));
}
public IHttpActionResult PosttblCropRequest(tblCropRequest tblCropRequest)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblCropRequests.Add(tblCropRequest);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblCropRequest.RequestId }, tblCropRequest));
}
public IHttpActionResult DeletetblCropRequest(int id)
{
tblCropRequest tblCropRequest = db.tblCropRequests.Find(id);
if (tblCropRequest == null)
{
return(NotFound());
}
db.tblCropRequests.Remove(tblCropRequest);
db.SaveChanges();
return(Ok(tblCropRequest));
}
public IHttpActionResult Post([FromUri] int Id, int adminId, int initprice)
{
tblCropRequest tblCropRequest = db.tblCropRequests.Find(Id);
tblCropRequest.CropApproved = true;
tblCropRequest.ApprovalAdminId = adminId;
db.Entry(tblCropRequest).State = EntityState.Modified;
db.SaveChanges();
tblBidding tblBidding = new tblBidding();
tblBidding.RequestId = tblCropRequest.RequestId;
tblBidding.InitialPrice = initprice;
tblBidding.CurrentBidPrice = initprice;
tblBidding.PreviousBidPrice = initprice;
DateTime dateTime = DateTime.Now;
tblBidding.BidCloseTime = dateTime.AddMinutes(720);
db.tblBiddings.Add(tblBidding);
db.SaveChanges();
return(Ok("OK"));
}
public IHttpActionResult ApproveAuctionAdmin([FromUri] int id, int adminid)
{
tblBidding tblBidding = db.tblBiddings.Find(id);
tblBidding.ApprovalAdminId = adminid;
tblCropRequest tblCropRequest = db.tblCropRequests.Find(tblBidding.RequestId);
tblFarmer tblFarmer = db.tblFarmers.Find(tblCropRequest.FarmerId);
tblSale tblSale = new tblSale();
tblSale.FarmerId = tblFarmer.FarmerId;
tblSale.BidderId = tblBidding.BidderId;
tblSale.Quantity = (int?)tblCropRequest.Quantity;
tblSale.CropName = tblCropRequest.CropName;
tblSale.MinSalePrice = tblBidding.InitialPrice;
tblSale.TotalPrice = tblBidding.CurrentBidPrice;
tblSale.SaleDate = DateTime.Now.Date;
tblSale.ApprovalAdminId = adminid;
db.Entry(tblBidding).State = EntityState.Modified;
db.tblSales.Add(tblSale);
db.SaveChanges();
return(Ok("OK"));
}
