public List <VoyageViewModel> SearchVoyages(SearchVoyageViewModel searchVoyage)
{
var result = new List <VoyageViewModel>();
var d = DateTime.Parse(searchVoyage.Date);
var d1 = d.AddDays(1);
using (var DB = new BusTicketsContext())
{
result = DB.Voyages.Where(x => x.DepartureStopId == searchVoyage.DepartureId &&
x.ArivalStopId == searchVoyage.ArriveId &&
x.DepartureDateTime > d && x.DepartureDateTime < d1)
.Select(x => new VoyageViewModel
{
Id = x.Id,
Name = x.VoyageName,
Number = x.VoyageNumber,
TravelTime = x.TravelTime.ToString(),
Departure = x.DepartureDateTime.ToString(),
Arrival = x.ArrivalDateTime.ToString(),
NumberSeats = x.NumberOfSeets,
OneTicketCost = x.TicketCost
}).ToList();
}
return(result);
}
public JsonResult SearchVoyage(SearchVoyageViewModel voyage)
{
return(Json(_service.SearchVoyages(voyage)));
}
