protected override void Seed(MailerDbContext context)
{
using (var helper = new MailerDbInitializerHelper(context))
{
SeedUserAccounts(helper);
SeedMailAccounts(helper);
SeedApiKeys(helper);
}
base.Seed(context);
}
private static void SeedUserAccounts(MailerDbInitializerHelper helper)
{
helper.AddUsers(new List <MailUserEntity>
{
new MailUserEntity
{
CreationDateUtc = DateTime.UtcNow,
DisplayName = "Administrator",
Username = "******",
Enabled = true,
LastLoginDateUtc = DateTime.UtcNow,
Password = helper.EncryptionService.EncryptText("admin")
}
});
}
// http://localhost/Rn.Mailer/API/v1/Test/MailApiKeys
private static void SeedApiKeys(MailerDbInitializerHelper helper)
{
var apiKeys = new List <MailApiKeyEntity>();
// If there are initial mail accounts - seed at least 1 Api key per account
foreach (var account in helper.MailAccounts)
{
apiKeys.Add(new MailApiKeyEntity
{
ApiKey = Guid.NewGuid().ToString().ToUpper(),
CreationDateUtc = DateTime.UtcNow,
Enabled = true,
MailSendCount = 0,
MailAccountId = account.Id
});
}
// If we are in developer mode - seed my required API keys
if (helper.DevelopmentMode)
{
var account = helper.MailAccounts.FirstOrDefault(x => x.Enabled);
if (account != null)
{
apiKeys.AddRange(new List <MailApiKeyEntity>
{
new MailApiKeyEntity(account.Id, "9FFED1DF-F031-4BAC-A296-8A182D983E66"),
new MailApiKeyEntity(account.Id, "6D5D5360-9236-488A-9B17-F6887C087F67"),
new MailApiKeyEntity(account.Id, "3A8C6899-DA22-4E62-B1EA-2E017DAAFDDE")
});
}
}
// Finally commit all API keys to the DB
helper.AddApiKeys(apiKeys);
}
// http://localhost/Rn.Mailer/API/v1/Test/MailAccounts
private static void SeedMailAccounts(MailerDbInitializerHelper helper)
{
if (!helper.DevelopmentMode)
{
return;
}
// Ensure that we have a valid directory to work with
var baseDir = helper.WebConfig.GetAppSetting("Rn.Mailer.DevSeedBaseDir")
.AppendIfMissing("\\");
if (!Directory.Exists(baseDir))
{
throw new DirectoryNotFoundException($"Unable to find directory: {baseDir}");
}
// Get all account information from the expected accounts file
var accountFilePath = $"{baseDir}mail-accounts.csv";
if (!File.Exists(accountFilePath))
{
return;
}
var headerRow = true;
var lines = File.ReadAllLines(accountFilePath);
var admin = helper.Users.FirstOrDefault(x => x.Username.Equals("admin"));
var seedAccounts = new List <MailAccountEntity>();
// Populate the "seedAccounts" list with all the CSV lines
foreach (var rawAccount in lines)
{
// Cater for the header row in the mail-accounts.csv file
if (headerRow)
{
headerRow = false;
continue;
}
if (string.IsNullOrWhiteSpace(rawAccount))
{
continue;
}
// Create our account we wish to seed
var rawParts = rawAccount.Split(',');
seedAccounts.Add(new MailAccountEntity
{
SmtpUsername = rawParts[0].Trim(),
SmtpPassword = rawParts[1].Trim(),
SmtpHost = rawParts[2].Trim(),
SmtpPort = int.Parse(rawParts[3].Trim()),
EnableSsl = bool.Parse(rawParts[4].Trim()),
FromAddress = rawParts[5].Trim(),
FromDisplayName = rawParts[6].Trim(),
Enabled = bool.Parse(rawParts[7].Trim()),
CreationDateUtc = DateTime.UtcNow,
UserId = admin.Id,
RedirectToDisk = bool.Parse(rawParts[8].Trim())
});
}
// Finally append the extracted accounts to the DB
helper.AddMailAccounts(seedAccounts);
}
