public void Run(string budgetId, string userId, string file) { var excel = new ExcelQueryFactory(file); var anni = new[] { 2011, 2012, 2013, 2014 }; var movements = new List<Movimento>(); DateTime ld; int count = 0; //"B3","F22", //foreach (var asd in excel.WorksheetRange<Movimento>("B3", "F300", 2020 + "")) //foreach (var asd in excel.Worksheet<Movimento>(2020 + "")) //{ // count++; // if (asd.Data != DateTime.MinValue) // ld = asd.Data; //} foreach (var anno in anni) { //movements.AddRange(excel.WorksheetRange<Movimento>("B3", "E300", anno + "").Where(r => r.Data != DateTime.MinValue)); movements.AddRange(excel.Worksheet<Movimento>(anno + "").Where(r => r.Data != DateTime.MinValue)); } movements = movements.OrderBy(d => d.Data).ToList(); var stats = movements.GroupBy(g => g.Data.Year).ToList(); var zero = movements.Where(m => m.Spesa == decimal.Zero).ToList(); Console.WriteLine("Read {0} movements from {1}", movements.Count, file); var importer = new ImportManager(_cm, _pm); var categorie = movements.Select(s => s.Categoria).Where(r => r != "Arancio").ToArray(); importer.ImportCategoriesByName(categorie, budgetId, userId); var categories = _pm.GetCategories().GetBudgetsCategories(budgetId); var createLine = _cm.Create<CreateLine>(); DateTime last = DateTime.MinValue; foreach (var m in movements) { last = DateTime.Now; createLine(m.ToCreateLine(last, new BudgetId(budgetId), userId, categories)); } var bp = _pm.GetBudgetLinesProjection(budgetId); var galt = bp.GetAllLines(last); galt.Wait(); var lines = galt.Result; Console.WriteLine("Loaded {0} movements into {1}", lines.Count(), budgetId); }
static void CreateLines(int numberOfLines, IEventStoreConnection esCon, string userId) { var cm = new CommandManager(esCon); var budgetId = MyBudget.Domain.Budgets.BudgetId.Create(); var currency = Currencies.Euro(); var random = new Random(); var categories = new[] { "C1", "C2", "C3", "C4" }; var mindate = new DateTime(2010, 1, 1); //var cb = cm.Create<CreateBudget>(); //cb.Handle(new CreateBudget //{ // BudgetId = budgetId.ToString(), // UserId = userId, // BudgetName = "test 1. #" + numberOfLines //}); var cl = cm.Create<CreateLine>(); var po = new ParallelOptions { MaxDegreeOfParallelism = 10 }; Parallel.For(0, numberOfLines,po, i => //for (int i = 0; i < numberOfLines; i++) { cl(new CreateLine { UserId = userId, BudgetId = budgetId.ToString(), Expense = new Expense( new Amount(currency, random.Next(100)), mindate.AddDays(random.Next(365 * 3)), categories[random.Next(categories.Length)], "nothing special" ), LineId = MyBudget.Domain.Lines.LineId.Create(budgetId).ToString(), }); } ); }
public void Run(string budgetId, string userId, string file) { var excel = new ExcelQueryFactory(file); var anni = new[] { 2013, 2014 }; var movements = new List<Movimento>(); foreach (var anno in anni) { //movements.AddRange(excel.Worksheet<Movement>(anno + "") // .Where(r => r.Data != DateTime.MinValue)); var laura = excel.WorksheetRange<Movimento>("B6", "E10000", anno + "") .Where(r => r.Data != DateTime.MinValue) .ToList(); laura.ForEach(m => m.DistributionKey = "Laura"); var valerio = excel.WorksheetRange<Movimento>("G6", "J10000", anno + "") .Where(r => r.Data != DateTime.MinValue) .ToList(); valerio.ForEach(m => m.DistributionKey = "Valerio"); var comune = excel.WorksheetRange<Movimento>("L6", "O10000", anno + "") .Where(r => r.Data != DateTime.MinValue) .ToList(); movements.AddRange(laura); movements.AddRange(valerio); movements.AddRange(comune); } //var tasse = movements.GroupBy(g => g.Categoria).ToList(); Console.WriteLine("Read {0} movements from {1}", movements.Count, file); movements = movements.Where(r => r.Categoria != "Arancio").OrderBy(d => d.Data).ToList(); var importer = new ImportManager(_cm, _pm); var categorie = movements.Select(s => s.Categoria).ToArray(); importer.ImportCategoriesByName(categorie, budgetId, userId); var categories = _pm.GetCategories().GetBudgetsCategories(budgetId); var createLine = _cm.Create<CreateLine>(); //foreach (var m in movements.Where(r=> r.Categoria != "Arancio")) // createLine(m.ToCreateLine(new BudgetId(budgetId), userId, categories)); DateTime last = DateTime.MinValue; foreach (var m in movements) { last = DateTime.Now; createLine(m.ToCreateLine(last, new BudgetId(budgetId), userId, categories)); } var bp = _pm.GetBudgetLinesProjection(budgetId); var galt = bp.GetAllLines(last); galt.Wait(); var lines = galt.Result; Console.WriteLine("Loaded {0} movements into {1}", lines.Count(), budgetId); }