public ActionResult AddEditExpenses(int itemId) { BudgetReport model = new BudgetReport(); if (itemId > 0) { model = objexpense.GetExpenseData(itemId); } return(PartialView("_expenseForm", model)); }
internal void GetBudgetTemplate() { try { AppSettingsReader setting = new AppSettingsReader(); string report = (string)setting.GetValue("BudgetReport", typeof(string)); BudgetReport.Open(report); } catch (Exception ex) { new Error(ex).ShowDialog(); } }
// CONSTRUCTORS public ExcelForm() { InitializeComponent(); Source = Source.DivisionAccounts; Provider = Provider.SQLite; DbData = new DataBuilder(Source, Provider); BindingSource = new BindingSource(); Table = DbData.Table; BindingSource.DataSource = Table; ProgramElements = DbData.ProgramElements; Ninja = new FormData(Source, Provider); BudgetTemplate = GetInternalFilePath(); BudgetReport.Open(BudgetTemplate); }
public ActionResult Create(BudgetReport newExpense) { if (ModelState.IsValid) { if (newExpense.ItemId > 0) { objexpense.UpdateBudget(newExpense); } else { objexpense.AddBudget(newExpense); } } return(RedirectToAction("Index")); }
private static void Main(string[] args) { if (args is null) { throw new ArgumentNullException(nameof(args)); } //Skapa en ecocontroller. EconomicController ecoController = new EconomicController(); //För in data i ecocontrollern ecoController.AddEconomicObjectToList("Giraffe", EconomicType.Saving, 9999.9); ecoController.AddEconomicObjectToList("Income", EconomicType.Income, 5000); ecoController.AddEconomicObjectToList(" ", EconomicType.Expense, double.MaxValue); ecoController.AddEconomicObjectToList(null, EconomicType.Income, -2222.222); //Skapa en rapport med ecocontrollern BudgetReport report = new BudgetReport(ecoController); //Skapa en writer WriteToFile writer = new WriteToFile(); //Skriv errorloggern till fil writer.WriteStringToFile("the error log", ErrorLogger.GetSummarizedLogAsString()); //Ta bort giraffen, för dyr. ecoController.RemoveEconomicObjectFromList("Giraffe"); //Lägg till lite grejjer ecoController.AddEconomicObjectToList("Salary", EconomicType.Income, 14000); ecoController.AddEconomicObjectToList("Rent", EconomicType.Expense, 2000); ecoController.AddEconomicObjectToList("Subscription", EconomicType.Expense, 99); ecoController.AddEconomicObjectToList("Food", EconomicType.Expense, 1500); ecoController.AddEconomicObjectToList("Savings", EconomicType.Saving, 0.1); //Ny rapport report = new BudgetReport(ecoController); //Skicka till consolen Console.WriteLine(report.GetCalculatedDataToString()); //Skriv rapporten till fil writer.WriteStringToFile("Private economy report", report.GetCalculatedDataToString()); }
public ActionResult BudgetReport([Bind(Prefix = "")] BudgetReport report) { return(viewReport(report)); }
public void UpdateChart() { if (this.MyMoney == null || !this.IsVisible) { return; } BudgetReport report = new BudgetReport(null, this.money); ObservableCollection <BudgetData> list = new ObservableCollection <BudgetData>(); if (CategoryFilter == null) { Dictionary <string, BudgetData> totals = new Dictionary <string, BudgetData>(); decimal sum = 0; // for new average // then we need to do all categories and compute the totals. foreach (Category rc in money.Categories.GetRootCategories()) { if (rc.Type != CategoryType.Expense) { continue; } report.CategoryFilter = rc; foreach (BudgetData b in report.Compute()) { BudgetData total = null; if (!totals.TryGetValue(b.Name, out total)) { totals[b.Name] = b; } else { total.Merge(b); sum += (decimal)b.Average; } } } if (totals.Count > 0) { decimal average = sum / totals.Count; foreach (BudgetData data in totals.Values) { data.Average = (double)average; } } ComputeLinearRegression(totals.Values); list = new ObservableCollection <BudgetData>(from b in totals.Values orderby b.BudgetDate ascending select b); } else { report.CategoryFilter = this.CategoryFilter; IEnumerable <BudgetData> result = report.Compute(); ComputeLinearRegression(result); // Now update the observable collection. list = new ObservableCollection <BudgetData>(from b in result orderby b.BudgetDate ascending select b); } // compute cumulative totals. double budgetTotal = 0; double actualTotal = 0; foreach (BudgetData d in list) { budgetTotal += d.Budget; actualTotal += d.Actual; d.BudgetCumulative = budgetTotal; d.ActualCumulative = actualTotal; } try { BudgetSeries.ItemsSource = list; ActualSeries.ItemsSource = list; AverageSeries.ItemsSource = list; BudgetCumulativeSeries.ItemsSource = list; ActualCumulativeSeries.ItemsSource = list; LineChart.InvalidateArrange(); } catch (Exception ex) { Trace.WriteLine(ex.ToString()); } }