public BookCarRequestModel(int _carId, string _customerId, DestinationOrigin _customerCurrentPosition, DestinationOrigin _customerDestinationPosition)
{
car_id = _carId;
customerId = _customerId;
customerCurrentPosition = _customerCurrentPosition;
customerDestinationPosition = _customerDestinationPosition;
}
public BookCarRequestModel()
{
car_id = 0;
customerId = string.Empty;
customerCurrentPosition = new DestinationOrigin();
customerDestinationPosition = new DestinationOrigin();
}
public List <DestinationOrigin> GetDestinationOrigins()
{
List <DestinationOrigin> originFlights = new List <DestinationOrigin>();
try
{
var conn = _dbContext.ConnectToDB();
var rdr = _dbContext.ExecuteQuery("SELECT dest , COUNT(dest), origin FROM flights WHERE dest IN (select * FROM (Select dest FROM flights GROUP BY dest ORDER BY COUNT(dest) DESC LIMIT 0,10) AS t1) GROUP BY dest, origin ORDER BY origin, dest;", conn);
var j = 0;
while (rdr.Read() && j < 3)
{
var originFlight = new DestinationOrigin {
Origin = rdr.GetString(2)
};
var origin = originFlight.Origin;
var flights = new List <DestinationFlights>();
do
{
var flight = new DestinationFlights
{
Destination = rdr.GetString(0),
count = rdr.GetInt16(1)
};
flights.Add(flight);
origin = rdr.GetString(2);
} while (rdr.Read() && rdr.GetString(2) == origin);
originFlight.Flights = flights;
originFlights.Add(originFlight);
j++;
}
_dbContext.CloseConnections(rdr, conn);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(originFlights);
}
public BookCarResponseModel bookCar(BookCarRequestModel bookCarRequestModel)
{
if (lstCars.Where(lc => lc.bookedBy == bookCarRequestModel.customerId).Count() != 0)
{
return(new BookCarResponseModel(string.Format("{0} is already booked", bookCarRequestModel.car_id), false));
}
Car car = lstCars.Find(c => c.id == bookCarRequestModel.car_id && c.isBooked == false);
if (car != null)
{
car.isBooked = true;
car.bookedBy = bookCarRequestModel.customerId;
car.lstDestinationPosition.Clear();
DestinationOrigin dOrigin = new DestinationOrigin(bookCarRequestModel.customerCurrentPosition.x, bookCarRequestModel.customerCurrentPosition.y, false);
DestinationOrigin dOrigin1 = new DestinationOrigin(bookCarRequestModel.customerDestinationPosition.x, bookCarRequestModel.customerDestinationPosition.y, false);
car.lstDestinationPosition.Add(dOrigin);
car.lstDestinationPosition.Add(dOrigin1);
return(new BookCarResponseModel(string.Format("{0} is booked for {1}", bookCarRequestModel.car_id, bookCarRequestModel.customerId), true));
}
return(new BookCarResponseModel(string.Format("{0} is already booked", bookCarRequestModel.car_id), false));
}