public List <Log> GetAllLogItems()
{
string query = "select * from Log";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <Log>());
}
public List <Vehicle> GetVehiclesByUserId(string userId)
{
string query = "select * from Vehicle where UserId='" + userId + "'";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <Vehicle>());
}
public bool IsViaPointExists(Ride ride, string viaPoint)
{
string query = "select Name from ViaPoint where RideId='" + ride.Id + "'";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <string>().Contains(viaPoint));
}
public int GetViaPointsCount(Ride ride)
{
string query = "select * from ViaPoint where RideId='" + ride.Id + "'";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <ViaPoint>().Count());
}
public int GetIndex(Ride ride, string viaPoint)
{
string query = "select Name from ViaPoint where RideId='" + ride.Id + "'";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <string>().IndexOf(viaPoint));
}
public List <ViaPoint> GetAllViaPoints(string rideId)
{
string query = "select * from ViaPoint where RideId='" + rideId + "'";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <ViaPoint>());
}
public List <VehicleType> GetAllVehicleTypes()
{
string query = "select * from VehicleType";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
return(extensionObject.GetAllItems <VehicleType>());
}
public List <Ride> FindRide(string from, string to)
{
from = from.ToLower();
to = to.ToLower();
List <Ride> requiredRides = new List <Ride>();
int availableSeats = 0;
IBookingService bookingService = new BookingService(configuration);
IViaPointService viaPointService = new ViaPointService(configuration);
string query = "select * from Ride";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
List <Ride> rides = extensionObject.GetAllItems <Ride>();
foreach (Ride ride in rides)
{
availableSeats = bookingService.AvailableSeats(ride, from, to);
if (availableSeats > 0)
{
ride.AvailableSeats = availableSeats;
query = "select id,name,phoneNumber from [User] where Id= (select publisherId from Ride where Id='" + ride.Id + "')";
ExtensionObject publisherExtensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
ride.Publisher = publisherExtensionObject.GetItem <User>();
query = "select value from Status where Id=(select statusId from Ride where Id='" + ride.Id + "')";
ExtensionObject statusExtensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
ride.Status = statusExtensionObject.GetItem <Status>();
requiredRides.Add(ride);
}
}
return(requiredRides);
}
public int GetBookingsCount(string rideId, string from, string to)
{
string query = "select NumberOfSeatsBooked from Booking where StatusId in (select Id from Status where Type='Booking' and Value='Approved') and RideId='" + rideId +
"' and PickUp='" + from + "' and [Drop]='" + to + "'";
ExtensionObject extensionObject = new ExtensionObject()
{
Query = query,
ConnectionString = connectionString
};
List <Booking> approvedBookings = extensionObject.GetAllItems <Booking>();
int count = 0;
if (approvedBookings == null)
{
return(count);
}
foreach (Booking booking in approvedBookings)
{
count += booking.NumberOfSeatsBooked;
}
return(count);
}