public IHttpActionResult GetAuctionDetails()
{
// List<tblBidding> res = db.tblBiddings.ToList();
List <sp_approveauction_Result> cp = db.sp_approveauction().ToList();
List <AuctionCropDetails> output = new List <AuctionCropDetails>();
foreach (var item in cp)
{
DateTime t1 = (DateTime)item.BidCloseTime;
//t1.Date>DateTime.Now.Date
//if (t1.Date < DateTime.Now.Date || t1.TimeOfDay < DateTime.Now.TimeOfDay)
if (item.ApprovalAdminId == null && item.BidderId != null)
{
AuctionCropDetails crop = new AuctionCropDetails();
crop.BiddingId = (int)item.BiddingId;
crop.FarmerId = (int)item.FarmerId;
crop.BidderId = (int)item.BidderId;
crop.CropName = item.CropName;
crop.Quantity = (int)item.Quantity;
crop.InitialPrice = (int)item.InitialPrice;
crop.CurrentBidPrice = (int)item.CurrentBidPrice;
output.Add(crop);
}
}
return(Ok(output));
}
public IHttpActionResult GetAuctionDetails()
{
// List<tblBidding> res = db.tblBiddings.ToList();
var cp = (from crps in db.tblCropRequests
join bd in db.tblBiddings on crps.RequestId equals bd.RequestId
join fmr in db.tblFarmers on crps.FarmerId equals fmr.FarmerId
select new
{
bd.BiddingId,
bd.BidderId,
fmr.FarmerId,
crps.CropType,
crps.CropName,
bd.InitialPrice,
crps.Quantity,
bd.BidCloseTime,
bd.CurrentBidPrice,
bd.ApprovalAdminId
}).ToList();
List <AuctionCropDetails> output = new List <AuctionCropDetails>();
foreach (var item in cp)
{
DateTime t1 = (DateTime)item.BidCloseTime;
//t1.Date>DateTime.Now.Date
if (t1.Date < DateTime.Now.Date || t1.TimeOfDay < DateTime.Now.TimeOfDay)
{
if (item.ApprovalAdminId == null && item.BidderId != null)
{
AuctionCropDetails crop = new AuctionCropDetails();
crop.Biddingid = (int)item.BiddingId;
crop.Farmerid = (int)item.FarmerId;
crop.Bidderid = (int)item.BidderId;
crop.CropName = item.CropName;
crop.Quantity = (int)item.Quantity;
crop.InitalPrce = (int)item.InitialPrice;
crop.CurrentBidPrice = (int)item.CurrentBidPrice;
output.Add(crop);
}
}
}
return(Ok(output));
}
