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 }
//Delete Tag from Database public static string DeleteTag(TagObject tag) { StringBuilder SQL_Statement = new StringBuilder(); SQL_Statement.Append("Delete from ReviewTags where TagID in (Select TagID from Tags where Name ='" + tag.Name + "' and TagType = '" + (char)tag.Type + "'); "); SQL_Statement.Append("Delete from Tags where Name ='" + tag.Name + "' and TagType = '" + (char)tag.Type + "';"); return(SQL_Statement.ToString()); }
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"); } }
public void deleteTag(TagObject tag) { ExecuteNoResponseSQL(SqlStatements.DeleteTag(tag)); }
public void AddTag(TagObject tag) { ExecuteNoResponseSQL(SqlStatements.AddTag(tag)); }
public void RemoveTag(TagObject newTag) { this.Tags.Remove(newTag); }
public void AddTag(TagObject Tag) { this.Tags.Add(Tag); }
public bool HasTag(TagObject tag) { return(this.Tags.Contains(tag)); }
//Add Tag to the table public static string AddTag(TagObject tag) { return("Insert into Tags(Name,TagType) VALUES('" + tag.Name + "','" + (char)tag.Type + "')"); }