Example #1
0
        public ReviewObject GetReview(string title, string artist, int releaseDate)
        {
            List <string[]> results = Query(SqlStatements.GetIDFromReview(title, artist, releaseDate));

            return(new ReviewObject
            {
                Title = results[0][1],
                Release_Date = int.Parse(results[0][2]),
                Review_Date = int.Parse(results[0][3]),
                Album = results[0][4],
                Artist = results[0][5],
                Rating = float.Parse(results[0][6]),
                Review = results[0][7],
                File_Path = results[0][8]
            });
        }
Example #2
0
        public int GetReviewID(string title, string artist, int releaseDate)
        {
            List <string[]> results = Query(SqlStatements.GetIDFromReview(title, artist, releaseDate));

            return(int.Parse(results[0][0]));
        }