コード例 #1
0
        private void DeleteExpenseCategory()
        {
            //блок инициирования валидации
            FlagCanValidateinputOrDeleteExpenseCategories = true;
            SetOrDeleteExpenseCategoryText += " ";
            int x1 = SetOrDeleteExpenseCategoryText.Length - 1;

            SetOrDeleteExpenseCategoryText = SetOrDeleteExpenseCategoryText.Substring(0, x1);
            FlagCanValidateinputOrDeleteExpenseCategories = false;

            //если все поля верны
            if (valideteResultInputOrDeleteExpenseCategories)
            {
                SqlConnectExpenseCategories con = new SqlConnectExpenseCategories();
                int countOfExpenseCategories    = con.TateExpenseCategoriesCount();
                //если количество категорий пользователя не равно нулю
                if (countOfExpenseCategories > 0 && countOfExpenseCategories != -1)
                {
                    //удаляем категорию из БД
                    con.DeleteExpenseCategory(SetOrDeleteExpenseCategoryText);
                    //обновляем категории на странице
                    SetExpenceCategories();
                    //обновляем comboboxы на странице
                    ExpenseCategorySource = new ObservableCollection <ExpenseCategory>(expenseCategoriesView);


                    SetOrDeleteExpenseCategoryText = "";
                }
            }

            valideteResultInputOrDeleteExpenseCategories = true;
        }
コード例 #2
0
        private void AddExpenseAmount()
        {
            //блок инициирования валидации
            FlagCanValidateExpenseaddAmount = true;

            ExpenseAmount           += " ";
            valideteaddExpenseAmount = true;
            int x1 = ExpenseAmount.Length - 1;

            ExpenseAmount = ExpenseAmount.Substring(0, x1);

            ExpenseCategoryText += " ";
            x1 = ExpenseCategoryText.Length - 1;
            ExpenseCategoryText = ExpenseCategoryText.Substring(0, x1);

            ExpenseCategory += " ";
            x1 = ExpenseCategory.Length - 1;
            ExpenseCategory = ExpenseCategory.Substring(0, x1);

            ExpenseWallet2 += " ";
            x1              = ExpenseWallet2.Length - 1;
            ExpenseWallet2  = ExpenseWallet2.Substring(0, x1);

            FlagCanValidateExpenseaddAmount = false;

            //если все поля верны
            if (valideteaddExpenseAmount)
            {
                SqlConnectExpenseCategories spam = new SqlConnectExpenseCategories();
                //транзакция которая отнимает значение у кашелька и если значение большн 0 то прибавляет в категорию, иначе rollback
                bool transResult = spam.UpdateCategoryAmount(Convert.ToInt32(ExpenseAmount), ExpenseCategoryText, ExpenseWallet2);
                //если транзакция прошла
                if (transResult)
                {
                    //обновляем кошельки
                    SetWallets();
                    //обновляем категории
                    SetExpenceCategories();
                    SqlConnectExpenseCategoriesStats sqlConnectStats = new SqlConnectExpenseCategoriesStats();
                    //получаем индекс не пользовательской категории
                    int idcategory = sqlConnectStats.GiveCategoryIndex(ExpenseCategory);
                    if (idcategory != 0)
                    {
                        // записываем статистику
                        sqlConnectStats.InsertWalletStats(idcategory, ExpenseWallet2, ExpenseCategoryText, Convert.ToInt32(ExpenseAmount));
                    }


                    SqlConnectUserInfo connectUserInfo = new SqlConnectUserInfo();
                    //обновляем информацию о общих расходах
                    connectUserInfo.UpdateTotalExpense(Convert.ToInt32(ExpenseAmount));

                    //выводим информацию о общих расходах
                    int sum2 = connectUserInfo.Take_TotalExpense();

                    if (sum2 != -1)
                    {
                        TotalExpense = sum2.ToString();
                    }
                    ExpenseAmount = "";
                }
                else
                {
                    FlagCanValidateExpenseaddAmount = true;
                    tranzfalseflag = true;
                    ExpenseAmount  = "";
                    tranzfalseflag = false;
                    FlagCanValidateExpenseaddAmount = false;
                }
            }

            valideteaddExpenseAmount = true;
        }
コード例 #3
0
        /// <summary>
        /// устанавливаю значения в категории
        /// </summary>
        private void SetExpenceCategories()
        {
            SqlConnectExpenseCategories spam = new SqlConnectExpenseCategories();

            expenseCategoriesView = spam.TakeExpenseCategories(Convert.ToInt32(Properties.Settings.Default.UserId));
            int count = expenseCategoriesView.Count();

            if (count > 0)
            {
                IsVisibilityExpense1 = true;  ExpenseTitle1 = expenseCategoriesView[0].Title; ExpenseAmount1 = expenseCategoriesView[0].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense1 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense2 = true;  ExpenseTitle2 = expenseCategoriesView[1].Title; ExpenseAmount2 = expenseCategoriesView[1].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense2 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense3 = true;  ExpenseTitle3 = expenseCategoriesView[2].Title; ExpenseAmount3 = expenseCategoriesView[2].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense3 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense4 = true;  ExpenseTitle4 = expenseCategoriesView[3].Title; ExpenseAmount4 = expenseCategoriesView[3].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense4 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense5 = true; ExpenseTitle5 = expenseCategoriesView[4].Title; ExpenseAmount5 = expenseCategoriesView[4].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense5 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense6 = true; ExpenseTitle6 = expenseCategoriesView[5].Title; ExpenseAmount6 = expenseCategoriesView[5].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense6 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense7 = true; ExpenseTitle7 = expenseCategoriesView[6].Title; ExpenseAmount7 = expenseCategoriesView[6].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense7 = false;
            }
            count--;
            if (count > 0)
            {
                IsVisibilityExpense8 = true; ExpenseTitle8 = expenseCategoriesView[7].Title; ExpenseAmount8 = expenseCategoriesView[7].Amount.ToString();
            }
            else
            {
                IsVisibilityExpense8 = false;
            }
            count--;
        }