public ActionResult EmailBody(int id) { var content = CurrentDatabase.ContentFromID(id); content.RemoveGrammarly(); return(View(content)); }
private int SaveDraft(int? draftId, string name, int roleId, string draftSubject, string draftBody, string draftDesign, bool? useUnlayer) { Content content = null; if (draftId.HasValue && draftId > 0) { content = CurrentDatabase.ContentFromID(draftId.Value); } if (content != null) { if (CurrentDatabase.Setting("UseEmailDraftVersioning", false)) { CurrentDatabase.ArchiveContent(draftId); } } else { content = new Content { Name = name.HasValue() ? name : "new draft " + DateTime.Now.FormatDateTm(), TypeID = ContentTypeCode.TypeSavedDraft, RoleID = roleId, OwnerID = Util.UserId }; } content.Title = draftSubject; if (useUnlayer.GetValueOrDefault()) { var body = new { design = draftDesign, rawHtml = GetBody(draftBody) }; content.Body = JsonConvert.SerializeObject(body); content.TypeID = ContentTypeCode.TypeUnlayerSavedDraft; } else { content.Body = GetBody(draftBody); } content.Archived = null; content.ArchivedFromId = null; content.DateCreated = DateTime.Now; if (!draftId.HasValue || draftId == 0) { CurrentDatabase.Contents.InsertOnSubmit(content); } CurrentDatabase.SubmitChanges(); return content.Id; }
public ActionResult ContentDelete(int id) { var content = CurrentDatabase.ContentFromID(id); CurrentDatabase.ExecuteCommand("DELETE FROM dbo.ContentKeywords WHERE Id = {0}", id); CurrentDatabase.ExecuteCommand("DELETE FROM dbo.Content WHERE Id = {0}", id); var url = GetIndexTabUrl(content); return(Redirect(url)); }
public ActionResult Content(int?id) { if (!id.HasValue) { throw new HttpException(404, "No ID found."); } var content = CurrentDatabase.ContentFromID(id.Value); if (content == null) { throw new HttpException(404, "No ID found."); } return(Content(content.Body)); }
private string SendAnEmail() { if (person == null) { return(GetNoPersonMessage()); } row.Args = $"{{ \"EmailId\": \"{action.EmailId}\"}}"; if (action.EmailId == null) { return(GetError($"Email Draft not found for id {action.EmailId}")); } var email = CurrentDatabase.ContentFromID(action.EmailId.Value); CurrentDatabase.Email(DbUtil.AdminMail, person, email.Title, email.Body); return(GetActionReplyMessage()); }
public Content SaveUnlayerTemplateCommon(int?saveid, string name, int roleid, string title, string body, string unlayerDesign) { Content content = null; if (saveid.HasValue && saveid > 0) { content = CurrentDatabase.ContentFromID(saveid.Value); } if (content == null) { content = new Content { Name = name.HasValue() ? name : "new template", TypeID = ContentTypeCode.TypeUnlayerTemplate, RoleID = roleid, OwnerID = CurrentDatabase.UserId }; } content.Title = title; content.RoleID = roleid; content.Name = name.HasValue() ? name : content.Name; content.DateCreated = DateTime.Now; content.CreatedBy = Util.UserName; var bodytemplate = new { design = unlayerDesign, rawHtml = GetBody(body) }; content.Body = JsonConvert.SerializeObject(bodytemplate); SaveThumbnail(body, content); if (!saveid.HasValue || saveid == 0) { CurrentDatabase.Contents.InsertOnSubmit(content); } CurrentDatabase.SubmitChanges(); return(content); }