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