public static string DeleteReview(Review_Reference ro)
{
StringBuilder SQL_Statement = new StringBuilder();
SQL_Statement.Append("Delete from ReviewTags where ReviewID in (Select ID as ReviewID from MusicReview where Title = '" + ro.Title + "' and " + "Artist = '" + ro.Artist + "'" + " and Release_Date = " + ro.Release_Date.ToString() + "); ");
SQL_Statement.Append("Delete from MusicReview where Title = '" + ro.Title + "' and " + "Artist = '" + ro.Artist + "'" + " and Release_Date = " + ro.Release_Date.ToString());
return(SQL_Statement.ToString());
}
//Get All the Tags assosiated with a review object
//Does not set the Review OBject with tags.
public List <TagObject> GetTagsForReview(Review_Reference ro)
{
List <TagObject> ReviewTags = new List <TagObject>();
List <string[]> results = Query(SqlStatements.GetTagsForReview(ro));
foreach (string[] row in results)
{
ReviewTags.Add(new TagObject(row[0], TagObject.ConvertToTagType(row[1][0])));
}
return(ReviewTags);
}
public static string GetTagsForReview(Review_Reference ro)
{
StringBuilder SQL_Statement = new StringBuilder();
if (ro.Valid())
{
SQL_Statement.Append("Select Name, TagType from MusicReview inner join ReviewTags on MusicReview.ID = ReviewTags.ReviewID inner join Tags on ReviewTags.TagID = Tags.TagID where ");
SQL_Statement.Append("Title = '" + ro.Title + "' AND ");
SQL_Statement.Append("Artist = '" + ro.Artist + "' AND ");
SQL_Statement.Append("Release_Date = " + ro.Release_Date.ToString());
}
return(SQL_Statement.ToString());
}
public ReviewObject GetReview(Review_Reference RR)
{
List <string[]> results = Query(SqlStatements.GetReview(RR));
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]
});
}
public void deleteReview(Review_Reference ro)
{
ExecuteNoResponseSQL(SqlStatements.DeleteReview(ro));
}
public static string GetReview(Review_Reference ro)
{
return("Select * from MusicReview Where Title = '" + ro.Title + "' And Artist = '" + ro.Artist + "' And Release_Date = " + ro.Release_Date.ToString());
}
