Ejemplo n.º 1
0
        /* Sale
         * 0.  Get info about purchase from program (Customer, Number of Shares, Total (money))
         * 1.  Create empty operation
         * 2.1 Get Customer balance info
         * 2.2 - Customer balance amount
         * 3.  Create blocked money
         * 4.1 Get Seller shares number info
         * 4.2 - Seller shares number
         * 5.  Create blocked shares number // after that action purchase can't cancel
         * 6.1 Get Seller balance info
         * 6.2 + Seller balance amount
         * 7.1 Get Customer shares number info
         * 7.2 + Customer shares number
         * 8.  Fill operation columns
         * 9.  Remove blocked money
         * 10. Remove blocked shares number
         */
        public void Deal(int customerId, int shareId, int requiredSharesNumber)
        {
            OperationEntity    operation            = null;
            SharesNumberEntity customerSharesNumber = null;
            SharesNumberEntity sellerSharesNumber   = null;
            ClientEntity       customer             = null;
            ClientEntity       seller          = null;
            BalanceEntity      customerBalance = null;
            BalanceEntity      sellerBalance   = null;
            ShareEntity        share           = null;
            BlockedMoneyEntity blockedMoney    = null;
            bool blockedMoneyFlag = false;
            BlockedSharesNumberEntity blockedSharesNumber = null;
            bool    blockedSharesNumberFlag = false;
            decimal customerBalanceAmount   = 0M;
            decimal total = 0M;
            int     sellerSharesNumberNumber = 0;

            operation = CreateOperation();
            try
            {
                sellerSharesNumber = SearchSharesNumberForBuy(shareId, requiredSharesNumber); // search required shares on stock exchange
                seller             = sellerSharesNumber.Client;
                share           = sellerSharesNumber.Share;
                customerBalance = SearchBalanceByClientId(customerId);
                customer        = customerBalance.Client;
                sellerBalance   = SearchBalanceByClientId(seller.Id);

                // get total
                CheckShareAndShareTypeStatuses(share);
                total = share.Type.Cost * requiredSharesNumber;

                // Blocked money
                customerBalanceAmount = customerBalance.Amount;
                if (customerBalanceAmount < total)
                {
                    throw new ArgumentException("Customer don't have enough money.");
                }
                blockedMoneyFlag = ChangeBalance(customerBalance, customerBalanceAmount - total);
                blockedMoney     = CreateBlockedMoney(new BlockedMoneyRegistrationInfo()
                {
                    Operation     = operation,
                    ClientBalance = customerBalance,
                    Total         = total
                });

                // Blocked shares Number
                sellerSharesNumberNumber = sellerSharesNumber.Number;
                blockedSharesNumberFlag  = ChangeSharesNumber(sellerSharesNumber, sellerSharesNumberNumber - requiredSharesNumber);
                blockedSharesNumber      = CreateBlockedSharesNumber(new BlockedSharesNumberRegistrationInfo()
                {
                    ClientSharesNumber = sellerSharesNumber,
                    Operation          = operation,
                    //Share = sellerSharesNumber.Share,
                    //ShareTypeName = sellerSharesNumber.Share.Type.Name,
                    //Cost = sellerSharesNumber.Share.Type.Cost,
                    Number = requiredSharesNumber
                });
            }
            catch (Exception e)
            {
                RemoveOperation(operation);

                if (blockedMoneyFlag)
                {
                    ChangeBalance(customerBalance, customerBalanceAmount + total);
                    if (blockedMoney != null)
                    {
                        RemoveBlockedMoney(blockedMoney);
                    }
                }

                if (blockedSharesNumberFlag)
                {
                    ChangeSharesNumber(sellerSharesNumber, sellerSharesNumberNumber + requiredSharesNumber);
                    if (blockedSharesNumber != null)
                    {
                        RemoveBlockedSharesNumber(blockedSharesNumber);
                    }
                }

                throw new ArgumentException($"Deal was broken cause: {e.Message}");
            }

            if (sellerSharesNumber.Number == 0)
            {
                RemoveSharesNumber(sellerSharesNumber);
            }

            ChangeBalance(sellerBalance, sellerBalance.Amount + total);

            customerSharesNumber = SearchOrCreateSharesNumberForAddition(customer, share);
            ChangeSharesNumber(customerSharesNumber, customerSharesNumber.Number + requiredSharesNumber);

            FillOperationColumns(blockedMoney, blockedSharesNumber);

            RemoveBlockedMoney(blockedMoney);
            RemoveBlockedSharesNumber(blockedSharesNumber);
        }
