public TagCollection FetchAll() { TagCollection coll = new TagCollection(); Query qry = new Query(Tag.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public static WeightedTagList GetOrInsertTags(string tagString, bool isAdministrator) { List<string> rawTags = TagHelper.DistillTagInput(tagString, isAdministrator); WeightedTagList tags = new WeightedTagList(); TagCollection newTags = new TagCollection(); foreach (string tagIdentifier in rawTags) { //TODO: GJ: get from cache Tag tag = Tag.FetchTagByIdentifier(tagIdentifier); if (tag == null) { tag = new Tag(); tag.TagIdentifier = tagIdentifier; newTags.Add(tag); } else { tags.Add(new WeightedTag(tag.TagID, tag.TagIdentifier, 1)); } } // newTags.BatchSave(); //TODO: GJ: does BatchSave update identity colums after save? foreach (Tag newTag in newTags) { newTag.Save(); //TODO: GJ: does BatchSave update identity colums after save? tags.Add(new WeightedTag(newTag.TagID, newTag.TagIdentifier, 1)); } return tags; }
public static Tag FetchTagByParameter(string columnName, object value) { //NOTE: GJ: maybe we should add support for this in SubSonic? (like rails does) TagCollection t = new TagCollection(); t.Load(Tag.FetchByParameter(columnName, value)); if (t.Count == 0) return null; else return t[0]; }
public static TagCollection FetchUserTags(int userID) { TagCollection tags = new TagCollection(); tags.Load(SPs.Kick_GetTagsByUserID(userID).GetReader()); return tags; }
public static TagCollection FetchTags(int hostID, DateTime createdOnLower, DateTime createdOnUpper) { TagCollection tags = new TagCollection(); tags.Load(SPs.Kick_GetTagsByHostIDAndCreatedOnRange(hostID, createdOnLower, createdOnUpper).GetReader()); return tags; }
public static TagCollection FetchStoryTags(int storyID) { TagCollection tags = new TagCollection(); tags.LoadAndCloseReader(SPs.Kick_GetTagsByStoryID(storyID).GetReader()); return tags; }
public TagCollection FetchByQuery(Query qry) { TagCollection coll = new TagCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public TagCollection FetchByID(object TagID) { TagCollection coll = new TagCollection().Where("TagID", TagID).Load(); return coll; }
public TagCollection FetchByID(object TagID) { TagCollection coll = new TagCollection().Where("TagID", TagID).Load(); return(coll); }