public IHttpActionResult GetCropById([FromUri] int id)
{
var cp = (from crps in db.tblCropRequests
join bd in db.tblBiddings on
crps.RequestId equals bd.RequestId
select new
{
bd.BiddingId,
crps.CropType,
crps.CropName,
crps.Quantity,
bd.InitialPrice,
bd.PreviousBidPrice,
bd.BidCloseTime,
bd.CurrentBidPrice
}).ToList();
BiddingCrops output = new BiddingCrops();
foreach (var item in cp)
{
if (item.BiddingId == id)
{
output.Biddingid = (int)item.BiddingId;
output.CropName = item.CropName;
output.CropType = item.CropType;
output.Quantity = (int)item.Quantity;
output.InitalPrce = (int)item.InitialPrice;
output.CurrentBidPrice = (int)item.CurrentBidPrice;
output.PreviousBidPrice = (int)item.PreviousBidPrice;
output.BidCloseTime = (DateTime)item.BidCloseTime;
}
}
return(Ok(output));
}
public IHttpActionResult GetSales()
{
List <tblBidding> res = db.tblBiddings.ToList();
var cp = (from crps in db.tblCropRequests
join bd in db.tblBiddings on
crps.RequestId equals bd.RequestId
select new
{
bd.BiddingId,
crps.CropType,
crps.CropName,
crps.Quantity,
bd.InitialPrice,
bd.PreviousBidPrice,
bd.BidCloseTime,
bd.CurrentBidPrice,
bd.ApprovalAdminId
}).ToList();
List <BiddingCrops> output = new List <BiddingCrops>();
foreach (var item in cp)
{
DateTime t1 = (DateTime)item.BidCloseTime;
if (t1.Date >= DateTime.Now.Date && t1.TimeOfDay > DateTime.Now.TimeOfDay && item.ApprovalAdminId == null)
{
BiddingCrops bd = new BiddingCrops();
bd.Biddingid = (int)item.BiddingId;
bd.CropName = item.CropName;
bd.CropType = item.CropType;
bd.Quantity = (int)item.Quantity;
bd.InitalPrce = (int)item.InitialPrice;
bd.CurrentBidPrice = (int)item.CurrentBidPrice;
bd.PreviousBidPrice = (int)item.PreviousBidPrice;
bd.BidCloseTime = (DateTime)item.BidCloseTime;
output.Add(bd);
}
}
return(Ok(output));
}
