private DataSet FillGrid()
{
this.connectionObject = ConnectionObject.CreateInstance(this.model.ReportSettings.ConnectionString,
System.Data.Common.DbProviderFactories.GetFactory("System.Data.OleDb"));
this.txtSqlString.Text = String.Empty;
SqlQueryChecker.Check(model.ReportSettings.CommandType,
model.ReportSettings.CommandText);
DataSet dataSet = ResultPanel.CreateDataSet ();
this.txtSqlString.Text = model.ReportSettings.CommandText;
if (model.ReportSettings.CommandType == CommandType.StoredProcedure){
if (reportStructure.SharpQueryProcedure == null) {
throw new IllegalQueryException();
}
SharpQueryProcedure procedure = reportStructure.SharpQueryProcedure;
SharpQuerySchemaClassCollection sc = procedure.GetSchemaParameters();
if ((sc != null) && sc.Count > 0) {
dataSet = ExecuteStoredProc (procedure);
}else {
dataSet = ExecuteStoredProc ();
}
}
// from here we create from an SqlString like "Select...."
if (model.ReportSettings.CommandType == CommandType.Text){
this.txtSqlString.Text = model.ReportSettings.CommandText;
dataSet = BuildFromSqlString();
}
return dataSet;
}
private ReportDataSource(ConnectionObject connectionObject, ReportSettings reportSettings)
{
this.connectionObject = connectionObject;
this.reportSettings = reportSettings;
this.connection = connectionObject.Connection;
if (this.connection.State == ConnectionState.Open)
{
this.connection.Close();
}
if (this.reportSettings.DataModel != GlobalEnums.PushPullModel.PushData)
{
SqlQueryChecker.Check(this.reportSettings.CommandType, this.reportSettings.CommandText);
}
this.dataSource = this.FillDataSet().Tables[0];
CheckDataSource();
/*
* this.dataViewStrategy = new TableStrategy((DataTable)this.dataSource,
* reportSettings);
*
* this.dataViewStrategy.ListChanged += new EventHandler <ListChangedEventArgs> (NotifyListChanged);
*
*/
}
public static IDataManager CreateDataManager(IReportModel reportModel, ReportParameters reportParameters)
{
if (reportModel == null)
{
throw new ArgumentNullException("reportModel");
}
IDataManager dataManager = null;
ConnectionObject connectionObject = null;
IDataAccessStrategy accesStrategy = null;
if (reportParameters != null)
{
connectionObject = reportParameters.ConnectionObject;
}
if (connectionObject != null)
{
accesStrategy = new SqlDataAccessStrategy(reportModel.ReportSettings, connectionObject);
}
else
{
accesStrategy = new SqlDataAccessStrategy(reportModel.ReportSettings, null);
}
dataManager = DataManager.CreateInstance(reportModel.ReportSettings, accesStrategy);
if (dataManager == null)
{
throw new MissingDataManagerException();
}
return(dataManager);
}
private DataSet FillGrid()
{
SqlQueryChecker.Check(model.ReportSettings.CommandType,
model.ReportSettings.CommandText);
DataSet dataSet = ResultPanel.CreateDataSet ();
this.txtSqlString.Text = model.ReportSettings.CommandText;
switch (model.ReportSettings.CommandType) {
case CommandType.Text:
this.connectionObject = CreateConnection ();
var dataAccess = new SqlDataAccessStrategy(model.ReportSettings,connectionObject);
dataSet = dataAccess.ReadData();
dataSet.Tables[0].TableName = CreateTableName (reportStructure);
break;
case CommandType.StoredProcedure:
dataSet = DatasetFromStoredProcedure();
break;
case CommandType.TableDirect:
MessageService.ShowError("TableDirect is not suppurted at the moment");
break;
default:
throw new Exception("Invalid value for CommandType");
}
return dataSet;
}
public static ConnectionObject BuildConnectionObject(ReportSettings reportSettings)
{
if (reportSettings == null)
{
throw new ArgumentNullException("reportSettings");
}
return(ConnectionObject.CreateInstance(reportSettings.ConnectionString,
DbProviderFactories.GetFactory("System.Data.OleDb")));
}
public static ConnectionObject BuildConnectionObject(string connectionString)
{
if (String.IsNullOrEmpty(connectionString))
{
throw new ArgumentNullException("connectionString");
}
return(ConnectionObject.CreateInstance(connectionString,
DbProviderFactories.GetFactory("System.Data.OleDb")));
}
/// <summary>
/// use this Constructor for PullDataReports
/// </summary>
/// <param name="connection">A valid connection</param>
/// <param name="reportSettings">a <see cref="ReportSettings"></see></param>
#region Constructores
public static ReportDataSource CreateInstance (ConnectionObject connectionObject, ReportSettings reportSettings)
{
if (connectionObject == null) {
throw new ArgumentNullException("connectionObject");
}
if (reportSettings == null) {
throw new ArgumentNullException("reportSettings");
}
ReportDataSource instance = new ReportDataSource(connectionObject,reportSettings);
return instance;
}
public SqlDataAccessStrategy(ReportSettings reportSettings,ConnectionObject connectionObject)
{
if (reportSettings == null) {
throw new ArgumentNullException("reportSettings");
}
this.reportSettings = reportSettings;
if (connectionObject == null) {
this.connectionObject = ConnectionObjectFactory.BuildConnectionObject(reportSettings.ConnectionString);
} else {
this.connectionObject = connectionObject;
}
}
private DataSet FillGrid()
{
this.connectionObject = ConnectionObject.CreateInstance(this.model.ReportSettings.ConnectionString,
System.Data.Common.DbProviderFactories.GetFactory("System.Data.OleDb"));
this.txtSqlString.Text = String.Empty;
SqlQueryChecker.Check(model.ReportSettings.CommandType,
model.ReportSettings.CommandText);
DataSet dataSet = ResultPanel.CreateDataSet ();
switch (model.ReportSettings.CommandType) {
case CommandType.Text:
this.txtSqlString.Text = model.ReportSettings.CommandText;
dataSet = BuildFromSqlString();
break;
case CommandType.StoredProcedure:
MessageService.ShowError("Stored Procedures are not suppurted at the moment");
break;
case CommandType.TableDirect:
MessageService.ShowError("TableDirect is not suppurted at the moment");
break;
default:
throw new Exception("Invalid value for CommandType");
}
if (model.ReportSettings.CommandType == CommandType.StoredProcedure){
/*
if (reportStructure.SharpQueryProcedure == null) {
throw new IllegalQueryException();
}
SharpQueryProcedure procedure = reportStructure.SharpQueryProcedure;
SharpQuerySchemaClassCollection sc = procedure.GetSchemaParameters();
if ((sc != null) && sc.Count > 0) {
dataSet = ExecuteStoredProc (procedure);
}else {
dataSet = ExecuteStoredProc ();
}
*/
}
// from here we create from an SqlString like "Select...."
// if (model.ReportSettings.CommandType == CommandType.Text){
// this.txtSqlString.Text = model.ReportSettings.CommandText;
// dataSet = BuildFromSqlString();
// }
return dataSet;
}
/// <summary>
/// use this Constructor for PullDataReports
/// </summary>
/// <param name="connection">A valid connection</param>
/// <param name="reportSettings">a <see cref="ReportSettings"></see></param>
#region Constructores
public static ReportDataSource CreateInstance(ConnectionObject connectionObject, ReportSettings reportSettings)
{
if (connectionObject == null)
{
throw new ArgumentNullException("connectionObject");
}
if (reportSettings == null)
{
throw new ArgumentNullException("reportSettings");
}
ReportDataSource instance = new ReportDataSource(connectionObject, reportSettings);
return(instance);
}
public static ConnectionObject CreateInstance (IDbConnection connection,
DbProviderFactory providerFactory)
{
if (connection == null) {
throw new ArgumentNullException("connection");
}
if (providerFactory == null) {
throw new ArgumentNullException("providerFactory");
}
ConnectionObject instance = new ConnectionObject ();
instance.connection = connection;
instance.providerFactory = providerFactory;
return instance;
}
public SqlDataAccessStrategy(ReportSettings reportSettings, ConnectionObject connectionObject)
{
if (reportSettings == null)
{
throw new ArgumentNullException("reportSettings");
}
this.reportSettings = reportSettings;
if (connectionObject == null)
{
this.connectionObject = ConnectionObjectFactory.BuildConnectionObject(reportSettings.ConnectionString);
}
else
{
this.connectionObject = connectionObject;
}
}
public static ConnectionObject CreateInstance(IDbConnection connection,
DbProviderFactory providerFactory)
{
if (connection == null)
{
throw new ArgumentNullException("connection");
}
if (providerFactory == null)
{
throw new ArgumentNullException("providerFactory");
}
ConnectionObject instance = new ConnectionObject();
instance.connection = connection;
instance.providerFactory = providerFactory;
return(instance);
}
public static ConnectionObject CreateInstance (string connectionString,
DbProviderFactory providerFactory)
{
if (String.IsNullOrEmpty(connectionString)) {
throw new ArgumentNullException("connectionString");
}
if (providerFactory == null) {
throw new ArgumentNullException("providerFactory");
}
IDbConnection con = providerFactory.CreateConnection();
con.ConnectionString = connectionString;
ConnectionObject instance = new ConnectionObject ();
instance.connection = con;
instance.providerFactory = providerFactory;
return instance;
}
public static ConnectionObject CreateInstance(string connectionString,
DbProviderFactory providerFactory)
{
if (String.IsNullOrEmpty(connectionString))
{
throw new ArgumentNullException("connectionString");
}
if (providerFactory == null)
{
throw new ArgumentNullException("providerFactory");
}
IDbConnection con = providerFactory.CreateConnection();
con.ConnectionString = connectionString;
return(ConnectionObject.CreateInstance(con, providerFactory));
}
private ReportDataSource(ConnectionObject connectionObject, ReportSettings reportSettings)
{
this.connectionObject = connectionObject;
this.reportSettings = reportSettings;
this.connection = connectionObject.Connection;
if (this.connection.State == ConnectionState.Open) {
this.connection.Close();
}
if (this.reportSettings.DataModel != GlobalEnums.PushPullModel.PushData) {
SqlQueryChecker.Check(this.reportSettings.CommandType,this.reportSettings.CommandText);
}
this.dataSource = this.FillDataSet().Tables[0];
CheckDataSource();
/*
this.dataViewStrategy = new TableStrategy((DataTable)this.dataSource,
reportSettings);
this.dataViewStrategy.ListChanged += new EventHandler <ListChangedEventArgs> (NotifyListChanged);
*/
}
public static ConnectionObject PrepareConnectionFromParameters(ReportSettings settings,
ReportParameters reportParameters)
{
if (settings == null)
{
throw new ArgumentNullException("settings");
}
ConnectionObject conObj = null;
if (reportParameters != null)
{
if (reportParameters.ConnectionObject != null)
{
conObj = reportParameters.ConnectionObject;
}
}
if (!String.IsNullOrEmpty(settings.ConnectionString))
{
conObj = ConnectionObjectFactory.BuildConnectionObject(settings.ConnectionString);
}
return(conObj);
}
public ReportParameters(ConnectionObject connectionObject)
{
this.connectionObject = connectionObject;
}
public ReportParameters(ConnectionObject connectionObject)
{
this.connectionObject = connectionObject;
}
DataSet DatasetFromStoredProcedure()
{
this.connectionObject = CreateConnection();
DataSet dataSet = ResultPanel.CreateDataSet();
IProcedure procedure = reportStructure.IDatabaseObjectBase as IProcedure;
var paramCollection = CheckParameters(procedure);
if (paramCollection.Count > 0) {
FillParameters(paramCollection);
reportStructure.SqlQueryParameters.AddRange(paramCollection);
}
var dataAccess = new SqlDataAccessStrategy(model.ReportSettings,connectionObject);
dataSet = dataAccess.ReadData();
dataSet.Tables[0].TableName = procedure.Name;
return dataSet;
}
