예제 #1
0
        private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
        {
            coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
            // TODO: Add code here to load data into the table USP_getOneCat.
            // This code could not be generated, because the categoriesDataSetUSP_getOneCatTableAdapter.Fill method is missing, or has unrecognized parameters.
            coolBlue.CategoriesDataSetTableAdapters.USP_getOneSubCatTableAdapter categoriesDataSetUSP_getOneSubCatTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getOneSubCatTableAdapter();
            coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter   categoriesDataSetUSP_getAllCatsTableAdapter   = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();


            categoriesDataSet.EnforceConstraints = false;

            categoriesDataSetUSP_getOneSubCatTableAdapter.Fill(categoriesDataSet.USP_getOneSubCat, nSubCatID);
            categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
            categoriesDataSet.EnforceConstraints = true;



            System.Windows.Data.CollectionViewSource uSP_getOneSubCatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneSubCatViewSource")));
            uSP_getOneSubCatViewSource.View.MoveCurrentToFirst();
            // TODO: Add code here to load data into the table USP_getAllCats.
            // This code could not be generated, because the categoriesDataSetUSP_getAllCatsTableAdapter.Fill method is missing, or has unrecognized parameters.
            // coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
            System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));
            uSP_getAllCatsViewSource.View.MoveCurrentToFirst();

            DataRowView drv   = (DataRowView)uSP_getOneSubCatViewSource.View.CurrentItem;
            int         catID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCatID"]) == true ? 0 : (int)drv["nCatID"]);

            LookupEditCat.EditValue = catID;
        }
예제 #2
0
        private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
        {
            coolBlue.AccountsDataSet   accountsDataSet   = ((coolBlue.AccountsDataSet)(this.FindResource("accountsDataSet")));
            coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
            coolBlue.RegisterDataSet   registerDataSet   = ((coolBlue.RegisterDataSet)(this.FindResource("registerDataSet")));

            coolBlue.AccountsDataSetTableAdapters.USP_getOneAccountTableAdapter      accountsDataSetUSP_getOneAccountTableAdapter      = new coolBlue.AccountsDataSetTableAdapters.USP_getOneAccountTableAdapter();
            coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountTypesTableAdapter accountsDataSetUSP_getAllAccountTypesTableAdapter = new coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountTypesTableAdapter();
            coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter       categoriesDataSetUSP_getAllCatsTableAdapter       = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
            coolBlue.RegisterDataSetTableAdapters.USP_getAllCurrencyTableAdapter     registerDataSetUSP_getAllCurrencyTableAdapter     = new coolBlue.RegisterDataSetTableAdapters.USP_getAllCurrencyTableAdapter();

            accountsDataSet.EnforceConstraints = false;
            accountsDataSetUSP_getOneAccountTableAdapter.Fill(accountsDataSet.USP_getOneAccount, nAccountID);
            accountsDataSetUSP_getAllAccountTypesTableAdapter.Fill(accountsDataSet.USP_getAllAccountTypes);
            accountsDataSet.EnforceConstraints = true;


            categoriesDataSet.EnforceConstraints = false;
            categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
            categoriesDataSet.EnforceConstraints = true;

            registerDataSet.EnforceConstraints = false;
            registerDataSetUSP_getAllCurrencyTableAdapter.Fill(registerDataSet.USP_getAllCurrency);
            registerDataSet.EnforceConstraints = true;


            System.Windows.Data.CollectionViewSource uSP_getOneAccountViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneAccountViewSource")));
            uSP_getOneAccountViewSource.View.MoveCurrentToFirst();
            System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesViewSource")));
            uSP_getAllAccountTypesViewSource.View.MoveCurrentToFirst();
            System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));
            uSP_getAllCatsViewSource.View.MoveCurrentToFirst();
            System.Windows.Data.CollectionViewSource uSP_getAllCurrencyViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCurrencyViewSource")));
            uSP_getAllCurrencyViewSource.View.MoveCurrentToFirst();

            DataRowView drv   = (DataRowView)uSP_getOneAccountViewSource.View.CurrentItem;
            int         catID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCatID"]) == true ? 0 : (int)drv["nCatID"]);

            LookupEditCat.EditValue = catID;

            int currencyID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCurrencyID"]) == true ? 0 : (int)drv["nCurrencyID"]);

            LookupEditCurrency.EditValue = currencyID;


            int accountTypeID = (drv == null ? 0 : DBNull.Value.Equals(drv["nAccountTypeID"]) == true ? 0 : (int)drv["nAccountTypeID"]);

            LookupEditAccountType.EditValue = accountTypeID;

            cOrigName = (drv == null ? "" : DBNull.Value.Equals(drv["cName"]) == true ? "" : (string)drv["cName"]);
        }
예제 #3
0
        private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
        {
            coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
            coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter    categoriesDataSetUSP_getAllCatsTableAdapter    = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
            coolBlue.CategoriesDataSetTableAdapters.USP_getAllSubCatsTableAdapter categoriesDataSetUSP_getAllSubCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllSubCatsTableAdapter();

            categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
            categoriesDataSetUSP_getAllSubCatsTableAdapter.Fill(categoriesDataSet.USP_getAllSubCats);

            System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));
            System.Windows.Data.CollectionViewSource uSP_getAllCatsUSP_getAllSubCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsUSP_getAllSubCatsViewSource")));


            uSP_getAllCatsViewSource.View.MoveCurrentToFirst();
            uSP_getAllCatsUSP_getAllSubCatsViewSource.View.MoveCurrentToFirst();
        }
예제 #4
0
        private void goDetails()
        {
            System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));

            DataRowView drv        = (DataRowView)uSP_getAllCatsViewSource.View.CurrentItem;
            int         catCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
            editCat     editCat1   = new editCat(catCurrent);

            editCat1.ShowDialog();

            coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
            coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();


            categoriesDataSet.EnforceConstraints = false;
            categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
            categoriesDataSet.EnforceConstraints = true;

            uSP_getAllCatsViewSource.View.MoveCurrentToFirst();
        }