Ejemplo n.º 1
0
        public string EditQuery()
        {
            roundParams();
            int iTradeClosed = 0;

            if (TradeClosed == false)
            {
                iTradeClosed = 0;
                ClosingPrice = 0;
                Comission    = 0;
                Taxes        = 0;
                Profit       = 0;
            }
            else
            {
                iTradeClosed = 1;
            }

            int iTradeType      = 0;
            int iInstrumentType = 0;

            switch (InstrumentType.ToString())
            {
            case "Валюта":
                iInstrumentType = 0;
                break;

            case "Акция":
                iInstrumentType = 1;
                break;

            case "Фьючерс":
                iInstrumentType = 2;
                break;
            }
            switch (TradeType.ToString())
            {
            case "Long":
                iTradeType = 0;
                break;

            case "Short":
                iTradeType = 1;
                break;
            }

            //UPDATE `tradesassistant`.`trades` SET `trade_type`='0', `trade_sum`='2120.00' WHERE `id`='6';
            string query = "UPDATE `" + Schema + "`.`" + Table + "` SET " +
                           "`instrument_name`='" + InstrumentName + "', " +
                           "`instrument_class`='" + iInstrumentType.ToString() + "', " +
                           "`instrument_ticker`='" + Ticker + "', " +
                           "`trade_type`='" + iTradeType.ToString() + "', " +
                           "`opening_price`='" + OpeningPrice.ToString().Replace(",", ".") + "', " +
                           "`trade_volume`='" + TradeSize.ToString() + "', " +
                           "`trade_sum`='" + TradeSum.ToString().Replace(",", ".") + "', " +
                           "`trade_closed`='" + iTradeClosed.ToString() + "', " +
                           "`closing_price`='" + ClosingPrice.ToString().Replace(",", ".") + "', " +
                           "`comissions`='" + Comission.ToString().Replace(",", ".") + "', " +
                           "`taxes`='" + Taxes.ToString().Replace(",", ".") + "', " +
                           "`profit`='" + Profit.ToString().Replace(",", ".") + "' " +
                           "WHERE `id`='" + TradeId + "';";

            return(query);
        }
Ejemplo n.º 2
0
        //метод формирования строки удаления записи
        public string AddQuery()
        {
            roundParams();
            int iTradeClosed = 0;

            if (TradeClosed == false)
            {
                iTradeClosed = 0;
            }
            else
            {
                iTradeClosed = 1;
            }

            int iTradeType      = 0;
            int iInstrumentType = 0;

            switch (InstrumentType.ToString())
            {
            case "Валюта":
                iInstrumentType = 0;
                break;

            case "Акция":
                iInstrumentType = 1;
                break;

            case "Фьючерс":
                iInstrumentType = 2;
                break;
            }
            switch (TradeType.ToString())
            {
            case "Long":
                iTradeType = 0;
                break;

            case "Short":
                iTradeType = 1;
                break;
            }

            string query = "INSERT INTO `" + Schema + "`.`" + Table + "` " +
                           "(`instrument_name`, " +
                           "`instrument_class`, " +
                           "`instrument_ticker`, " +
                           "`trade_type`, " +
                           "`opening_price`, " +
                           "`trade_volume`, " +
                           "`trade_sum`, " +
                           "`trade_closed`, " +
                           "`closing_price`, " +
                           "`comissions`, " +
                           "`taxes`, " +
                           "`profit`) " +
                           "VALUES ('" +
                           InstrumentName + "', '"
                           + iInstrumentType.ToString() + "', '"
                           + Ticker + "', '"
                           + iTradeType.ToString() + "', '"
                           + OpeningPrice.ToString().Replace(",", ".") + "', '"
                           + TradeSize.ToString() + "', '"
                           + TradeSum.ToString().Replace(",", ".") + "', '"
                           + iTradeClosed.ToString() + "', '"
                           + ClosingPrice.ToString().Replace(",", ".") + "', '"
                           + Comission.ToString().Replace(",", ".") + "', '"
                           + Taxes.ToString().Replace(",", ".") + "', '"
                           + Profit.ToString().Replace(",", ".") + "');";

            return(query);
        }