public void SetQueries(DesignerDataConnection dataConnection, SqlDataSourceQuery selectQuery, SqlDataSourceQuery insertQuery, SqlDataSourceQuery updateQuery, SqlDataSourceQuery deleteQuery)
{
this._dataConnection = dataConnection;
this._selectQuery = selectQuery;
this._insertQuery = insertQuery;
this._updateQuery = updateQuery;
this._deleteQuery = deleteQuery;
this._previewTextBox.Text = this._selectQuery.Command;
}
public void SetQueries(DesignerDataConnection dataConnection, SqlDataSourceQuery selectQuery, SqlDataSourceQuery insertQuery, SqlDataSourceQuery updateQuery, SqlDataSourceQuery deleteQuery)
{
DesignerDataConnection connection = dataConnection;
if (!SqlDataSourceDesigner.ConnectionsEqual(this._dataConnection, connection))
{
this._dataConnection = connection;
Cursor current = Cursor.Current;
ArrayList storedProcedures = null;
try
{
Cursor.Current = Cursors.WaitCursor;
IDataEnvironment service = (IDataEnvironment)this._sqlDataSourceDesigner.Component.Site.GetService(typeof(IDataEnvironment));
if (service != null)
{
IDesignerDataSchema connectionSchema = service.GetConnectionSchema(this._dataConnection);
if ((connectionSchema != null) && connectionSchema.SupportsSchemaClass(DesignerDataSchemaClass.StoredProcedures))
{
ICollection schemaItems = connectionSchema.GetSchemaItems(DesignerDataSchemaClass.StoredProcedures);
if ((schemaItems != null) && (schemaItems.Count > 0))
{
storedProcedures = new ArrayList();
foreach (DesignerDataStoredProcedure procedure in schemaItems)
{
if (!procedure.Name.ToLowerInvariant().StartsWith("AspNet_".ToLowerInvariant(), StringComparison.Ordinal))
{
storedProcedures.Add(procedure);
}
}
}
}
}
}
catch (Exception exception)
{
UIServiceHelper.ShowError(base.ServiceProvider, exception, System.Design.SR.GetString("SqlDataSourceConnectionPanel_CouldNotGetConnectionSchema"));
}
finally
{
Cursor.Current = current;
}
this._selectCommandEditor.SetConnection(this._dataConnection);
this._selectCommandEditor.SetStoredProcedures(storedProcedures);
this._insertCommandEditor.SetConnection(this._dataConnection);
this._insertCommandEditor.SetStoredProcedures(storedProcedures);
this._updateCommandEditor.SetConnection(this._dataConnection);
this._updateCommandEditor.SetStoredProcedures(storedProcedures);
this._deleteCommandEditor.SetConnection(this._dataConnection);
this._deleteCommandEditor.SetStoredProcedures(storedProcedures);
this._selectCommandEditor.SetQuery(selectQuery);
this._insertCommandEditor.SetQuery(insertQuery);
this._updateCommandEditor.SetQuery(updateQuery);
this._deleteCommandEditor.SetQuery(deleteQuery);
}
}
public override bool OnNext()
{
SqlDataSourceQuery selectQuery = new SqlDataSourceQuery(this._selectQuery.Command, this._selectQuery.CommandType, this._parameterEditorUserControl.GetParameters());
SqlDataSourceSummaryPanel nextPanel = base.NextPanel as SqlDataSourceSummaryPanel;
if (nextPanel == null)
{
nextPanel = ((SqlDataSourceWizardForm)base.ParentWizard).GetSummaryPanel();
base.NextPanel = nextPanel;
}
nextPanel.SetQueries(this._dataConnection, selectQuery, this._insertQuery, this._updateQuery, this._deleteQuery);
return(true);
}
public override bool OnNext()
{
SqlDataSourceQuery selectQuery = this._selectCommandEditor.GetQuery();
SqlDataSourceQuery query = this._insertCommandEditor.GetQuery();
SqlDataSourceQuery updateQuery = this._updateCommandEditor.GetQuery();
SqlDataSourceQuery deleteQuery = this._deleteCommandEditor.GetQuery();
if (((selectQuery == null) || (query == null)) || ((updateQuery == null) || (deleteQuery == null)))
{
return(false);
}
int num = 0;
foreach (Parameter parameter in selectQuery.Parameters)
{
if ((parameter.Direction == ParameterDirection.Input) || (parameter.Direction == ParameterDirection.InputOutput))
{
num++;
}
}
if (num == 0)
{
SqlDataSourceSummaryPanel summaryPanel = base.NextPanel as SqlDataSourceSummaryPanel;
if (summaryPanel == null)
{
summaryPanel = ((SqlDataSourceWizardForm)base.ParentWizard).GetSummaryPanel();
base.NextPanel = summaryPanel;
}
summaryPanel.SetQueries(this._dataConnection, selectQuery, query, updateQuery, deleteQuery);
return(true);
}
SqlDataSourceConfigureParametersPanel nextPanel = base.NextPanel as SqlDataSourceConfigureParametersPanel;
if (nextPanel == null)
{
nextPanel = ((SqlDataSourceWizardForm)base.ParentWizard).GetConfigureParametersPanel();
base.NextPanel = nextPanel;
SqlDataSource component = (SqlDataSource)this._sqlDataSourceDesigner.Component;
Parameter[] selectParameters = new Parameter[component.SelectParameters.Count];
for (int i = 0; i < component.SelectParameters.Count; i++)
{
Parameter original = component.SelectParameters[i];
Parameter clone = (Parameter)((ICloneable)original).Clone();
this._sqlDataSourceDesigner.RegisterClone(original, clone);
selectParameters[i] = clone;
}
nextPanel.InitializeParameters(selectParameters);
}
nextPanel.SetQueries(this._dataConnection, selectQuery, query, updateQuery, deleteQuery);
return(true);
}
public void SetQueries(DesignerDataConnection dataConnection, SqlDataSourceQuery selectQuery, SqlDataSourceQuery insertQuery, SqlDataSourceQuery updateQuery, SqlDataSourceQuery deleteQuery)
{
this._dataConnection = dataConnection;
this._selectQuery = selectQuery;
this._insertQuery = insertQuery;
this._updateQuery = updateQuery;
this._deleteQuery = deleteQuery;
this._previewTextBox.Text = this._selectQuery.Command;
Parameter[] array = new Parameter[this._selectQuery.Parameters.Count];
this._selectQuery.Parameters.CopyTo(array, 0);
Parameter[] parameters = MergeParameters(this._parameterEditorUserControl.GetParameters(), array);
this._parameterEditorUserControl.ClearParameters();
this._parameterEditorUserControl.AddParameters(parameters);
}
public SqlDataSourceQuery GetUpdateQuery(string oldValuesFormatString, bool includeOldValues)
{
if (!this.CanAutoGenerateQueries())
{
return(null);
}
StringBuilder builder = new StringBuilder("UPDATE ");
builder.Append(this.GetTableName());
builder.Append(" SET ");
List <SqlDataSourceColumnData> effectiveColumns = this.GetEffectiveColumns();
List <Parameter> parameters = new List <Parameter>();
bool flag = true;
foreach (SqlDataSourceColumnData data in effectiveColumns)
{
if (!data.Column.PrimaryKey)
{
if (!flag)
{
builder.Append(", ");
}
builder.Append(data.EscapedName);
builder.Append(" = ");
builder.Append(data.ParameterPlaceholder);
flag = false;
DbProviderFactory dbProviderFactory = SqlDataSourceDesigner.GetDbProviderFactory(this.DesignerDataConnection.ProviderName);
parameters.Add(SqlDataSourceDesigner.CreateParameter(dbProviderFactory, data.WebParameterName, data.Column.DataType));
}
}
if (flag)
{
return(null);
}
SqlDataSourceQuery whereClause = this.GetWhereClause(oldValuesFormatString, includeOldValues);
if (whereClause == null)
{
return(null);
}
builder.Append(whereClause.Command);
foreach (Parameter parameter in whereClause.Parameters)
{
parameters.Add(parameter);
}
return(new SqlDataSourceQuery(builder.ToString(), SqlDataSourceCommandType.Text, parameters));
}
public SqlDataSourceQuery GetDeleteQuery(string oldValuesFormatString, bool includeOldValues)
{
if (!this.CanAutoGenerateQueries())
{
return(null);
}
StringBuilder builder = new StringBuilder("DELETE FROM ");
builder.Append(this.GetTableName());
SqlDataSourceQuery whereClause = this.GetWhereClause(oldValuesFormatString, includeOldValues);
if (whereClause == null)
{
return(null);
}
builder.Append(whereClause.Command);
return(new SqlDataSourceQuery(builder.ToString(), SqlDataSourceCommandType.Text, whereClause.Parameters));
}
public void SetQuery(SqlDataSourceQuery query)
{
this._storedProcedureComboBox.SelectedIndex = -1;
if (this._storedProcedures != null)
{
foreach (StoredProcedureItem item in this._storedProcedureComboBox.Items)
{
if (item.DesignerDataStoredProcedure.Name == query.Command)
{
this._storedProcedureComboBox.SelectedItem = item;
break;
}
}
}
if (this._storedProcedureComboBox.SelectedIndex != -1)
{
this._sqlRadioButton.Checked = false;
this._storedProcedureRadioButton.Checked = true;
}
else
{
this._sqlRadioButton.Checked = true;
this._storedProcedureRadioButton.Checked = false;
if (this._storedProcedureComboBox.Items.Count > 0)
{
this._storedProcedureComboBox.SelectedIndex = 0;
}
}
if (!this._queryInitialized)
{
this._commandTextBox.Text = query.Command;
this._originalCommand = query.Command;
this._commandType = query.CommandType;
this._parameters = query.Parameters;
this._queryInitialized = true;
}
this.UpdateEnabledState();
}
public override bool OnNext()
{
if (this._tableRadioButton.Checked)
{
SqlDataSourceQuery insertQuery;
SqlDataSourceQuery updateQuery;
SqlDataSourceQuery deleteQuery;
SqlDataSourceQuery selectQuery = this._tableQuery.GetSelectQuery();
if (selectQuery == null)
{
selectQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
if (this._generateMode > 0)
{
SqlDataSource sqlDataSource = (SqlDataSource) this._sqlDataSourceDesigner.Component;
bool adjustForOptimisticConcurrency = this._generateMode == 2;
string oldValuesFormatString = GetOldValuesFormatString(sqlDataSource, adjustForOptimisticConcurrency);
insertQuery = this._tableQuery.GetInsertQuery();
if (insertQuery == null)
{
insertQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
updateQuery = this._tableQuery.GetUpdateQuery(oldValuesFormatString, adjustForOptimisticConcurrency);
if (updateQuery == null)
{
updateQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
deleteQuery = this._tableQuery.GetDeleteQuery(oldValuesFormatString, adjustForOptimisticConcurrency);
if (deleteQuery == null)
{
deleteQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
}
else
{
insertQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
updateQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
deleteQuery = new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
SqlDataSourceSummaryPanel summaryPanel = base.NextPanel as SqlDataSourceSummaryPanel;
if (summaryPanel == null)
{
summaryPanel = ((SqlDataSourceWizardForm) base.ParentWizard).GetSummaryPanel();
base.NextPanel = summaryPanel;
}
summaryPanel.SetQueries(this._dataConnection, selectQuery, insertQuery, updateQuery, deleteQuery);
return true;
}
SqlDataSourceCustomCommandPanel nextPanel = base.NextPanel as SqlDataSourceCustomCommandPanel;
if (nextPanel == null)
{
nextPanel = ((SqlDataSourceWizardForm) base.ParentWizard).GetCustomCommandPanel();
base.NextPanel = nextPanel;
}
SqlDataSource component = (SqlDataSource) this._sqlDataSourceDesigner.Component;
ArrayList dest = new ArrayList();
ArrayList list2 = new ArrayList();
ArrayList list3 = new ArrayList();
ArrayList list4 = new ArrayList();
this._sqlDataSourceDesigner.CopyList(component.SelectParameters, dest);
this._sqlDataSourceDesigner.CopyList(component.InsertParameters, list2);
this._sqlDataSourceDesigner.CopyList(component.UpdateParameters, list3);
this._sqlDataSourceDesigner.CopyList(component.DeleteParameters, list4);
nextPanel.SetQueries(this._dataConnection, new SqlDataSourceQuery(component.SelectCommand, component.SelectCommandType, dest), new SqlDataSourceQuery(component.InsertCommand, component.InsertCommandType, list2), new SqlDataSourceQuery(component.UpdateCommand, component.UpdateCommandType, list3), new SqlDataSourceQuery(component.DeleteCommand, component.DeleteCommandType, list4));
return true;
}
private void UpdatePreview()
{
SqlDataSourceQuery selectQuery = this._tableQuery.GetSelectQuery();
this._previewTextBox.Text = (selectQuery == null) ? string.Empty : selectQuery.Command;
}
public void SetQueries(DesignerDataConnection dataConnection, SqlDataSourceQuery selectQuery, SqlDataSourceQuery insertQuery, SqlDataSourceQuery updateQuery, SqlDataSourceQuery deleteQuery)
{
this._dataConnection = dataConnection;
this._selectQuery = selectQuery;
this._insertQuery = insertQuery;
this._updateQuery = updateQuery;
this._deleteQuery = deleteQuery;
this._previewTextBox.Text = this._selectQuery.Command;
Parameter[] array = new Parameter[this._selectQuery.Parameters.Count];
this._selectQuery.Parameters.CopyTo(array, 0);
Parameter[] parameters = MergeParameters(this._parameterEditorUserControl.GetParameters(), array);
this._parameterEditorUserControl.ClearParameters();
this._parameterEditorUserControl.AddParameters(parameters);
}
public override bool OnNext()
{
SqlDataSourceQuery selectQuery = new SqlDataSourceQuery(this._selectQuery.Command, this._selectQuery.CommandType, this._parameterEditorUserControl.GetParameters());
SqlDataSourceSummaryPanel nextPanel = base.NextPanel as SqlDataSourceSummaryPanel;
if (nextPanel == null)
{
nextPanel = ((SqlDataSourceWizardForm) base.ParentWizard).GetSummaryPanel();
base.NextPanel = nextPanel;
}
nextPanel.SetQueries(this._dataConnection, selectQuery, this._insertQuery, this._updateQuery, this._deleteQuery);
return true;
}
public SqlDataSourceQuery GetQuery()
{
SqlDataSourceQuery query;
Cursor current = Cursor.Current;
try
{
DbProviderFactory dbProviderFactory;
Cursor.Current = Cursors.WaitCursor;
if (this._sqlRadioButton.Checked)
{
SqlDataSourceCommandType text;
ICollection is2;
if (this._commandTextBox.Text.Trim().Length <= 0)
{
return new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
if (string.Equals(this._commandTextBox.Text, this._originalCommand, StringComparison.OrdinalIgnoreCase))
{
text = this._commandType;
}
else
{
text = SqlDataSourceCommandType.Text;
}
dbProviderFactory = SqlDataSourceDesigner.GetDbProviderFactory(this._dataConnection.ProviderName);
if ((this._editorMode == QueryBuilderMode.Select) || SqlDataSourceDesigner.SupportsNamedParameters(dbProviderFactory))
{
Parameter[] c = this._sqlDataSourceDesigner.InferParameterNames(this._dataConnection, this._commandTextBox.Text, text);
if (c == null)
{
return null;
}
ArrayList list = new ArrayList(c);
is2 = this.MergeParameters(this._parameters, list, SqlDataSourceDesigner.SupportsNamedParameters(dbProviderFactory));
}
else
{
is2 = this._parameters;
}
return new SqlDataSourceQuery(this._commandTextBox.Text, text, is2);
}
StoredProcedureItem selectedItem = this._storedProcedureComboBox.SelectedItem as StoredProcedureItem;
if (selectedItem == null)
{
return new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]);
}
ArrayList newParameters = new ArrayList();
ICollection is3 = null;
try
{
is3 = selectedItem.DesignerDataStoredProcedure.Parameters;
}
catch (Exception exception)
{
UIServiceHelper.ShowError(this._sqlDataSourceDesigner.Component.Site, exception, System.Design.SR.GetString("SqlDataSourceCustomCommandEditor_CouldNotGetStoredProcedureSchema"));
return null;
}
dbProviderFactory = SqlDataSourceDesigner.GetDbProviderFactory(this._dataConnection.ProviderName);
if ((is3 != null) && (is3.Count > 0))
{
foreach (DesignerDataParameter parameter in is3)
{
string name = SqlDataSourceDesigner.StripParameterPrefix(parameter.Name);
Parameter parameter2 = SqlDataSourceDesigner.CreateParameter(dbProviderFactory, name, parameter.DataType);
parameter2.Direction = parameter.Direction;
newParameters.Add(parameter2);
}
}
ICollection parameters = this.MergeParameters(this._parameters, newParameters, SqlDataSourceDesigner.SupportsNamedParameters(dbProviderFactory));
query = new SqlDataSourceQuery(selectedItem.DesignerDataStoredProcedure.Name, SqlDataSourceCommandType.StoredProcedure, parameters);
}
finally
{
Cursor.Current = current;
}
return query;
}
public void SetQuery(SqlDataSourceQuery query)
{
this._storedProcedureComboBox.SelectedIndex = -1;
if (this._storedProcedures != null)
{
foreach (StoredProcedureItem item in this._storedProcedureComboBox.Items)
{
if (item.DesignerDataStoredProcedure.Name == query.Command)
{
this._storedProcedureComboBox.SelectedItem = item;
break;
}
}
}
if (this._storedProcedureComboBox.SelectedIndex != -1)
{
this._sqlRadioButton.Checked = false;
this._storedProcedureRadioButton.Checked = true;
}
else
{
this._sqlRadioButton.Checked = true;
this._storedProcedureRadioButton.Checked = false;
if (this._storedProcedureComboBox.Items.Count > 0)
{
this._storedProcedureComboBox.SelectedIndex = 0;
}
}
if (!this._queryInitialized)
{
this._commandTextBox.Text = query.Command;
this._originalCommand = query.Command;
this._commandType = query.CommandType;
this._parameters = query.Parameters;
this._queryInitialized = true;
}
this.UpdateEnabledState();
}
public SqlDataSourceQuery GetQuery()
{
SqlDataSourceQuery query;
Cursor current = Cursor.Current;
try
{
DbProviderFactory dbProviderFactory;
Cursor.Current = Cursors.WaitCursor;
if (this._sqlRadioButton.Checked)
{
SqlDataSourceCommandType text;
ICollection is2;
if (this._commandTextBox.Text.Trim().Length <= 0)
{
return(new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]));
}
if (string.Equals(this._commandTextBox.Text, this._originalCommand, StringComparison.OrdinalIgnoreCase))
{
text = this._commandType;
}
else
{
text = SqlDataSourceCommandType.Text;
}
dbProviderFactory = SqlDataSourceDesigner.GetDbProviderFactory(this._dataConnection.ProviderName);
if ((this._editorMode == QueryBuilderMode.Select) || SqlDataSourceDesigner.SupportsNamedParameters(dbProviderFactory))
{
Parameter[] c = this._sqlDataSourceDesigner.InferParameterNames(this._dataConnection, this._commandTextBox.Text, text);
if (c == null)
{
return(null);
}
ArrayList list = new ArrayList(c);
is2 = this.MergeParameters(this._parameters, list, SqlDataSourceDesigner.SupportsNamedParameters(dbProviderFactory));
}
else
{
is2 = this._parameters;
}
return(new SqlDataSourceQuery(this._commandTextBox.Text, text, is2));
}
StoredProcedureItem selectedItem = this._storedProcedureComboBox.SelectedItem as StoredProcedureItem;
if (selectedItem == null)
{
return(new SqlDataSourceQuery(string.Empty, SqlDataSourceCommandType.Text, new Parameter[0]));
}
ArrayList newParameters = new ArrayList();
ICollection is3 = null;
try
{
is3 = selectedItem.DesignerDataStoredProcedure.Parameters;
}
catch (Exception exception)
{
UIServiceHelper.ShowError(this._sqlDataSourceDesigner.Component.Site, exception, System.Design.SR.GetString("SqlDataSourceCustomCommandEditor_CouldNotGetStoredProcedureSchema"));
return(null);
}
dbProviderFactory = SqlDataSourceDesigner.GetDbProviderFactory(this._dataConnection.ProviderName);
if ((is3 != null) && (is3.Count > 0))
{
foreach (DesignerDataParameter parameter in is3)
{
string name = SqlDataSourceDesigner.StripParameterPrefix(parameter.Name);
Parameter parameter2 = SqlDataSourceDesigner.CreateParameter(dbProviderFactory, name, parameter.DataType);
parameter2.Direction = parameter.Direction;
newParameters.Add(parameter2);
}
}
ICollection parameters = this.MergeParameters(this._parameters, newParameters, SqlDataSourceDesigner.SupportsNamedParameters(dbProviderFactory));
query = new SqlDataSourceQuery(selectedItem.DesignerDataStoredProcedure.Name, SqlDataSourceCommandType.StoredProcedure, parameters);
}
finally
{
Cursor.Current = current;
}
return(query);
}
public void SetQueries(DesignerDataConnection dataConnection, SqlDataSourceQuery selectQuery, SqlDataSourceQuery insertQuery, SqlDataSourceQuery updateQuery, SqlDataSourceQuery deleteQuery)
{
this._dataConnection = dataConnection;
this._selectQuery = selectQuery;
this._insertQuery = insertQuery;
this._updateQuery = updateQuery;
this._deleteQuery = deleteQuery;
this._previewTextBox.Text = this._selectQuery.Command;
}