Exemple #1
0
        /// <summary>
        /// Saves the transaction (purchase or sale)
        /// </summary>
        /// <param name="type">The transaction type : s(ales), c(harge), t(akeoff), p(urchase)</param>
        /// <param name="stock">the stock data</param>
        public void saveTransaction(TransactionItem.TransactionTypeEnum type, StockListitem stock)
        {
            BankAccountModel bankModel = new BankAccountModel();
            var bank     = bankModel.getBank();
            var ttype    = (type == TransactionItem.TransactionTypeEnum.Purchase) ? 'p' : 's';
            var totalSum = (decimal)stock.PricePurchase * (decimal)stock.Quantity;

            if (ConnectionState == true && bank != null)
            {
                if (totalSum <= bank.AccountBalance)
                {
                    decimal change = 0;
                    switch (type)
                    {
                    case TransactionItem.TransactionTypeEnum.Sales: change += totalSum; break;

                    case TransactionItem.TransactionTypeEnum.Purchase: change -= totalSum; break;
                    }

                    var bankQuery = (from bk in db.BankAccount
                                     where bk.BankAccountID == bank.BankAccountID
                                     select bk).First();

                    bankQuery.AccountBalance += change;
                    db.SubmitChanges();

                    db.Transactions.InsertOnSubmit(new Transactions
                    {
                        Description     = stock.Quantity + " - " + stock.name,
                        BankAccountID   = bank.BankAccountID,
                        Created         = DateTime.Now,
                        Amount          = totalSum,
                        TransactionType = ttype,
                    });
                    db.SubmitChanges();
                }
            }
        }
Exemple #2
0
        /// <summary>
        /// Sales the stock and saves the transaction
        /// </summary>
        public void removeStock(StockListitem stock, decimal quantity)
        {
            if (ConnectionState == true)
            {
                var query = (from ds in db.StocksMap
                             where ds.StocksMapID == stock.StocksMapID
                             select ds).FirstOrDefault();

                if (query != null)
                {
                    if (quantity < stock.Quantity)
                    {
                        query.Quantity -= (int)quantity;
                    }
                    else if (quantity == stock.Quantity)
                    {
                        db.UserLines.DeleteAllOnSubmit(query.UserLines);
                        db.StocksMap.DeleteOnSubmit(query);
                    }
                    db.SubmitChanges();

                    BankAccountModel bankModel = new BankAccountModel();
                    var bank        = bankModel.getBank();
                    var valueBought = quantity * query.PurchasePrice;
                    var valueSold   = quantity * Convert.ToDecimal(stock.PriceCurrent);

                    db.Transactions.InsertOnSubmit(new Transactions
                    {
                        Description     = quantity + " - " + stock.name,
                        BankAccountID   = bank.BankAccountID,
                        Created         = DateTime.Now,
                        Amount          = valueSold,
                        TransactionType = 's',
                    });

                    var capitalGainTax = SettingsModel.getInstance().getCapitalGainTax();
                    if (capitalGainTax > 0)
                    {
                        decimal valueTax     = 0;
                        var     taxType      = "";
                        char    taxTransType = 'x';
                        if (valueSold > valueBought) // Profit
                        {
                            valueTax = Convert.ToDecimal(valueSold - valueBought) * (capitalGainTax / 100);
                            taxType  = "Kapitalerstragssteuer nach Verkauf - " + stock.name;
                        }
                        else if (valueSold < valueBought) // Loss
                        {
                            valueTax     = Convert.ToDecimal(valueBought - valueSold) * (capitalGainTax / 100);
                            taxType      = "Steuergutschrift durch Verkauf - " + stock.name;
                            taxTransType = 'y';
                        }

                        db.Transactions.InsertOnSubmit(new Transactions
                        {
                            Description     = taxType,
                            BankAccountID   = bank.BankAccountID,
                            Created         = DateTime.Now,
                            Amount          = valueTax,
                            TransactionType = taxTransType,
                        });
                    }
                    db.SubmitChanges();
                }
            }
        }