Exemplo n.º 1
0
 public int getTicketCountEvent(Event _event)
 {
     int count = 0;
     eventDAO = EventDAOMySQL.getInstance();
     int id = eventDAO.getId(_event);
     String sql = "SELECT id FROM ticket WHERE event_id=" + id;
     try
     {
         conn.Open();
         MySqlCommand cmd = new MySqlCommand(sql, conn);
         MySqlDataReader reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             id = (int)reader["id"];
             count++;
         }
     }
     catch (MySqlException e)
     {
         Console.WriteLine(e.Message);
     }
     finally
     {
         conn.Close();
     }
     return count;
 }
Exemplo n.º 2
0
 public bool checkTicket(Ticket ticket)
 {
     bool ok = true;
     eventDAO = EventDAOMySQL.getInstance();
     int id = eventDAO.getId(ticket._event);
     String sql = "SELECT id FROM ticket WHERE event_id=" + id + " AND number=" + ticket.number +
         " AND row=" + ticket.row;
     try
     {
         conn.Open();
         MySqlCommand cmd = new MySqlCommand(sql, conn);
         MySqlDataReader reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             id = (int)reader["id"];
             ok = false;
         }
     }
     catch (MySqlException e)
     {
         Console.WriteLine(e.Message);
     }
     finally
     {
         conn.Close();
     }
     return ok;
 }
Exemplo n.º 3
0
 public List<Ticket> getTicketsOfEvent(Event _event)
 {
     List<Ticket> tickets = new List<Ticket>();
     eventDAO = EventDAOMySQL.getInstance();
     int id = eventDAO.getId(_event);
     String sql = "SELECT * FROM ticket WHERE event_id=" + id;
     try
     {
         conn.Open();
         MySqlCommand cmd = new MySqlCommand(sql, conn);
         MySqlDataReader reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             Ticket ticket = new Ticket(_event, (int)reader["number"], (int)reader["row"]);
             tickets.Add(ticket);
         }
     }
     catch (MySqlException e)
     {
         Console.WriteLine(e.Message);
     }
     finally
     {
         conn.Close();
     }
     return tickets;
 }
Exemplo n.º 4
0
        public void addTicket(Ticket ticket)
        {
            EventDAOMySQL eventDAO = EventDAOMySQL.getInstance();
            int eventId = eventDAO.getId(ticket._event);
            String sql = "INSERT INTO ticket(`row`,`number`,`event_id`) VALUES(" + ticket.row +
                "," + ticket.number + "," + eventId + ");";

            conn.Open();
            MySqlCommand cmd = new MySqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
        }