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))); }