public void Generate()
{
_dataSet = new DataSet();
using (var sqlConnection = new SqlConnection(connectionString))
using (var commandBuilder = new StoredProcedureCommandBuilder("sp_WeightVsLimitScheduleReport", sqlConnection))
using (var dataAdapter = new SqlDataAdapter(commandBuilder.Command))
{
commandBuilder.AddParameter <int?>("@SessionId", 521);
//commandBuilder.AddParameter<int?>("@SessionId", 521);
commandBuilder.AddParameter <int?>("@RuleId", null);
commandBuilder.AddParameter <string>("@RuleIdList", null);
commandBuilder.AddParameter <int?>("@RuleGroupId", null);
commandBuilder.AddParameter <int?>("@PortfolioId", null);
dataAdapter.Fill(_dataSet);
_dataSet.Tables[0].TableName = "Default";
//_dataSet.Tables[1].TableName = "BreachResults";
//_dataSet.Tables[2].TableName = "BreachComments";
}
}
public void Generate()
{
_dataSet = new DataSet();
using (var sqlConnection = new SqlConnection(connectionString))
using (var commandBuilder = new StoredProcedureCommandBuilder("sp_BreachHistoryReport", sqlConnection))
using (var dataAdapter = new SqlDataAdapter(commandBuilder.Command))
{
commandBuilder.AddParameter("@StartDate", DateTime.Parse("2018-01-01"));
commandBuilder.AddParameter("@EndDate", DateTime.Parse("2018-03-30"));
commandBuilder.AddParameter <int?>("@BucketFilterType", 1);
commandBuilder.AddParameter <int?>("@ProcessingResult", 3);
commandBuilder.AddParameter <int?>("@BreachStatus", null);
commandBuilder.AddParameter <int?>("@ContextType", null);
commandBuilder.AddParameter <int?>("@RuleId", null);
commandBuilder.AddParameter <string>("@RuleIdList", null);
commandBuilder.AddParameter <int?>("@RuleGroupId", null);
commandBuilder.AddParameter <string>("@RuleGroupIdList", null);
commandBuilder.AddParameter <int?>("@RuleContextId", null);
commandBuilder.AddParameter <int?>("@PortfolioId", null);
commandBuilder.AddParameter <string>("@PortfolioIdList", null);
commandBuilder.AddParameter <int?>("@PortfolioContextId", null);
commandBuilder.AddParameter <int?>("@CompositeId", null);
commandBuilder.AddParameter <string>("@CompositeIdList", null);
commandBuilder.AddParameter <int?>("@AggregateTypeId", null);
commandBuilder.AddParameter <string>("@AggregateIdList", null);
commandBuilder.AddParameter <int?>("@AggregateId", null);
commandBuilder.AddParameter("@IncludeInstrumentDerivatives", false);
commandBuilder.AddParameter("@IncludeNoAggregates", false);
dataAdapter.Fill(_dataSet);
_dataSet.Tables[0].TableName = "Default";
_dataSet.Tables[1].TableName = "BreachResults";
_dataSet.Tables[2].TableName = "BreachComments";
}
}
