public void UpdateDesigner(ExecuteStoredProcedureDesigner designer)
{
if (ShouldUpdateConnectionString)
{
designer.ConnectionType = ConnectionType;
designer.ConnectionString = ConnectionString;
}
else
{
designer.DesignTimeConnectionType = ConnectionType;
designer.DesignTimeConnectionString = ConnectionString;
}
if (ShouldUpdateStoredProcedure)
{
designer.StoredProcedure = StoredProcedure;
}
else
{
designer.DesignTimeStoredProcedure = StoredProcedure;
}
if (ShouldUpdateProcedureParameters)
{
designer.Parameters = ProcedureParameters;
}
if (ShouldUpdateResultSets)
{
designer.ResultSets = ResultSets;
}
}
public EditingInfo(ExecuteStoredProcedureDesigner designer)
{
ConnectionType = designer.DesignTimeConnectionType;
ConnectionString = designer.DesignTimeConnectionString;
StoredProcedure = designer.DesignTimeStoredProcedure;
ProcedureParameters = designer.Parameters;
ResultSets = designer.ResultSets;
}
public void EditValue(Property storedProcedureProperty, object designer)
{
ExecuteStoredProcedureDesigner executeStoredProcedureDesigner = designer as ExecuteStoredProcedureDesigner;
EditingInfo editingInfo = new EditingInfo(executeStoredProcedureDesigner)
{
ShouldUpdateConnectionString = false,
ShouldUpdateStoredProcedure = true,
ShouldUpdateProcedureParameters = true,
ShouldUpdateResultSets = true
};
if (EditStoredProcedure(editingInfo))
{
executeStoredProcedureDesigner.Context.TransactionManager.StartTransaction("Change stored procedure");
editingInfo.UpdateDesigner(executeStoredProcedureDesigner);
executeStoredProcedureDesigner.Context.TransactionManager.StopTransaction();
}
}
public void EditValue(Property property, object designer)
{
ExecuteStoredProcedureDesigner executeStoredProcedureDesigner = designer as ExecuteStoredProcedureDesigner;
EditingInfo editingInfo = new EditingInfo(executeStoredProcedureDesigner)
{
ShouldUpdateConnectionString = false,
ShouldUpdateStoredProcedure = false,
ShouldUpdateProcedureParameters = true,
ShouldUpdateResultSets = false
};
if (ProcedureParametersEditorWindow.Display(new ProcedureParametersViewModel(editingInfo)))
{
executeStoredProcedureDesigner.Context.TransactionManager.StartTransaction("Change procedure parameters");
editingInfo.UpdateDesigner(executeStoredProcedureDesigner);
executeStoredProcedureDesigner.Context.TransactionManager.StopTransaction();
}
}
