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);
}
