Exemple #1
0
        public TicketDTO map(TicketModel ticketmodel)
        {
            TicketDTO dto = new TicketDTO();

            dto.setID(ticketmodel.getID());
            dto.setShowID(ticketmodel.getShowID());
            dto.setRow(ticketmodel.getRow());
            dto.setColumn(ticketmodel.getColumn());

            return(dto);
        }
Exemple #2
0
        private void getAllTickets()
        {
            ticketsList = new List <TicketDTO>();
            SqlCommand cmd = connectToDB();

            cmd.CommandText = "select * from Tickets";
            SqlDataReader dataReader = cmd.ExecuteReader();

            while (dataReader.Read())
            {
                TicketDTO ticket = new TicketDTO();
                ticket.setID((Int32)dataReader["ID"]);
                ticket.setShowID((Int32)dataReader["ShowID"]);
                ticket.setRow((Int32)dataReader["Row"]);
                ticket.setColumn((Int32)dataReader["Col"]);
                ticketsList.Add(ticket);
            }
            cmd.Connection.Close();
        }
Exemple #3
0
        public List <TicketDTO> getTicketsByShowID(int ID)
        {
            List <TicketDTO> ticketByShow = new List <TicketDTO>();
            SqlCommand       cmd          = connectToDB();

            cmd.Parameters.AddWithValue("ShowID", ID);
            cmd.CommandText = "select * from Tickets where ShowID = @ShowID";
            SqlDataReader dataReader = cmd.ExecuteReader();

            while (dataReader.Read())
            {
                TicketDTO ticket = new TicketDTO();
                ticket.setID((Int32)dataReader["ID"]);
                ticket.setShowID((Int32)dataReader["ShowID"]);
                ticket.setRow((Int32)dataReader["Row"]);
                ticket.setColumn((Int32)dataReader["Col"]);
                ticketByShow.Add(ticket);
            }
            cmd.Connection.Close();

            return(ticketByShow);
        }