public ExpenseView(DBDataOperation myBd, System.Windows.Window w2) { bd = myBd; ExpenseGuide = bd.GetEXPENSE_GUIDE(); EXPENSEDate = DateTime.Now; EXPENSESize = "0"; EXPENSEDate2 = DateTime.Now; EXPENSEDate1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); ExpenseDataGrid = bd.GetEXPENSESELECT(EXPENSEDate1, EXPENSEDate2, App.id); w = w2; double r = 0; for (int i = 0; i < ExpenseDataGrid.Count; i++) { r += (double)ExpenseDataGrid[i].expense_size; } EXPENSESum = "Итого " + r.ToString(); }
public EditMyProfileView(DBDataOperation myBd, Window w2) { bd = myBd; user = bd.GetUSER(App.id)[0]; Name = user.name; Surname = user.surname; Login = user.login; Password = user.password; Limit = user.limit_size.ToString(); thisW = w2; DateTime Date2 = DateTime.Now; DateTime Date1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); List <Order> or = bd.GetEXPENSESELECT(Date1, Date2, App.id); double r = 0; for (int i = 0; i < or.Count; i++) { r += (double)or[i].expense_size; } Limit2 = Convert.ToDouble(Limit) - r; }