/// <summary>
/// Import a language from CSV
/// </summary>
/// <param name="langKey"> </param>
/// <param name="allLines"></param>
/// <returns>A report on the import</returns>
public CsvReport FromCsv(string langKey, List <string> allLines)
{
var commaSeparator = new[] { ',' };
var report = new CsvReport();
if (allLines == null || allLines.Count == 0)
{
report.Errors.Add(new CsvErrorWarning
{
ErrorWarningType = CsvErrorWarningType.BadDataFormat,
Message = "No language keys or values found."
});
return(report);
}
// Look up the language and culture
Language language;
try
{
var cultureInfo = LanguageUtils.GetCulture(langKey);
if (cultureInfo == null)
{
report.Errors.Add(new CsvErrorWarning
{
ErrorWarningType = CsvErrorWarningType.DoesNotExist,
Message = string.Format("The language culture '{0}' does not exist.", langKey)
});
return(report);
}
// See if this language exists already, and if not then create it
language = GetLanguageByLanguageCulture(langKey) ?? Add(cultureInfo);
}
catch (LanguageOrCultureAlreadyExistsException ex)
{
report.Errors.Add(new CsvErrorWarning {
ErrorWarningType = CsvErrorWarningType.AlreadyExists, Message = ex.Message
});
return(report);
}
catch (Exception ex)
{
report.Errors.Add(new CsvErrorWarning {
ErrorWarningType = CsvErrorWarningType.ItemBad, Message = ex.Message
});
return(report);
}
return(FromCsv(language, allLines));
}
protected override void Seed(KunturContext context)
{
const string langCulture = "en-US";
var language = context.Language.FirstOrDefault(x => x.LanguageCulture == langCulture);
if (language == null)
{
var cultureInfo = LanguageUtils.GetCulture(langCulture);
language = new Language
{
Name = cultureInfo.EnglishName,
LanguageCulture = cultureInfo.Name,
};
context.Language.Add(language);
context.SaveChanges();
}
}
public ActionResult CreateLanguage(CreateLanguageViewModel languageViewModel)
{
try
{
if (ModelState.IsValid)
{
// Get the culture info
var cultureInfo = LanguageUtils.GetCulture(languageViewModel.Name);
try
{
LocalizationService.Add(cultureInfo);
Context.SaveChanges();
ShowSuccess("Language Created");
}
catch (Exception ex)
{
Context.RollBack();
LoggingService.Error(ex);
throw;
}
}
else
{
var errors = (from key in ModelState.Keys
select ModelState[key]
into state
where state.Errors.Any()
select state.Errors.First().ErrorMessage).ToList();
ShowErrors(errors);
}
}
catch (Exception ex)
{
ShowError(ex.Message);
}
// Default ie error
return(RedirectToAction("Index"));
}
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
}
/// <summary>
/// Import a language from CSV
/// </summary>
/// <param name="langKey"> </param>
/// <param name="allLines"></param>
/// <returns>A report on the import</returns>
public CsvReport FromCsv(string langKey, List <string> allLines)
{
var commaSeparator = new[] { ',' };
var report = new CsvReport();
if (allLines == null || allLines.Count == 0)
{
report.Errors.Add(new CsvErrorWarning
{
ErrorWarningType = CsvErrorWarningType.BadDataFormat,
Message = "No language keys or values found."
});
return(report);
}
// Look up the language and culture
Language language;
try
{
var cultureInfo = LanguageUtils.GetCulture(langKey);
if (cultureInfo == null)
{
report.Errors.Add(new CsvErrorWarning
{
ErrorWarningType = CsvErrorWarningType.DoesNotExist,
Message = string.Format("The language culture '{0}' does not exist.", langKey)
});
return(report);
}
// See if this language exists already, and if not then create it
language = GetLanguageByLanguageCulture(langKey) ?? Add(cultureInfo);
}
catch (LanguageOrCultureAlreadyExistsException ex)
{
report.Errors.Add(new CsvErrorWarning {
ErrorWarningType = CsvErrorWarningType.AlreadyExists, Message = ex.Message
});
return(report);
}
catch (Exception ex)
{
report.Errors.Add(new CsvErrorWarning {
ErrorWarningType = CsvErrorWarningType.ItemBad, Message = ex.Message
});
return(report);
}
try
{
var lineCounter = 0;
foreach (var line in allLines)
{
lineCounter++;
var keyValuePair = line.Split(commaSeparator);
if (keyValuePair.Length < 2)
{
report.Errors.Add(new CsvErrorWarning
{
ErrorWarningType = CsvErrorWarningType.MissingKeyOrValue,
Message = string.Format("Line {0}: a key and a value are required.", lineCounter)
});
continue;
}
var key = keyValuePair[0];
if (string.IsNullOrEmpty(key))
{
// Ignore empty keys
continue;
}
key = key.Trim();
var value = keyValuePair[1];
var resourceKey = _localizationRepository.GetResourceKey(key);
if (language == null)
{
throw new ApplicationException(string.Format("Unable to create language"));
}
// If key does not exist, it is a new one to be created
if (resourceKey == null)
{
resourceKey = new LocaleResourceKey
{
Name = key,
DateAdded = DateTime.UtcNow,
};
Add(resourceKey);
report.Warnings.Add(new CsvErrorWarning
{
ErrorWarningType = CsvErrorWarningType.NewKeyCreated,
Message = string.Format("A new key named '{0}' has been created, and will require a value in all languages.", key)
});
}
// In the new language (only) set the value for the resource
var stringResources = language.LocaleStringResources.Where(res => res.LocaleResourceKey.Name == resourceKey.Name).ToList();
if (stringResources.Any())
{
foreach (var res in stringResources)
{
res.ResourceValue = value;
break;
}
}
else
{
// No string resources have been created, so most probably
// this is the installer creating the keys so we need to create the
// string resource to go with it and add it
var stringResource = new LocaleStringResource
{
Language = language,
LocaleResourceKey = resourceKey,
ResourceValue = value
};
_localizationRepository.Add(stringResource);
}
}
}
catch (Exception ex)
{
report.Errors.Add(new CsvErrorWarning {
ErrorWarningType = CsvErrorWarningType.GeneralError, Message = ex.Message
});
}
return(report);
}
