public static DataTable GetUsers(WorkflowDynamicSecurityGroup group, Workflow workflow, WorkflowStep step, string EntityID, string UserName)
{
DataTable retVal = null;
DataCommandService dataCommandDB = DataCommandService.GetInstance();
DataCommand command = Core.DataCommand.GetDataCommand(group.DataCommand);
if (command == null)
{
throw new ApplicationException(String.Format("DataCommand {0} could not be found in configuration", group.DataCommand));
}
List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>();
ScreenDataCommandParameter parameter = null;
if (!String.IsNullOrEmpty(group.WorkflowCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = group.WorkflowCodeParameter;
parameter.Value = workflow.Code;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(group.CurrentWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = group.CurrentWorkflowStepCodeParameter;
parameter.Value = step.Code;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(group.EntityIDParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = group.EntityIDParameter;
parameter.Value = EntityID;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(group.UsernameParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = group.UsernameParameter;
parameter.Value = UserName;
parameters.Add(parameter);
}
//execute command with transaction
//CommandType type = (command.Type == DataCommandCommandType.StoredProcedure) ? CommandType.StoredProcedure : CommandType.Text;
retVal = dataCommandDB.GetDataForDataCommand(command.Name, parameters);
return(retVal);
}
private DataTable GetData(System.Data.Common.DbTransaction tran,
string CommandName,
string WorkflowCode,
string FromWorkflowStepCode,
string ToWorkflowStepCode,
string EntityID,
string Comment,
string UserName,
string WorkflowCodeParameter,
string FromWorkflowStepCodeParameter,
string ToWorkflowStepCodeParameter,
string EntityIDParameter,
string CommentParameter,
string UsernameParameter
)
{
DataCommandService dataCommandDB = DataCommandService.GetInstance();
List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>();
ScreenDataCommandParameter parameter = null;
DataCommand command = DataCommand.GetDataCommand(CommandName);
if (command == null)
{
throw new ApplicationException(String.Format("DataCommand {0} could not be found in configuration", CommandName));
}
if (!String.IsNullOrEmpty(WorkflowCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = WorkflowCodeParameter;
parameter.Value = WorkflowCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(FromWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = FromWorkflowStepCodeParameter;
parameter.Value = FromWorkflowStepCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(ToWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = ToWorkflowStepCodeParameter;
parameter.Value = ToWorkflowStepCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(EntityIDParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = EntityIDParameter;
parameter.Value = EntityID;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(CommentParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = CommentParameter;
parameter.Value = Comment;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(UsernameParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = UsernameParameter;
parameter.Value = UserName;
parameters.Add(parameter);
}
//execute command with transaction
// CommandType type = (command.Type == DataCommandCommandType.StoredProcedure) ? CommandType.StoredProcedure : CommandType.Text;
DataTable data = dataCommandDB.GetData(tran, command, parameters, command.Text);
return(data);
}
public override void Execute(System.Data.Common.DbTransaction tran, string WorkflowCode, string FromWorkflowStepCode, string ToWorkflowStepCode, string EntityID, string Comment, string UserName)
{
//base.Execute(tran);
DataCommandService dataCommandDB = DataCommandService.GetInstance();
DataCommand command = DataCommand.GetDataCommand(this.ExecuteCommand);
if (command == null)
{
throw new ApplicationException(String.Format("DataCommand {0} could not be found in configuration", this.ExecuteCommand));
}
List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>();
ScreenDataCommandParameter parameter = null;
if (!String.IsNullOrEmpty(this.WorkflowCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = this.WorkflowCodeParameter;
parameter.Value = WorkflowCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(this.FromWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = this.FromWorkflowStepCodeParameter;
parameter.Value = FromWorkflowStepCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(this.ToWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = this.ToWorkflowStepCodeParameter;
parameter.Value = ToWorkflowStepCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(this.EntityIDParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = this.EntityIDParameter;
parameter.Value = EntityID;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(this.CommentParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = this.CommentParameter;
parameter.Value = Comment;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(this.UsernameParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = this.UsernameParameter;
parameter.Value = UserName;
parameters.Add(parameter);
}
//execute command with transaction
//CommandType type = (command.Type == DataCommandCommandType.StoredProcedure) ? CommandType.StoredProcedure : CommandType.Text;
object retVal = dataCommandDB.ExecuteCommand(tran, command, parameters, command.Text);
}