public async Task <IEnumerable <DocumentDetailDTO> > GetAllDocument()
{
List <DocumentDetailDTO> lstDocDTO = new List <DocumentDetailDTO>();
DocumentDetailDTO itemDocs;
var lstDocs = await _documentRepository.GetAllAsync().ConfigureAwait(false);
foreach (var item in lstDocs)
{
var username = await _userRepository.GetUsersByUserName(item.created_user).ConfigureAwait(false);
var foldername = await _doctypeRepository.GetByIdAsync(item.document_folder_id).ConfigureAwait(false);
itemDocs = new DocumentDetailDTO
{
id = item.id,
document_name = item.document_name,
document_description = item.document_description,
document_extension = item.document_extension,
created_user = username.username,
created_date = item.created_date?.ToString("dd/MM/yyyy"),
approve_date = item.approve_date?.ToString("dd/MM/yyyy"),
folder_name = foldername.text,
folder_id = item.document_folder_id,
stage = item.stage,
status = GetDocDesEnum(item.status),
document_receiver = item.document_receiver,
document_agency = item.document_agency,
approver = item.approver
};
lstDocDTO.Add(itemDocs);
}
return(lstDocDTO.OrderByDescending(x => x.created_date).ThenByDescending(x => x.id));
}
public async Task <IEnumerable <DocumentDetailDTO> > GetDocsByFolderId(string id)
{
var listFolder = await _doctypeService.GetChildFoldersById(id).ConfigureAwait(false);
List <DocumentDetailDTO> lstDocs = new List <DocumentDetailDTO>();
if (listFolder.Count() != 0)
{
foreach (var itemFolder in listFolder)
{
string where = $"where DOCUMENT_FOLDER_ID = {itemFolder.id}";
var tmpLst = await _documentRepository.SelectQuery(where).ConfigureAwait(false);
if (tmpLst.Count() != 0)
{
List <DocumentDetailDTO> subList = new List <DocumentDetailDTO>();
foreach (var itemDoc in tmpLst)
{
var username = await _userRepository.GetUsersByUserName(itemDoc.created_user).ConfigureAwait(false);
var foldername = await _doctypeRepository.GetByIdAsync(itemDoc.document_folder_id).ConfigureAwait(false);
var tmpDocs = new DocumentDetailDTO
{
id = itemDoc.id,
document_name = itemDoc.document_name,
document_description = itemDoc.document_description,
document_extension = itemDoc.document_extension,
created_user = username.display_name,
created_date = itemDoc.created_date?.ToString("dd/MM/yyyy"),
approve_date = itemDoc.approve_date?.ToString("dd/MM/yyyy"),
folder_name = foldername.text,
folder_id = itemDoc.document_folder_id,
stage = itemDoc.stage,
status = GetDocDesEnum(itemDoc.status),
document_receiver = itemDoc.document_receiver,
document_agency = itemDoc.document_agency,
approver = itemDoc.approver
};
subList.Add(tmpDocs);
}
lstDocs.AddRange(subList);
}
}
}
return(lstDocs.OrderByDescending(x => x.created_date).ThenByDescending(x => x.id));
}
