/// <summary>
/// Method - Get list of all users
/// </summary>
/// <returns>Employee</returns>
public List<RideRequest> GetActiveRideRequests()
{
try
{
using (connection)
{
requestList = new List<RideRequest>();
connection = new SqlConnection(DAL.ConnectionString);
string sqlSelectString = "SELECT userid, fromAddress, toAddress, pickupDate, pickupTime, status, recID from [RideRequests] where status = 1";
command = new SqlCommand(sqlSelectString, connection);
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
RideRequest rideRequest = new RideRequest();
User user = new User();
rideRequest.UserID = reader[0].ToString();
rideRequest.OriginAddress = reader[1].ToString();
rideRequest.DestinationAddress = reader[2].ToString();
rideRequest.PickupDate = Convert.ToString(reader[3]);
rideRequest.PickupTime = Convert.ToString(reader[4]);
rideRequest.Status = Convert.ToInt32(reader[5].ToString());
rideRequest.RecID = Convert.ToInt64(reader[6]);
user = userDAL.GetUser(rideRequest.UserID);
rideRequest.Requestor = user;
requestList.Add(rideRequest);
}
command.Connection.Close();
return requestList;
}
}
catch (Exception ex)
{
// err.ErrorMessage = ex.Message.ToString();
throw;
}
}
public bool insert(RideRequest rideRequest)
{
bool isInserted;
try
{
using (connection)
{
connection = new SqlConnection(DAL.ConnectionString);
Int64 nextRecID = getNextRecID();
string sqlSelectString = "INSERT into [RideRequests] (Userid, FromAddress, ToAddress, PickupDate, PickupTime, Status, RecID) values('"
+ rideRequest.UserID + "','"
+ rideRequest.OriginAddress + "','"
+ rideRequest.DestinationAddress + "','"
+ rideRequest.PickupDate + "','"
+ rideRequest.PickupTime + "', 1, "+nextRecID+")";
command = new SqlCommand(sqlSelectString, connection);
command.Connection.Open();
int totalRowsAffected = command.ExecuteNonQuery();
command.Connection.Close();
isInserted = totalRowsAffected > 0;
return isInserted;
}
}
catch (Exception ex)
{
// err.ErrorMessage = ex.Message.ToString();
throw;
}
}