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 List <TagObject> GetAllTags()
{
List <TagObject> allTags = new List <TagObject>();
List <string[]> results = Query(SqlStatements.GetAllTags);
foreach (string[] row in results)
{
allTags.Add(new TagObject(row[1], TagObject.ConvertToTagType(row[2][0])));
}
return(allTags);
}
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);
}
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");
}
}
