예제 #1
0
        public List<RideOffer> GetActiveOffers(Int64 requestRecID)
        {
            try
            {
                using (connection)
                {
                    rideOffersList = new List<RideOffer>();
                    connection = new SqlConnection(DAL.ConnectionString);

                    string sqlSelectString = "SELECT RideRequestRecID, DriverUserID, Notes, Status from [RideOffers] where Status in (1, 2) and RideRequestRecID = " + requestRecID;
                    command = new SqlCommand(sqlSelectString, connection);
                    command.Connection.Open();

                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        RideOffer rideOffer = new RideOffer();
                        User user = new User();
                        rideOffer.RideRequestRecID = Convert.ToInt64(reader[0]);
                        rideOffer.DriverUserID = reader[1].ToString();
                        rideOffer.Notes = reader[2].ToString();
                        rideOffer.Status = Convert.ToInt32(reader[3]);

                        user = userDAL.GetUser(rideOffer.DriverUserID);
                        rideOffer.Driver = user;

                        rideOffersList.Add(rideOffer);
                    }

                    command.Connection.Close();
                    return rideOffersList;
                }
            }
            catch (Exception ex)
            {
                // err.ErrorMessage = ex.Message.ToString();
                throw;
            }
        }
예제 #2
0
        public bool AcceptOffer(RideOffer rideOffer)
        {
            bool isAccepted = false;

            return isAccepted;
        }