public void SavePermission(DataConnection connection, Permission permission)
{
List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>();
ScreenDataCommandParameter p = null;
p = new ScreenDataCommandParameter(ParameterPermissionName, permission.Name);
parameters.Add(p);
p = new ScreenDataCommandParameter(ParameterCategory, permission.Category);
parameters.Add(p);
p = new ScreenDataCommandParameter(ParameterDescription, permission.Description);
parameters.Add(p);
DataCommand command = DataCommand.GetDataCommand(DataCommandPermissionSave);
if (command == null)
{
throw new Exception(String.Format("DataCommand {0} could not be found in configuration", DataCommandPermissionSave));
}
//execute command
sql.ExecuteCommand(null, connection, command, parameters, command.Text);
}
private void ExecuteDataCommand(string dataCommand, List <ScreenDataCommandParameter> parameters)
{
if (Connection == null)
{
sql.ExecuteDataCommand(dataCommand, parameters);
}
else
{
DataCommand command = DataCommand.GetDataCommand(dataCommand);
if (command == null)
{
throw new Exception(String.Format("DataCommand {0} could not be found in configuration", dataCommand));
}
sql.ExecuteCommand(null, Connection, command, parameters, command.Text);
}
}
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);
}