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