public virtual ActionResult ByCategory(string budgetId, string From, string To)
{
DateTime?from = null;
DateTime?to = null;
if (From != null)
{
from = DateTime.Parse(From);
}
if (To != null)
{
to = DateTime.Parse(To);
}
var projection = ProjectionManager.GetBudgetLinesProjection(budgetId);
IEnumerable <BudgetLine> lines = projection.GetAllLinesBetween(from, to);
if (from == null)
{
from = lines.Select(s => s.Date).DefaultIfEmpty(DateTime.MinValue).Min(r => r.Date.Date);
}
if (to == null)
{
to = lines.Select(s => s.Date).DefaultIfEmpty(DateTime.MaxValue).Max(r => r.Date.Date);
}
var categories = ProjectionManager.GetCategories().GetBudgetsCategories(budgetId);
var model = new BudgetStatsByCategoryViewModel(categories, lines, budgetId, "NA", from, to);
return(View(model));
}
public virtual ActionResult Index(string id)
{
var readModel = ProjectionManager.GetBudgetLinesProjection(id);
var lines = readModel.GetAllLines();
var model = new BudgetLinesViewModel(id, lines);
return(View(model));
}
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);
}
public virtual ActionResult ByCategoryInTime(string budgetId, string From, string To, string GroupBy)
{
DateTime?from = null;
DateTime?to = null;
if (From != null)
{
from = DateTime.Parse(From);
}
if (To != null)
{
to = DateTime.Parse(To);
}
GroupBy groupBy = MyBudget.Web.AspNet.Controllers.GroupBy.Year;
try
{
groupBy = (GroupBy)Enum.Parse(typeof(GroupBy), GroupBy);
}
catch { }
var projection = ProjectionManager.GetBudgetLinesProjection(budgetId);
IEnumerable <BudgetLine> lines = projection.GetAllLinesBetween(from, to);
if (from == null)
{
from = lines.Select(s => s.Date).DefaultIfEmpty(DateTime.MinValue).Min(r => r.Date.Date);
}
if (to == null)
{
to = lines.Select(s => s.Date).DefaultIfEmpty(DateTime.MaxValue).Max(r => r.Date.Date);
}
var categories = ProjectionManager.GetCategories().GetBudgetsCategories(budgetId);
var model = new BudgetStatsByCategoryInTimeViewModel(categories, lines, budgetId, "NA", from, to, groupBy);
return(View(model));
}
public virtual ActionResult Page(string id, string From, string To, int?pageIndex, string category)
{
DateTime?from = null;
DateTime?to = null;
if (string.IsNullOrEmpty(From) == false)
{
from = DateTime.Parse(From);
}
if (string.IsNullOrEmpty(To) == false)
{
to = DateTime.Parse(To);
}
var categories = ProjectionManager.GetCategories().GetBudgetsCategories(new Domain.Budgets.BudgetId(id));
var readModel = ProjectionManager.GetBudgetLinesProjection(id);
var lines = readModel.GetAllLinesPaged(pageIndex.GetValueOrDefault(), from, to, category);
var model = new BudgetLinesPagedViewModel(id, lines, from, to, categories, category);
return(View(model));
}
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);
}