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()); }