public DocumentResponse GetDocumentsForUser(DocumentRequestGetForUser request) { DocumentResponse retval = default; try { var param = _paramConverter.ConvertToParameter(request, "UserID"); var dataset = _SQLDAL.ExecSPQuery("GetDocumentsForUser", con, param); if (dataset.Tables[0].Rows.Count != 0) { retval = new DocumentResponse() { documentDTO = new List <DocumentDTO>() }; var docList = dataset.Tables[0].AsEnumerable().Select(dataRow => new DocumentDTO { DocName = dataRow.Field <string>("DocName"), ImageURL = dataRow.Field <string>("ImageURL"), UserID = dataRow.Field <string>("UserID"), DocID = dataRow.Field <Guid>("DocID") }).ToList(); retval.documentDTO = docList; } var sharing = _DocumentSharingDAL.GetShareForUser(new DocumentSharingRequestGetForUser() { userID = request.UserID }); List <DocumentDTO> sharedDocs = new List <DocumentDTO>(); if (sharing.DocumentSharingDTO != null && sharing.DocumentSharingDTO.Count != 0) { foreach (var item in sharing.DocumentSharingDTO) { var doc = GetDocument(item.DocID); if (doc.documentDTO[0].UserID != request.UserID) { sharedDocs.Add(doc.documentDTO[0]); } } if (retval == null) { retval = new DocumentResponse() { documentDTO = new List <DocumentDTO>() }; } retval.documentDTO.AddRange(sharedDocs); } if (retval == null) { retval = new DocumentResponseEmpty(); } } catch (Exception e) { //log } return(retval); }
public DocumentResponse GetDocumentForUser(DocumentRequestGetForUser request) { DocumentResponse retval = default; if (request.UserID != "" && request.UserID != null) { retval = _DAL.GetDocumentsForUser(request); } return(retval); }