public IHttpActionResult JoinedRiders(int rid) { RideRequest rr = new RideRequest(); rr.RideId = rid; rr.RequestStatus = "2"; List <RideRequest> rrlist = new RideRequestDAC().SelectALLAcceptedRequestByRideId(rr); List <JoinedRidersModel> jrlist = new List <JoinedRidersModel>(); if (rrlist != null) { foreach (RideRequest m in rrlist) { JoinedRidersModel jrmodel = new JoinedRidersModel(); Users utemp = new UsersDAC().SelectById(m.PassengerId); jrmodel.Id = m.Id; jrmodel.PassengerId = m.PassengerId; jrmodel.PickupLocation = m.PickupLocation; jrmodel.Destination = m.Destination; jrmodel.RideId = m.RideId; jrmodel.RequestStatus = m.RequestStatus; jrmodel.TotalAmount = m.TotalAmount; jrmodel.UserName = utemp.UserName; jrlist.Add(jrmodel); } jrlist.TrimExcess(); return(Ok(jrlist)); } else { return(NotFound()); } }
public IHttpActionResult SelectRideRequests(int uid) { Ride r = new Ride(); r.RideStatusId = 1; r.UserId = uid; List <Ride> rides = new RideDAC().SelectAllRidesByUserId(r); List <RideRequest> rtemplist = new List <RideRequest>(); List <JoinedRidersModel> jrlist = new List <JoinedRidersModel>(); if (rides != null) { foreach (Ride ride in rides) { rtemplist = new RideRequestDAC().SelectAllPendingRideRequestByRideId(ride.Id); if (rtemplist != null) { foreach (RideRequest m in rtemplist) { JoinedRidersModel jrmodel = new JoinedRidersModel(); Users utemp = new UsersDAC().SelectById(m.PassengerId); jrmodel.Id = m.Id; jrmodel.PassengerId = m.PassengerId; jrmodel.PickupLocation = m.PickupLocation; jrmodel.Destination = m.Destination; jrmodel.RideId = m.RideId; jrmodel.RequestStatus = m.RequestStatus; jrmodel.TotalAmount = m.TotalAmount; jrmodel.UserName = utemp.UserName; jrlist.Add(jrmodel); } rtemplist.Clear(); } } jrlist.TrimExcess(); return(Ok(jrlist)); } return(NotFound()); }