public static void ImportIncomeAndExpense(string INN) { for (int year = 2008; year <= 2020; year++) { IncomeAndExpenseDataProvider incomeAndExpenseDataProvider = new IncomeAndExpenseDataProvider(); List <IncomeAndExpense> listToImport = incomeAndExpenseDataProvider.LoadIncomeAndExpense(new IncomeAndExpenseTimePeriod(year)); if (listToImport.Count != 0) { IncomeAndExpenseSQLiteDataProvider.Import(listToImport, year, INN); } } }
private void IncomeAndExpenseReportForm_Load(object sender, EventArgs e) { IncomeAndExpenseSQLiteDataProvider incomeAndExpenseDataProvider = new IncomeAndExpenseSQLiteDataProvider(); List <IncomeAndExpense> incomeAndExpense = incomeAndExpenseDataProvider.Load(timePeriod, INN); incomeAndExpense.Sort(delegate(IncomeAndExpense ps1, IncomeAndExpense ps2) { return(DateTime.Compare(DateTime.Parse(ps1.Date), DateTime.Parse(ps2.Date))); }); foreach (var i in incomeAndExpense) { i.Income = Convert.ToDouble(i.Income).ToString("F2"); i.Expense = Convert.ToDouble(i.Expense).ToString("F2"); } IncomeAndExpenseBindingSource.DataSource = incomeAndExpense; string semesterName = ""; switch (semesterToLoad) { case SemesterToLoad.FirstSemester: { semesterName += "I полугодие"; } break; case SemesterToLoad.SecondSemester: { semesterName += "II полугодие"; } break; case SemesterToLoad.BothSemesters: case SemesterToLoad.Period: { semesterName += "весь " + timePeriod.Year + " год"; } break; } ReportParameter rp0 = new ReportParameter("rp0", semesterName); ReportParameter isDemo = new ReportParameter("isDemo", Constants.isDemoVersion.ToString()); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp0, isDemo }); this.reportViewer1.RefreshReport(); }
public IncomeAndExpenseLogic(DataGridView incomeAndExpenseGridView) { incomeAndExpenseDataProvider = new IncomeAndExpenseSQLiteDataProvider(); this.incomeAndExpenseGridView = incomeAndExpenseGridView; }