protected virtual void DataPortal_Fetch(IdCriteria criteria) { using (IDataConnection connection = SimpleQuery.ConfigurationManagerConnection("")) { if (connection.State == ConnectionState.Closed) { connection.Open(); } using (IDataCommand command = new DataCommand((connection.CreateCommand()))) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "Pricing.Owner#FetchByDealerId"; command.AddParameterWithValue("DealerId", DbType.Int32, false, criteria.Id); using (IDataReader reader = command.ExecuteReader()) { if (reader.Read()) { Fetch(reader); } else { throw new Exception("No such Owner!"); } } } } }
public static DataTable LoadReportDataTable(string reportId, string dataSetName, IDictionary <string, object> parameterValues, DataTableCallback callback) { string reportPath = ConfigurationManager.AppSettings["VB.Reports.App.ReportDefinitionLibrary.Xml.Serialization.ReportMetadata.Path"]; IReport report = ReportFactory.NewReportFactory(reportPath).FindReport(reportId); ILocalReportProcessingLocation location = (ILocalReportProcessingLocation)report.ReportProcessingLocation; DataTable table; using (IDataConnection connection = SimpleQuery.ConfigurationManagerConnection(location.DataSourceName)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } IReportDataCommandTemplate reportDataCommandTemplate = report.DataSource(dataSetName); using (IDataCommand command = connection.CreateCommand(reportDataCommandTemplate, new DictionaryDataParameterValue(parameterValues).DataParameterValue)) { command.CommandTimeout = 90; using (IDataReader reader = command.ExecuteReader()) { table = DataTableMapper.ToDataTable(reader, reportDataCommandTemplate.DataMap, callback); } } } return(table); }
public static NonQueryResult ExecuteNonQuery(IDataConnection connection, IDataCommandTemplate commandTemplate, DataParameterValue parameterValue, bool collectPrimaryKey) { if (connection.State == ConnectionState.Closed) { connection.Open(); } using (IDataCommand command = connection.CreateCommand(commandTemplate, parameterValue)) { using (IDbTransaction transaction = connection.BeginTransaction()) { command.Transaction = transaction; int rowsAffected = command.ExecuteNonQuery(); if (rowsAffected != 1) { throw new DataException("Number of rows affected = " + rowsAffected + " expected 1"); } object primaryKey; if (collectPrimaryKey) { DataCommandTemplate identity = new DataCommandTemplate(CommandType.Text, "SELECT @@IDENTITY Id"); using (IDbCommand primaryKeyCommand = connection.CreateCommand(identity, parameterValue)) { primaryKeyCommand.Transaction = transaction; primaryKey = primaryKeyCommand.ExecuteScalar(); } } else { primaryKey = null; } transaction.Commit(); return(new NonQueryResult(primaryKey, rowsAffected)); } } }
protected void Run() { using (IDataConnection connection = SimpleQuery.ConfigurationManagerConnection("Merchandising")) { if (connection.State == ConnectionState.Closed) { connection.Open(); } using (var command = connection.CreateCommand()) { command.CommandText = "settings.MiscSettings#Fetch"; command.CommandType = CommandType.StoredProcedure; IDbDataParameter param = command.CreateParameter(); param.ParameterName = "businessUnitID"; param.Value = BusinessUnitId; param.DbType = DbType.Int32; command.Parameters.Add(param); using (var reader = command.ExecuteReader()) { if (reader.Read()) { HasSettings = true; OptimalFormat = reader.GetBoolean(reader.GetOrdinal("sendOptimalFormat")); PriceNewCars = reader.GetBoolean(reader.GetOrdinal("priceNewCars")); ShowDashboard = reader.GetBoolean(reader.GetOrdinal("showDashboard")); ShowGroupLevelDashboard = reader.GetBoolean(reader.GetOrdinal("ShowGroupLevelDashboard")); AnalyticsSuite = reader.GetBoolean(reader.GetOrdinal("analyticsSuite")); BatchAutoload = reader.GetBoolean(reader.GetOrdinal("batchAutoload")); MaxVersion = reader.GetByte(reader.GetOrdinal("MaxVersion")); WebLoaderEnabled = reader.GetBoolean(reader.GetOrdinal("WebLoaderEnabled")); ModelLevelFrameworksEnabled = reader.GetBoolean(reader.GetOrdinal("ModelLevelFrameworksEnabled")); AutoOfflineWholesalePlanTrigger = reader.GetBoolean(reader.GetOrdinal("AutoOffline_WholesalePlanTrigger")); ShowCtrGraph = reader.GetBoolean(reader.GetOrdinal("ShowCtrGraph")); } } } } }
public IDbCommand CreateCommand() { EnsureOpen(); return(_connection.CreateCommand()); }
protected void BindLocalReport(MsLocalReport localReport, IReport report) { ILocalReportProcessingLocation location = (ILocalReportProcessingLocation)report.ReportProcessingLocation; localReport.LoadReportDefinition(ReportDefinitionCache.GetReportDefinition(location.File).GetReportStream()); localReport.EnableHyperlinks = true; localReport.EnableExternalImages = true; localReport.SetBasePermissionsForSandboxAppDomain(new System.Security.PermissionSet(System.Security.Permissions.PermissionState.Unrestricted)); //localReport.ExecuteReportInCurrentAppDomain(AppDomain.CurrentDomain.Evidence); //localReport.AddFullTrustModuleInSandboxAppDomain(new System.Security.Policy.StrongName(new System.Security.Permissions.StrongNamePublicKeyBlob(Nullable),"VB.Reports.App.ReportStyleLibrary.StyleSheet","1.0.0")); //localReport.AddTrustedCodeModuleInCurrentAppDomain(System.Reflection.Assembly.GetAssembly(typeof(VB.Reports.App.ReportStyleLibrary.StyleSheet)).ToString()); if (localReport.IsDrillthroughReport) { localReport.SetParameters(localReport.OriginalParametersToDrillthrough); } else { IList <MsReportParameter> parameters = new List <MsReportParameter>(); foreach (IReportParameter parameter in report.ReportParameters) { parameters.Add(new MsReportParameter(parameter.Name, GetParameterValue(parameter))); } localReport.SetParameters(parameters); } localReport.DataSources.Clear(); foreach (IReportDataCommandTemplate reportDataCommandTemplate in report.ReportDataCommandTemplates) { DictionaryDataParameterValue parameterValues = new DictionaryDataParameterValue(); foreach (IReportParameter parameter in reportDataCommandTemplate.Parameters) { if (localReport.IsDrillthroughReport) { parameterValues[parameter.Name] = GetParameterValue(parameter, localReport.OriginalParametersToDrillthrough); } else { parameterValues[parameter.Name] = GetParameterValue(parameter); } } using (IDataConnection connection = SimpleQuery.ConfigurationManagerConnection(location.DataSourceName)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } using (IDataCommand command = connection.CreateCommand(reportDataCommandTemplate, parameterValues.DataParameterValue)) { command.CommandTimeout = 200; using (IDataReader reader = command.ExecuteReader()) { DataTable table = DataTableMapper.ToDataTable(reader); localReport.DataSources.Add(new MsReportDataSource(reportDataCommandTemplate.Name, table)); } } } } localReport.Refresh(); }
protected void BindLocalReport(MsLocalReport localReport, IReport report) { ILocalReportProcessingLocation location = (ILocalReportProcessingLocation)report.ReportProcessingLocation; localReport.LoadReportDefinition(ReportDefinitionCache.GetReportDefinition(location.File).GetReportStream()); localReport.EnableHyperlinks = true; localReport.EnableExternalImages = true; localReport.SetBasePermissionsForSandboxAppDomain(new System.Security.PermissionSet(System.Security.Permissions.PermissionState.Unrestricted)); if (localReport.IsDrillthroughReport) { localReport.SetParameters(localReport.OriginalParametersToDrillthrough); } else { IList <MsReportParameter> parameters = new List <MsReportParameter>(); foreach (IReportParameter parameter in report.ReportParameters) { parameters.Add(new MsReportParameter(parameter.Name, GetParameterValue(parameter))); } localReport.SetParameters(parameters); } localReport.DataSources.Clear(); foreach (IReportDataCommandTemplate reportDataCommandTemplate in report.ReportDataCommandTemplates) { DictionaryDataParameterValue parameterValues = new DictionaryDataParameterValue(); foreach (var dataParameterTemplate in reportDataCommandTemplate.Parameters) { var parameter = (IReportParameter)dataParameterTemplate; if (localReport.IsDrillthroughReport) { parameterValues[parameter.Name] = GetParameterValue(parameter, localReport.OriginalParametersToDrillthrough); } else { parameterValues[parameter.Name] = GetParameterValue(parameter); } } var dataCommandTemplate = reportDataCommandTemplate as ReportDataCommandTemplate; if (dataCommandTemplate != null) { using (IDataConnection connection = SimpleQuery.ConfigurationManagerConnection(dataCommandTemplate.DataSourceName)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } DataTable table = null; Boolean isOlap = ChangeOlapParameter(dataCommandTemplate.DataSourceName, parameterValues); if (reportDataCommandTemplate.Name.Equals("DealerGroupID")) { continue; } if (isOlap) { table = ReportAnalyticsClient.GetReportData <DataTable>(GetParameterList(parameterValues)); } if (table == null) { using (IDataCommand command = connection.CreateCommand(reportDataCommandTemplate, parameterValues.DataParameterValue)) { command.CommandTimeout = 200; using (IDataReader reader = command.ExecuteReader()) { table = (isOlap.Equals(true) ? DataTableMapper.ToOlapDataTable(reader, reportDataCommandTemplate.DataMap, new DataTableCallback()) : DataTableMapper.ToDataTable(reader, reportDataCommandTemplate.DataMap, new DataTableCallback())); } } } localReport.DataSources.Add(new MsReportDataSource(reportDataCommandTemplate.Name, table)); } } } localReport.Refresh(); }