Ejemplo n.º 2
0
        public static Operation[] GetOperations(DateTime from, DateTime to)
        {
            var ret = new List <Operation>();

            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "select o.ID, o.[Date], o.[Description], o.Operation, o.CurrentBalance, o.Notes, o.Exception,"
                                  + " o.AutoEntityID, o.ForceEntityID, o.ForceTypeID "
                                  //+ " auto_oe.ID as AutoEntityID, auto_oe.[Description] as AutoEntityDesc, auto_oe.[Place] as AutoEntityPlace,"
                                  //+ " auto_ot.ID as AutoEntityTypeID, auto_ot.[Description] as AutoEntityTypeDesc,"
                                  //+ " forced_oe.ID as ForcedEntityID, forced_oe.[Description] as ForcedEntityDesc, forced_oe.[Place] as ForcedEntityPlace,"
                                  //+ " forced_oeot.ID as ForcedEntityTypeID, forced_oeot.[Description] as ForcedEntityTypeDesc,"
                                  //+ " forced_ot.ID as ForcedTypeID, forced_ot.[Description] as ForcedTypeDesc"
                                  + " from Operations o with(nolock)"
                                  //+ " left join OperationEntities auto_oe with(nolock) on auto_oe.ID = o.AutoEntityID"
                                  //+ " left join OperationTypes auto_ot with(nolock) on auto_ot.ID = auto_oe.IDType"
                                  //+ " left join OperationEntities forced_oe with(nolock) on forced_oe.ID = o.ForceEntityID"
                                  //+ " left join OperationTypes forced_oeot with(nolock) on forced_oeot.ID = forced_oe.IDType"
                                  //+ " left join OperationTypes forced_ot with(nolock) on forced_ot.ID = o.ForceTypeID"
                                  + " where o.[Date] between @from and @to"
                                  + " order by o.[Date] asc";

                cmd.Parameters.AddWithValue("@from", from);
                cmd.Parameters.AddWithValue("@to", to);

                foreach (DataRow row in doSelect(cmd).Rows)
                {
                    var             id           = Convert.ToInt32(row["ID"]);
                    var             date         = Convert.ToDateTime(row["Date"]);
                    var             desc         = Convert.ToString(row["Description"]);
                    var             op           = Convert.ToDouble(row["Operation"]);
                    var             curr         = Convert.ToDouble(row["CurrentBalance"]);
                    var             notes        = Convert.ToString(row["Notes"]);
                    var             exception    = Convert.ToBoolean(row["Exception"]);
                    OperationEntity autoEntity   = null;
                    OperationEntity forcedEntity = null;
                    OperationType   forcedType   = null;

                    if (row["AutoEntityID"] != DBNull.Value)
                    {
                        autoEntity = Keeper.Entities[Convert.ToInt32(row["AutoEntityID"])];
                    }

                    if (row["ForceEntityID"] != DBNull.Value)
                    {
                        forcedEntity = Keeper.Entities[Convert.ToInt32(row["ForceEntityID"])];
                    }

                    if (row["ForceTypeID"] != DBNull.Value)
                    {
                        forcedType = Keeper.Types[Convert.ToInt32(row["ForceTypeID"])];
                    }

                    var operation = new Operation(id, date, desc, new OperationValue(op), new OperationValue(curr), autoEntity, notes, exception, forcedEntity, forcedType);

                    ret.Add(operation);
                }
            }

            return(ret.ToArray());
        }
Ejemplo n.º 3
0
        public void RemoveOperation(OperationEntity operation)
        {
            this.operationTableRepository.Remove(operation.Id);

            this.operationTableRepository.SaveChanges();
        }
 public void Add(OperationEntity entity)
 {
     this.dBContext.Operations.Add(entity);
 }