public bool RemoveByPath(String path) { using (var db = new SQLLite3Context()) { db.TagTable.Where(b => b.Path.Equals(path.ToLower())).DeleteFromQuery(); return(db.SaveChanges() > 0); } }
public bool UpdateAllTag(string oldTag, string newTag) { using (var db = new SQLLite3Context()) { db.TagTable.Where(b => b.Tag.Equals(oldTag.ToLower())) .UpdateFromQuery(x => new TagEntity { Tag = newTag.ToLower(), OriginalTag = newTag }); return(db.SaveChanges() > 0); } }
public bool IsExist(String tag, String path) { using (var db = new SQLLite3Context()) { var tags = db.TagTable.Where(b => b.Tag.Equals(tag.ToLower()) && b.Path.Equals(path.ToLower())); if (tags == null || !tags.Any()) { return(false); } return(true); } }
public List <TagEntity> GetTagsByTag(String tag) { using (var db = new SQLLite3Context()) { var tags = db.TagTable.Where(b => b.Path.Equals(tag.ToLower())); if (tags == null || !tags.Any()) { return(new List <TagEntity>()); } return(tags.ToList <TagEntity>()); } }
public bool Add(String tag, String path) { if (IsExist(tag, path)) { return(false); } TagEntity tagEntity = new TagEntity(tag, path); using (var db = new SQLLite3Context()) { db.TagTable.Add(tagEntity); return(db.SaveChanges() > 0); } }
public bool UpdateTag(String path, string oldTag, string newTag) { if (!IsExist(path, oldTag)) { return(false); } using (var db = new SQLLite3Context()) { var tagE = db.TagTable.Where(b => b.Tag.Equals(oldTag.ToLower()) && b.Path.Equals(path.ToLower())).FirstOrDefault(); tagE.Tag = newTag.ToLower(); tagE.OriginalTag = newTag; return(db.SaveChanges() > 0); } }