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