public WritaSettings LoadSettings() { using (var db = new WritaBlogContext()) { return(db.WritaSettings.Take(1).SingleOrDefault()); } }
public void DeletePluginValue(string sid) { var db = new WritaBlogContext(); var plugin = db.WritaPluginSettings.AsQueryable().Where(w => w.Id == sid).SingleOrDefault(); db.WritaPluginSettings.Remove(plugin); db.SaveChanges(); }
public void UpdatePluginValue(string sid, string value) { var db = new WritaBlogContext(); var plugin = db.WritaPluginSettings.AsQueryable().Where(w => w.Id == sid).SingleOrDefault(); plugin.Value = value; db.SaveChanges(); }
public bool DeletePost(string postid) { var db = new WritaBlogContext(); var plugin = db.WritaPosts.AsQueryable().Where(w => w.PostId == postid).SingleOrDefault(); db.WritaPosts.Remove(plugin); db.SaveChanges(); return(true); }
public bool DeleteAllPosts() { var db = new WritaBlogContext(); var plugin = db.WritaPosts.AsQueryable().ToList(); db.WritaPosts.RemoveRange(plugin); db.SaveChanges(); return(true); }
public WritaUser UpdateUser(WritaUser u) { var db = new WritaBlogContext(); var euser = db.WritaUsers.AsQueryable().Where(w => w.Id == u.Id).SingleOrDefault(); euser.UserPasswordEncrypted = u.UserPasswordEncrypted; db.SaveChanges(); return(euser); }
public WritaUser CreateUser(WritaUser u) { var db = new WritaBlogContext(); u.Id = System.Guid.NewGuid().ToString(); db.WritaUsers.Add(u); db.SaveChanges(); return(u); }
public WritaStats GetStats() { WritaStats s = new WritaStats(); var db = new WritaBlogContext(); s.NumberOfPosts = db.WritaPosts.AsQueryable().Where(w => w.PostType == WritaPostType.BLOGPOST).Count(); s.NumberOfStaticPages = db.WritaPosts.AsQueryable().Where(w => w.PostType != WritaPostType.BLOGPOST).Count(); s.LastPostDate = db.WritaPosts.AsQueryable().Where(w => w.PostType == WritaPostType.BLOGPOST).OrderByDescending(w => w.PostCreated).Take(1).First().PostCreated; var config = LoadSettings(); s.ActiveTheme = config.BlogTheme; return(s); }
public WritaSettings SaveSettings(WritaSettings s) { using (var db = new WritaBlogContext()) { var x = db.WritaSettings.Take(1).SingleOrDefault(); x.BlogTheme = s.BlogTheme; x.BlogSummary = s.BlogSummary; x.BlogTitle = s.BlogTitle; x.BlogDefaultEmail = s.BlogDefaultEmail; db.SaveChanges(); } return(s); }
public WritaPost GetPreviousPost(WritaPost p) { var db = new WritaBlogContext(); var x = db.WritaPosts.AsQueryable().Where(w => w.PostCreated < p.PostCreated && w.PostType == WritaPostType.BLOGPOST && w.PostStatus == WritaPostStatus.PUBLISHED).OrderByDescending(w => w.PostCreated).Take(1).ToList(); if (x.Count == 1) { return(x[0]); } else { return(null); } }
public WritaPluginSetting GetPluginSettings(string PluginName, string Key, string DefaultValue) { var db = new WritaBlogContext(); var exists = db.WritaPluginSettings.AsQueryable().Where(w => w.PluginName == PluginName && w.Key == Key).SingleOrDefault(); if (exists != null) { return(exists); } else { WritaPluginSetting p = new WritaPluginSetting() { Id = System.Guid.NewGuid().ToString(), Key = Key, PluginName = PluginName, Value = DefaultValue }; db.WritaPluginSettings.Add(p); db.SaveChanges(); return(p); } }
public bool CheckInstall(GlobalSettings s) { try { using (var db = new WritaBlogContext()) { if (db.WritaPosts.Count() == 0) { InstallSet set = InstallHelper.GetInstall(); CreatePost(set.homepage); CreatePost(set.firstpost); db.WritaSettings.Add(set.settings); db.SaveChanges(); //install. } } return(true); } catch { return(false); } }
public WritaPost CreatePost(WritaPost p) { using (var db = new WritaBlogContext()) { p.PostId = System.Guid.NewGuid().ToString(); p.PostCreated = DateTime.Now; p.PostLastEdited = DateTime.Now; p.PostSlug = p.PostTitle.ToLower().Replace(" ", "-"); db.WritaPosts.Add(p); db.SaveChanges(); WritaPostContent c = new WritaPostContent(); c.PostContentId = System.Guid.NewGuid().ToString(); c.PostId = p.PostId; c.PostEditDate = DateTime.Now; c.PostEditAuthor = p.PostAuthor; c.PostMarkdown = p.PostContent; db.WritaPostContents.Add(c); db.SaveChanges(); return(p); } }
public WritaPost GetPostFromSlug(string slug) { var db = new WritaBlogContext(); return(db.WritaPosts.AsQueryable().Where(w => w.PostSlug == slug.ToLower()).SingleOrDefault()); }
public IQueryable <WritaPost> GetAllPosts() { var db = new WritaBlogContext(); return(db.WritaPosts.AsQueryable()); }
public WritaPost GetPostFromId(string id) { var db = new WritaBlogContext(); return(db.WritaPosts.AsQueryable().Where(w => w.PostId == id).SingleOrDefault()); }
public WritaUser GetUserById(WritaUser u) { var db = new WritaBlogContext(); return(db.WritaUsers.AsQueryable().Where(w => w.Id == u.Id).SingleOrDefault()); }
public IQueryable <WritaUser> GetUsers() { var db = new WritaBlogContext(); return(db.WritaUsers.AsQueryable()); }
public IQueryable <WritaPost> GetPosts() { var db = new WritaBlogContext(); return(db.WritaPosts.AsQueryable().Where(w => w.PostType == WritaPostType.BLOGPOST).AsQueryable()); }
public IQueryable <WritaPluginSetting> GetPluginSettings() { var db = new WritaBlogContext(); return(db.WritaPluginSettings.AsQueryable()); }