private void SetSecurities()
{
try
{
DbQueryManager dbManager = new DbQueryManager(connString);
IDataReader queryResult = dbManager.ToExecuteReader("sel_SecurityStream", true, new Dictionary <string, object>()
{
{ "Kriter", 1 }
});
while (queryResult.Read())
{
SecurityBuilder secBuilder = new SecurityBuilder();
Security sec = secBuilder.Build(queryResult);
dataProvider.SecurityValues.AddOrUpdate(sec.OrgSecurity, sec, (k, v) => { return(sec); });
}
queryResult.Close();
queryResult.Dispose();
}
catch (Exception ex)
{
TBYException tex = new TBYException(MethodInfo.GetCurrentMethod().GetFullName(), "Veritabanından semboller getirilirken hata oluştu", ex);
ProcessException(tex);
}
}
public void UpdateOrder(Teb.FIX.Model.Order order)
{
DbQueryManager dbQueryManager = new DbQueryManager(ConnectionString, ProviderName);
dbQueryManager.OpenConnection();
Dictionary <string, object> pList = new Dictionary <string, object>();
pList.Add("Kriter", 1);
pList.Add("State", order.State == null ? -1 : order.State.GetStateID());
pList.Add("IsGlobal", order.IsGlobal);
pList.Add("MessageId", order.DbID);
pList.Add("TEBID", order.TEBID);
pList.Add("UpdateDateTime", DateTime.Now);
pList.Add("ClOrdIncrement", order.ClOrdIncrement);
pList.Add("MarketClOrdID", order.MarketClOrdId);
pList.Add("MarketOrdID", order.MarketOrdID);
pList.Add("ConnectionID", order.ConnectionID);
pList.Add("ConnectionClOrdID", order.ConnectionClOrdID);
pList.Add("ConnectionOrigClOrdID", order.ConnectionOrigClOrdID);
pList.Add("ClOrdID", order.ClOrdID);
pList.Add("OrigClOrdID", order.OrigClOrdID);
pList.Add("OrderID", order.OrderID);
pList.Add("SecurityType", order.SecurityType);
pList.Add("Afe", order.Afe);
pList.Add("Kafe", order.Kafe);
pList.Add("SellShort", order.IsSellShort);
pList.Add("Account", order.Account);
pList.Add("AccountSubNo", order.AccountSubNo);
pList.Add("PartyID", order.PartyID);
//pList.Add("AccountType", order.AccountType);
pList.Add("ServerStatusID", (int)order.ServerStatus);
pList.Add("ClientStatusID", (int)order.ClientStatus);
pList.Add("HistoryStatusID", (int)order.HistoryStatus);
pList.Add("IsUIActive", order.IsActive);
pList.Add("TimeInForce", order.Core.TimeInForce);
pList.Add("OrgTimeInForce", order.Core.OrgTimeInForce);
pList.Add("ExpireDate", order.ExpireDate);
pList.Add("Side", order.Core.Side);
pList.Add("Symbol", order.Symbol);
pList.Add("SymbolSfx", order.SymbolSfx);
if (order.TransactTime.HasValue)
{
pList.Add("TransactTime", order.TransactTime.Value);
}
if (order.SendingTime.HasValue)
{
pList.Add("SendingTime", order.SendingTime.Value);
}
if (order.Price.HasValue)
{
pList.Add("Price", order.Price.Value);
}
if (order.Price2.HasValue)
{
pList.Add("Price2", order.Price2.Value);
}
if (order.TriggerPrice.HasValue)
{
pList.Add("TriggerPrice", order.TriggerPrice.Value);
}
if (order.OrderQty.HasValue)
{
pList.Add("OrderQty", order.OrderQty.Value);
}
if (order.OrderQty2.HasValue)
{
pList.Add("OrderQty2", order.OrderQty2.Value);
}
if (order.CumQty.HasValue)
{
pList.Add("CumQty", order.CumQty.Value);
}
if (order.AvgPx.HasValue)
{
pList.Add("AvgPx", order.AvgPx.Value);
}
if (order.LeavesQty.HasValue)
{
pList.Add("LeavesQty", order.LeavesQty.Value);
}
if (order.GrossTradeAmt.HasValue)
{
pList.Add("GrossTradeAmount", order.GrossTradeAmt.Value);
}
if (order.LastQty.HasValue)
{
pList.Add("LastQty", order.LastQty.Value);
}
if (order.LastPx.HasValue)
{
pList.Add("LastPx", order.LastPx.Value);
}
pList.Add("SenderCompID", order.SenderCompID);
pList.Add("TargetCompID", order.TargetCompID);
pList.Add("MarketSegmentID", order.Core.MarketSegmentID);
pList.Add("PositionEffect", order.PositionEffect);
pList.Add("Text", order.Text);
pList.Add("EncodedText", order.EncodedText);
pList.Add("OrdType", order.Core.OrdType);
pList.Add("MarketSourceID", order.MarketSource == null ? "-1" : order.MarketSource.Id);
pList.Add("InstructionSourceID", order.InstructionSource == null ? "-1" : order.InstructionSource.Id);
pList.Add("ConnectionFirstClOrdID", order.ConnectionFirstClOrdID);
pList.Add("MaxFloor", order.MaxFloor);
pList.Add("PegPriceType", order.PegPriceType);
pList.Add("FirstClOrdID", order.FirstClOrdID);
dbQueryManager.Execute("up_FIXAppOrders", true, pList);
dbQueryManager.CloseConnection();
}
