コード例 #1
0
        //Dodaje serial do bazy
        public void addTvSeries(Series s)
        {
            ReadFromDataBase rd = new ReadFromDataBase();

            if (!rd.SeriesExist(s._id))
            {
                SqlConnection Connect = new SqlConnection(DataBaseConnection.connString);
                SqlCommand    Command = new SqlCommand(@"Insert Into Series(Name, Id, Overview, LastUpdate) 
                                                    Values(@Name, @Id, @Overview, @LastUpdate)", Connect);

                Command.Parameters.AddWithValue("@Name", s._seriesName);
                Command.Parameters.AddWithValue("@Id", s._id);
                Command.Parameters.AddWithValue("@Overview", s._overview);
                Command.Parameters.AddWithValue("@LastUpdate", s._lastUpdated);


                Connect.Open();
                Command.ExecuteNonQuery();
                Connect.Close();

                //Wstawia baner, plakat jeśli istnieją
                UpdateDataBase UB = new UpdateDataBase();

                if (s._poster != null)
                {
                    UB.addPoster(s._id, s._poster);
                }

                if (s._banner != null)
                {
                    UB.addBanner(s._id, s._banner);
                }
            }
        }
コード例 #2
0
        //Dodaje epizod (jak data niepoprawna)
        private void addEpisodeWithoutDate(int SeriesId, Episode e)
        {
            ReadFromDataBase rd      = new ReadFromDataBase();
            SqlConnection    Connect = new SqlConnection(DataBaseConnection.connString);
            SqlCommand       Command = new SqlCommand(@"Insert Into Episode(SeriesId, Season, Number, Title, Id, Overview, LastUpdate) 
                                                    Values(@SeriesId, @Season, @Number, @Title, @Id, @Overview, @LastUpdate)", Connect);

            Command.Parameters.AddWithValue("@SeriesId", SeriesId);
            Command.Parameters.AddWithValue("@Season", e._seasonNumber);
            Command.Parameters.AddWithValue("@Number", e._episodeNumber);
            Command.Parameters.AddWithValue("@Title", e._episodeName != null ? e._episodeName : "");
            Command.Parameters.AddWithValue("@Id", e._id);
            Command.Parameters.AddWithValue("@Overview", e._overview != null ? e._overview : "");
            Command.Parameters.AddWithValue("@LastUpdate", e._lastUpdate);

            Connect.Open();
            Command.ExecuteNonQuery();
            Connect.Close();
        }