public List <DTO_Ticket> GetTicketsByBookingReference(string bookingReference) { List <DTO_Ticket> lsTicket = new List <DTO_Ticket>(); DataTable dt = dal_tickets.GetTicketsTableByBookingReference(bookingReference); foreach (DataRow dr in dt.Rows) { DTO_Ticket ticket = new DTO_Ticket(); ticket.ID = dr[0].ToString(); ticket.UserID = dr[1].ToString(); ticket.ScheduleID = dr[2].ToString(); ticket.CabinTypeID = dr[3].ToString(); ticket.FirstName = dr[4].ToString(); ticket.LastName = dr[5].ToString(); ticket.Phone = dr[6].ToString(); ticket.PassportNumber = dr[7].ToString(); ticket.PassportCountryID = dr[8].ToString(); ticket.BookingReference = dr[9].ToString(); ticket.Confirmed = dr[10].ToString(); lsTicket.Add(ticket); } return(lsTicket); }
public DTO_Ticket GetTicketByID(string ID) { DataTable dt = dal_tickets.GetTicketTableByID(ID); DataRow dr = dt.Rows[0]; DTO_Ticket ticket = new DTO_Ticket(); ticket.ID = dr["ID"].ToString(); ticket.UserID = dr["UserID"].ToString(); ticket.ScheduleID = dr["ScheduleID"].ToString(); ticket.CabinTypeID = dr["CabinTypeID"].ToString(); ticket.FirstName = dr["FirstName"].ToString(); ticket.LastName = dr["LastName"].ToString(); ticket.Phone = dr["Phone"].ToString(); ticket.PassportNumber = dr["PassportNumber"].ToString(); ticket.PassportCountryID = dr["PassportCountryID"].ToString(); ticket.BookingReference = dr["BookingReference"].ToString(); ticket.Confirmed = dr["Confirmed"].ToString(); return(ticket); }