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