private void MonthPlanExist()
{
DB db = new DB();
if (db.CheckMonthPlan(UserId, Year, Month))
{
MonthPlans mp = db.GetMonthPlan(UserId.ToString(), Year.ToString(), Month.ToString());
monthplans = mp;
cat.Clear();
cat = db.GetCategoryPlanWithSum(Convert.ToInt16(mp.__recid), Month, Year);
MonthBudgetGrid.ItemsSource = cat;
EarningsBox.Text = monthplans.Earning;
IrregularBudgetBox.Text = monthplans.IrregularBudgetFund;
}
else
{
List <CategoryPlan> EmptyList = new List <CategoryPlan>();
MonthBudgetGrid.ItemsSource = EmptyList;
EarningsBox.Text = "0,00";
IrregularBudgetBox.Text = "0,00";
if (first == false)
{
MessageBox.Show("Nie zaplanowano budżetu na ten miesiąc");
}
}
}
private void GetMonthAndCatPlan()
{
DB db = new DB();
MonthPlans mp = db.GetMonthPlan(UserId.ToString(), Year.ToString(), Month.ToString());
monthplans = mp;
cat.Clear();
cat = db.GetCategoryPlanWithSum(Convert.ToInt16(mp.__recid), Month, Year);
}
public AnnualSummaryPanel(int Id)
{
InitializeComponent();
Page p1 = new InterfacePanel();
InterfaceFrame.NavigationService.Navigate(p1);
UserId = Id;
DateTime localDate = DateTime.Now;
Month = Validation.Validation.GetMonthFromDate(localDate.ToString());
Year = Validation.Validation.GetYearFromDate(localDate.ToString());
YearBox.Text = Convert.ToString(Year);
monthplans = new MonthPlans(UserId.ToString());
GetData();
}
public HistoryMonthPlansPanel(int Id)
{
InitializeComponent();
Page p1 = new InterfacePanel();
InterfaceFrame.NavigationService.Navigate(p1);
UserId = Id;
DateTime localDate = DateTime.Now;
Month = Validation.Validation.GetMonthFromDate(localDate.ToString());
Year = Validation.Validation.GetYearFromDate(localDate.ToString());
YearBox.Text = Convert.ToString(Year);
monthplans = new MonthPlans(UserId.ToString());
GetMonths(Month);
MonthPlanExist();
first = false;
}
private void MonthPlanExist()
{
DB db = new DB();
if (db.CheckMonthPlan(UserId, Year, Month))
{
MonthPlans mp = db.GetMonthPlan(UserId.ToString(), Year.ToString(), Month.ToString());
monthplans = mp;
cat.Clear();
cat = db.GetCategoryPlan(Convert.ToInt16(mp.__recid));
MonthBudgetGrid.ItemsSource = cat;
EarningsBox.Text = monthplans.Earning;
IrregularBudgetBox.Text = monthplans.IrregularBudgetFund;
}
else
{
monthplans.ChangeMonthPlan(Year.ToString(), Month.ToString(), false, IrregularBudgetBox.Text);
GetDataToGrid();
EarningsBox.Text = Validation.Validation.GetNumberTwoZero(db.GetUserEarnings(UserId));
IrregularBudgetBox.Text = "0,00";
}
}
