public void UpdateDetails(int userId, string emailAddress, string givenName, string familyName) { var user = _context.Users.SingleOrDefault(x => x.UserId == userId); user.EmailAddress = emailAddress; user.GivenName = givenName; user.FamilyName = familyName; _context.SaveChanges(); }
public int Add(string roleName) { var newRole = new Role { RoleName = roleName }; _context.Roles.Add(newRole); _context.SaveChanges(); return(newRole.RoleId); }
public int Create(string menuName) { var newMenu = new Entities.Models.Menu.Menu { MenuName = menuName }; _context.Menus.Add(newMenu); _context.SaveChanges(); return(newMenu.MenuId); }
public int Add(string postCategoryName) { var newPostCategory = new PostCategory { PostCategoryName = postCategoryName }; _context.PostCategories.Add(newPostCategory); _context.SaveChanges(); return(newPostCategory.PostCategoryId); }
public void Add(int postId, int imageId, PostImageType postImageType) { var postImage = new PostImage { PostId = postId, PostImageType = postImageType, ImageId = imageId }; _context.PostImages.Add(postImage); _context.SaveChanges(); }
public int Add(string settingName, string settingValue) { var newSetting = new Setting { SettingName = settingName, SettingValue = settingValue }; _context.Settings.Add(newSetting); _context.SaveChanges(); return(newSetting.SettingId); }
public int Create(string imageFilePath, ImageCategory imageCategory) { var image = new Image { ImagePath = imageFilePath, ImageCategory = imageCategory }; _context.Images.Add(image); _context.SaveChanges(); return(image.ImageId); }
public int Create(string copyName, string copyBody) { var newCopy = new WebCMS.Entities.Models.Copy.Copy { CopyName = copyName, CopyBody = copyBody, DateAdded = DateTime.Now, DateUpdated = DateTime.Now }; _context.CopySections.Add(newCopy); _context.SaveChanges(); return(newCopy.CopyId); }
public void Element(int pageSectionId, string elementId, string elementBody) { var pageSection = _context.PageSections.SingleOrDefault(x => x.PageSectionId == pageSectionId); if (pageSection == null) { return; } var document = new Document(pageSection.PageSectionBody); document.UpdateElementContent(elementId, elementBody); pageSection.PageSectionBody = document.OuterHtml; _context.SaveChanges(); }
public int Create(int menuId, string linkText, string linkAction, string linkController, string linkArea) { var newMenuItem = new Entities.Models.Menu.MenuItem { MenuId = menuId, LinkText = linkText, LinkAction = linkAction, LinkController = linkController, LinkArea = linkArea }; _context.MenuItems.Add(newMenuItem); _context.SaveChanges(); return(newMenuItem.MenuItemId); }
public int Add(int pageId, int pageSectionTypeId) { var page = _context.Pages.SingleOrDefault(x => x.PageId == pageId); var sectionType = _context.PageSectionTypes.SingleOrDefault(x => x.PageSectionTypeId == pageSectionTypeId); var sectionPosition = 1; if (page.PageSections.Any()) { sectionPosition = (page.PageSections.Max(x => x.PageSectionId) + 1); } var newPageSection = new PageSection { PageId = pageId, PageSectionTypeId = pageSectionTypeId, PageSectionBody = sectionType.PageSectionTypeBody, PageSectionOrder = sectionPosition }; _context.PageSections.Add(newPageSection); _context.SaveChanges(); var document = new Document(newPageSection.PageSectionBody); newPageSection.PageSectionBody = Document.ReplaceTokens(newPageSection.PageSectionBody, newPageSection.PageSectionId); _context.SaveChanges(); return(newPageSection.PageSectionId); }
public int Add(string pageName, string area, string controller, string action) { var newPage = new Page { PageName = pageName, PageArea = area, PageController = controller, PageAction = action, DateAdded = DateTime.Now, DateUpdated = DateTime.Now }; _context.Pages.Add(newPage); _context.SaveChanges(); return(newPage.PageId); }
public string Add(string emailAddress, UserTokenType userTokenType) { var user = _userService.Get(emailAddress); if (user == null) { return(string.Empty); } var userToken = new UserToken { UserId = user.UserId, Token = Guid.NewGuid().ToString(), UserTokenType = userTokenType, DateAdded = DateTime.Now }; _context.UserTokens.Add(userToken); _context.SaveChanges(); return(userToken.Token); }
public int?Register(string emailAddress, string password, string givenName, string familyName) { if (_context.Users.Any(x => x.EmailAddress.Equals(emailAddress, StringComparison.OrdinalIgnoreCase))) { return(-1); } var userAccount = new User { EmailAddress = emailAddress, Password = GenerateSecurePassword(password), GivenName = givenName, FamilyName = familyName, AvatarImagePath = "/Areas/Admin/Content/Images/profile-image-male.png", DateAdded = DateTime.Now, DateUpdated = DateTime.Now }; _context.Users.Add(userAccount); _context.SaveChanges(); return(userAccount.UserId); }
public void Add(int userId, int postId, string commentBody) { var comment = new PostComment { UserId = userId, PostId = postId, CommentBody = commentBody, DateAdded = DateTime.Now }; _context.PostComments.Add(comment); _context.SaveChanges(); }
public int Create(string postTitle, int postCategoryId, int postAuthorUserId, string postDescription, string postBody) { var post = new Post { PostTitle = postTitle, PostCategoryId = postCategoryId, PostAuthorUserId = postAuthorUserId, PostDescription = postDescription, PostBody = postBody, DateAdded = DateTime.Now, DateUpdated = DateTime.Now }; _context.Posts.Add(post); _context.SaveChanges(); return(post.PostId); }