public async Task DeleteAsync(int pageAssociationId) { var pageAssociation = await _context.PageAssociations.SingleOrDefaultAsync(x => x.PageAssociationId == pageAssociationId); if (pageAssociation == null) { return; } if (pageAssociation.PageSection != null) { if (!await _context.PageAssociations.AnyAsync(x => x.PageSectionId == pageAssociation.PageSectionId)) { var pageSection = await _context.PageSections.SingleOrDefaultAsync(x => x.PageSectionId == pageAssociation.PageSectionId); _context.PageSections.Remove(pageSection); } } else if (pageAssociation.PagePartial != null) { if (!_context.PageAssociations.Any(x => x.PagePartialId == pageAssociation.PagePartialId)) { var pagePartial = await _context.PagePartials.SingleOrDefaultAsync(x => x.PagePartialId == pageAssociation.PagePartialId); _context.PagePartials.Remove(pagePartial); } } _context.PageAssociations.Remove(pageAssociation); await _context.SaveChangesAsync(); }
public async Task UpdateDetailsAsync(int userId, string emailAddress, string givenName, string familyName) { var user = await _context.Users.SingleOrDefaultAsync(x => x.UserId == userId); user.EmailAddress = emailAddress; user.GivenName = givenName; user.FamilyName = familyName; await _context.SaveChangesAsync(); }
public async Task <int> AddAsync(string roleName) { var newRole = new Role { RoleName = roleName }; _context.Roles.Add(newRole); await _context.SaveChangesAsync(); return(newRole.RoleId); }
public async Task AddAsync(int postId, int imageId, PostImageType postImageType) { var postImage = new PostImage { PostId = postId, PostImageType = postImageType, ImageId = imageId }; _context.PostImages.Add(postImage); await _context.SaveChangesAsync(); }
public async Task <int> AddAsync(string postCategoryName) { var newPostCategory = new PostCategory { PostCategoryName = postCategoryName }; _context.PostCategories.Add(newPostCategory); await _context.SaveChangesAsync(); return(newPostCategory.PostCategoryId); }
public async Task <int> CreateAsync(string imageFilePath, ImageCategory imageCategory) { var image = new Image { ImagePath = imageFilePath, ImageCategory = imageCategory }; _context.Images.Add(image); await _context.SaveChangesAsync(); return(image.ImageId); }
public async Task <int> UpsertAsync(int themeId, string themeName, int titleFontId, int textFontId, int largeTitleFontSize, int mediumTitleFontSize, int smallTitleFontSize, int tinyTitleFontSize, int textStandardFontSize, string pageBackgroundColour, string menuBackgroundColour, string menuTextColour) { var existingTheme = await GetAsync(themeId); if (existingTheme == null) { var newTheme = new CustomTheme { ThemeName = themeName, TitleFontId = titleFontId, TextFontId = textFontId, DateAdded = DateTime.Now, DateUpdated = DateTime.Now, TitleLargeFontSize = largeTitleFontSize, TitleMediumFontSize = mediumTitleFontSize, TitleSmallFontSize = smallTitleFontSize, TitleTinyFontSize = tinyTitleFontSize, TextStandardFontSize = textStandardFontSize, PageBackgroundColour = pageBackgroundColour, MenuBackgroundColour = menuBackgroundColour, MenuTextColour = menuTextColour, IsDefault = false, }; _context.Themes.Add(newTheme); await _context.SaveChangesAsync(); return(newTheme.ThemeId); } else { existingTheme.ThemeName = themeName; existingTheme.TitleFontId = titleFontId; existingTheme.TextFontId = textFontId; existingTheme.DateUpdated = DateTime.Now; existingTheme.TitleLargeFontSize = largeTitleFontSize; existingTheme.TitleMediumFontSize = mediumTitleFontSize; existingTheme.TitleSmallFontSize = smallTitleFontSize; existingTheme.TitleTinyFontSize = tinyTitleFontSize; existingTheme.TextStandardFontSize = textStandardFontSize; existingTheme.PageBackgroundColour = pageBackgroundColour; existingTheme.MenuBackgroundColour = menuBackgroundColour; existingTheme.MenuTextColour = menuTextColour; await _context.SaveChangesAsync(); return(existingTheme.ThemeId); } }
public async Task <int> CreateAsync(int menuId, string linkText, string linkURL, string linkIcon) { var newMenuItem = new MenuItem { MenuId = menuId, LinkText = linkText, LinkURL = linkURL, LinkIcon = linkIcon }; _context.MenuItems.Add(newMenuItem); await _context.SaveChangesAsync(); return(newMenuItem.MenuItemId); }
public async Task AddAsync(int pageId, string area, string controller, string action) { var page = await _context.Pages.SingleOrDefaultAsync(x => x.PageId == pageId); if (page == null) { return; } var orderPosition = 0; if (page.PageAssociations.Any()) { orderPosition = page.PageAssociations.Max(x => x.PageAssociationOrder + 1); } var pageAssociation = new PageAssociation { PageId = page.PageId, PageAssociationOrder = orderPosition, PagePartial = new PagePartial { RouteArea = area, RouteController = controller, RouteAction = action } }; _context.PageAssociations.Add(pageAssociation); await _context.SaveChangesAsync(); }
public async Task <int> CreateAsync(string copyName, string copyBody) { var newCopy = new CopyItem { CopyName = copyName, CopyBody = copyBody, DateAdded = DateTime.Now, DateUpdated = DateTime.Now }; _context.CopyItems.Add(newCopy); await _context.SaveChangesAsync(); return(newCopy.CopyId); }
public async Task <int> CreateAsync(string fontName, string fontType, string fontFilePath) { var newFont = new Font { FontName = fontName, FontType = fontType, FontPath = fontFilePath, DateAdded = DateTime.Now, DateUpdated = DateTime.Now }; _context.Fonts.Add(newFont); await _context.SaveChangesAsync(); return(newFont.FontId); }
public async Task LogPageViewAsync(string area, string controller, string action, string referredUrl, string ipAddress, string userAgent, int?userId) { var newAnalyticPageView = new AnalyticPageView { Area = area ?? "", Controller = controller, Action = action, ReferredUrl = referredUrl, IPAddress = ipAddress, UserAgent = userAgent, UserId = userId ?? 0, DateAdded = DateTime.Now }; _context.AnalyticPageViews.Add(newAnalyticPageView); await _context.SaveChangesAsync(); }
public async Task <int> AddAsync(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); await _context.SaveChangesAsync(); return(newPage.PageId); }
public async Task EditAsync(string settingName, string settingValue) { var setting = await _context.Settings.FirstOrDefaultAsync(x => x.SettingName == settingName); if (setting == null) { return; } setting.SettingValue = settingValue; await _context.SaveChangesAsync(); }
public async Task <int> CreateAsync(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); await _context.SaveChangesAsync(); return(post.PostId); }
public async Task AddAsync(int userId, int postId, string commentBody) { var comment = new PostComment { UserId = userId, PostId = postId, CommentBody = commentBody, DateAdded = DateTime.Now }; _context.PostComments.Add(comment); await _context.SaveChangesAsync(); }
public async Task <string> AddAsync(string emailAddress, UserTokenType userTokenType) { var user = await _userService.GetAsync(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); await _context.SaveChangesAsync(); return(userToken.Token); }
public async Task <int?> RegisterAsync(string emailAddress, string password, string givenName, string familyName) { if (await _context.Users.AnyAsync(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); await _context.SaveChangesAsync(); return(userAccount.UserId); }
public async Task AddAsync(int pageSectionId, string containerElementId, string elementBody) { var pageSection = await _context.PageSections.SingleOrDefaultAsync(x => x.PageSectionId == pageSectionId); if (pageSection == null) { return; } var document = new Document(pageSection.PageSectionBody); document.AddElement(containerElementId, elementBody); pageSection.PageSectionBody = document.OuterHtml; await _context.SaveChangesAsync(); }
public async Task <PageAssociation> AddAsync(int pageId, int pageSectionTypeId, string componentStamp) { var page = await _context.Pages.SingleOrDefaultAsync(x => x.PageId == pageId); if (page == null) { return(null); } var sectionType = await _context.PageSectionTypes.SingleOrDefaultAsync(x => x.PageSectionTypeId == pageSectionTypeId); if (sectionType == null) { return(null); } var sectionPosition = 1; if (page.PageAssociations.Any()) { sectionPosition = page.PageAssociations.Max(x => x.PageAssociationOrder) + 1; } var newPageAssociation = new PageAssociation { PageId = pageId, PageSection = new PageSection { PageSectionBody = sectionType.PageSectionTypeBody, }, PageAssociationOrder = sectionPosition }; _context.PageAssociations.Add(newPageAssociation); await _context.SaveChangesAsync(); newPageAssociation.PageSection.PageSectionBody = Document.ReplaceTokens(newPageAssociation.PageSection.PageSectionBody, newPageAssociation.PageSection.PageSectionId, componentStamp); await _context.SaveChangesAsync(); return(newPageAssociation); }