protected override void Seed(MvcForumContext context)
{
#region Initial Installer Code
//var isFirstInstall = false;
// Add the language - If it's not already there
const string langCulture = "en-GB";
var language = context.Language.FirstOrDefault(x => x.LanguageCulture == langCulture);
if (language == null)
{
//isFirstInstall = true;
var cultureInfo = LanguageUtils.GetCulture(langCulture);
language = new Language
{
Name = cultureInfo.EnglishName,
LanguageCulture = cultureInfo.Name
};
context.Language.Add(language);
// Save the language
context.SaveChanges();
// Now add the default language strings
var file = HostingEnvironment.MapPath(@"~/Installer/en-GB.csv");
var commaSeparator = new[] { ',' };
if (file != null)
{
// Unpack the data
var allLines = new List <string>();
using (var streamReader = new StreamReader(file, Encoding.UTF8, true))
{
while (streamReader.Peek() >= 0)
{
allLines.Add(streamReader.ReadLine());
}
}
// Read the CSV file and import all the keys and values
var lineCounter = 0;
foreach (var csvline in allLines)
{
var line = csvline;
if (line.StartsWith("\""))
{
line = line.Replace("\"", "");
}
lineCounter++;
// Only split on the first comma, so the value strings can have commas in
var keyValuePair = line.Split(commaSeparator, 2, StringSplitOptions.None);
// Get the key and value
var key = keyValuePair[0];
var value = keyValuePair[1];
if (string.IsNullOrWhiteSpace(key))
{
// Ignore empty keys
continue;
}
if (string.IsNullOrWhiteSpace(value))
{
// Ignore empty values
continue;
}
// Trim both the key and value
key = key.Trim();
value = value.Trim();
// Create the resource key
var resourceKey = new LocaleResourceKey
{
Name = key,
DateAdded = DateTime.UtcNow
};
context.LocaleResourceKey.Add(resourceKey);
// Set the value for the resource
var stringResource = new LocaleStringResource
{
Language = language,
LocaleResourceKey = resourceKey,
ResourceValue = value
};
context.LocaleStringResource.Add(stringResource);
}
// Save the language strings
context.SaveChanges();
}
var saveRoles = false;
// Create the admin role if it doesn't exist
var adminRole = context.MembershipRole.FirstOrDefault(x => x.RoleName == AppConstants.AdminRoleName);
if (adminRole == null)
{
adminRole = new MembershipRole {
RoleName = AppConstants.AdminRoleName
};
context.MembershipRole.Add(adminRole);
saveRoles = true;
}
// Create the Standard role if it doesn't exist
var standardRole = context.MembershipRole.FirstOrDefault(x => x.RoleName == SiteConstants.Instance.StandardMembers);
if (standardRole == null)
{
standardRole = new MembershipRole {
RoleName = SiteConstants.Instance.StandardMembers
};
context.MembershipRole.Add(standardRole);
saveRoles = true;
}
// Create the Guest role if it doesn't exist
var guestRole = context.MembershipRole.FirstOrDefault(x => x.RoleName == AppConstants.GuestRoleName);
if (guestRole == null)
{
guestRole = new MembershipRole {
RoleName = AppConstants.GuestRoleName
};
context.MembershipRole.Add(guestRole);
saveRoles = true;
}
if (saveRoles)
{
context.SaveChanges();
}
// Create an example Category
if (!context.Category.Any())
{
// Doesn't exist so add the example category
const string exampleCatName = "Example Category";
var exampleCat = new Category
{
Name = exampleCatName,
ModeratePosts = false,
ModerateTopics = false,
Slug = ServiceHelpers.CreateUrl(exampleCatName),
DateCreated = DateTime.UtcNow
};
context.Category.Add(exampleCat);
context.SaveChanges();
}
// if the settings already exist then do nothing
// If not then add default settings
var currentSettings = context.Setting.FirstOrDefault();
if (currentSettings == null)
{
// create the settings
var settings = new Settings
{
ForumName = "MvcForum",
ForumUrl = "http://www.mydomain.com",
IsClosed = false,
EnableRSSFeeds = true,
DisplayEditedBy = true,
EnablePostFileAttachments = false,
EnableMarkAsSolution = true,
EnableSpamReporting = true,
EnableMemberReporting = true,
EnableEmailSubscriptions = true,
ManuallyAuthoriseNewMembers = false,
EmailAdminOnNewMemberSignUp = true,
TopicsPerPage = 20,
PostsPerPage = 20,
EnablePrivateMessages = true,
MaxPrivateMessagesPerMember = 50,
PrivateMessageFloodControl = 1,
EnableSignatures = false,
EnablePoints = true,
PointsAllowedToVoteAmount = 1,
PointsAllowedForExtendedProfile = 1,
PointsAddedPerPost = 1,
PointsAddedForSolution = 4,
PointsDeductedNagativeVote = 2,
PointsAddedPostiveVote = 2,
AdminEmailAddress = "*****@*****.**",
NotificationReplyEmail = "*****@*****.**",
SMTPEnableSSL = false,
Theme = "Metro",
NewMemberStartingRole = standardRole,
DefaultLanguage = language,
ActivitiesPerPage = 20,
EnableAkisment = false,
EnableSocialLogins = false,
EnablePolls = true,
MarkAsSolutionReminderTimeFrame = 7,
EnableEmoticons = true,
DisableStandardRegistration = false
};
context.Setting.Add(settings);
context.SaveChanges();
}
// Create the initial category permissions
// Edit Posts
if (context.Permission.FirstOrDefault(x => x.Name == SiteConstants.Instance.PermissionEditPosts) ==
null)
{
var permission = new Permission {
Name = SiteConstants.Instance.PermissionEditPosts
};
context.Permission.Add(permission);
// NOTE: Because this is null - We assumed it's a new install so carry on checking and adding the other permissions
// Read Only
if (context.Permission.FirstOrDefault(x => x.Name == SiteConstants.Instance.PermissionReadOnly) ==
null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionReadOnly
};
context.Permission.Add(p);
}
// Delete Posts
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionDeletePosts) == null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionDeletePosts
};
context.Permission.Add(p);
}
// Sticky Topics
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionCreateStickyTopics) ==
null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionCreateStickyTopics
};
context.Permission.Add(p);
}
// Lock Topics
if (context.Permission.FirstOrDefault(x => x.Name == SiteConstants.Instance.PermissionLockTopics) ==
null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionLockTopics
};
context.Permission.Add(p);
}
// Vote In Polls
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionVoteInPolls) == null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionVoteInPolls
};
context.Permission.Add(p);
}
// Create Polls
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionCreatePolls) == null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionCreatePolls
};
context.Permission.Add(p);
}
// Create Topics
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionCreateTopics) == null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionCreateTopics
};
context.Permission.Add(p);
}
// Attach Files
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionAttachFiles) == null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionAttachFiles
};
context.Permission.Add(p);
}
// Deny Access
if (context.Permission.FirstOrDefault(x => x.Name == SiteConstants.Instance.PermissionDenyAccess) ==
null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionDenyAccess
};
context.Permission.Add(p);
}
// === Global Permissions === //
// Deny Access
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionEditMembers) == null)
{
var p = new Permission {
Name = SiteConstants.Instance.PermissionEditMembers, IsGlobal = true
};
context.Permission.Add(p);
}
// Insert Editor Images
if (context.Permission.FirstOrDefault(x =>
x.Name == SiteConstants.Instance.PermissionInsertEditorImages) ==
null)
{
var p = new Permission
{
Name = SiteConstants.Instance.PermissionInsertEditorImages,
IsGlobal = true
};
context.Permission.Add(p);
}
// Save to the database
context.SaveChanges();
}
// If the admin user exists then don't do anything else
const string adminUsername = "******";
if (context.MembershipUser.FirstOrDefault(x => x.UserName == adminUsername) == null)
{
// create the admin user and put him in the admin role
var admin = new MembershipUser
{
Email = "*****@*****.**",
UserName = adminUsername,
Password = "******",
IsApproved = true,
DisableEmailNotifications = false,
DisablePosting = false,
DisablePrivateMessages = false,
CreateDate = DateTime.UtcNow,
LastLockoutDate = (DateTime)SqlDateTime.MinValue,
LastPasswordChangedDate = (DateTime)SqlDateTime.MinValue,
LastLoginDate = DateTime.UtcNow,
LastActivityDate = null,
IsLockedOut = false,
Slug = ServiceHelpers.CreateUrl(adminUsername)
};
// Hash the password
var salt = StringUtils.CreateSalt(AppConstants.SaltSize);
var hash = StringUtils.GenerateSaltedHash(admin.Password, salt);
admin.Password = hash;
admin.PasswordSalt = salt;
// Put the admin in the admin role
admin.Roles = new List <MembershipRole> {
adminRole
};
context.MembershipUser.Add(admin);
context.SaveChanges();
// Now add read me
const string name = "Read Me";
var category = context.Category.FirstOrDefault();
var topic = new Topic
{
Category = category,
CreateDate = DateTime.UtcNow,
User = admin,
IsSticky = true,
Name = name,
Slug = ServiceHelpers.CreateUrl(name)
};
context.Topic.Add(topic);
context.SaveChanges();
const string readMeText = @"<h2>Administration</h2>
<p>We have auto created an admin user for you to manage the site</p>
<p>Username: <strong>admin</strong><br />Password: <strong>password</strong></p>
<p>Once you have logged in, you can manage the forum <a href=""/admin/"">through the admin section</a>. </p>
<p><strong><font color=""#ff0000"">Important:</font> </strong>Please update the admin password (and username) before putting this site live.</p>
<h2>Documentation</h2>
<p>We have documentation on Github in the WIKI</p>
<p><a href=""https://github.com/YodasMyDad/mvcforum/wiki"">https://github.com/YodasMyDad/mvcforum/wiki</a></p>
<p>You can also grab the source code from Github too.</p>";
var post = new Post
{
DateCreated = DateTime.UtcNow,
DateEdited = DateTime.UtcNow,
Topic = topic,
IsTopicStarter = true,
User = admin,
PostContent = readMeText,
SearchField = name
};
topic.LastPost = post;
context.Post.Add(post);
context.SaveChanges();
}
}
else
{
// ---- Do Data Updates here
// Data to update on versions v1.7+
// Insert Editor Images
if (context.Permission.FirstOrDefault(
x => x.Name == SiteConstants.Instance.PermissionInsertEditorImages) == null)
{
var p = new Permission
{
Name = SiteConstants.Instance.PermissionInsertEditorImages,
IsGlobal = true
};
context.Permission.Add(p);
}
}
#endregion
}
/// <inheritdoc />
public async Task <IPipelineProcess <Group> > Process(IPipelineProcess <Group> input,
IMvcForumContext context)
{
_localizationService.RefreshContext(context);
_groupService.RefreshContext(context);
try
{
Guid?parentGroupGuid = null;
if (input.ExtendedData.ContainsKey(Constants.ExtendedDataKeys.ParentGroup))
{
parentGroupGuid = input.ExtendedData[Constants.ExtendedDataKeys.ParentGroup] as Guid?;
}
// Sort if this is a section
Section section = null;
if (input.ExtendedData.ContainsKey(Constants.ExtendedDataKeys.Section))
{
if (input.ExtendedData[Constants.ExtendedDataKeys.Section] is Guid guid)
{
section = _groupService.GetSection(guid);
}
}
// Sort the section - If it's null remove it
input.EntityToProcess.Section = section ?? null;
var isEdit = false;
if (input.ExtendedData.ContainsKey(Constants.ExtendedDataKeys.IsEdit))
{
isEdit = input.ExtendedData[Constants.ExtendedDataKeys.IsEdit] as bool? == true;
}
if (isEdit)
{
var parentCat = parentGroupGuid != null
? _groupService.Get(parentGroupGuid.Value)
: null;
// Check they are not trying to add a subGroup of this Group as the parent or it will break
if (parentCat?.Path != null && parentGroupGuid != null)
{
var parentCats = parentCat.Path.Split(',').Where(x => !string.IsNullOrWhiteSpace(x))
.Select(x => new Guid(x)).ToList();
if (parentCats.Contains(input.EntityToProcess.Id))
{
// Remove the parent Group, but still let them create the catgory
parentGroupGuid = null;
}
}
if (parentGroupGuid != null)
{
// Set the parent Group
var parentGroup = _groupService.Get(parentGroupGuid.Value);
input.EntityToProcess.Parent_GroupId = parentGroup;
// Append the path from the parent Group
_groupService.SortPath(input.EntityToProcess, parentGroup);
}
else
{
// Must access property (trigger lazy-loading) before we can set it to null (Entity Framework bug!!!)
var triggerEfLoad = input.EntityToProcess.Parent_GroupId;
input.EntityToProcess.Parent_GroupId = null;
// Also clear the path
input.EntityToProcess.Path = null;
}
Guid user = new Guid();
_groupService.UpdateSlugFromName(input.EntityToProcess, user);
try
{
await context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(null);
}
}
else
{
if (parentGroupGuid != null)
{
var parentGroup = await context.Group.FirstOrDefaultAsync(x => x.Id == parentGroupGuid.Value);
input.EntityToProcess.Parent_GroupId = parentGroup;
_groupService.SortPath(input.EntityToProcess, parentGroup);
}
// url slug generator
input.EntityToProcess.Slug = ServiceHelpers.GenerateSlug(input.EntityToProcess.Name,
_groupService.GetBySlugLike(ServiceHelpers.CreateUrl(input.EntityToProcess.Name)).Select(x => x.Slug).ToList(), null);
// Add the Group
context.Group.Add(input.EntityToProcess);
}
try
{
await context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(null);
}
_cacheService.ClearStartsWith("GroupList");
}
catch (Exception ex)
{
input.AddError(ex.Message);
_loggingService.Error(ex);
}
return(input);
}
