public virtual Booking[] GetTicketsForUser(string username)
{
var userRepository = new TicketMasterUserRepository(new UnitOfWork.UnitOfWork());
var user = userRepository.GetUserByName(username);
return(DBContextFactory.GetDbContextInstance().Bookings.Where(p => p.UserId == user.UserId).ToArray());
}
public virtual BookingTicketInfo[] GetTicketsForUserVerified()
{
var DBContext = DBContextFactory.GetDbContextInstance();
var userRepository = new TicketMasterUserRepository(new UnitOfWork.UnitOfWork());
var tickets = from t in DBContext.Tickets
from b in DBContext.Bookings
from u in DBContext.TicketMasterUsers
where t.TicketId == b.TicketId && b.IsVerifiedPayment == true && u.UserId == b.UserId
select new BookingTicketInfo
{
BookingId = b.BookingId,
EventName = b.Ticket.Event.EventName,
IsVerifiedPayment = true,
NumberOfTickets = (int)b.NumberOfTickets,
Username = u.UserName
};
return(tickets.ToArray());
}