private static void CreateDatabaseSchemaAndDemoData()
{
CreateDatabaseSchema();
var session = NHibernateHelper.SessionFactory.OpenSession();
var passwordPolicy = new RegularExpressionPasswordPolicy(".{5,}$");
var translationsRepository = new TranslationRepository(session, new InMemoryKeyValueCache());
var applicationSettings = new ApplicationSettings();
var encryptor = new DefaultEncryptor();
var userRepository = new UserRepository(session, passwordPolicy, applicationSettings, encryptor);
// Create administrators
PocoGenerator.CreateAdministrators(userRepository);
// Create users
PocoGenerator.CreateUsers(100, userRepository);
session.Transaction.Begin();
// Create translations
PocoGenerator.CreateTranslations(translationsRepository);
session.Transaction.Commit();
// Create logitems
PocoGenerator.CreateLogItems(new NLogLogger(applicationSettings, "Console.Admin"));
}
/// <summary>
/// Reads the xlsx file from the given input file path and writes as a CSV file to the given output path
/// </summary>
/// <param name="inputFilePath">The complete path to the location of xlsx file which needs to be processed</param>
/// <param name="OutputFilePath">The complete path to which the output CSV should be written to</param>
public void Execute(string inputFilePath, string OutputFilePath)
{
var dataSet = DataSetProvider.GetDataSet(inputFilePath);
var skbData = PocoGenerator.GeneratePoco(dataSet, data => new SkbData(data));
//The Map column values should be in the order we desire ion output file
ClassMap <SkbData> classMapFun() => new Factory()
.CreateClassMapBuilder <SkbData>()
.Map(m => m.UserId).Name("User ID")
.Map(m => m.Height).Name("Height")
.Map(m => m.Age).Name("Age")
.Map(m => m.PrimaryScore).Name("Primary Score")
.Map(m => m.SecondaryScore).Name("Secondary Score")
.Build();
CsvWriter.WriteCsv(skbData, OutputFilePath, classMapFun);
}
