Пример #1
0
        // NOT including image DATA, as that's not 'compulsory' data
        public void insertRow(ASComicAccess.xkcd.ComicMetadata metadata)
        {
            int num = int.Parse(metadata.num);
            string img = metadata.img;
            string safe_title = metadata.safe_title;
            string alt = metadata.alt;
            string transcript = metadata.transcript;
            string date = metadata.day + ":" + metadata.month + ":" + metadata.year;

            using (SqlCeConnection conn = new SqlCeConnection(@"Data Source = " + dbPath)) // DB connection
            {
                using (SqlCeCommand cmd = new SqlCeCommand(@"INSERT comics (num, img, safe_title, alt, transcript, date) VALUES (@num, @img, @safe_title, @alt, @transcript, @date)")) // SQL command
                {
                    // Add C# data to the SQL query
                    cmd.Parameters.AddWithValue(@"@num", num);
                    //cmd.Parameters.Add(new SqlCeParameter("@num", num));
                    cmd.Parameters.AddWithValue(@"@img", img);
                    cmd.Parameters.AddWithValue(@"@safe_title", safe_title);
                    cmd.Parameters.AddWithValue(@"@alt", alt);
                    cmd.Parameters.AddWithValue(@"@transcript", transcript);
                    cmd.Parameters.AddWithValue(@"@date", date);

                    conn.Open(); // Open DB connection
                    cmd.Connection = conn;
                    cmd.ExecuteNonQuery(); // Run query
                }
            }
        }
Пример #2
0
        // Get comic by ID test
        private bool testComicByID(ASComicAccess.xkcd testClass, int ID)
        {
            ASComicAccess.xkcd.ComicMetadata metadata;

            try
            {
                metadata = testClass.getComic(ID);
            }
            catch
            {
                return false; // Test failed.
            }

            output = ("\n         ID (string): " + (string)metadata.num + "\nComic Title (string): " + (string)metadata.safe_title + "\n"); // Generate output
            return true;
        }