public async Task <ActionResult <int> > Count([FromBody] WorkflowStep_WorkflowStepFilterDTO WorkflowStep_WorkflowStepFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
WorkflowStepFilter WorkflowStepFilter = ConvertFilterDTOToFilterEntity(WorkflowStep_WorkflowStepFilterDTO);
WorkflowStepFilter = WorkflowStepService.ToFilter(WorkflowStepFilter);
int count = await WorkflowStepService.Count(WorkflowStepFilter);
return(count);
}
private WorkflowStepFilter ConvertFilterDTOToFilterEntity(WorkflowStep_WorkflowStepFilterDTO WorkflowStep_WorkflowStepFilterDTO)
{
WorkflowStepFilter WorkflowStepFilter = new WorkflowStepFilter();
WorkflowStepFilter.Selects = WorkflowStepSelect.ALL;
WorkflowStepFilter.Skip = WorkflowStep_WorkflowStepFilterDTO.Skip;
WorkflowStepFilter.Take = WorkflowStep_WorkflowStepFilterDTO.Take;
WorkflowStepFilter.OrderBy = WorkflowStep_WorkflowStepFilterDTO.OrderBy;
WorkflowStepFilter.OrderType = WorkflowStep_WorkflowStepFilterDTO.OrderType;
WorkflowStepFilter.Id = WorkflowStep_WorkflowStepFilterDTO.Id;
WorkflowStepFilter.WorkflowDefinitionId = WorkflowStep_WorkflowStepFilterDTO.WorkflowDefinitionId;
WorkflowStepFilter.Code = WorkflowStep_WorkflowStepFilterDTO.Code;
WorkflowStepFilter.Name = WorkflowStep_WorkflowStepFilterDTO.Name;
WorkflowStepFilter.RoleId = WorkflowStep_WorkflowStepFilterDTO.RoleId;
return(WorkflowStepFilter);
}
public async Task <ActionResult <List <WorkflowStep_WorkflowStepDTO> > > List([FromBody] WorkflowStep_WorkflowStepFilterDTO WorkflowStep_WorkflowStepFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
WorkflowStepFilter WorkflowStepFilter = ConvertFilterDTOToFilterEntity(WorkflowStep_WorkflowStepFilterDTO);
WorkflowStepFilter = WorkflowStepService.ToFilter(WorkflowStepFilter);
List <WorkflowStep> WorkflowSteps = await WorkflowStepService.List(WorkflowStepFilter);
List <WorkflowStep_WorkflowStepDTO> WorkflowStep_WorkflowStepDTOs = WorkflowSteps
.Select(c => new WorkflowStep_WorkflowStepDTO(c)).ToList();
return(WorkflowStep_WorkflowStepDTOs);
}
public async Task <FileResult> ExportTemplate([FromBody] WorkflowStep_WorkflowStepFilterDTO WorkflowStep_WorkflowStepFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region WorkflowStep
var WorkflowStepHeaders = new List <string[]>()
{
new string[] {
"Id",
"WorkflowDefinitionId",
"Name",
"RoleId",
"SubjectMailForReject",
"BodyMailForReject",
}
};
List <object[]> WorkflowStepData = new List <object[]>();
excel.GenerateWorksheet("WorkflowStep", WorkflowStepHeaders, WorkflowStepData);
#endregion
#region Role
var RoleFilter = new RoleFilter();
RoleFilter.Selects = RoleSelect.ALL;
RoleFilter.OrderBy = RoleOrder.Id;
RoleFilter.OrderType = OrderType.ASC;
RoleFilter.Skip = 0;
RoleFilter.Take = int.MaxValue;
List <Role> Roles = await RoleService.List(RoleFilter);
var RoleHeaders = new List <string[]>()
{
new string[] {
"Id",
"Code",
"Name",
"StatusId",
}
};
List <object[]> RoleData = new List <object[]>();
for (int i = 0; i < Roles.Count; i++)
{
var Role = Roles[i];
RoleData.Add(new Object[]
{
Role.Id,
Role.Code,
Role.Name,
Role.StatusId,
});
}
excel.GenerateWorksheet("Role", RoleHeaders, RoleData);
#endregion
#region WorkflowDefinition
var WorkflowDefinitionFilter = new WorkflowDefinitionFilter();
WorkflowDefinitionFilter.Selects = WorkflowDefinitionSelect.ALL;
WorkflowDefinitionFilter.OrderBy = WorkflowDefinitionOrder.Id;
WorkflowDefinitionFilter.OrderType = OrderType.ASC;
WorkflowDefinitionFilter.Skip = 0;
WorkflowDefinitionFilter.Take = int.MaxValue;
List <WorkflowDefinition> WorkflowDefinitions = await WorkflowDefinitionService.List(WorkflowDefinitionFilter);
var WorkflowDefinitionHeaders = new List <string[]>()
{
new string[] {
"Id",
"Name",
"WorkflowTypeId",
"StartDate",
"EndDate",
"StatusId",
}
};
List <object[]> WorkflowDefinitionData = new List <object[]>();
for (int i = 0; i < WorkflowDefinitions.Count; i++)
{
var WorkflowDefinition = WorkflowDefinitions[i];
WorkflowDefinitionData.Add(new Object[]
{
WorkflowDefinition.Id,
WorkflowDefinition.Name,
WorkflowDefinition.WorkflowTypeId,
WorkflowDefinition.StartDate,
WorkflowDefinition.EndDate,
WorkflowDefinition.StatusId,
});
}
excel.GenerateWorksheet("WorkflowDefinition", WorkflowDefinitionHeaders, WorkflowDefinitionData);
#endregion
excel.Save();
}
return(File(memoryStream.ToArray(), "application/octet-stream", "WorkflowStep.xlsx"));
}
