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("Лимит за год превышен");
}
}
}
public void UpdatePage()
{
int d = SelectedYear.Year % 10;
DateTime date1 = new DateTime(SelectedYear.Year, 1, 1).AddYears(-d).AddDays(-1);
DateTime date2 = new DateTime(SelectedYear.Year, 1, 1).AddYears(-d + 9).AddYears(1);
IPlan2 = bd.GetIncomePlanSum(App.id, 3, date1, date2).ToString();
EPlan2 = bd.GetExpensePlanSum(App.id, 3, date1, date2).ToString();
IPlan3 = bd.GetIncomeFor10Years(App.id, 3, date1, date2).ToString();
EPlan3 = bd.GetIncomeFor10Years(App.id, 3, date1, date2).ToString();
iNCOMEItogSize = bd.GetExpenseForYear(App.id, SelectedYear).ToString();
EXPENSEItogSize = bd.GetExpenseForYear(App.id, SelectedYear).ToString();
ItogBalance = Convert.ToDecimal(iNCOMEItogSize) - Convert.ToDecimal(EXPENSEItogSize);
var ips = bd.GetIncomePlanForYear(App.id, SelectedYear);
if (ips == null)
{
iNCOMEPlanSize = "";
}
else
{
iNCOMEPlanSize = ips.plan_income_size.ToString();
}
var eps = bd.GetExpensePlanForYear(App.id, SelectedYear);
if (eps == null)
{
EXPENSEPlanSize = "";
}
else
{
EXPENSEPlanSize = eps.plan_expense_size.ToString();
}
if (ips != null && eps != null)
{
PlanBalance = Convert.ToDecimal(iNCOMEPlanSize) - Convert.ToDecimal(EXPENSEPlanSize);
}
PlanDataGrid = bd.GetPlansYears(App.id, date1, date2);
}
public void UpdatePage()
{
var ip = bd.GetIncomePlanForYear(App.id, SelectedMonth);
if (ip == null || ip.plan_income_size == 0)
{
IPlan1 = "Нет";
}
else
{
IPlan1 = ip.plan_income_size.ToString();
}
var ep = bd.GetExpensePlanForYear(App.id, SelectedMonth);
if (ep == null || ip.plan_income_size == 0)
{
EPlan1 = "Нет";
}
else
{
EPlan1 = ep.plan_expense_size.ToString();
}
DateTime date1 = new DateTime(SelectedMonth.Year, 1, 1).AddDays(-1);
DateTime date2 = new DateTime(SelectedMonth.Year, 12, 1).AddMonths(1);
IPlan2 = bd.GetIncomePlanSum(App.id, 2, date1, date2).ToString();
EPlan2 = bd.GetExpensePlanSum(App.id, 2, date1, date2).ToString();
IPlan3 = bd.GetIncomeForYear(App.id, SelectedMonth).ToString();
EPlan3 = bd.GetExpenseForYear(App.id, SelectedMonth).ToString();
iNCOMEItogSize = bd.GetIncomeForMonth(App.id, SelectedMonth).ToString();
EXPENSEItogSize = bd.GetExpenseForMonth(App.id, SelectedMonth).ToString();
ItogBalance = Convert.ToDecimal(iNCOMEItogSize) - Convert.ToDecimal(EXPENSEItogSize);
var ips = bd.GetIncomePlanForMonth(App.id, SelectedMonth);
if (ips == null)
{
iNCOMEPlanSize = "";
}
else
{
iNCOMEPlanSize = ips.plan_income_size.ToString();
}
var eps = bd.GetExpensePlanForMonth(App.id, SelectedMonth);
if (eps == null)
{
EXPENSEPlanSize = "";
}
else
{
EXPENSEPlanSize = eps.plan_expense_size.ToString();
}
if (ips != null && eps != null)
{
PlanBalance = Convert.ToDecimal(iNCOMEPlanSize) - Convert.ToDecimal(EXPENSEPlanSize);
}
PlanDataGrid = bd.GetPlansMonths(App.id, SelectedMonth);
}
