/// <summary>
/// Inserir stop start da ordem na tabela tbStopStartOrder
/// </summary>
/// <param name="pOrdem"></param>
/// <returns></returns>
public virtual int EnviarOrdemStop(AutomacaoOrdensInfo pOrdem)
{
SqlCommand command = new SqlCommand();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = Conn;
conn.Open();
try
{
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "PRC_INS_ORDEM_STOP_OMS";
SqlParameter OutParameter = new SqlParameter();
OutParameter.Direction = ParameterDirection.Output;
OutParameter.ParameterName = "@StopStartID";
OutParameter.Size = 32;
command.Parameters.Add(OutParameter);
command.Parameters.AddWithValue("@OrdTypeID", pOrdem.OrdTypeID);
command.Parameters.AddWithValue("@StopStartStatusID", pOrdem.StopStartStatusID);
command.Parameters.AddWithValue("@Symbol", pOrdem.Symbol);
command.Parameters.AddWithValue("@OrderQty", pOrdem.OrderQty);
command.Parameters.AddWithValue("@Account", pOrdem.Account);
//command.Parameters.AddWithValue("@RegisterTime", pOrdem.RegisterTime);
command.Parameters.AddWithValue("@ExpireDate", pOrdem.ExpireDate);
command.Parameters.AddWithValue("@ExecutionTime", pOrdem.ExecutionTime);
command.Parameters.AddWithValue("@ReferencePrice", pOrdem.ReferencePrice);
command.Parameters.AddWithValue("@StartPriceValue", pOrdem.StartPriceValue);
command.Parameters.AddWithValue("@SendStartPrice", pOrdem.SendStartPrice);
command.Parameters.AddWithValue("@StopGainValuePrice", pOrdem.StopGainValuePrice);
command.Parameters.AddWithValue("@SendStopGainPrice", pOrdem.SendStopGainPrice);
command.Parameters.AddWithValue("@StopLossValuePrice", pOrdem.StopLossValuePrice);
command.Parameters.AddWithValue("@SendStopLossValuePrice", pOrdem.SendStopLossValuePrice);
command.Parameters.AddWithValue("@InitialMovelPrice", pOrdem.InitialMovelPrice);
command.Parameters.AddWithValue("@AdjustmentMovelPrice", pOrdem.AdjustmentMovelPrice);
command.Parameters.AddWithValue("@StopStartTipoEnum", (int)pOrdem.IdStopStartTipo);
command.Parameters.AddWithValue("@PortaControle", pOrdem.ControlePorta);
command.ExecuteNonQuery();
int id_stopstart = int.Parse(command.Parameters["@StopStartID"].Value.ToString());
return(id_stopstart);
}
catch (Exception ex)
{
throw new Exception(string.Format("{0}{1}", "EnviarOrdemStop: ", ex.Message));
}
finally
{
conn.Close();
conn.Dispose();
command.Connection.Close();
command.Dispose();
command = null;
}
}
public virtual AutomacaoOrdensInfo SelecionaOrdemStopStart(int pIdStartStop)
{
SqlCommand command = new SqlCommand();
AutomacaoOrdensInfo _TOrdem = new AutomacaoOrdensInfo();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = Conn;
conn.Open();
try
{
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "prc_sel_stopstart";
command.Parameters.AddWithValue("@StopStartID", pIdStartStop);
DataTable dtDados = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dtDados);
if (dtDados.Rows.Count > 0)
{
_TOrdem = new AutomacaoOrdensInfo();
_TOrdem.Account = int.Parse(dtDados.Rows[0]["Account"].ToString());
_TOrdem.StopStartID = int.Parse(dtDados.Rows[0]["StopStartID"].ToString());
_TOrdem.Symbol = dtDados.Rows[0]["Symbol"].ToString();
_TOrdem.IdStopStartTipo = (StopStartTipoEnum)dtDados.Rows[0]["StopStartTipoEnum"];
_TOrdem.OrdTypeID = int.Parse(dtDados.Rows[0]["OrdTypeID"].ToString());
_TOrdem.IdBolsa = Conversao.ToInt(dtDados.Rows[0]["id_Bolsa"].ToString());
_TOrdem.InitialMovelPrice = Conversao.ToDecimal(dtDados.Rows[0]["InitialMovelPrice"]);
_TOrdem.OrderQty = int.Parse(dtDados.Rows[0]["OrderQty"].ToString());
_TOrdem.ReferencePrice = Conversao.ToDecimal(dtDados.Rows[0]["ReferencePrice"]);
_TOrdem.SendStartPrice = Conversao.ToDecimal(dtDados.Rows[0]["SendStartPrice"]);
_TOrdem.SendStopGainPrice = Conversao.ToDecimal(dtDados.Rows[0]["SendStopGainPrice"]);
_TOrdem.SendStopLossValuePrice = Conversao.ToDecimal(dtDados.Rows[0]["SendStopLossValuePrice"]);
_TOrdem.StartPriceValue = Conversao.ToDecimal(dtDados.Rows[0]["StartPriceValue"]);
_TOrdem.StopGainValuePrice = Conversao.ToDecimal(dtDados.Rows[0]["StopGainValuePrice"]);
_TOrdem.StopLossValuePrice = Conversao.ToDecimal(dtDados.Rows[0]["StopLossValuePrice"]);
_TOrdem.StopStartStatusID = int.Parse(dtDados.Rows[0]["StopStartStatusID"].ToString());
_TOrdem.RegisterTime = Conversao.ToDateTime(dtDados.Rows[0]["RegisterTime"]);
_TOrdem.ExecutionTime = Conversao.ToDateTime(dtDados.Rows[0]["ExecutionTime"]);
_TOrdem.ExpireDate = Conversao.ToDateTime(dtDados.Rows[0]["ExpireDate"]);
}
return(_TOrdem);
}
finally
{
conn.Close();
conn.Dispose();
command.Connection.Close();
command.Dispose();
command = null;
}
}
/// <summary>
/// Seleciona o Stop/Start
/// </summary>
/// <param name="id_startstop">Id do Stop/Start</param>
/// <returns>Retorna uma entidade do tipo AutomacaoOrdensInfo</returns>
public virtual AutomacaoOrdensInfo ListarOrdemStopStartResumido(int id_startstop)
{
SqlCommand command = new SqlCommand();
AutomacaoOrdensInfo _TOrdem = new AutomacaoOrdensInfo();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = Conn;
conn.Open();
try
{
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "prc_sel_stopstart";
command.Parameters.AddWithValue("@StopStartID", id_startstop);
DataTable dtDados = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dtDados);
if (dtDados.Rows.Count > 0)
{
_TOrdem.Account = int.Parse(dtDados.Rows[0]["Account"].ToString());
_TOrdem.StopStartID = int.Parse(dtDados.Rows[0]["StopStartID"].ToString());
_TOrdem.Symbol = dtDados.Rows[0]["Symbol"].ToString();
_TOrdem.ControlePorta = dtDados.Rows[0]["PortaControle"].ToString();
}
return(_TOrdem);
}
finally
{
conn.Close();
conn.Dispose();
command.Connection.Close();
command.Dispose();
command = null;
}
}
