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