public EditWorkflowTypeViewModel(WorkflowTypeOperations operations, WorkflowTypeSearchDC workflowTypeParam, Action canUploadWorkflowType)
{
this.refreshCommandCanExecute = canUploadWorkflowType;
this.BroswerPublishingWorkflowsCommand = new DelegateCommand(BrowserPublishingWorkflows);
this.BroswerTemplateWorkflowsCommand = new DelegateCommand(BrowserTemplateWorkflows);
if (workflowTypeParam != null)
this.workflowType = workflowTypeParam;
else
{
this.workflowType = new WorkflowTypeSearchDC();
this.workflowType.Guid = Guid.NewGuid();
}
if (operations == WorkflowTypeOperations.Add)
this.WindowTitle = addWorkflowType;
else
this.WindowTitle = editWorkflowType;
this.Name = this.workflowType.Name;
this.PublishingWorkflow = this.workflowType.PublishingWorkflow;
this.PublishingWorkflowId = this.workflowType.PublishingWorkflowId;
this.Template = this.workflowType.WorkflowTemplate;
this.TemplateId = this.workflowType.WorkflowTemplateId;
WorkflowsQueryServiceUtility.UsingClient(this.GetAuthGroups);
}
/// <summary>
/// Search workflowtypes
/// </summary>
/// <returns></returns>
public static WorkflowTypeSearchReply SearchWorkflowTypes(WorkflowTypeSearchRequest request)
{
WorkflowTypeSearchReply reply = new WorkflowTypeSearchReply();
IList<WorkflowTypeSearchDC> wftList = new List<WorkflowTypeSearchDC>();
try
{
WorkflowTypeSearchDC wfat = null;
Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetStoredProcCommand(StoredProcNames.WorkflowType_Search);
db.AddParameter(cmd, "@SearchText", DbType.String, ParameterDirection.Input, null, DataRowVersion.Default, request.SearchText);
db.AddParameter(cmd, "@SortColumn", DbType.String, ParameterDirection.Input, null, DataRowVersion.Default, request.SortColumn);
db.AddParameter(cmd, "@SortAscending", DbType.Boolean, ParameterDirection.Input, null, DataRowVersion.Default, request.SortAscending);
db.AddParameter(cmd, "@PageSize", DbType.Int32, ParameterDirection.Input, null, DataRowVersion.Default, request.PageSize);
db.AddParameter(cmd, "@PageNumber", DbType.Int32, ParameterDirection.Input, null, DataRowVersion.Default, request.PageNumber);
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
wfat =new WorkflowTypeSearchDC();
wfat.Guid = reader[DataColumnNames.Guid] != DBNull.Value ?(Guid)reader[DataColumnNames.Guid] : Guid.Empty;
wfat.Id = Convert.ToInt32(reader[DataColumnNames.Id]);
wfat.Name = Convert.ToString(reader[DataColumnNames.Name]);
wfat.AuthGroupId = Convert.ToInt32(reader[DataColumnNames.AuthGroupId]);
wfat.AuthGroupName = reader[DataColumnNames.AuthGroupName] != DBNull.Value ? Convert.ToString(reader[DataColumnNames.AuthGroupName]) : string.Empty;
wfat.PublishingWorkflow = reader[DataColumnNames.PublishingWorkflowName] != DBNull.Value
? Convert.ToString(reader[DataColumnNames.PublishingWorkflowName]) : string.Empty;
wfat.PublishingWorkflowVersion = reader[DataColumnNames.PublishingWorkflowVersion] != DBNull.Value
? Convert.ToString(reader[DataColumnNames.PublishingWorkflowVersion]) : string.Empty;
wfat.PublishingWorkflowId = reader[DataColumnNames.PublishingWorkflowId] != DBNull.Value
? Convert.ToInt32(reader[DataColumnNames.PublishingWorkflowId]) : 0;
wfat.WorkflowTemplate = reader[DataColumnNames.WorkflowTemplateName] != DBNull.Value
? Convert.ToString(reader[DataColumnNames.WorkflowTemplateName]) : string.Empty;
wfat.WorkflowTemplateVersion = reader[DataColumnNames.WorkflowTemplateVersion] != DBNull.Value
? Convert.ToString(reader[DataColumnNames.WorkflowTemplateVersion]) : string.Empty;
wfat.WorkflowTemplateId = reader[DataColumnNames.WorkflowTemplateId] != DBNull.Value
? Convert.ToInt32(reader[DataColumnNames.WorkflowTemplateId]) : 0;
wfat.WorkflowsCount = reader[DataColumnNames.WorkflowsCount] != DBNull.Value
? Convert.ToInt32(reader[DataColumnNames.WorkflowsCount]) : 0;
wftList.Add(wfat);
}
reply.SearchResults = wftList;
reader.NextResult();
if (reader.Read())
{
reply.ServerResultsLength = Convert.ToInt32(reader["Total"]);
}
}
}
catch (SqlException e)
{
e.HandleException();
}
return reply;
}
