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 DeleteAllPosts() { var db = new WritaBlogContext(); var plugin = db.WritaPosts.AsQueryable().ToList(); db.WritaPosts.RemoveRange(plugin); db.SaveChanges(); return(true); }
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 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 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 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 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); } }