public void UpdatePage() { var ip = bd.GetIncomePlanForMonth(App.id, SelectedDay); if (ip == null || ip.plan_income_size == 0) { IPlan1 = "Нет"; } else { IPlan1 = ip.plan_income_size.ToString(); } var ep = bd.GetExpensePlanForMonth(App.id, SelectedDay); if (ep == null || ip.plan_income_size == 0) { EPlan1 = "Нет"; } else { EPlan1 = ep.plan_expense_size.ToString(); } DateTime date1 = new DateTime(SelectedDay.Year, SelectedDay.Month, 1).AddDays(-1); DateTime date2 = new DateTime(SelectedDay.Year, SelectedDay.Month, 1).AddMonths(1); IPlan2 = bd.GetIncomePlanSum(App.id, 1, date1, date2).ToString(); EPlan2 = bd.GetExpensePlanSum(App.id, 1, date1, date2).ToString(); IPlan3 = bd.GetIncomeForMonth(App.id, SelectedDay).ToString(); EPlan3 = bd.GetExpenseForMonth(App.id, SelectedDay).ToString(); iNCOMEItogSize = bd.GetIncomeForDay(App.id, SelectedDay).ToString(); EXPENSEItogSize = bd.GetExpenseForDay(App.id, SelectedDay).ToString(); var ips = bd.GetIncomePlanForDay(App.id, SelectedDay); if (ips == null) { iNCOMEPlanSize = ""; } else { iNCOMEPlanSize = ips.plan_income_size.ToString(); } var eps = bd.GetExpensePlanForDay(App.id, SelectedDay); if (eps == null) { EXPENSEPlanSize = ""; } else { EXPENSEPlanSize = eps.plan_expense_size.ToString(); } PlanDataGrid = bd.GetPlansDays(App.id, SelectedDay); }
public void LimitTracking() { var ep = bd.GetExpensePlanForDay(App.id, EXPENSEDate); if (ep != null && ep.plan_expense_size != 0) { var e = bd.GetExpenseForDay(App.id, EXPENSEDate); if (ep.plan_expense_size == e) { MessageBox.Show("Лимит за день достигнут"); } else if (ep.plan_expense_size < e) { MessageBox.Show("Лимит за день превышен"); } } ep = bd.GetExpensePlanForMonth(App.id, EXPENSEDate); if (ep != null && ep.plan_expense_size != 0) { var e = bd.GetExpenseForMonth(App.id, EXPENSEDate); if (ep.plan_expense_size == e) { MessageBox.Show("Лимит за месяц достигнут"); } else if (ep.plan_expense_size < e) { MessageBox.Show("Лимит за месяц превышен"); } } ep = bd.GetExpensePlanForYear(App.id, EXPENSEDate); if (ep != null && ep.plan_expense_size != 0) { var e = bd.GetExpenseForYear(App.id, EXPENSEDate); if (ep.plan_expense_size == e) { MessageBox.Show("Лимит за год достигнут"); } else if (ep.plan_expense_size < e) { MessageBox.Show("Лимит за год превышен"); } } }