public IEnumerable <TransactionDetailsViewModel> GetTransactionDetails()
{
List <TransactionDetailsViewModel> _list = new List <TransactionDetailsViewModel>();
List <BookingsViewModel> _bookingsViewModel = new List <BookingsViewModel>();
// _dbEntities.Configuration.ProxyCreationEnabled = false;
_bookingsViewModel = bvm.GetListofBookings().ToList();
try
{
_list = (from b in _bookingsViewModel
join c in _dbEntities.Customers on b.c_Id equals c.c_Id
join p in _dbEntities.Packages on b.pId equals p.p_id
select new TransactionDetailsViewModel()
{
transactionId = b.trn_Id,
Booking_Trans = b,
Customer = c,
Package_Trans = p
}).ToList();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(_list);
}
public PaymentsDetailsViewModel PayDetails(int trans_Id)
{
var _dbcontext = new PegasusEntities();
var bk = new BookingsViewModel();
var bookings = bk.GetListofBookings().ToList();
var pDetails = new PaymentsDetailsViewModel();
pDetails = (from b in bookings
select new PaymentsDetailsViewModel()
{
transId = trans_Id,
bookingview = b
}).FirstOrDefault(x => x.transId == trans_Id);
return(pDetails);
}
public IEnumerable <EventsViewModel> GetAllBookingEvents()
{
List <BookingsViewModel> eventbookings = new List <BookingsViewModel>();
eventbookings = bookModel.GetListofBookings().Where(x => x.iscancelled == false).ToList();
return((from e in eventbookings
select new EventsViewModel
{
EventId = e.trn_Id,
EventName = e.occasion,
EventDescription = e.venue,
StartDateTime = e.startdate,
EndDatetime = e.enddate,
packageType = e.packageType,
booktype = e.booktypecode?.Trim() ?? "",
eventType = "booking",
Allday = false
}).ToList());
}
