Esempio n. 1
0
        public ShowDTO map(ShowModel showmodel)
        {
            ShowDTO dto = new ShowDTO();

            dto.setID(showmodel.getID());
            dto.setGenre(showmodel.getGenre());
            dto.setDistribution(showmodel.getDistribution());
            dto.setDate(showmodel.getDate());
            dto.setNumberOfTickets(showmodel.getNumberOfTickets());
            dto.setTitle(showmodel.getTitle());

            return(dto);
        }
Esempio n. 2
0
        private void getAllShows()
        {
            showsList = new List <ShowDTO>();
            SqlCommand cmd = connectToDB();

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

            while (dataReader.Read())
            {
                ShowDTO show = new ShowDTO();
                show.setID((Int32)dataReader["ID"]);
                show.setTitle(dataReader["Title"].ToString());
                show.setGenre(dataReader["Genre"].ToString());
                show.setDistribution(dataReader["Distr"].ToString());
                DateTime dt;
                DateTime.TryParse(dataReader["Date"].ToString(), out dt);
                show.setDate(dt);
                show.setNumberOfTickets((Int32)dataReader["NumberOfTickets"]);
                showsList.Add(show);
            }
            cmd.Connection.Close();
        }
Esempio n. 3
0
        public List <ShowDTO> getShowsByTitle(string Title)
        {
            List <ShowDTO> showsByTitle = new List <ShowDTO>();
            SqlCommand     cmd          = connectToDB();

            cmd.Parameters.AddWithValue("Title", Title);
            cmd.CommandText = "select * from Shows where Title = @Title";
            SqlDataReader dataReader = cmd.ExecuteReader();

            while (dataReader.Read())
            {
                ShowDTO show = new ShowDTO();
                show.setID((Int32)dataReader["ID"]);
                show.setTitle(dataReader["Title"].ToString());
                show.setGenre(dataReader["Genre"].ToString());
                show.setDistribution(dataReader["Distr"].ToString());
                show.setDate(DateTime.Parse(dataReader["Date"].ToString()));
                show.setNumberOfTickets((Int32)dataReader["NumberOfTickets"]);
                showsByTitle.Add(show);
            }
            cmd.Connection.Close();

            return(showsByTitle);
        }