private static void Initialize(DealingPolicyDetail dealingPolicyDetail, DataRow dataRow)
{
dealingPolicyDetail.DealingPolicyId = (Guid)(dataRow["DealingPolicyID"]);
dealingPolicyDetail.InstrumentId = (Guid)(dataRow["InstrumentID"]);
dealingPolicyDetail.MaxDQLot = dataRow.GetItemValue <decimal>("MaxDQLot", 0);
dealingPolicyDetail.MaxOtherLot = dataRow.GetItemValue <decimal>("MaxOtherLot", 0);
dealingPolicyDetail.DQQuoteMinLot = dataRow.GetItemValue <decimal>("DQQuoteMinLot", 0);
dealingPolicyDetail.AcceptDQVariation = dataRow.GetItemValue <int>("AcceptDQVariation", 0);
dealingPolicyDetail.AcceptLmtVariation = dataRow.GetItemValue <int>("AcceptLmtVariation", 0);
dealingPolicyDetail.CancelLmtVariation = dataRow.GetItemValue <int>("CancelLmtVariation", 0);
dealingPolicyDetail.AllowedNewTradeSides = Convert.ToInt16(dataRow["AllowedNewTradeSides"]);
dealingPolicyDetail.AcceptCloseLmtVariation = dataRow.GetItemValue <int>("AcceptCloseLmtVariation", 0);
dealingPolicyDetail.PriceValidTime = dataRow.GetItemValue <int>("PriceValidTime", 0);
}
internal static DealingPolicyDetail[] GetDealingPolicyDetails(Guid userId)
{
using (SqlConnection sqlConnection = new SqlConnection(SettingManager.Default.ConnectionString))
{
using (SqlCommand sqlCommand = new SqlCommand("P_GetDealingPolicyDetails", sqlConnection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlConnection.Open();
SqlCommandBuilder.DeriveParameters(sqlCommand);
sqlCommand.Parameters["@userId"].Value = userId;
List<DealingPolicyDetail> dealingPolicyDetails = new List<DealingPolicyDetail>();
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
DealingPolicyDetail dealingPolicyDetail = new DealingPolicyDetail();
dealingPolicyDetail.AcceptDQVariation = (int)reader["AcceptDQVariation"];
dealingPolicyDetail.AcceptLmtVariation = (int)reader["AcceptLmtVariation"];
dealingPolicyDetail.AcceptCloseLmtVariation = (int)reader["AcceptCloseLmtVariation"];
dealingPolicyDetail.CancelLmtVariation = (int)reader["CancelLmtVariation"];
dealingPolicyDetail.DealingPolicyId = (Guid)reader["DealingPolicyId"];
dealingPolicyDetail.DQQuoteMinLot = (decimal)reader["DQQuoteMinLot"];
dealingPolicyDetail.InstrumentId = (Guid)reader["InstrumentId"];
dealingPolicyDetail.MaxDQLot = (decimal)reader["MaxDQLot"];
dealingPolicyDetail.MaxOtherLot = (decimal)reader["MaxOtherLot"];
dealingPolicyDetail.AllowedNewTradeSides = Convert.ToInt16(reader["AllowedNewTradeSides"]);
dealingPolicyDetail.PriceValidTime = (int)reader["PriceValidTime"];
dealingPolicyDetails.Add(dealingPolicyDetail);
}
}
return dealingPolicyDetails.ToArray();
}
}
}
