Exemple #1
0
        private void OnBondChanged(object sender, EventArgs e)
        {
            clearBondData();

            int _investorId = fInvestorId = Convert.ToInt32(cbInvestor.SelectedValue);
            int _bondId     = fBondId = Convert.ToInt32(cbBond.SelectedValue);

            BondsTFF         _bond         = manager.My_db.BondsTFFs.FirstOrDefault(x => x.Id == _bondId);
            BondsTFFInvestor _bondInvestor = manager.My_db.BondsTFFInvestors.FirstOrDefault(x => x.FK_BondsInvestors_Bonds == _bondId && x.FK_BondsInvestors_Investors == _investorId);

            if (_bond != null && _bondInvestor != null)
            {
                lblNumber.Text         = _bond.number;
                lblPrice.Text          = _bond.price.ToString();
                lblPieces.Text         = _bond.pieces.ToString();
                lblInterest.Text       = _bond.interest_on_bond.ToString();
                lblTFF.Text            = _bond.interest_tff_contribution.ToString();
                lblIssuingDate.Text    = _bond.issued.ToLongDateString();
                lblExpirationDate.Text = _bond.expired.HasValue ? _bond.expired.Value.ToLongDateString() : "";
                lblInvestorPieces.Text = _bondInvestor.quantity.ToString();

                loadInterests();

                lblExpired.Visible = _bond.active == 0;
            }
        }
