public static List <Reservation> GetAllReservationDate()
{
using (var context = new BusProjectEntities())
{
return(context.Reservations.ToList());
}
}
public Customer GetByLogid(string loginId)
{
using (var context = new BusProjectEntities())
{
return(context.Customers.FirstOrDefault(x => x.LoginId == loginId));
}
}
public Reservation GetByReservationId(int reservationId)
{
using (var context = new BusProjectEntities())
{
return(context.Reservations.FirstOrDefault(x => x.ReservationId == reservationId));
}
}
public List <Customer> GetManReservation()
{
using (var context = new BusProjectEntities())
{
var query = from x in context.Customers
select x;
List <Customer> customers = query.ToList();
foreach (Customer customer in customers)
{
Seat seat = context.Seats.FirstOrDefault(x => x.CustomerId == customer.CustomerId);
customer.SeatColumn = seat.SeatColumn;
customer.SeatColumnNumber = seat.SeatColumnNumber;
customer.PaymentMethod = seat.PaymentMethod;
Operation operation = context.Operations.FirstOrDefault(x => x.OperationId == seat.OperationId);
customer.DepartureLocation = operation.DepartureLocation;
customer.ArrivalLocation = operation.ArrivalLocation;
customer.OperationDate = operation.OperationDate;
//customer.DepartureTime = operation.DepartureTime;
Route route = context.Routes.FirstOrDefault(x => x.RouteId == operation.RouteId);
customer.BusTypeId = route.BusTypeId;
Reservation reservation = context.Reservations.FirstOrDefault(x => x.RouteId == route.RouteId);
customer.ReservationDate = reservation.ReservationDate;
}
return(customers);
}
}
public List <string> GetArrivalCities(string arrival)
{
using (var context = new BusProjectEntities())
{
return(context.Routes.Select(x => x.ArrivalLocation).ToList());
}
}
public List <string> GetDepartureCities()
{
using (var context = new BusProjectEntities())
{
return(context.Routes.Select(x => x.DepartureLocation).ToList());
}
}
public static List <Route> GetByRouteId()
{
using (var context = new BusProjectEntities())
{
return(context.Routes.ToList());
}
}
public List <Operation> GetByOperationId(int operationId)
{
using (var context = new BusProjectEntities())
{
var query = from x in context.Operations
where x.OperationId == operationId
select x;
return(query.ToList());
}
}
public List <Reservation> ReservationRouteId()
{
using (var context = new BusProjectEntities())
{
var query = from x in context.Reservations
select new { Reservation = x, RouteId = x.RouteId };
var list = query.ToList();
foreach (var item in list)
{
item.Reservation.RouteId = item.RouteId;
}
return(list.ConvertAll(x => x.Reservation));
}
}
public List <Operation> GetManOperation()
{
using (var context = new BusProjectEntities())
{
var query = from x in context.Operations
select x;
List <Operation> operations = query.ToList();
foreach (Operation operation in operations)
{
Route route = context.Routes.SingleOrDefault(x => x.RouteId == operation.RouteId);
operation.DepartureLocation = route.DepartureLocation;
operation.ArrivalLocation = route.ArrivalLocation;
operation.BusTypeId = route.BusTypeId;
}
return(operations);
}
}