public TagType GetTagType(string TagName)
{
//Length of inner array is 3, 1 = ID, 2 = Name, 3 = TagType
List <string[]> results = Query(SqlStatements.GetTagTypeFromTag(TagName));
return(TagObject.ConvertToTagType(results[0][2][0])); //takes the first char
}
public TagObject GetTag(string TagName)
{
List <string[]> results = Query(SqlStatements.GetTagTypeFromTag(TagName));
string Name = results[0][1];
TagType Type = TagObject.ConvertToTagType(results[0][2][0]); //takes the first char
TagObject tag = new TagObject(Name, Type);
return(tag);
}
//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 List <Review_Reference> getReviews(SQL_Review_REQUEST request)
{
List <string[]> results = Query(SqlStatements.GetMusicReviews_Builder(request));
List <Review_Reference> reviews = new List <Review_Reference>();
//Each row will be a review build them here and return them.
foreach (string[] row in results)
{
reviews.Add(new Review_Reference(row));
}
return(reviews);
}
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 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]
});
}
private void InitializeTags()
{
try
{
FileStream tagFile = new FileStream(TagFileName, FileMode.Open, FileAccess.ReadWrite);
StreamReader reader = new StreamReader(tagFile);
StringBuilder TagStrings = new StringBuilder();
List <TagObject> TagsToAdd = new List <TagObject>();
while (reader.EndOfStream == false)
{
readThroughWhiteSpace();
if (reader.EndOfStream == true)
{
return;
}
TagType nextTagType = TagObject.ConvertToTagType((char)reader.Read());
if (reader.EndOfStream == true)
{
return;
}
if ((char)reader.Read() != '<')
{
throw new Exception("Parse Error");
}
if (reader.EndOfStream == true)
{
return;
}
char nextToAdd = (char)reader.Read();
if (reader.EndOfStream == true)
{
return;
}
while (nextToAdd != '>')
{
TagStrings.Append(nextToAdd);
nextToAdd = (char)reader.Read();
if (nextToAdd != '>' && reader.EndOfStream == true)
{
throw new Exception("Parse Error");
}
}
TagsToAdd.Add(new TagObject(TagStrings.ToString(), nextTagType));
TagStrings.Clear();
}
System.Console.WriteLine(SqlStatements.AddTags(TagsToAdd));
ExecuteNoResponseSQL(SqlStatements.AddTags(TagsToAdd));
void readThroughWhiteSpace()
{
while (reader.EndOfStream == false && char.IsWhiteSpace((char)reader.Peek()))
{
reader.Read(); //read it in.
}
}
}
catch (System.IO.FileNotFoundException)
{
Console.WriteLine("Error in Project set up, tag ini files not found");
}
}
public void UpdateReview(ReviewObject old_ro, ReviewObject new_ro)
{
ExecuteNoResponseSQL(SqlStatements.UpdateReview(old_ro, new_ro));
}
public void deleteTag(TagObject tag)
{
ExecuteNoResponseSQL(SqlStatements.DeleteTag(tag));
}
public void deleteReview(Review_Reference ro)
{
ExecuteNoResponseSQL(SqlStatements.DeleteReview(ro));
}
public void deleteReview(ReviewObject ro)
{
ExecuteNoResponseSQL(SqlStatements.DeleteReview(ro));
}
public void AddTag(TagObject tag)
{
ExecuteNoResponseSQL(SqlStatements.AddTag(tag));
}
//Adding stuff to the database
public void AddReview(ReviewObject rvw)
{
ExecuteNoResponseSQL(SqlStatements.AddReview(rvw));
}
public int GetReviewID(string title, string artist, int releaseDate)
{
List <string[]> results = Query(SqlStatements.GetIDFromReview(title, artist, releaseDate));
return(int.Parse(results[0][0]));
}
public int GetTagID(string TagName)
{
List <string[]> results = Query(SqlStatements.GetTagTypeFromTag(TagName));
return(int.Parse(results[0][0]));
}