Exemple #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if (manager.My_db.ClosedPeriods.FirstOrDefault(x => x.year == dtpIssuingDate.Value.Year && x.fund_id == manager.Selected) == null)
                {
                    BondsTFF bond = new BondsTFF();
                    bond.number                    = txtNumber.Text;
                    bond.issued                    = Convert.ToDateTime(dtpIssuingDate.Text);
                    bond.expired                   = Convert.ToDateTime(dtpExpirationDate.Text);
                    bond.FK_Bonds_Funds            = manager.Selected;
                    bond.price                     = Math.Round(Convert.ToDecimal(txtPrice.Text), 2);
                    bond.pieces                    = (float)Convert.ToDecimal(txtBondPieces.Text);
                    bond.interest_on_bond          = Convert.ToInt32(txtBondInterest.Text);
                    bond.interest_tff_contribution = Convert.ToInt32(txtTFFInterest.Text);

                    bond.active = 1;

                    manager.My_db.BondsTFFs.Add(bond);
                    manager.My_db.SaveChanges();

                    foreach (InvestorForBond _investor in investors)
                    {
                        BondsTFFInvestor bond_investor = new BondsTFFInvestor();
                        bond_investor.FK_BondsInvestors_Bonds     = bond.Id;
                        bond_investor.FK_BondsInvestors_Investors = _investor.Id;
                        bond_investor.quantity = _investor.Pieces;
                        manager.My_db.BondsTFFInvestors.Add(bond_investor);
                        manager.My_db.SaveChanges();
                    }

                    Resource _resource = manager.My_db.Resources.FirstOrDefault(x => x.Name == KeyDefinitions.BONDTFF_CONSECUTIVE_KEY && x.FundId == manager.Selected);

                    fBondConsecutive++;

                    _resource.Value = fBondConsecutive.ToString();

                    manager.My_db.SaveChanges();



                    //TODO: Crear un movimiento contable con un debito a 100 y un credito a 510 por el monto del bono

                    //Obtener nuevo numero de referencia
                    //Crear AccountingMovement
                    //Crear Movements_Accounts con un debito a 100
                    //Crear Movements_Accounts con un credito a 510

                    Account    _CashAtBank    = manager.My_db.Accounts.FirstOrDefault(x => x.number == "100" && x.FK_Accounts_Funds == manager.Selected);
                    Account    _Bonds         = manager.My_db.Accounts.FirstOrDefault(x => x.number == "510" && x.FK_Accounts_Funds == manager.Selected);
                    Subaccount _CashAtBankEUR = manager.My_db.Subaccounts.FirstOrDefault(x => x.name == "Cash at Bank EUR");
                    Subaccount _BondI         = manager.My_db.Subaccounts.FirstOrDefault(x => x.name == "Bond I");

                    if (_CashAtBank != null &&
                        _Bonds != null &&
                        _CashAtBankEUR != null &&
                        _BondI != null)
                    {
                        AccountingMovement _movement = new AccountingMovement();
                        _movement.FK_AccountingMovements_Funds = manager.Selected;
                        //TODO: Poner description correcta cuando la manden
                        _movement.description = "";
                        _movement.date        = bond.issued;
                        _movement.reference   = KeyDefinitions.NextAccountMovementReference(dtpIssuingDate.Value.Year);
                        _movement.FK_AccountingMovements_Currencies = manager.My_db.Currencies.FirstOrDefault().Id;
                        //TODO: Poner ORIG cuando la manden
                        _movement.original_reference = "";
                        manager.My_db.AccountingMovements.Add(_movement);
                        manager.My_db.SaveChanges();

                        Movements_Accounts _movAcctCashAtBank = new Movements_Accounts();
                        Movements_Accounts _movAcctBond       = new Movements_Accounts();

                        _movAcctCashAtBank.FK_Movements_Accounts_AccountingMovements = _movement.Id;
                        _movAcctCashAtBank.FK_Movements_Accounts_Funds       = manager.Selected;
                        _movAcctCashAtBank.FK_Movements_Accounts_Accounts    = _CashAtBank.Id;
                        _movAcctCashAtBank.FK_Movements_Accounts_Subaccounts = _CashAtBankEUR.Id;
                        //TODO: Poner subaccount type correcto cuando lo manden
                        //_movAcctCashAtBank.subaccount_type = my_movement.Detail_type;
                        //TODO: Poner subaccount type correcto cuando lo manden
                        //_movAcctCashAtBank.subaccount = my_movement.Detail;

                        _movAcctCashAtBank.debit  = Math.Round((decimal)bond.pieces * bond.price, 2);
                        _movAcctCashAtBank.credit = 0;

                        manager.My_db.Movements_Accounts.Add(_movAcctCashAtBank);

                        _movAcctBond.FK_Movements_Accounts_AccountingMovements = _movement.Id;
                        _movAcctBond.FK_Movements_Accounts_Funds       = manager.Selected;
                        _movAcctBond.FK_Movements_Accounts_Accounts    = _Bonds.Id;
                        _movAcctBond.FK_Movements_Accounts_Subaccounts = _BondI.Id;
                        //TODO: Poner subaccount type correcto cuando lo manden
                        //_movAcctBond.subaccount_type = my_movement.Detail_type;
                        //TODO: Poner subaccount type correcto cuando lo manden
                        //_movAcctBond.subaccount = my_movement.Detail;

                        _movAcctBond.debit  = 0;
                        _movAcctBond.credit = Math.Round((decimal)bond.pieces * bond.price, 2);

                        manager.My_db.Movements_Accounts.Add(_movAcctBond);

                        manager.My_db.SaveChanges();

                        investors.Clear();
                        check_pieces           = 0;
                        txtNumber.Text         = "Bond " + Conversions.toRomanNumeral(fBondConsecutive);
                        txtPrice.Text          = "0";
                        txtBondInterest.Text   = "10";
                        txtTFFInterest.Text    = "1";
                        txtInvestorPieces.Text = "0";
                        txtBondPieces.Text     = "0";
                        listView1.Items.Clear();
                        txtPrice.ReadOnly      = false;
                        txtBondPieces.ReadOnly = false;
                    }
                }
                else
                {
                    ErrorMessage.showErrorMessage(new Exception("No movement allowed in closed period."));
                }
            }
            catch (Exception _ex)
            {
                ErrorMessage.showErrorMessage(_ex);
            }
        }