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)); }